Making a backup is really easy, and you have to do it often. So, in case of trouble of your forum, for instance if the forum was spoiled by some spammers, you can easily go back to a point in time where your forum worked correctly.
Also, a backup is necessary in case of a big mistake (“do you really want to destroy your forum, answer yes or no” – oops sorry !)
Now comes the reason of this topic. This reason is twofold.
First of all, a backup is useful only if you are sure that it’s valid. As long as you did not test your backup, you don’t know if really everything is there.
Secondly, the version of phpbb on astahost forum is 2.0.22, which is a rather old version. The forecomming version is phpbb3, currently RC7. So, you must get ready to switch from phpbb2 to phpbb3, in order to take full benefit from the new release features.
That’s why I suggest you to make a full backup of your current phpbb2 forum here at astahost, and check your backup by means of perforuming a fresh installation on another machine, and switching your fresh install to phpbb3.
The whole operation is completely harmless : you don’t touch your current installation, you only perform a backup. And, as you perform a fresh installation of a completely new machine, if you don’t like your installation you simply remove everything on the new machine.
1. FIRST STEP : BACKUP YOUR CURRENT FORUM.
Log in to your forum using the forum administrator name and password.
Then, click “Go to the Administration pannel”. Confirmation of your password will be asked, and you will be connected to the administration page. In the left-side pannel, go to the “General Admin” section and click “Backup Database”. You will be asked for the place on your PC where to download the database backup. This file, which has a name like something.sql, is the backup we will test by mean of restoring and testing it. Put this file in a safe place, it’s your security in case of huge catastrophy experienced by your current forum.
Please perform now a copy of this file, and name this copy “modified.sql”. Now we will feel free to modify this “modified.sql” file because the modifications will not affect the original file.
2. DOWNLOAD A FRESH COPY OF THE PHPBB2 AND PHPBB3 SOFTWARE.
In order to master everything, even in case of a big catastrophy, you need to have all the necessary building elements. You already have tha data in your “modified.sql” file, now you need the basic forum software.
You need to download the phpbb2 forum sofware from http://downloads.sourceforge.net/phpbb/phpBB-2.0.22.tar.gz , and the phpbb3 forum software from http://downloads.sourceforge.net/phpbb/php...C7.zip?download .
3. CREATE YOUR TESTING WEBSITE.
If you don’t have it yet, create a hosting account on another web hosting site. You don’t need a very performant site, because you just want to test your own skills and your method of backup, during a very limited period in time. This is anyhow a good idea, in order to see how astahost is better than the competitors. If you don’t know where to go in order to get a free hosting account, have a look here http://www.astahost.com/voice-review-f199.html , and especially here http://www.astahost.com/who-favourite-free-host-t10395.html .
4. INSTALL PHPBB2 ON YOUR NEW WEBSITE.
After having created your site, and verified that this site works by mean of using a browser in order to go to http://yourname.yoursubdomain.com , create two folders, the first one named “oldforum” and the second one name “newforum” on your hosted account root directory.
Locally on your pc, unpack the two files XXXgz you previously downloaded. Then, use a ftp client in order to upload the content of the PHPBB2 subfolder to the folder you named “oldforum” and the content of the PHPBB3 subfolder to the folder you named “newforum”.
Now, use the tools provided by your website provider in order to create a database and a database user. Give them names you can easily remember, like “myname_myforum”.
Using your favourite web browser, go to the subfolder name oldforum of your hosting account, it’s name is probably something like http://yourname.yoursubdomain.com/oldforum.
You will see the main screen of the phpbb2 installer. You will be asked for the database name, give the database name you decided when creating the database, the database manager you also decided, and choose the forum administrator name and password for your forum.
Continue the installation until you see that your forum is open and that people can connect and read the standard welcome messages.
Now your new phpbb2 forum is ready. It’s empty, so it’s ready for receiving your modified backup.
5. MODIFY YOUR “MODIFIED.SQL” FILE.
We are going to midify your backup, in order to remove unwanted informations.
As a matter of fact, the backup of your current phpbb2 forum at astahost has some infos concerning the way to connect to the database, as well as the exact URL of your forum programs at your current astahost forum.
These values are useless for the new forum, because you just replaced them for the values concerning the new location at the empty freshly installed phpbb2 forum.
Use your favourite word processor in order to edit the “modified.sql” backup file. Personally, I use microsoft Word, but you can use any other word processor. You will have to remove eveything concerning the phpbb_config table. Locate the line starting with “# TABLE: phpbb_config”
Remove everything between this line and the line just before “# TABLE: phpbb_forums”. Do not remove the line with phpbb_forums.
By the way, this name “phpbb_config” is the name with the default prefix name. This is subject to change to something slightly different if you happened to choose another prefix, like “myforum_” instead of “phpbb_”, you can see it easily when looking for the word “config” in the sql file.
Now you have a backup which has everything except the forum server, database and cookie informations.
6. RELOAD YOUR MODIFIED BACKUP.
These infos are the only ones currently in your new forum location. Log in to the new phpbb2 forum administration panel, and click on “Restore database”. As backup file to be restored, choose the modified.sql file.
That’s all, all the infos of your live forum are now in your new site ! You can go to the forum index and see that all your posts are there.
7. INSTALL PHPBB3 ON YOUR NEW WEBSITE.
Open your browser and give the url of the newforum where you downloaded the phpbb3 software. Answer all the questions, including the name of the database, the name of the database administrator and it’s password, the name of the forum admin and his password, as well as the table prefix. Choose phpbb3_ as prefix instead of the standard value of phpbb_ suggested by the install, in order not to have the “table already exists” error message during the table creation.
8. MIGRATE YOUR RESTORED DATABASE.
At the end of the phpbb3 standard installation, you will be asked if you want to go live, or if you want to migrate a previous phpbb2 database. Choose the migration option, you will be asked for the location of the phpbb2 forum to be converted, give the path ../oldforum.
9. THAT’S ALL.
At the end of the migration process, you will be able to see all your forums in the phpbb3 format. Connect to your new phpbb3 forum, and you will be able to see all the posts from your current phpbb2 forum.
10. CONCLUSION.
As you can verify it now, all your data from your current phpbb2 forum have been migrated to the new site with a phpbb3 forum format. You have been able to backup your forum, test your backup and update it to the newest version.
This is a very important part of the Open world philosophy. The only precious thing is your set of data, the content of the backup. You see that you are able to move it anywhere at any time. Now you do not depend from any hardware, software or hosting provider, you can put your forum on any platform, hosted by any provider on any kind of hardware or operating system, for instance you can move it to your own PC with your own web server.
Because you are free, you will be able to freely choose your hardware and software provider ; and of course you will freely choose to keep going with Astahost because it has the best price/perforcance available today !
