I have a 40 GB MySQL dump file. Can anyone give me the idea how to import the file via phpmyadmin?
-
5Don't. There's clearly a difference of opinion about the scale of your operations between whoever only allows you access via PHPmyAdmin and your business requirements (requiring 40GB of data).– 0xCAFEBABECommented Jul 29, 2013 at 7:29
-
5I'd say don't even try. Load it from the database server, not over a web interface.– MatCommented Jul 29, 2013 at 7:30
Add a comment
|
3 Answers
If you really want to restore it with PHPmyadmin you have to split the files into little chunks, because PHP will block too large files, depending on the serverconfig.
- Dump just the structure of your tables
- Import them
- Dump the data of your tables into a csv
- split the csv (on windows you can do this with gsplit for example and on unix with the split command
- Import the little chunks of data
But in general i'll recommend the commandline or contact your ISP
You better use a program like Sequel Pro or MySQL Workbench to import data if you don't have terminal access.
If you have terminal access use:
mysql -u username -ppassword database_name < dump.sql
Don't do large restore with phpmyadmin, PHP will block you, you will have something like "Allowed memory size" after few megs loaded...
Max.
answered Jul 29, 2013 at 11:42
-
It depends - if I run my server, I can change the PHP settings as I wish, and even very big files could be uploaded that way. I don't say phpmyadmin will digest it, so I basically agree with 'don't do it' Commented Jul 30, 2013 at 8:10
-
Sure, but if you have access on your servers, use the mysql client instead. Commented Jul 31, 2013 at 8:15