Restoring a .sql file via shell

[sneekyshadow]

Hello,

I had a hard time restoring .sql files through phpmyadmin because it timed out, especially when you have a large MySQL. I found the post by kylec regarding backing up MySQL very good here:

http://forums.dathorn.com/showthread.php?t=351

Now, how do I RESTORE the .sql file via shell? I found shell procedures much faster than any other.

Thanks.

[chrisd]

Now, how do I RESTORE the .sql file via shell?

Presumably your backup file is just INSERT statements.

There's more than one way - but this is what works for me:

#/>mysql -udbuser_name -puser_password

mysql>use db_name

mysql>source ./path_to_sql_file_name

You can also execute any valid sql from the mysql prompt ... which comes in handy when your source file explodes and you have to delete * from or DROP TABLE. Enter help or ? for more options.

[sneekyshadow]

Ok thanks chrisd. I'll try this.