How to upload large SQL Files?

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 u开发者_如何学Pythonpload 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

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