Re: copy tables between db's
| From: | Muhammed Mamedov | Date: | Wed, 10 Sep 2003 22:25:40 +0000 |
| Subject: | Re: copy tables between db's | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30441@lists.php.net to get a copy of this message | ||
What DBMS are you using? ... Oracle, MySQL or what?
If MySQL then you don't have to make it manual with PHP code (I mean copy
process) .. use something link PhpMyAdmin - there it is very easy to do it.
--
Muhammed Mamedov
Software Engineer
YTM.com.tr
"Jeremy" <jeremy@elijahgeneration.com> wrote in message
news:20030907132515.88322.qmail@pb1.pair.com...
> 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