Mysqldump add drop table?

It only affects the output of your MySQL dump in the file that is created.

It isn’t necessary. It is just there so that if you import the created dump file into a database that already has a table with the same name, it will drop that table and then add the new table in its place. Otherwise you will get an error, and the dump file won’t be imported.

It adds this line before the create table statement in the dump file:

DROP TABLE IF EXISTS `tablename`;

If you plan to import the dump file into a fresh database, it won’t matter.

Related Posts:

  1. Backing up and restoring multiple sites efficiently
  2. Locally restoring a ManageWP full site backup
  3. SQL error on restoring database
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. MySQL error 2006: mysql server has gone away
  6. Which MySQL data type to use for storing boolean values
  7. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  8. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  9. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  10. Your password does not satisfy the current policy requirements
  11. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  12. what does “/index.php?admin/admin_dashboard” in my url mean
  13. How to join two tables by multiple columns in SQL?
  14. How to get size of mysql database?
  15. Selecting data from two different tables without using joins
  16. SQL – Update multiple records in one query
  17. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  18. mysqladmin: connect to server at ‘localhost’ failed
  19. mysql update multiple columns with same now()
  20. Usage of MySQL’s “IF EXISTS”
  21. How can I loop through all rows of a table? (MySQL)
  22. Generating a random & unique 8 character string using MySQL
  23. MySQL > Table doesn’t exist. But it does (or it should)
  24. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  25. mysql count duplicates
  26. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  27. MySQL config file location – redhat linux server
  28. How to create a foreign key in phpmyadmin
  29. Can’t create test file lower test start server mysql
  30. MySQL delete multiple rows in one query conditions unique to each row
  31. Create boolean column in MySQL with false as default value?
  32. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  33. CAST to DECIMAL in MySQL
  34. Is merge statement available in MySQL
  35. GROUP_CONCAT comma separator – MySQL
  36. Failed to Connect to MySQL at localhost:3306 with user root
  37. How do you properly prepare a %LIKE% SQL statement?
  38. Complex meta query with 3 keys
  39. Set page template for all pages?
  40. Optimize Multiple Taxonomy Term MySQL Query?
  41. WordPress MySQL & PHP Performance
  42. What specific database privileges does WordPress need?
  43. Using source control with WordPress
  44. My WordPress site always displays a cached version of its homepage
  45. Updating User Meta with SQL Query
  46. wpdb prepare syntax
  47. How to run this SQL query of wp_terms database
  48. Configure WordPress to connect to Mysql DB using SSH tunneling
  49. Proper way to work with wpdb to get user’s firstname
  50. How to change post format from Aside to Image for all posts?
  51. Inserting Hundreds of Thousands of Posts at Once
  52. wp_admin edit.php slow with lots of queries
  53. How to add and SQL query of posts only published
  54. Slow Mysql Queries
  55. can database and media folder be moved to a different drive?
  56. Find duplicate posts with same slug and author
  57. Rewrite database urls
  58. What happens if I overwrite the current wp_options table with a backup from a week ago?
  59. writing inner join in wpdb
  60. How to get data from WordPress site sql file
  61. Unknown collation when I import a dump from an existing site into a development database?
  62. PHP script can’t connect to Database on port 3307
  63. WordPress with php5-fpm and nginx
  64. How to split the a table in database?
  65. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  66. How to translate this mySQL query to $wpdb query
  67. $wpdb to insert html form information
  68. Proper usage of $wpdb->update()?
  69. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  70. Separate DB by yearly archive of WordPress
  71. What should a WordPress developer know about MySQL? [closed]
  72. Copyright: Get first and last date of post type
  73. Update MySQL query so that it functions again
  74. Query posts by custom taxonomy and sort by post_modified
  75. WordPress $wpdb get posts from category and sort by custom meta
  76. WordPress tables and aliases?
  77. What’s the sql for this condition?
  78. Copy usermeta value where ID matches in the same table
  79. Array Formation Issue
  80. How can I write a formal sql query to get data from a custom table
  81. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  82. WordPress $wpdb no result
  83. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  84. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  85. edit_user_created_user hook – using to update Groups
  86. Changes not being reflected on new server
  87. Mysql Error in querying form entries in Gravity Form plugin
  88. Improving performance of SQL sub-queries in WordPress
  89. Saving custom term value to the database in new table
  90. MySQL errors after a WordPress clone
  91. MYSQL Join on meta key value?
  92. Woocommerce: Grab total revenue of a product over all orders
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?

Leave a Comment

error code: 523