Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By jeefers on
I am moving a drupal 5.1 site off of a dedicated server and moving it to a standard hosting plan. I have three different hosting plans from three different companies to move it to. I have backed up the database using mysql dump.
I moved it to a plan that i had to have ssh available to import the database. I have done an import of the database and ive copied all the files over from the dedicated server to this other hosting plan.
I was getting an error "Duplicate entry '0' for key 1 query: INSERT INTO watchdog drupal 5.1" I got passed that i believe via this page. http://drupal.org/node/65665
but currently the site comes up but i cant log in. it gives me a 404 error now whenever i try to log in. below is the url i pretty much get when attempting to login
http://domainname.com/user/login?destination=login_redirect
I believe this is because the site had clean urls setup on the dedicated server and now i dont have mod rewrite configured on the shared hosting plan.
A fear I also have is because I downgraded from mysql 5.1 to mysql 4.02. Can anyone point me on how to get the site setup on a shared hosting plans... to get the cleanurls working
or how to manually get the cleanurls setting off of the drupal site?
Also is there anything else i would have to do for downgrading the the site?
Comments
update
Ok ive went back and turned off cleanurls then downloaded the database. Then I took the database (mysql 5.1) then i restored it to a mysql 4.0 database and im still in the same boat. I keep getting 404 errors when i try to log in.
Ive cleared all the cache, sessions, and watchdog tables.
still have had no luck with moving the site
Oy!
Other than special characters, the DB downgrade might go well.
With our hosting provider, MySQL 5.x client was on the web server while we yet had MySQL 4.0.x as the back end DB server. Thus, I specified utf8 as the character set do backup with, and was able to easily migrate the DB from 4.0.x to 5.x.
Certain things are specified with the full path of where files reside on the server itself - strings inside the DB have the full path on the server that is. That was one thing to watch out for when moving between providers.
As for rewrite, hand type in non-clean URL's to get to where you need to get to. There might be countless instances of clean URL's in the DB... haffa change them one by one. Also get it turned off in the admin interface ASAP.