CODEWITHSUNDEEP
phpmysqldatabasebackup
Saleh
Saleh

Reputation: 2719

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 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

Upvotes: 1

Views: 603

Answers (3)

Haim Evgi
Haim Evgi

Reputation: 125476

use mysql command line

you can see more details in this link

Upvotes: 0

Joshua Martell
Joshua Martell

Reputation: 7212

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.

Upvotes: 0

Tobias Reithmeier
Tobias Reithmeier

Reputation: 683

Try the command line. Must be something like:

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

Upvotes: 2

Related Questions