Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySql db: how to backup data only and backup tables only

843854May 1 2005 — edited May 1 2005
Hi Guys,

I know this q belongs to the mysql forum but I have always enjoyed to use this one.

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 adding a new tables).

The problem:
Say I have added a new tables in the db --> I need to update HIS db as well. since I don't want to use "Create tables statments" I thought about doing this:

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2005
Added on May 1 2005
6 comments
236 views