How to export a mysql database using Command Prompt?

First check if your command line recognizes mysql command. If not go to command & type in:

set path=c:\wamp\bin\mysql\mysql5.1.36\bin

Then use this command to export your database:

mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql

You will then be prompted for the database password.

This exports the database to the path you are currently in, while executing this command

Note: Here are some detailed instructions regarding both import and export

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Cannot add or update a child row: a foreign key constraint fails
  3. How to make MySQL table primary key auto increment with some prefix
  4. MySQL error 2006: mysql server has gone away
  5. sql query with multiple where statements
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. Syntax error due to using a reserved word as a table or column name in MySQL
  8. MySQL root password change
  9. Installation of MySQL for Visual Studio 1.2.8 failed
  10. How do I import an SQL file using the command line in MySQL?
  11. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  12. Select from multiple tables without a join?
  13. SQL Query Where Field DOES NOT Contain $x
  14. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  15. SQL – Update multiple records in one query
  16. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  17. Mysql command not found in OS X 10.7
  18. MySQL – UPDATE query based on SELECT Query
  19. grabbing first row in a mysql query only
  20. What does SQL clause “GROUP BY 1” mean?
  21. LAST_INSERT_ID() MySQL
  22. Generating a random & unique 8 character string using MySQL
  23. MySQL > Table doesn’t exist. But it does (or it should)
  24. SQL select only rows with max value on a column
  25. Trying to perform MINUS operation in MySQL
  26. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  27. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  28. MySQL config file location – redhat linux server
  29. How to create a foreign key in phpmyadmin
  30. Can’t create test file lower test start server mysql
  31. MySQL delete multiple rows in one query conditions unique to each row
  32. Create boolean column in MySQL with false as default value?
  33. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  34. Is there a naming convention for MySQL?
  35. CAST to DECIMAL in MySQL
  36. GROUP_CONCAT comma separator – MySQL
  37. Failed to Connect to MySQL at localhost:3306 with user root
  38. How do you properly prepare a %LIKE% SQL statement?
  39. Set page template for all pages?
  40. What specific database privileges does WordPress need?
  41. SQL query to update post_date (one post = one single date & time)
  42. My WordPress site always displays a cached version of its homepage
  43. How to copy post titles to post slug in phpmyadmin
  44. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  45. Proper way to work with wpdb to get user’s firstname
  46. How to change post format from Aside to Image for all posts?
  47. Inserting Hundreds of Thousands of Posts at Once
  48. wp_admin edit.php slow with lots of queries
  49. How to add and SQL query of posts only published
  50. Slow Mysql Queries
  51. Database: Custom table: sprintf value for DateTime column
  52. What is the most secure way to set up the MySQL user in WPMU?
  53. Find duplicate posts with same slug and author
  54. WP_USE_EXT_MYSQL
  55. writing inner join in wpdb
  56. Distinction on meta value on pre_get_posts
  57. How to get data from WordPress site sql file
  58. WordPress with php5-fpm and nginx
  59. MySQL Rank & $wpdb
  60. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  61. WordPress post_status is future, manually added
  62. How are multiple WordPress WPDB queries handled?
  63. Regarding “Insert query error” in wordpress
  64. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  65. WordPress plugin overloading with tmp tables
  66. Site not responding error – taking long to load [closed]
  67. What should a WordPress developer know about MySQL? [closed]
  68. Copyright: Get first and last date of post type
  69. WordPress(wpdb class) and mysql stored procedures
  70. WordPress plugins for database queries
  71. WordPress doesn’t display accents after migration
  72. Replace a character in all post titles and slugs
  73. Understanding custom php that reads from WP MYSQL
  74. $wpdb->get_var multiple queries in one database check
  75. List users with the most posts in the last 30 days
  76. Way to extract wordpress data from folder backup
  77. WordPress $wpdb no result
  78. Data is not constatntly loading from custom wordpress table
  79. Mysql Server keeps crashing
  80. How to search usermeta table
  81. How to add virtual column in wpdb get_result statement
  82. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  83. I want to share local developement and staging DB — Is this very smart or very stupid?
  84. Extract all users along with yoast metadata description
  85. WordPress asks to install, but is already installed?
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. Deleting a table row through query
  88. An SQL query to find orphaned image attachments and their meta
  89. Weird characters displayed when importing WordPress MySQL db
  90. Simple SQL Query in wordpress
  91. Saving custom term value to the database in new table
  92. MySQL errors after a WordPress clone
  93. optimise SQL wordpress call
  94. Complicated MySQL Query
  95. problem with quotes on new post
  96. WP_Query with LIKE returns strange query
  97. Where other than wp-config can database access details be defined?
  98. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  99. How can I show user’s privileges in MySQL?
  100. Changing host permissions for MySQL users

Leave a Comment