Backing up Board

[K!nG]

Originally Posted by SweetAngel

The video was great and easy to follow. I followed each step but I still have 4.0.5 version what I began with. I don't understand where I went wrong. If you have any suggestions, I would be very interested to hear them.

I also left this message on the video forum too

Thank you in advance!

Well when i did the upgrade first time i had the same issue.... even after upgrading it was still showing me on some places that i have 4.0.8 n some places it showed me 4.1.0 what i found out was that i did the upgrade on a custom template and wat i did i deleted all those custom onez since they weren't gonna work on 4.1.0 anyways and redid the upgrade and everything went goood without any issues...also just make sure u upload all da files of 4.1.0 not just a patch

[borbole]

Originally Posted by SweetAngel

The video was great and easy to follow. I followed each step but I still have 4.0.5 version what I began with. I don't understand where I went wrong. If you have any suggestions, I would be very interested to hear them.

I also left this message on the video forum too

Thank you in advance!

Can you tell us all the steps you took to upgrade your forum?

[SweetAngel]

Originally Posted by metalguy639

I might add that its a known fact that using phpmyadmin to export your forum database will sometimes cause you to have an incomplete backup of your forum especially if your forum is really large and has a large database. Your browser will time out when using phpmyadmin and get an incomplete backup. The best way to get a complete backup of your forum is to use either MySQLDumper or use the CPanel built in option. I have a tutorial on the cpanel option here: http://www.skinsnstyles.com/xenforo/...via-cpanel.26/ Its remarkably easy to use Cpanel for the complete backup if your host has allowed this function. if not you can usually get them to turn it on for you. To restore the database from the Cpanel backup you can use BigDump usually.

Thank you I will have a look at that. I really don't know what I am doing. I am very new to this sort of thing and I paid originally for the board to be uploaded. I have never done a update. I even had to download a FTP program as I have never used one before. I am a true dummy when it comes to this sort of thing!

--------------- Added [DATE]1294527360[/DATE] at [TIME]1294527360[/TIME] ---------------

Originally Posted by K!nG

Well when i did the upgrade first time i had the same issue.... even after upgrading it was still showing me on some places that i have 4.0.8 n some places it showed me 4.1.0 what i found out was that i did the upgrade on a custom template and wat i did i deleted all those custom onez since they weren't gonna work on 4.1.0 anyways and redid the upgrade and everything went goood without any issues...also just make sure u upload all da files of 4.1.0 not just a patch

Maybe that is where I went wrong. Now come to think of it, maybe it was the patch that I download and not the whole of the upgrade. I was very confused where to download it from in the members section.

[borbole]

Originally Posted by SweetAngel

Thank you I will have a look at that. I really don't know what I am doing. I am very new to this sort of thing and I paid originally for the board to be uploaded. I have never done a update. I even had to download a FTP program as I have never used one before. I am a true dummy when it comes to this sort of thing!

--------------- Added [DATE]1294527360[/DATE] at [TIME]1294527360[/TIME] ---------------



Maybe that is where I went wrong. Now come to think of it, maybe it was the patch that I download and not the whole of the upgrade. I was very confused where to download it from in the members section.

Upgrading is very easy. You don''t need to pay anyone to do it. Make sure to first make a complete backup of your database and then follow the steps at the link above or here:

http://www.vbulletin.com/docs/html/upgrade

http://www.vbulletin.com/forum/conte...e-Instructions

[SweetAngel]

Originally Posted by borbole

Can you tell us all the steps you took to upgrade your forum?

Sure. I went exactly by the video. I had to download a FTP program. I actually downloaded three LOL One I couldn't get working. The second one kept on freezing on me. Then I downloaded SmartFTP and that seemed to work, I think. I have never used one of these programs before. I did a back up, which was easy enough done. I deleted two files as per the video. I can't remember which ones but it was the two that were in the video. I also added something to the top of the config file as per the video. I turned off my board and then transfered all the files over via the FTP program. Once that was done. I went to the install/upgrade page and went through all those steps. I think there were 6 in total. Then I went back to my board and everything worked fine. At the bottom of the board it still said that I had version 4.0.5. When I went to the admin panel at the top it still said I had 4.0.5. It looked like nothing had changed.

Ohh and I don't have any mods attached to the board, so there was nothing to turn off there.

I hope all that makes sense?

[metalguy639]

No problem. To check your database backup you can see if its complete by just downloading it to your hard drive if you have not already and double clicking on it to open it. Give it a moment because sometimes it takes a minute or two to totally load. Then scroll all the way to the bottom and look for something to the effect of:

--
-- Dumping data for table `vb3_word`
--

Yours may look like this:

--
-- Dumping data for table `word`
--

That is the end of it and it would be complete as long as you have the last table on the file.

