Someone recommended I change this:
mysqldump --add-drop-table -uroot -ppassword dbname >
/path/to/database/dbname_sql.txt
To this:
mysqldump --opt -uroot -ppassword dbname >
/path/to/database/dbname_sql.txt
Saying that --opt adds a few more things into the backup. What is the difference between these two methods of backing up the database?
Jason
mysqldump --add-drop-table -uroot -ppassword dbname >
/path/to/database/dbname_sql.txt
To this:
mysqldump --opt -uroot -ppassword dbname >
/path/to/database/dbname_sql.txt
Saying that --opt adds a few more things into the backup. What is the difference between these two methods of backing up the database?
Jason