Copying tables

[skills2go]

Hi Folks

I'm trying to copy a database table form one database to another on a different server. Is it possible through myphpadmin, or do I need software? If software, do you know of any good programs to do this?

Bob

[Daniel Brown-5]

On Mon, Mar 10, 2008 at 2:58 PM, skills2go
<support@...> wrote:
>
>  Hi Folks
>
>  I'm trying to copy a database table form one database to another on a
>  different server. Is it possible through myphpadmin, or do I need software?
>  If software, do you know of any good programs to do this?

    The same question just received an excellent answer from Rolando
Edwards about ten minutes ago.  Check the archive here:

    http://marc.info/?l=mysql&m=120517563300467&w=2

--
</Dan>

Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...

[Tim McDaniel-2]

On Mon, 10 Mar 2008, Daniel Brown <parasane@...> wrote:

> On Mon, Mar 10, 2008 at 2:58 PM, skills2go
> <support@...> wrote:
>>  I'm trying to copy a database table form one database to another
>>  on a different server. Is it possible through myphpadmin, or do I
>>  need software?  If software, do you know of any good programs to
>>  do this?
>
> The same question just received an excellent answer from Rolando
>Edwards about ten minutes ago.  Check the archive here:
>
>
>    http://marc.info/?l=mysql&m=120517563300467&w=2

The one missing piece: mysqldump can choose to dump only one or a few
databases, and if given one database name, can dump only selected
tables.  <http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>:

     There are three general ways to invoke mysqldump:

     shell> mysqldump [options] db_name [tables]
     shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
     shell> mysqldump [options] --all-databases

Read the manual for your version of MySQL for more options.
--opt looks like it might be most useful.

--
Tim McDaniel, tmcd@...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...

[Daniel Brown-5]

On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel <tmcd@...> wrote:

> On Mon, 10 Mar 2008, Daniel Brown <parasane@...> wrote:
>  > The same question just received an excellent answer from Rolando
>  >Edwards about ten minutes ago.  Check the archive here:
>  >
>  >
>  >    http://marc.info/?l=mysql&m=120517563300467&w=2
>
>  The one missing piece: mysqldump can choose to dump only one or a few
>  databases, and if given one database name, can dump only selected
>  tables.  <http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>:

    Good point.  I forgot to mention that.  Thanks, Tim.

--
</Dan>

Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...