RE: question on data manipulation

Thank you all for your reply, it works perfectly. Gael Victor Pendleton <[EMAIL PROTECTED]> wrote on 21/05/2004 16.55.23: > One option: > > UPDATE table_name > SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com') > WHERE > > -Original Message- > From: [EMAIL PROTECT

question on data manipulation

Hi All I've xml contents in a column of one table. Inside that xml content, I've sometime an hardcoded link which I needs to change automatically (lets say: from host.domain.com/dev to host2.domain.com) I'm searching how to build the sql statement to do it but I don't understand how to do t

Re: Restore problem between MySQL on Win32 and MySQL on Linux?

It works like a charme with the -Q option Thank you Gael Victoria Reznichenko <[EMAIL PROTECTED]> wrote on 23/04/2004 11.26.01: > [EMAIL PROTECTED] wrote: > > > > I performed the backup (mysqldump -u username -p db > backup.sql) of a > > database on a Win32 (4.0.15-max-debug) server in orde

Restore problem between MySQL on Win32 and MySQL on Linux?

Hi All, I performed the backup (mysqldump -u username -p db > backup.sql) of a database on a Win32 (4.0.15-max-debug) server in order to restore it on Linux server (4.0.15-9) When I try to restore it on the linux machine (with mysql -u username -p db < backup.sql), there is an error saying: ERR