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,021,779questions on
Add New Page
Add New Page Talk0

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

Also on Fandom

Random Wiki