[SweetAngel]

Originally Posted by metalguy639

No problem. To check your database backup you can see if its complete by just downloading it to your hard drive if you have not already and double clicking on it to open it. Give it a moment because sometimes it takes a minute or two to totally load. Then scroll all the way to the bottom and look for something to the effect of:

--
-- Dumping data for table `vb3_word`
--

Yours may look like this:

--
-- Dumping data for table `word`
--

That is the end of it and it would be complete as long as you have the last table on the file.

I just opened up my download that I did before trying to upgrade and it has nothing like that. The last thing it has is this

CREATE TABLE IF NOT EXISTS `visitormessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Does that mean I have not backed up my board right?

[metalguy639]

Originally Posted by SweetAngel

Sure. I went exactly by the video. I had to download a FTP program. I actually downloaded three LOL One I couldn't get working. The second one kept on freezing on me. Then I downloaded SmartFTP and that seemed to work, I think. I have never used one of these programs before. I did a back up, which was easy enough done. I deleted two files as per the video. I can't remember which ones but it was the two that were in the video. I also added something to the top of the config file as per the video. I turned off my board and then transfered all the files over via the FTP program. Once that was done. I went to the install/upgrade page and went through all those steps. I think there were 6 in total. Then I went back to my board and everything worked fine. At the bottom of the board it still said that I had version 4.0.5. When I went to the admin panel at the top it still said I had 4.0.5. It looked like nothing had changed.

Ohh and I don't have any mods attached to the board, so there was nothing to turn off there.

I hope all that makes sense?

I have not seen the video for the upgrade, but upgrading is rather easy to do. You need to follow these steps:

1. Download the latest version of vbulletin from your members area.
2. Unzip it to your hard drive (desktop most likely is easiest)
3. Look in the includes/ directory and find the config.php.new file.
4. Change the name to config.php.
5. Double click on the config file to open it (you'll need a html editor like dreaweaver, frontpage, or there are some frees ones or you can use windows built in notepad or a text editor.
6. In the file you will need to change the following items to match your info:

First find:

$config['Database']['dbname'] = 'forum';

Change it to your database name you can find this info on your old config file. Just download it from your includes directory on your site.

Then find:

$config['Database']['tableprefix'] = '';

Make sure its the same as your config file from your 4.0.5 version.

Then find:

$config['MasterServer']['servername'] = 'localhost';

Again make sure it matches your old config file.

Then find:

$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '';

Change the top one to your username for the database and the bottom to the password for the database.

Now save the file. Make sure that you ALWAYS edit between the ' and '. So if the code is

$config['MasterServer']['username'] = 'root';

Your would edit it to be:

$config['MasterServer']['username'] = 'your_username';

Always keeping the little quotes in place.

7. Now you need to delete the install.php file from your includes directory in the new files you are about to upload.

8. Turn your board off.

9. Upload all the files keeping the directory structure and order together. Make sure that you "OVERWRITE" all your old files. If you have a custom skin then do not upload the images directory.

10. After all the files are uploaded and overwritten open your browser to:

http://www.yoursite.com/forums/install/upgrade.php

Change yoursite.com to your domain and if your forum is not in a forums directory then drop the forums part from the link like so

http://www.yoursite.com/install/upgrade.php

11. Now you should see a screen asking you for your customer number. Copy and paste it in the box and click the button to start.

12. From here you just wait and let it do its thing. When its done it will tell you. Then you should be all ready to go.

--------------- Added [DATE]1294529330[/DATE] at [TIME]1294529330[/TIME] ---------------

Originally Posted by SweetAngel

I just opened up my download that I did before trying to upgrade and it has nothing like that. The last thing it has is this

CREATE TABLE IF NOT EXISTS `visitormessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Does that mean I have not backed up my board right?

Yeah actually that is very possible because you usually have to have a dump command at the end of the file. Try backing it up using the Cpanel tutorial I put a link to earlier if you have CPanel. http://www.skinsnstyles.com/xenforo/...via-cpanel.26/ If you do not have CPanel let me know and I can help you a different way to back it up.

[SweetAngel]

Wow! Ok, I am going to try your step by step instructions. Thank you so very much for laying them out for me.

But before I try that, I need to know if I am backing up correctly. What I have been doing is this.

1. Open my cpanel
2. Open phpMyAdmin
3. Click on the forum
4. Click on export
5. Unclick "comments"
6. Unclick "Complete Inserts"
7. Unclick "Extended Inserts"
8. Change the name of the file (which I usually put the date)
9. Then press go.

Is this correct?

[metalguy639]

That is not usually the way I use phpmyadmin to do a backup. Not saying it does not work, but I do not untick options on it. I do those options listed above leaving out the untick parts.

Let me ask you something, how large is your forum? How many members, posts threads?