 |
MEKAEEL
User
Jan 4, 2007, 1:08 AM
Post #1 of 5
(368 views)
Shortcut
|
|
is there a way to do it?
|
Can't Post
|
|
Hello guys!
I'm facing a great problem which affected my articles, all because of my hosting company  recently the company moved to new servers and for some reason they changed the IP address of my website. Unfortunately I've been using the old IP address in many links in my articles, for several reasons, and now all the links are broken the problem is that I have more than 2300 articles! and I use MySQL database. I can't really search all my articles to replace the old IP manually, so I was wondering if there is a simpler way around it maybe?
any kind of help is appreciated, I'm devastated with all the emails I'm getting from users about the links 
best wishes,
mekaeel
|
|
| |
|
simonwh
User
Jan 4, 2007, 6:01 AM
Post #2 of 5
(362 views)
Shortcut
|
|
Re: [MEKAEEL] is there a way to do it?
[In reply to]
|
Can't Post
|
|
Are these links in the article content itself? <gulp!!>
If they're in the templates it'd be an easy enough fix but im not sure of any magic-bullet way of updating every article unless you could extract the data from the mysql database and replace it with the amended text.
I know it should be possible but you'd probably need someone with mysql experience to do it for you.
|
|
| |
|
MEKAEEL
User
Jan 4, 2007, 11:21 AM
Post #3 of 5
(355 views)
Shortcut
|
|
Re: [simonwh] is there a way to do it?
[In reply to]
|
Can't Post
|
|
yes they are in the article content
I already changed all the templates links. I know however that there are only 100-150 articles that needs to be edited. And I was thinking about the same thing you suggested, I thought about changing the database type to flat files and then download the articles, after that I use the extensive search in Frontpage to search and replace all the files that contain the links, upload them again, and lastly change again to MySQL. But this sounds really scary, unless someone from interactivetools tells me this is totally safe I will not do it.
any ideas?
|
|
| |
|
Donna
Staff
/ Moderator
Jan 5, 2007, 2:33 PM
Post #4 of 5
(336 views)
Shortcut
|
|
Re: [MEKAEEL] is there a way to do it?
[In reply to]
|
Can't Post
|
|
Hi Mekaeel,
What you're describing (switching to flat file) would work -- the only thing I would recommend is using a plain text editor, rather than FrontPage. FrontPage really isn't suitable for editing non-HTML pages. The database file is definitely not HTML, so FrontPage is likely to add in all sorts of things you don't want.
We use a program called UltraEdit here -- anything like that would work, or even Notepad if your database isn't too big.
The main thing to do to make sure that what you're doing doesn't harm anything is 1) Make a backup! 2) Test everything thoroughly while it's still flatfile before switching back to MySQL -- republish, poke around, take a look at some of the articles you modified, etc. That way, if anything DID go wrong, you can easily revert to your backed up file.
I hope this helps! :)
Donna
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
MEKAEEL
User
Jan 5, 2007, 5:40 PM
Post #5 of 5
(329 views)
Shortcut
|
|
Re: [Donna] is there a way to do it?
[In reply to]
|
Can't Post
|
|
Thank you so much for the reply Donna!
I was about to start my plan when I thought of using the search engine to find how many articles include the old IP number, I don't know why I didn't think of this before! When I found that there are only 150 I hesitated and reconsidered, even though it would take some time to edit them all I think it's better and safer after all. If it was 500 or more articles to edit then yes I would go with the scary plan certainly.
anyway thank you again so much,
mekaeel
|
|
| |
|
