mymilkexpired
02-07-2006, 02:14 AM
Hey--I'm looking to do a large database import, roughly 500mb. However i want the import to be done at a low priority, IE slowly so it doesnt consume massive server resources.
I'm importing on a Windows 2k3 server and am trying to minimize the impact to my other hosted sites for the duration of the database import. I intend to use the following command for the import
mysql.exe -uXXXX -p database < file.sql
Is there anyway that i can establish a resource priority to the operation?
I'm importing on a Windows 2k3 server and am trying to minimize the impact to my other hosted sites for the duration of the database import. I intend to use the following command for the import
mysql.exe -uXXXX -p database < file.sql
Is there anyway that i can establish a resource priority to the operation?