restore from sql dump fails

[QatQat]

Hi There,

I have just been given laptop to configure with mysql and I have installed my usual proven 5.0.27.

When I try to re-install DBs from sql dumps, it only restores very small files and stops after a few thousands lines when attempting the bigger sql files.

I have therefore updated to the latest 5.0.45 but I am still having the same issue.

Has anybody experience something similar on windoz?

Thanks in advance

QatQat



If I could have sex each time I reboot my server, I would definitely prefer Windoz over Linux!

 

[guelphdad]

how are you trying to restore the files?

 

[QatQat]

the usual way, from command line.

They restore fine on my linux box but get stuck after a few lines on a windoz laptop

The restore process works perfectly on smaller size DB. Anything over 8-10Mb of sql dump will cause mysql to stop executing the batch without reporting any error, just hanging there without completing the job.

QatQat



If I could have sex each time I reboot my server, I would definitely prefer Windoz over Linux!