I have a 40 GB MySQL dump file. Can anyone give me the idea how to import the file via phpmyadmin?
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...