Restore a MySQL Database

June 6, 2008

To restore a MySQL database with a backed up *.sql file, enter the following from a command line prompt after moving into the directory in which the *.sql file is in:

mysql -u root -p databasename < backupfile.sql

That’s it..
Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.