Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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
0
Jsara
Asked:
Jsara
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now