Re: copy all tables in database

[Thimble Smith]

At 09:20, 19991006, ratnakd wrote:
>I like to copy all the tables in my database to another database in
>order to backup the data.

Usually we use the 'mysqldump' command to do this:

$ mysqladmin create backup_db
$ mysqldump --opt your_db | mysql backup_db

Something like that.

Tim