Re: Cloning a Database

2003-07-08 Thread Paul DuBois
At 19:58 +0200 7/8/03, Boris Villazon wrote: Hi I need to know if is there anyway to clone a existing database (structure and data)? If yes, how can I do this? I looking for a SQL command. There is no single SQL statement to do this. You can use mysqldump to generate a file containing multiple

Re: Cloning a Database

2003-07-08 Thread Greg Donald
> I need to know if is there anyway to clone a existing database (structure and > data)? I use mysqlhotcopy myself. http://www.mysql.com/doc/en/mysqlhotcopy.html -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Cloning a Database

2003-07-08 Thread Dan Anderson
couldn't you dump the database and then use the backup to reload the database? -dan On Tue, 2003-07-08 at 13:58, Boris Villazon wrote: > Hi > > I need to know if is there anyway to clone a existing database (structure and data)? > > If yes, how can I do this? I looking for a SQL command. > >

Cloning a Database

2003-07-08 Thread Boris Villazon
Hi I need to know if is there anyway to clone a existing database (structure and data)? If yes, how can I do this? I looking for a SQL command. Thanks in advance and best regards Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li