Setting up Mysql

[kwickcut]

hello all i am new to sql i have been running windows advanced server 2000 for about a year and have set up a few v bulliten sites on h*stsave and another but now i would like to transfer these sites to my server. at this time i have WinMySQL 1.4 i think this is the latest but am not sure. i have deleted the my.ini file and installed as per directions. i am not sure if this is what i am in need of or even how to set it up i am totaly new to this i would be greatful for any help thanks


kwick

i am running Amd athalon 2400 with 1 gig of ram 1-120 gig hd and 1-80 gig hd at this time i am hosting iis server and ftp sites.

[Floris]

I am not familiar with WinMySQL, but I rather install MySQL binairy for Win32 instead. You can get various packages that help you install both Apache with PHP and MySQL where vBulletin has no issues running with.

[kwickcut]

wear can i get a copy of these programs i am not sure wear to look. now i did find a program called SQLypg and this is the specs will this work for vbulliten or is there something else that is easyer to learn and wear can i get it thanks again
<LI class=normal>MySQL 4.1.1 compatible
very fast retrieval of data
ODBC Import with option to import data through query
data sycnhronization tool
schedule various jobs
schema synchronization tool
notification services
update result returned from query
manage foreign key relationships
fully InnoDB compliant
view your results in GRID / TEXT mode
fast client side sorting and filtering
execute ( very large ) SQL-scripts as batch files
execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory
very compact binary
written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used
connection manager
excel like grid interface to create/alter tables
excel like grid interface to edit data with support for Enum/Set
create/drop databases
manage indexes
comprehensive security manager. Control access to databases/tables/columns
reorder columns of table
copy database between two MySQL hosts
drop all tables of a database with a single click
edit BLOBs with Bitmap/GIF/JPEG-Support
export table-structure and data into SQL-scripts
export/import data in/from CSV files
export database schema in HTML
log all queries for a session
profile queries
syntax-highlighting
save resultset in CSV, HTML and XML
save your commonly used SQL scripts in a personal folder with a click of mouse
is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
view and kill other user-processes
view advanced table-properties, such as Type, Comment, Key_Length and so on
a list of server-variables e.g processlist, status, variables etc
copy your result as CSV in clipboard
copy tables to new table-names
change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
flush Host/Logs/Privileges/Tables
do table-diagnostics (check, optimize, repair, analyze)
and a lot more...



kwick