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=2The 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/mysqlTo unsubscribe:
http://lists.mysql.com/mysql?unsub=lists@...
