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 bye, -christian- -- Real programmers confuse Christmas and Halloween, because Dec 25 = Oct 31 !!!