Site Moving: Mysql 5.0.51a to 5.0.37 issue
Hi everybody,
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. 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
Most likely the problem is
Most likely the problem is not the database version. I don't think 5.0.51a and 5.0.37 have any important differences.
Give more details about one particular error page, its path etc. It is easier to find what the problem is by examining a specific example.
Check the URLs of the links which don't work. Do they seem correct? Do they contain any path which they shouldn't?
Try accessing the problem pages without clean URLs, for example using /?q=admin instead of /admin, to see if the problem is clean URLs. If it is, then make sure that you have uploaded Drupal's .htaccess file.
Also check if you have entered anything specific to the old domain in the new site's .htaccess file or settings.php file.