Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • 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
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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