php – How to upload large SQL Files? – Education Career Blog

I have a large sql file < 600 MB.

This files is backup for forum and I want to upload it to empty db.

How I can upload it??

I can’t use PHPMyAdmin? and I used BigDump and it doesn’t insert all tables.

How to do it?? Is there any other way?


EDIT : I don’t have access to command line, I just have my CPanel


Try the command line. Must be something like:

mysql --user=name --password=pw < mysql_db_dump.sql


This is usually done from the command line like this:

mysql -hhostname -uusername -ppassword < bigfile.sql

Make sure you create your database first and that the user has CREATE TABLE privileges such as the root user.


use mysql command line

you can see more details in this link

Leave a Comment