Re: how to backup just the data? and how to backup only the tables???

[Guilhem Bichot]

Hello,
mysqldump has several options which could help.
To have only INSERT into your mysqldump output, no CREATE TABLE, no CREATE DATABASE:
mysqldump --no-create-db --no-create-info
To have only CREATE TABLE:
mysqldump --no-data
You can just look at "mysqldump --help" for more info... time to experiment!

Mr. Guilhem Bichot <[e-mail]>
MySQL AB, Lead Software Engineer
Bordeaux, France
www.mysql.com