Welcome! Enter your question below. Please use words like "Who, What, Where, When, Why, How, etc..." in your question. Nothing to ask? Click here for a random, un-answered question.

How do you restore a MySQL dump to a database?

1,069,988questions on
Add New Page
Talk0 Share

Use the following procedure to reload the contents of a database:

1. Uncompress the backup file you wish to use.

2. Open it up and pull out only the information that you will need.

3. Save this text file.

4. Use the following command to feed back in the contents of a text file:

  mysql --verbose –u USERNAME -p DB_NAME < /PATH/TO/DUMPFILE.SQL

Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.