By voytechs on

Sourceforge.net who hosts my OpenSource project and its website upgraded their MySQL engine to 4.1 and are forcing everyone to migrate their data. I did a little digging on drupal site and basically found out that normal mysqldump into a mysql client for a pure copy works fine. It took me just a few minutes to execute and change the config files and I'm running off of new database.

This is what I did:

1) Created the new sourceforge.net database accounts. This is done through SF.net admin pages for my project.

2) Created a new database for drupal to use on the new database server (stardard instructions found in the drupal install guide on how to create a new empty database. Just don't populate with the database.mysql script.) Permissions and all, were already setup for me by sourceforge system.

3) Copied the data from old database to new data base using the following command:

mysqldump -u jnetflow -p
-h mysql-j jnetflow | mysql -h mysql4-j -u j149342admin -p
j149342_drupal

4) Changed my sites/default/settings.php file in the drupal installation to point to the new database

and checked the web site. Its all working, articles and user accounts are all there. Perfect!!!!

Thanks Drupal team! Easy migration.....