DB Export/Import

[joerge80]

Hi,

I have two systems (one test and one productive). As I was about to set my computer up again I installed the latest version of XAMPP. Then I copied over the htdocs files and made a backup of the DB (mysql --> export in phpmyadmin) and imported it on my localhost. The thing I'm working on is a joomla project.

But there are a few differences now:

- The DB size is different
- When I try to login to the backend of joomla (same uiser/pw on both machines), the password seems to be wrong?!? However the values in the users table are both the same

The XAMPP version on the first machine is 1.6.5, the other one (where it's not working) is 1.7.3

Anyone got a clue?

Thx

[Nobbie]

Which operating systems?

Are the Joomla Passwords crypted somehow or plain text?

Do you still have the old installation? If yes, simply try to copy the whole mysql data folder from one installation to the other (like you did with htdocs folder) instead of running export/import.

[joerge80]

both windows (winxp/win7)

passwords are (i guess) MD5, at least that is how it normally worked, when i have reset the pw directly in the database

[H0MER]

Maybe you forgot to add the database user, which is used by joomla to access the database, into the new database.
And maybe you have to grant that user the correct rights to for that database.

Greets
H0MER