MonkeyClicker

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.

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)

Code: Select all

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.