Try:
mysqldump -h yourhost.com -u username -ppasswd mydatabase mytable | mysql -h
yournewhost.som -u newuser -ppasswd newdatabase
Santino Cusimano
At 17:19 +0200 20-08-2005, John thegimper wrote:
Thanks, but that copies the whole database
right? Can i specify only one table?
Quoting Pooly <[EMAIL PROTECTED]>:
If you have a mysqlclient an an access to the command line, you can
directly pipe it !
mysqldump -h yourhost.com -u username -ppasswd mydatabase | mysql -h
yournewhost.som -u newuser -ppasswd newdatabase
that's it !
otherwise, yes dump/export.
2005/8/20, John thegimper <[EMAIL PROTECTED]>:
> Is there an easy way to copy a table between two mysql servers? Or do
i need to
> export and then import? I´m using php btw.
>
> Thanks,
> Johhn
>
> -------------------------------------------------
> FREE E-MAIL IN 1 MINUTE!
> - [EMAIL PROTECTED] - http://www.pc.nu
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-------------------------------------------------
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
