How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?

It is that simple for WordPress too. I use the following to back up my WP sites:

mysqldump -u <user> -p<pass> --quick --extended-insert <db-name> > backup.sql

The mysqldump document gives the details on all the parameters.

--extended-insert is quicker when updating a DB from a dump file and makes the dump file smaller.

--quick makes the creation of the dump quicker.

You don’t really need to use either of those, just makes things a bit quicker and writing an insert for each row just makes me feel happier – your original dump syntax would be just fine.

Don’t forget though that there is domain-specific entries in the DB so if you are using this method to backup/restore then you are fine but if you want to move from one.com to two.com then you will need to edit entries in wp_options after you restore your dump.

Related Posts:

  1. MySQL Syntax Error upon restoring database from backup [closed]
  2. Why is my database import losing text widget data?
  3. Export WP database for import using WP-CLI on Vagrant Box
  4. WordPress database import: Row size too large
  5. Export / import WordPress database
  6. How to Mirror WordPress database from Remote server to Local server
  7. Merging two databases without borking it
  8. Import users from old WP site to new one
  9. Best practice to import user base (subscribers) from one website to another?
  10. Importer fails to import every post
  11. Is it good practice to import/export a blog to test a redesign?
  12. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  13. Featured image from custom to WordPress database
  14. I broke database after reuploading local version – what exactly happened? Database error
  15. export individual posts to text files or a single csv file
  16. Importing Concrete5 content to WordPress
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. Export Pervasive to MySQL (C#)
  19. MySQL SELECT increment counter
  20. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  21. WordPress Database lost auto increment
  22. wpdb->insert multiple record at once
  23. Slow wp_term_relationships query
  24. How to use “TRUNCATE TABLE” MySQL statement?
  25. Importing posts from old website to new conflicting post ID’s?
  26. Exporting revisions
  27. Export wordpress table to excel
  28. When importing database, it shows error
  29. WordPress for a very large website
  30. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  31. WooCommerce – Query for ordered products
  32. Import 10,000 Users into WordPress WITH a specific ID for each user
  33. Error establishing a database connection – with Debug Data
  34. Is a direct or import approach safer for migration into WordPress?
  35. Database with mixed collation (utf8mb4 & utf8_general_ci)
  36. Query WordPress database by registered date and role
  37. Tons of Twitter rows in my database
  38. Set Display Name to first and last name (phpmyadmin SQL Query)
  39. Importing New Posts from Live Site into Local Dev Site
  40. Does WordPress ever need multiple databases?
  41. Why are no posts showing despite my apparently correct DB restoration?
  42. Select Multiple meta_value from WP DB; Single Query
  43. Delete all post meta except featured image Using SQL
  44. Is it possible to split database tables using HyperDB?
  45. Adding new row to wp_post table
  46. What happens if I overwrite the current wp_options table with a backup from a week ago?
  47. SQL Error wp_commentmeta – incorrect table definition
  48. WordPress database error – Error in SQL syntax – I can’t identify any error?
  49. CRUD operations using WordPress database API
  50. Unknown collation when I import a dump from an existing site into a development database?
  51. Is MariaDB’s Aria storage engine suitable for WordPress?
  52. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  53. How do I query wp_options for expired transient pairs with MySQL commands?
  54. WordPress Local And Live Site
  55. WordPress running SQL query to update database from form
  56. How to fix database error duplicate entry
  57. Migration: Copying database content to a different server
  58. Connection refused on locahost after importing database?
  59. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  60. Query multiple tables at once?
  61. creating new field on mysql
  62. Remove empty rows from the database
  63. Custom WordPress Table wpdb
  64. Why this query is not showing any result on wordpresss home page?
  65. Database Update Required – Update from command-line
  66. Best practice to limit results in get_row()?
  67. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  68. Trouble running $wpdb->query() with last_insert_id
  69. how to encyrpt DB_PASSWORD in wp-config
  70. SQL query to set posts in bulk based on the post content
  71. Changing order of db results when encoding to JSON
  72. Second ezSQL initialization for MSSQL
  73. Fetch a single row from a custom table for to a given ID
  74. Database create or redirect
  75. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  76. Link multiple user databases together?
  77. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  78. Set a cron job to delete a specific database table table every midnight
  79. How to import products in host instead of database on wordpress?
  80. I would like some help wth an SQL query to link posts with categories
  81. Where is the HTML-handler part in the wpdb class?
  82. Exporting Post type from one theme and importing it to another theme
  83. next comment id number wordpress
  84. Merging development site with live site
  85. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  86. How to extract some part of WordPress full source code
  87. Missing latest posts and options after DB migration via phpMyAdmin
  88. Check if a database is well installed
  89. live site do not update after importing sql database
  90. How do i get value from wp_postmeta?
  91. “MySQL server has gone away” since update to 3.8
  92. featured image not showing up with mysql_connect
  93. MySQL Database User: Which Privileges are needed?
  94. Import Excel (or csv) Table with user-data as subscribers to wordpress
  95. Print output of Table Creation
  96. Saving data to database and exporting to excel
  97. SQL query : Select a thumbnail for a media
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. WordPress database connection failed, while mysql client is working [closed]
  100. Have WordPress Use a Different Database for users

Leave a Comment