How2 move database to 2nd HDD under Win2k Adv Srv & iis5.0?

[live2travel]

I saw a nice post here

http://www.vbulletin.com/forum/showthread.php?s=&threadid=8119

On how to move the mysql db to a 2nd hdd under Linux/Unix.

How can I achieve the same thing under Win2k Adv Server, and will it improve board performance in the same way?

I'm guessing it will.

Pertinent Current System Specs:

Athlon XP 1600+
ECS K7S5A mobo
512MB Crucial DDR CAS2.5 Unregistered NON-ECC (2x256MB)
Maxtor D740X 40GB HDD (currently only one, serving both vBulletin and the mysql DB)

Thanks for looking and your input.

Mark

[Pingu]

Putting in a second harddisk will improve performance of W2K overall if you put that second disk on the secondary IDE controller and move some disk i/o intensive apps to it. This will free the primary IDE controller of some work.
But any performance gained is relative to how busy your server is with this one disk....

To move the mysql databases to it, stop mysql, copy the databases to the second disk, and edit the my.ini file to point the datadir to the new location, like:
datadir = D:/mysql/data

[live2travel]

Uninstalled mysql, reinstalled mysql onto 2nd hard drive newly partitioned with NTFS.

Went to reinstall, and got a 1064 error on attempting to upload the backup.

I did it directly using the command prompt, since the server is right here in the house.

When I renamed the backup file to not include a number, in my case the number 212 (for Feb12); instead named forumbackup.sql, then the command line instruction:

d:\mysql\bin> mysql -u username -p vbulletin < d:\forumbackup.sql

password: ********

worked perfectly, and returned me directly to a prompt.

Bizarre.

Don't know why the # in the filename would cause problems but it did.

However, the backup worked, all my data was still there and we're off and running with the database on the 2nd HDD.

Just info for those of you who may want to try it.

mark