MySql db: how to backup data only and backup tables only
843854May 1 2005 — edited May 1 2005Hi 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