Hi everybody,

I'm new to drupal administration. I had configured drupal 6 on an internal test machine. Mysql version is 5.0.37 and it works fine for almost 6 months. Now I want to move the entire site to a server, with mysql version 5.0.51a. I have backed up the site files, and the database using mysqldump (/opt/lampp/bin/mysqldump -p --user=$dbuser --host=$dbhost --add-drop-table --socket=/opt/lampp/var/mysql/mysql.sock $dbname > dbcontent.sql) and important it to the new machine (echo "use $dbname; source dbcontent.sql;" | mysql --password --user=$dbuser --host=$dbhost). After that (in new machine), The main pages comes fine, but when I click on any other links, it says "page can not be found". What would be the issue, how can I fix it, is there any mysqldump compatibility mode? please help me!

PS: Please note, in old server Mysql database is 5.0.51a (higer version) and in the new server it is 5.0.37 (older). I can not change the mysql version @ server!

Best Regards,
-Vivek
Bangalore

Comments

vivekkc’s picture

Sorry, the first sentence should be (mysql version got inter changed) -

I'm new to drupal administration. I had configured drupal 6 on an internal test machine. Mysql version is 5.0.51a and it works fine for almost 6 months. Now I want to move the entire site to a server, with mysql version 5.0.37.

-ViveK

dww’s picture

Project: Database Administration » Drupal core
Version: 5.x-1.x-dev » 6.x-dev
Component: MySQL Support » database system

Your question is about migrating your database in general. It doesn't sound like you're using the Database Administration module at all. Moving this to a more appropriate place.

ainigma32’s picture

Status: Active » Postponed (maintainer needs more info)

It sounds like the .htaccess rewrite rules aren't working. Have you tried changing the path to something like: http://www.example.com/index.php?q=admin ?

- Arie

ainigma32’s picture

Status: Postponed (maintainer needs more info) » Fixed

Looks like vivekkc won't be posting any feedback so I'm setting this to fixed.

Feel free to reopen if you think that is wrong.

- Arie

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.