How to upload large SQL Files?

Question

Hi

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?

Thanks

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

Answer 1

Try the command line. Must be something like:

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

Answer 2

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.

Answer 3

use mysql command line

you can see more details in this link