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
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.
Powered by vBulletin® Version 4.2.2 Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.