List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:October 6 1999 2:46am
Subject:Re: copy all tables in database
View as plain text  
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
Thread
copy all tables in databaseratnakd6 Oct
  • Re: copy all tables in databasePatrick Greenwell6 Oct
  • Re: copy all tables in databaseThimble Smith6 Oct
  • Re: copy all tables in databaseMike Machado6 Oct
  • Re: copy all tables in databaseEd Carp6 Oct
  • Re: copy all tables in databaseDavor Cengija6 Oct