matt_lists wrote:
matt_lists wrote:
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts this on a couple tables, not all of them
Definitly the problem, but I cant find the option to remove it
If I replace it with the following it works fine
DATA DIRECTORY='E:\\mysql\\data\\campbell\\' INDEX DIRECTORY='E:\\mysql\\data\\campbell\\'
works great in test, wont work in production, the backup sql file is 20-60 gig depending on the site, there's no way I can search and replace that size a file
Anybody know?
Is there some option I'm not setting which causes the data directory and index directory to not be correct?
Why are there not hundreds of people with this problem, I would think it affects anyone on 4.x running on a windows machine, I hope they dont learn the hard way when a restore fails to work!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]