This tutorial assumes that Drupal5.x was installed using the same database as Postnuke.
Please download pn_2_drupal.txt from:
http://drupal.knet.ca/tutorial_files/pn_2_drupal.txt
1. Connect to the MySQL Database Management website (PhpMyAdmin) by connecting to one of the following websites:
If you have a domain name like http://www.yourname.com (.ca, net, org) connect to http://unmanaged.knet.ca/phpmyadmin
If you have a domain name like http://yourcommunity.firstnation.ca connect to
http://unmanaged.knet.ca/phpmyadmin
If you have a domain name like http://yourschool.firstnationschools.ca connect to
http://www.firstnationschools.ca/phpMyAdmin/
2. Enter the MySQL username and password supplied to you during registration.
3. On the left hand side, find your database in the drop down menu and select it.
4. In the new window, on the right side, select the tab that is marked SQL.
5. We are ready to insert the script that will transfer everything over. Open the pn_2_drupal.txt file in Notepad. Try right clicking the file and selecting Notepad if it isn't your default txt editor. It's very important to open this file up in Notepad because other editors will add hidden formatting characters that MySQL doesn't like
6. Now it's time to find Waldo. In the top lines in the script, find and replace "yourdatabase" with your database username. It shows up twice only. Click Save. Highlight everything and select copy or enter the following short cut keys, hit CTRL+A then CTRL+C.
7. Open up the browser window for PhpMyAdmin. Right click and paste or hotkey CTRL+V the script into the field provided. Click Go. If it works MyPhpAdmin will let you know. Confirm the script worked by connected to your Drupal website to view the new users and story content was added.
This concludes this tutorial.
Please download pn_2_drupal.txt from:
http://drupal.knet.ca/tutorial_files/pn_2_drupal.txt
1. Connect to the MySQL Database Management website (PhpMyAdmin) by connecting to one of the following websites:
If you have a domain name like http://www.yourname.com (.ca, net, org) connect to http://unmanaged.knet.ca/phpmyadmin
If you have a domain name like http://yourcommunity.firstnation.ca connect to
http://unmanaged.knet.ca/phpmyadmin
If you have a domain name like http://yourschool.firstnationschools.ca connect to
http://www.firstnationschools.ca/phpMyAdmin/
2. Enter the MySQL username and password supplied to you during registration.
3. On the left hand side, find your database in the drop down menu and select it.
4. In the new window, on the right side, select the tab that is marked SQL.
5. We are ready to insert the script that will transfer everything over. Open the pn_2_drupal.txt file in Notepad. Try right clicking the file and selecting Notepad if it isn't your default txt editor. It's very important to open this file up in Notepad because other editors will add hidden formatting characters that MySQL doesn't like
6. Now it's time to find Waldo. In the top lines in the script, find and replace "yourdatabase" with your database username. It shows up twice only. Click Save. Highlight everything and select copy or enter the following short cut keys, hit CTRL+A then CTRL+C.
7. Open up the browser window for PhpMyAdmin. Right click and paste or hotkey CTRL+V the script into the field provided. Click Go. If it works MyPhpAdmin will let you know. Confirm the script worked by connected to your Drupal website to view the new users and story content was added.
This concludes this tutorial.
Last modified: Thursday, 20 March 2008, 10:08 AM