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]
