Solved

Question related to mysql dump

Posted on 2011-09-20
4
273 Views
Last Modified: 2012-06-12
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
Comment
Question by:Jsara
4 Comments
 
LVL 23

Accepted Solution

by:
nemws1 earned 250 total points
ID: 36567995
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
 

Author Comment

by:Jsara
ID: 36575476
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question