Log in

View Full Version : Mysql large file import



eXceed69
03-14-2009, 04:16 PM
I have recently back-up my production database which is 160mb sql files... My problem is that I would like to have local back-up copy on my pc. Since restriction and exception hits on my phpmyadmin tool. Is that possible to chunk down each sql file into pieces let say 20mb sql file size... Is that posible and can you post it what software or steps should i take...


Thanks

Nile
03-15-2009, 01:07 AM
To download a copy of your sql, simple go in phpmyadmin, click on a database, find the tabs that look like this:
http://localhostr.com/files/bd34f3/capture.png

And click "Export"

You should see something like this:
http://localhostr.com/files/aec8bc/capture.png

Select the file type on the left, and then click "Go."

As for "chunking down" the sql file to 20mb, I dont know.