Kevin Posted April 22, 2005 Report Share Posted April 22, 2005 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? Quote Link to comment Share on other sites More sharing options...
Kdaddy Posted April 22, 2005 Report Share Posted April 22, 2005 Hopefully this will help you take a look here. BigDump Quote Link to comment Share on other sites More sharing options...
Kevin Posted April 22, 2005 Author Report Share Posted April 22, 2005 I can't get the DB again so, that script is helpless :angry:Thanks anyway Quote Link to comment Share on other sites More sharing options...
Kevin Posted April 22, 2005 Author Report Share Posted April 22, 2005 Oops, let me try this script hee Quote Link to comment Share on other sites More sharing options...
elyk Posted April 23, 2005 Report Share Posted April 23, 2005 have you tried to restore it using phpmyadmin? I'm not sure whether it'll work with that big of a file though. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted April 23, 2005 Report Share Posted April 23, 2005 No way for phpMyAdmin. Too big nd it wn't work cause of the maximum execution time/size. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Kevin Posted April 23, 2005 Author Report Share Posted April 23, 2005 nvmI tried mysql.exe -u usr -p db < file.sqlTook ~15 mins to restore lol Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted April 23, 2005 Report Share Posted April 23, 2005 lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :angry: Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Kevin Posted April 23, 2005 Author Report Share Posted April 23, 2005 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 Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted April 23, 2005 Report Share Posted April 23, 2005 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... Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
MrX Posted April 24, 2005 Report Share Posted April 24, 2005 nvmI tried mysql.exe -u usr -p db Took ~15 mins to restore lol540[/snapback]Shall I say.. I told you so?:angry: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.