Mysql dumping problem
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
