Question related to mysql dump

I have a database already with data in table, if I run the mysql dump command now with data only, will it delete the original data and reload or append to the original data.

Or what is the best to do this process
JsaraAsked:
Who is Participating?
 
nemws1Database AdministratorCommented:
If you do a data-only dump (no table or database DROP lines), then yes, it should append. (Always back up your database/tables before you attempt to do this!  Just to make sure.)

However, if you have a PRIMARY KEY or an AUTO_INCREMENT field, you'll run into problems, as you'll get collisions.
0
 
JsaraAuthor Commented:
Is this the only method that is to empty the data and run the dump to get the lates data.
Are there other ways if you want to load the data periodically.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.