How to upgrade from version 1.2 to version 2.0 without losing data - METHOD 2

Written by Hristo Genev Tuesday, 01 December 2009 15:20

News - Documentation

The second method (whichВ  I find easier) is also devided into 3 steps. It does not include any file deletion, but you will have to do some database manipulations. We are going to copy apoll 1.2 table and convert it into a apoll 2.0 compatible one. Then we are going to do a normal uninstall/install.

Requirements:

• Installed Apoll 1.2
• Access to your database via phpMyAdmin or other tool for database administration.
• Downloaded Apoll version 2.0

Step 1: BACKUP! BACKUP! BACKUP! Backing up your site database is very important in case something goes wrong;

Step 2: For this example we're going to use phpMyAdmin;

1.1 Download this sql script file;

1.2 Find out what is the prefix of your database. By default Joomla uses the 'har_' prefix, but it could be any other. If your db prefix is 'har_' you may skip the next step;

1.3 If your database prefix is not 'har_', open the downloaded file - upgrade-to-2-0.zip, extract it and open it using any text editor. Replace each occurrence of 'har_' with the prefix of your database. Save it as a *.sql file;

1.4 Go to phpMyAdmin - Import and browse for the file upgrade-to-2-0.sql which you just saved. When you find select it and hit "Go".

The script should create Apoll 2.0 database fields and import old polls. If you get "Import has been successfully finished, 8 queries executed." that means that everything was ok. Your apoll database is copied and ready to use by the new version of the component.

Step 3: Uninstall Apoll 1.2 the way you normally uninstall components and install Apoll v. 2.0;