Load huge sql dump to mySql

Question

I have a huge mysql dump file generated from phpmyAdmin (150 000 lines of create table, inserts....)

The mySql query tool fails to open such a big file. As a result i can't insert all the records.

Is there a way to do this ? Thanks John

Is it the command line 'mysql' tool that fails to load the file? Usually something like mysql -p -h DBSERVER dbname < dbname.sql should work. — Alistair
– Alistair, Commented May 28, 2010 at 13:44

konradowy · Accepted Answer · 2010-05-28 13:48:30Z

5

The solution to restore large mysql database from sql dump file is using unix/linux shell command. To restore mysql database from a dump file, just type the command below:

mysql -u #username# -p #database# < #dump_file#

Of course you need to replace #username# to your database username and #database# to your target database. and rename #dump_file# to your dump file file name (Ex: dump.sql) Once you enter the command, the linux/unix shell will prompt you for your database user password, just key in your database password and you are done

borrowed from: http://www.techiecorner.com/31/how-to-restore-mysql-database-from-sql-dump-file/

answered May 28, 2010 at 13:48

konradowy

1,56017 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jorge Ferreira · Accepted Answer · 2010-05-28 13:44:23Z

0

Split the file by parts. First the CREATE instructions, then the inserts.

answered May 28, 2010 at 13:44

Jorge Ferreira

98.3k25 gold badges127 silver badges134 bronze badges

1 Comment

jonathan Over a year ago

i can't even open the file with notepad ++! I was wondering if a tool could read line by line..

Collectives™ on Stack Overflow

Load huge sql dump to mySql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related