Importing Large Backups

Hi


I have a 600 MB .sql dump which I got from someone.

I need to import that .sql file to my database. PHPmyadmin does not allow that big files to import. The desktop based mysql client (SQLYog) which I am using to manage MySQL databases, also crashes while importing.

I am on a windows system. Could you please suggest me a better and effective way to import it?


Thanx in advance.

 

Did you heard about bigdump.php? that would help you or if not search for a sql splitter which will split your dump into smaller files and makes things easier

 

SSH or BigDump ( th, SSH is always an easier way for me ) ..

 

Hi sir

I am sorry but since I am on windows, SSH is not supported.


Thanx

 

Try bigdump.

It is very easy.

Create a folder called dump. Make some required changes on bigdump.php. Upload bigdump.php.

Add your sql to a zip file and upload the zip file. You can then extract the zip file on your server and run bigdump.php.

I will attach bigdump.php to this post for you.

 

PuTTY is a free implementation of Telnet and SSH for Win32 and Unix platforms, along with an xterm terminal emulator.

 

hello sir

ok plz guide me how to do it the SSH way


Thanx

 

If your talking about webserver uploads, I just upload it into my root directory on the server and then email my host. They handle it all

 

I m on a localhost FYI. So i have to handle it myself

 

dude !!! importing with big dump!!!! it is very easy

 

hey guys i need to import 400mb sql file, but big dump gives me error everytime at 10%, is there any other method, i also dont have ssh allowed on my shared hosting