Jump to content
The Uniform Server Community
Sign in to follow this  
Kevin

Restore a big mysql db file in Windows

Recommended Posts

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? ;)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
lol... That is the only way possible, but i believe that MySQL Administrator should be able to do that. :D

543[/snapback]

No MA is a piece of crap :angry: ;) :P It didnt even start to run 1 single query B)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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:

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...