PeterNRG
Fri 22nd Mar '02, 9:51pm
Probably a newbie question, but I'm not into mySQL at all:
I have a 180 MB mysql database on a remote server, with PHPmyAdmin access to it.
I want to do a find and replace action on the entire database on every table and field possible like this:
find "http://www.url1.com" and replace it with "http://www.url2.com"
If the database file would have been on my local PC, I simple would do this trick in a file editor (UltraEdit ie) because of my limited mysql knowledge :) But since the remote database is too big, I need to have a remote solution. I guess it can be done with some sort of queries in PHPmyAdmin.... the only question is: HOW?
:rolleyes:
I have a 180 MB mysql database on a remote server, with PHPmyAdmin access to it.
I want to do a find and replace action on the entire database on every table and field possible like this:
find "http://www.url1.com" and replace it with "http://www.url2.com"
If the database file would have been on my local PC, I simple would do this trick in a file editor (UltraEdit ie) because of my limited mysql knowledge :) But since the remote database is too big, I need to have a remote solution. I guess it can be done with some sort of queries in PHPmyAdmin.... the only question is: HOW?
:rolleyes: