Knowledgebase: MySQL
Import a MySQL Database
Posted by CTX Admin on 17 October 2014 11:04 AM
mysql -u DBUSER -pDBPASS DBNAME < dump.sql

Replace text in uppercase with the appropriate information:

  • DBUSER - Database user with privileges to the database

  • DBPASS - Password for the database user

  • DBNAME - Database name

If your password contains special characters like (* ? [ < > & ; ! | $), you will either need to escape them with a backslash, put the password between single quotes, or leave the password out (you'll be prompted to enter password). Here are some examples:

Escaped Password

mysql -u DBUSER -pM\*Y\?P\[A\<S\>S\&W\;O\!R\|D\$ DBNAME < dump.sql

Password In Quotes

mysql -u DBUSER -p'M*Y?P[A<S>S&W;O!R|D$' DBNAME < dump.sql

No Password

mysql -u DBUSER -p DBNAME < dump.sql
(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion