Dumping out mysql data only (no structure)


#1

Is it possible? It is mentioned in AWDWR but I cannot find that
option in the MySQL documentation. I can dump the whole db or just
the structure, but I’d like to be able to dump just the contents.

bruce


#2

Hi Bruce

Try this:

mysqldump -t database tablename

Bob S.


#3

Bruce B. <brucebalmer@…> writes:

Is it possible? It is mentioned in AWDWR but I cannot find that
option in the MySQL documentation. I can dump the whole db or just
the structure, but I’d like to be able to dump just the contents.

bruce

Hi Bruce,

There’s a utility called “mysqldump” that’s included in MySQL
distributions. One
of the flags to mysqldump is “–no-create-info” so the following will
dump all
the data in YOUR_DATABASE (in SQL INSERT format, ready to be loaded into
another
MySQL instance)
mysqldump --user=me --password=mypass --no-create-info YOUR_DATABASE

database_data_only.sql

One of the other useful flags is “–complete-insert” which will add the
column
names to the insert statements (eg "INSERT user(id, first_name,
last_name)
VALUES(1, ‘A’, ‘User’)). This is useful when your new database has a few
extra
columns that weren’t in the original dump file.

If you’re looking for csv or tab-delimited format instead of SQL insert
format,
I’d suggest writing a short Ruby script.

Cheers,

  • stuart

#4

Thanks guys - worked like a charm. I had read it in the mysql docs
but not realised what they meant. It’s great when more experienced
people can save someone so much time.

Rails mailing list is awesome.

bruce