MySQL DB Restore

How do I restore a MySQL database from an sql dump? mysql -h localhost -u [MySQL user, e.g. root] -p[database password] [name of the database] < [name of your sql dump, e.g. sqldump.sql]
mysql -h localhost -u root -p sq_offers_bkp < sq_offers_bkp.sql
http://www.howtoforge.com/faq/6_4_en.html

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>