Hi, I would suggest using --hex-blob and --quote-names options of the mysqldump command.
regards, esv. --- Santino <[EMAIL PROTECTED]> wrote: > 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] > > Enrique Sanchez Vela email: [EMAIL PROTECTED] ----------------------------------------------------------------------------- It's often easier to fight for one's || We live in the outer space principles than to live up to them || Rev. Kay Greenleaf Adlai Stevenson || __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
