How can I RESTORE a MySQL database from the command line?

Importing a MySQLDUMP

From your SSH command prompt type ...
mysqladmin -u {username} -p {password} create {databasename}
mysql -u {username} -p {password} < {databasename.sql}

Replace the parameters with the appropriate values

• {username} - this is your database username
• {password} - this is the password for your database
• {databasename} - the name of your database
• {databasename.sql} - the file to which the backup should be written.

Depending on your Unix/Linux version you may need to type the full path i.e. /usr/local/mysql/bin/mysql instead of just mysql

The {databasename.sql} shoudl contain all the SQL statements needed to create the tables and populate them with their current contents.

Example To restore your database myuser_portal with the database username mydbuser and database password mydbpassword from a file portal.sql, you would type the commands:

mysqladmin -u mydbuser -pmydbpassword create myuser_portal
mysql -u mydbuser -pmydbpassword < portal.sql

Add to Favourites    Print this Article

How do I see what is running / listening / responding on a port ? (Views: 1848)

DSNLess connection to MS SQL (Views: 1768)

DSNless connection to MS Access (Views: 2145)

Can a VPS/Cloud Server be used as a Game Server (Views: 2726)

How do I create a MySQL Database in the Ensim control panel ? (Views: 1988)