By electronicmonkey on

I presently have a Drupal 5 installation in a mySQL4 database. I will like to move this into a mySQL5 database and Drupal 6. can someone advise on the easy/safe way to do this ?

⋅ Categories: Drupal 6.x

Comments

electronicmonkey’s picture

electronicmonkey commented

Any suggestion from someone who knows ?

sagar ramgade’s picture

sagar ramgade commented

Hi,
First backup your site and upgrade it to drupal 6 by following the tutorial : http://drupal.org/videocasts/upgrading-to-6

After successful upgrade take a dump of your db and import it to mysql 5 version database server.

Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form

electronicmonkey’s picture

electronicmonkey commented

1. Will a mysql4 database export to mysql5 without any issues
2. I am not upgrading site , but building a new site completely and want to move content and modules tables

sagar ramgade’s picture

sagar ramgade commented

Yes msql 4 db should work on mysql5.
I would rather suggest to take a backup first and try the upgrade before going for a new site.

Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form

electronicmonkey’s picture

electronicmonkey commented

Sounds sensible. But the problem is that Drupal 6 fails to install in the mysql 4 db ;hence the need to create another site on a mysql 5 database and import content from the previous install. See the problem ?

hershel’s picture

hershel commented

> 1. Will a mysql4 database export to mysql5 without any issues

Generally speaking, yes.

> 2. I am not upgrading site , but building a new site completely and want to move content and modules tables

I would not recommend this. Not at all. Importing D5 content tables directly into D6 will undoubtedly cause problems. Using the upgrade path, as above, is the recommended method.

electronicmonkey’s picture

electronicmonkey commented

Alternative appears to be - copy all files to a new folder and the database to a mysql 5 db and alter the connecting string in settings. And then upgrade to D6 . Does that make sense ?

hershel’s picture

hershel commented

Yes, that should work. Be sure to retain a backup of the old files and the database of course, until you have verified that the new site works.

electronicmonkey’s picture

electronicmonkey commented

problem is that the SQL file comes to a massive 50mb, Impossible to work with

hershel’s picture

hershel commented

If you are using phpMyAdmin, then use the option to zip the export. That should work and can be imported also as a zip file.