path to images in database backup wrong

[agunther]

I have created a new site with drupal (drupal.org). I have created the site at home using xampp for linux (www.apachefriends). After I had achieved a certain level, I uploaded everything (incl. the database).

After adding stuff I tried downloading the database. Unfortunately thumbail images won't show up locally.

Somehow the path to all images got changed in the database.

src="files/images/image.jpg" --local database
src="../../files/images/image.jpg" --remote database (powweb)

Some other stuff got changed too (I tried replaxing ../../files with files but there was more stuff missing.
Is there a way to correct the path thing while downloading the database or maybe do some mysql command on it locally?

Hope someone knows the answer. I have been poking around online for days.

Thanks,

Andre

[RTH10260]

I don't know why the content of the database would show different path names, except for a different path names defined in the config for Drupal. Are you using the same level of Drupal in both locations ?

When you export the database, you will get a plain text file. With sufficient precautions you should be able to work with any text editor that allows long lines on the content.

Note: when exporting from Powweb to your local machine, make sure you are using the proper compatibility option, I believe the XAMPP level of MySql is less than Powwebs installation. Without chosing this option, you cannot import at the lower level.