[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: MySQL search/replace. help please

On Thu, 07.09.00 18:59 +0000, t s a d i wrote:
> hello gang!
yo man!

>   what i need to do is to search out all occurences of the string 
> "www.olddomain.com" and change it to "www.mynewdomain.com".
Well, I go the simple way for this problems: 

mysqldump --opt database table \
 | sed 's/oldstring/newstring/g' \
 | mysql database



       Real programmers confuse Christmas and Halloween,
		  because Dec 25 = Oct 31 !!!

Reply to: