On Thu, 23 Sep 2004, John Meyer wrote:
> Just to let people know. And BTW, you have to say that you want the
> account. Reply off list.
> Onlist, I'd like to know how most people back up their Mysql dbs? XML
> or direct SQL file? I prefer the latter, although I'd like to hear
> from proponents of the former.
I use mysqldump to dump entire databases to simple ASCII text files
that can then be compressed. Then I can simply pipe the file into the
mysql client to restore create them, eg:
mysqladmin -u root -pxx create sound_sources
cat sound_sources.dump | mysql -u root -pxx sound_sources
The nice thing about working with mysqldump fiels is they're editable
with any text editor, so you can massage tables, delete tables, etc or
you can simply restore a single table instead of all of them.
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]