How do I restore a dump file from mysqldump?

It should be as simple as running this:

mysql -u <user> -p < db_backup.dump

If the dump is of a single database you may have to add a line at the top of the file:

USE <database-name-here>;

If it was a dump of many databases, the use statements are already in there.

To run these commands, open up a command prompt (in Windows) and cd to the directory where the mysql.exe executable is (you may have to look around a bit for it, it’ll depend on how you installed mysql, i.e. standalone or as part of a package like WAMP). Once you’re in that directory, you should be able to just type the command as I have it above.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. 1052: Column ‘id’ in field list is ambiguous
  4. 1052: Column ‘id’ in field list is ambiguous
  5. difference between primary key and unique key
  6. How to do a batch insert in MySQL
  7. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  8. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. Cannot delete or update a parent row: a foreign key constraint fails
  11. Cannot delete or update a parent row: a foreign key constraint fails
  12. Case statement in MySQL
  13. Rename a column in MySQL
  14. How do I import an SQL file using the command line in MySQL?
  15. How do I quickly rename a MySQL database (change schema name)?
  16. What does SQL Select symbol || mean?
  17. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  18. When to use SELECT … FOR UPDATE?
  19. SQL Query Where Field DOES NOT Contain $x
  20. Create a new database with MySQL Workbench
  21. Error Code: 2013. Lost connection to MySQL server during query
  22. Column ‘user_id’ in field list is ambiguous
  23. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  24. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  25. SQL ZOO List each continent and the name of the country that comes first alphabetically
  26. How can I prevent SQL injection in PHP?
  27. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  28. Unknown Column In Where Clause
  29. SQL statement not working – “Operand type clash: date is incompatible with int’
  30. Convert partially non-numeric text into number in MySQL query
  31. MySQL equivalent of DECODE function in Oracle
  32. How can I search (case-insensitive) in a column using LIKE wildcard?
  33. How to create a foreign key in phpmyadmin
  34. importing a CSV into phpmyadmin
  35. How to check if mysql database exists
  36. #1062 – Duplicate entry for key ‘PRIMARY’
  37. Is there a Profiler equivalent for MySql?
  38. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  39. MySQL: Cloning a MySQL database on the same MySql instance
  40. How to get the count of each distinct value in a column?
  41. Data is not constantly loading from custom wordpress table
  42. What SQL Query to do a simple find and replace
  43. What’s a good strategy for planning WordPress DB growth?
  44. Optimize WordPress Query that take 5 seconds to execute
  45. Scanning Database for malicious Data
  46. Getting wrong relationship value in $args in wp_Query?
  47. wpdb->prepare function remove single quote for %s in SQL statment
  48. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  49. Inserting Post Meta From SQL
  50. Extending the database
  51. How to execute mulitple statement SQL queries using $wpdb->query?
  52. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  53. Size article thumbnails and retrieve them directly from database
  54. wpdb_prepare with multiple or condition
  55. How do I find which articles are missing a featured image in The WordPress database?
  56. How to find meta entries with their posts missing via SQL?
  57. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  58. How do I get the posts within a certain year/date(with sql query)?
  59. SQL Database, repeated tables?
  60. Create table from array with prepare
  61. Migrating to WordPress Recipe Plugin and Some SQL Issues
  62. Code to remove authors with no posts connected to them
  63. SQL command to convert all tags in lowercase?
  64. Which is better and faster ? WordPress Queries or SQL Query
  65. SQL Query in WordPress – Getting Impossible WHERE error
  66. Using AND and bracket grouping in SQL not working
  67. Why does changing Database Table Prefixes result in loss of content?
  68. How to get INSERT errors from $wpdb?
  69. SQL query to set posts in bulk based on the post content
  70. WP MultiSite: Can’t select database error after changing to new domain
  71. MySQL query for taxonomy-meta
  72. $wpdb->get_var – What value is returned when zero records are found?
  73. latency problems with wordpress install (from SQL import)
  74. Data is not constatntly loading from custom wordpress table
  75. DB prefix not updating
  76. Performing CRUD operations on front end in wordpress
  77. Lock wait timeout exceeded; try restarting transaction
  78. Find locations of all featured images of draft posts via SQL
  79. SQL query to change custom field in WordPress database
  80. How to show result of sql query in a page?
  81. How to create index (sql) to a meta_key?
  82. The function is deprecated; use mysql_real_escape_string() instead
  83. WPDB delivers wrong results from complex queries
  84. How to change link in all posts?
  85. Display MySQL as part of a Page
  86. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  87. can’t delete a row from post_meta table
  88. get_results() query not working only when entering strings
  89. SQL error on restoring database
  90. Query sql for truncate post_content in wp_posts table
  91. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  92. export individual posts to text files or a single csv file
  93. Delete posts with word count less than x number of words
  94. SQL – Pull products of particular category from a remote WordPress woocommerce db
  95. SQL command to export post_content from wp_posts using phpMyAdmin
  96. why you don’t Implement PDO for access every thing to database
  97. SQL get last entry of a specific gravity form
  98. How do I load a sql.gz file to my database? (importing)
  99. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment

tech