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. Cannot delete or update a parent row: a foreign key constraint fails
  15. How do I import an SQL file using the command line in MySQL?
  16. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  17. How do I quickly rename a MySQL database (change schema name)?
  18. What does SQL Select symbol || mean?
  19. What is the definition of cardinality in SQL
  20. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  21. When to use SELECT … FOR UPDATE?
  22. SQL Query Where Field DOES NOT Contain $x
  23. Create a new database with MySQL Workbench
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. Column ‘user_id’ in field list is ambiguous
  26. How to join two tables by multiple columns in SQL?
  27. How to get size of mysql database?
  28. mysql Foreign key constraint is incorrectly formed error
  29. Selecting data from two different tables without using joins
  30. how to drop partition without dropping data in MySQL?
  31. MySQL: Invalid use of group function
  32. Creating a search form in PHP to search a database?
  33. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  34. Simple Random Samples from a Sql database
  35. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  36. What does SQL clause “GROUP BY 1” mean?
  37. SQL ZOO List each continent and the name of the country that comes first alphabetically
  38. How can I prevent SQL injection in PHP?
  39. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  40. Generating a random & unique 8 character string using MySQL
  41. SQL select only rows with max value on a column
  42. Unknown Column In Where Clause
  43. SQL statement not working – “Operand type clash: date is incompatible with int’
  44. Convert partially non-numeric text into number in MySQL query
  45. Repair all tables in one go
  46. MySQL equivalent of DECODE function in Oracle
  47. How can I search (case-insensitive) in a column using LIKE wildcard?
  48. How to create a foreign key in phpmyadmin
  49. importing a CSV into phpmyadmin
  50. How to check if mysql database exists
  51. #1062 – Duplicate entry for key ‘PRIMARY’
  52. Is there a Profiler equivalent for MySql?
  53. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  54. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  55. Remove Primary Key in MySQL
  56. MySQL: Cloning a MySQL database on the same MySql instance
  57. Is merge statement available in MySQL
  58. How to get the count of each distinct value in a column?
  59. Data is not constantly loading from custom wordpress table
  60. How do you properly prepare a %LIKE% SQL statement?
  61. What SQL Query to do a simple find and replace
  62. What’s a good strategy for planning WordPress DB growth?
  63. Optimize WordPress Query that take 5 seconds to execute
  64. Scanning Database for malicious Data
  65. Getting wrong relationship value in $args in wp_Query?
  66. wpdb->prepare function remove single quote for %s in SQL statment
  67. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  68. Inserting Post Meta From SQL
  69. How to Join two tables from separate databases within WordPress
  70. Extending the database
  71. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  72. How to execute mulitple statement SQL queries using $wpdb->query?
  73. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  74. Query WordPress database by registered date and role
  75. Size article thumbnails and retrieve them directly from database
  76. wpdb_prepare with multiple or condition
  77. How do I find which articles are missing a featured image in The WordPress database?
  78. SQL Error wp_commentmeta – incorrect table definition
  79. How to find meta entries with their posts missing via SQL?
  80. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  81. How do I get the posts within a certain year/date(with sql query)?
  82. Database Tables Lost Indexes? How to Recover?
  83. SQL Database, repeated tables?
  84. Create table from array with prepare
  85. Migrating to WordPress Recipe Plugin and Some SQL Issues
  86. Code to remove authors with no posts connected to them
  87. SQL command to convert all tags in lowercase?
  88. Which is better and faster ? WordPress Queries or SQL Query
  89. SQL Query in WordPress – Getting Impossible WHERE error
  90. Why this query is not showing any result on wordpresss home page?
  91. Using AND and bracket grouping in SQL not working
  92. Why does changing Database Table Prefixes result in loss of content?
  93. How to get INSERT errors from $wpdb?
  94. SQL query to set posts in bulk based on the post content
  95. WP MultiSite: Can’t select database error after changing to new domain
  96. MySQL query for taxonomy-meta
  97. How can I write a formal sql query to get data from a custom table
  98. $wpdb->get_var – What value is returned when zero records are found?
  99. latency problems with wordpress install (from SQL import)
  100. Data is not constatntly loading from custom wordpress table

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)