April 22, 200520 yr comment_525 I have a 2.8 GB mysql file (700 MB in sql.gz) and I want to restore it. However, I tried MySQL Administrator and it didnt even start up :angry: Any ideas how to restore this big db? Report
April 22, 200520 yr Author comment_528 I can't get the DB again so, that script is helpless :angry:Thanks anyway Report
April 23, 200520 yr comment_534 have you tried to restore it using phpmyadmin? I'm not sure whether it'll work with that big of a file though. Report
April 23, 200520 yr comment_537 No way for phpMyAdmin. Too big nd it wn't work cause of the maximum execution time/size. Best Regards Olajide Olaolorun The Uniform Server Development Team Report
April 23, 200520 yr Author comment_540 nvmI tried mysql.exe -u usr -p db < file.sqlTook ~15 mins to restore lol Report
April 23, 200520 yr comment_543 lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :angry: Best Regards Olajide Olaolorun The Uniform Server Development Team Report
April 23, 200520 yr Author comment_546 lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. 543[/snapback]No MA is a piece of crap :angry: It didnt even start to run 1 single query Report
April 23, 200520 yr comment_550 lol... I got it to work :angry: and i used it for a while until i found no use for it Planned to make it a plugin but also discarded it because it is easy to install... Best Regards Olajide Olaolorun The Uniform Server Development Team Report
April 24, 200520 yr comment_568 nvmI tried mysql.exe -u usr -p db Took ~15 mins to restore lol540[/snapback]Shall I say.. I told you so?:angry: Report
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.