How can i skip error from load .sql back

[Anon]

I use Command mysql database < database.sql

but while importing found error .
How can i skip error and let import to the end and
I will fix problems manually after finish.

Help me..

[Anon]

hi pongpang,

with regards to your question, you should include the full path of your of the database and the text (backup file), the root and the password in order to execute the dumping without errors.

ex.

/usr/local/mysql/bin/mysql -u root -p /usr/local/mysql/var/worldroomevents < /usr/local/mysql/var/worldroomevents.sql

cheers,

jojit

[Anon]

If the sql statements have errors relative to the table design, you'll still get errors with that.

Use mysqlimport with the -f flag.

mysqlimport -f database_name filename.sql

Hope that helps.

---John Holmes...