copy tables between db's
| From: | Jeremy | Date: | Sun, 07 Sep 2003 13:25:07 +0000 |
| Subject: | copy tables between db's | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30398@lists.php.net to get a copy of this message | ||
I need to copy some tables from one mysql database to another mysql database
on the same server.
I looked at the php manual and couldn't find it...I found stuff on
mysqlhotcopy, but it doesn't look like that will do what I need it to do, or
maybe I'm reading the manual wrong.
Can someone please show me how to do this? To be specific, it's just a table
with a list of US states in it...
table name: states
fields: state_id, name, abbreviation
Thanks,
Jeremy