Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Mysql dumping problem

[Cuper]

Hello guys,

I'm trying to dump a large database (360 mb) through shell by using this command :

mysqldump -u username -p dbname > dbname.sql

after doing this command everything went ok and the sql file created , then i connect to the site through ftp and moved the sql file to the new server .

the problem is that when i want to dump this file again in the new database by using this command :

mysql -u myname -pmypassword dbname < dbname.sql

an error show and says that there is an error in a specified line .


i want to know if there is any dump command that can dump the file directly with ignoring any line that can be an error or problem .

Thanks

[nipl]

mysql -f -s -uusername -p dbname < script.sql

[sehe]

while importing use the -f option (see above)
-f, --force Continue even if we get an sql error.

[Brightadmin]

Hi,

As already provided solution by Sehe & nipl -

You can use the mysql command in the following way
mysql -f -u username -p dbname < dbname.sql
The -f option with mysql specifies to continue even if you get an sql error. It will good to rectify the error before dumping the database. You can post the error if you need any help in rectifying it.

Regards,

[nmluan]

When dumping try the "--opt" switch (mysqldump --opt -u user...), it tends to create a smaller and "better" output file.