copy tables 1

[hz]

Does anybody know, in MYSQL, how to copy an entire table in one database to another database? [sig][/sig]

 

[devnull22]

yea ,
just shut down the server , and copy the databse files
into another directory . remember that a database in
mysql is a directory. so if you copy the director and
give it a new name, you'll have a exact duplicate database.

ie.
database "work".
% cp /path_to_data_files/work /path_to_data_files/mywork

now, when you start up mysql, you'll see "work" and "mywork"

cheers
[sig]<p>Ken<br><a href=mailto:admin@mysqlwebring.com>admin@mysqlwebring.com</a><br><a href=

http://www.mysqlwebring.com>MySQL

Webring</a><br>

http://www.411eshop.com<br>

[/sig]

 

[hz]

Thanks Ken. I will go ahead and test it after I gain the permission.

[sig][/sig]