How can I get rid of these comments in a MySQL dump?

by

WHOA! These aren’t really comments even though they look that way. They are conditional-execution tokens.

Take this line:

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

If the version of mySQL is 4.00.14 or higher, then the MySQL server will run this statement.

This magic comment syntax is documented in the Comment Syntax section of the manual.

You probably don’t want to get rid of this stuff.

More Related Contents:

  1. #1071 – Specified key was too long; max key length is 1000 bytes
  2. How can I access the MySQL command line with XAMPP for Windows?
  3. Exporting results of a Mysql query to excel?
  4. Restore the mysql database from .frm files
  5. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  6. Mysqldump launched by cron and password security
  7. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  8. In SQL Server how to get the count of child if both parent and child are available [closed]
  9. Calculate a running total in MySQL
  10. What does character set and collation mean exactly?
  11. How do MySQL indexes work?
  12. How to change MySQL data directory?
  13. MySQL Syntax error message “Operand should contain 1 column(s)”
  14. Format number to 2 decimal places
  15. INSERT … ON DUPLICATE KEY (do nothing)
  16. How to remove new line characters from data rows in mysql?
  17. In SQL, is it OK for two tables to refer to each other?
  18. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  19. Query from two tables in report
  20. Is it safe to store usernames and passwords in the database?
  21. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  22. Compare only day and month with date field in mysql
  23. mysql, ifnull vs coalesce, which is faster?
  24. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  25. UPDATE with ORDER BY and LIMIT not working in MYSQL
  26. Can a MySQL query turn rows into columns?
  27. Xampp-mysql – “Table doesn’t exist in engine” #1932
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment