Restore a big mysql db file in Windows

[Kevin]

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?

[Kdaddy]

Hopefully this will help you take a look here. BigDump

[Kevin]

I can't get the DB again so, that script is helpless :angry:

Thanks anyway

[Kevin]

Oops, let me try this script hee

[elyk]

have you tried to restore it using phpmyadmin? I'm not sure whether it'll work with that big of a file though.

[olajideolaolorun]

No way for phpMyAdmin. Too big nd it wn't work cause of the maximum execution time/size.

[Kevin]

nvm

I tried mysql.exe -u usr -p db < file.sql

Took ~15 mins to restore lol

[olajideolaolorun]

lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :angry:

[Kevin]

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

[olajideolaolorun]

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...

[MrX]

nvm

I tried mysql.exe -u usr -p db

Took ~15 mins to restore lol

540[/snapback]

Shall I say.. I told you so?

:angry: