By sjames on

http://www.shreemaa.org
drupal-5 upgrade from 4.7.3

I upgraded from drupal-4.7.3 to drupal-5 and I see now that several of the web editors made hard coded links to drupal-4.7.3 in drupal nodes instead of to the drupal symlink that I have. I changed all the instances of drupal-4.7.3 to drupal in the mysql database. BUT, now I need to change all instances of drupal-4.7.3 to drupal at the web site as admin.
How can I do this without spending hours and hours doing it all manually?

Can someone help?

thanks,
Susan

⋅ Categories: Drupal 5.x

Comments

sjames’s picture

sjames commented

I sure wish someone can give me an idea on how to change our MySql database for all instances of drupal-4.7.3 to drupal. there's wrong paths after I upgraded to drupal-5.

I did a mysqldump and then used vim to change all instances of drupal-4.7.3 to drupal in the dump file.
then, I ran mysql to import into drupal database:
========
mysqldump -u root -p drupal473 > drupal473.sql
mysql -u root -p drupal473 < drupal473.sql
========

BUT, this didn't work because I got a home page full of errors generated from include files.

anyone can help?
thanks,
Susan

sjames’s picture

sjames commented

I upgraded to drupal-5 from 4.7.3, and the paths changed in the drupal database.
I did a live mysqldump, edited the dump file with vi and changed the paths from drupal-4.7.3 to drupal.
but, I got errors at the web site after I restarted mysql. so, I had to revert back to the old database with broken links.

mysqldump -u root -p drupal473 > drupal473.sql
vi drupal473.sql [changed paths as needed from drupal-4.7.3 to drupal]
mysql -u root -p drupal473 < drupal473.sql
but the web site was broken with errors.

can anyone give me a suggestion on how to change the paths in the MySql dbs?

thanks,
Susan