MySQL Forums
Forum List  »  Backup

how to backup just the data? and how to backup only the tables???
Posted by: peter primrose
Date: May 01, 2005 11:50AM

Hi Guys,

Here is the deal:

I have created a database with a Java application to a client of mine. Sometimes I'm upgrading the software and the database as well (say I have added a new table).

My Idea:
1. HE--> Backup his DATA only (insert & select NO TABLES). & send me the file
2. ME --> Create a backup for the new DB --> TABLES only! (this is a new version of the old db but with extra tables)
3. ME--> populating all info from step 1 into the new db
4. ME-->back everything (mysqldump -p -u root db>backup.txt) and send him the file
5.HE--> (mysqldump -p -u root db<backup.txt)

Question:

I don't want to write any "create table" statments in my program but I do want to make sure that everything he entererd to the db will transfer to the new db (the one that I added a new table)
so:
1. What is the command to backup only DATA and Only TABLES?
2. Do you have a better solution for this (again, no create tables on my program)

Thanks for any thoughts

Options: ReplyQuote


Subject
Views
Written By
Posted
how to backup just the data? and how to backup only the tables???
8585
May 01, 2005 11:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.