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