UBB.threads PHP Forum Software Community Forums Resources and Customizing Tutorials and Guides Proper Upgrade Route - Within UBB.Threads 7.x

1. Download the latest build from the members area.
2. Extract the archive to your hard disk (or to the server with any available utilities).
3. Upload (or move) all files EXCEPT for the cache_builders/custom, includes and styles directories.
4. Ensure chmods. All directories should be 777. All files should be 666.
5. After uploading (or moving) all directories, and ensuring all chmods are correct, run the install/upgrade.php script.
6. After you've gone through the upgrade procedure in the upgrade.php file, be sure to REMOVE the install and importers directories.

NOTE Please be sure to create a backup of your database and files before upgrading your installation; the upgrade should happen without a hitch, however, it's better to be safe than sorry...

Not sure about line 4 - I would be wary about making all directories 777 and all files 666.

What about language files?

I'm not too sure about this but if you make any changes to the language files will they be overwritten when you upload the upgrade?

When you go through the upgrade process it displays a page with language file changes and asks you if you want to update them.

I'm a little confused about this process.

I'm basing #4 off of the install instructions; in fact I prefer files 644 and directories (other than cache and templates/compiled) 755.

@Scriptkeeper
Language files and templates must be 666 if you plan to use the web-based editors on them.

I don't edit my wordlet fiels, so I'm unsure as to if they're updated completely

Sorry - what I meant was the instructions do not mention directories such as scripts, libs etc.. So not sure if we should be doing a blanket change to 777/666

According to initial statements "everything" should be 777/666; personally I say that nothing should be... IF you PLAN to use the built in editors, I myself would recommend chmods of the template files 666 and wordlet files 666 but other than that, I would recommend for securities sake to only have them 755/644.

Just wanted to add...

Careful overwriting your graemlins and posting icons if you've replaced them with custom ones...

Yeh, for users who insist on customizing their graphics, you should create a new folder with your own images, so that an upgrade does not overwrite your graphics...

What's wrong with this upgrade route?

Upload the install directory
get install\upgrade.php in your browser
replace/remove/add the files that upgrade.php mentions
follow the next steps
Done...

Nothing that i can see

That route works as well, the route mentioned here is the "quickest"/"most safe" way in my opinion, and is that which Rick has everyone do... A lot of people will get quite lost with your route

I would be lost with the first one

My board utilizes a lot of hacks. It saves a lot of time re-hacking files that were not changed in the first place.

True, but keep in mind that most people hardly grasp how to run their own site, let alone modify basecode or install hacks :x...

I would also recommend a backup of both your files and your database prior to any upgrade - better to be safe than sorry

(of course the upgrade should go fine, but every webhost is different)

Added

When backing up the MySQl table is the control panel option a sufficient tool for full restoration.
The reason I ask is that MYSQl is new to me and my host has me on a Windows2003 box.
With 7.2 coming out of beta I want to upgrade but I have not been able to educate myself on MySQl well enough yet to feel comfortable. using the tools provided by my host

You would want to backup the whole database not just a table.

That is my question. In the UBB control panel if I select the All Tables option it creates a file for each table in the backup directory. Is that the same as backing up the whole database to restore UBB?
Or do I need to use something else.
I believe my host is providing PHPADMIN ? but I have not been through all the docs yet.

The backup tool within the UBB.threads control panel is kind of the last resort you'd want to use. It's the slowest method to do a backup and is there for those cases that there is no other method available. It works, but it's pretty slow.

If your host is providing phpadmin, then that would definitely be a better option.

Even if they don't have phpAdmin they must have another tool like it within the Main Website Control Panel. The same place you would have been when you created the original database.

Either there or another location within the Website Control Panel (not the UBB control panel) and find one that does database backup. You should also find one that backs up the entire Website which you should run once in a while as your host provider may not be backing up your data, often it's up to you.

I already back up the web files FTP but the MYSQl database (New to me) is on another server. Just anxious after upgrading from Classic and wanted to make a backup. So you are telling me that the UBB control panel will only backup the tables even with the all tables option selected. To make a full backup I need another tool such as PHPADMIN. Back to the PHPADMIN DOC files I guess. Where is the match for the candle.

It'll make a backup of all the tables if you select all, it will just be a very slow process.

do you know the flavor of control panel they gave you with your domain account?

cpanel, plesk ?

if either one of them, then you'll have phpMyAdmin there. and then you select your Database, then Export..

probably enable gzip to a file.. and let er rip

My control panel is HELM
There is a tool called PHPMYADMIN but it just seemed easier at this piont to use the UBB control panel. The board looks to be only about 15MB so that is not that big of a deal to download the backup folder. But if the UBB tool will not provide me with a complete backup I will just read and read til I learn it.

15mb is no biggie.. you are fine then..

i'm still stuck (in my brain) on the 1.5gb database that i just finished upgrading..

phpmyadmin couldn't even deal with it.. i had to go to the console and do it..

good luck!!

If you're on a Linux/Unix machine, you can use the Command Line tools via SSH to create a database dump (backup of the mysql database) by inserting the command:

If you wish to compress the above output so that it's easier to transfer around, then you can do:

If you've compressed the output and would like to decompress it, then you can run:
(the output will extract as databasename/databasename.sql)

And to restore said backup, after you purge data out of the MySQL database:

if you're going 'geek', then go all the way. i'd pipe that through gzip also, mr. giz

You know, I was thinking about saying "if you'd like to compress the output, then run..." but figured it'd be above a lot more people... But I'l update none the less!

No Gizmo I am not on a Linux/Unix box I am on a windows 2003 box so???
I will wait on the upgrade Monday and hope for the best. meaning I will read the PHPMYADMIN docs till I am blue in the face. You guys make me wary of upgrades.

Well, I'm not a windows guy so i'm not 110% sure of your options; I think that with the size of your database it'd be best to use PHPMyAdmin; it's not recommended for larger databases (100mb+) as it'll die and you'll end up with an incomplete archive

Gizmo, in step #3, is it correct that at this stage all the old files are being over-written by the new ones?

This is a first for us - we've only done new installations, not upgrades. So forgive the questions.

Yes, in step3 you are over writing the old files with the current ones.

Questions always welcome; it's why this thread isn't in the FAQ and instead is a sticky of this forum

I am following thse instructions - I have no upgrade.php file that I can find and it wants to create new tables as I am doing this. This does not seem correct - any help would be greatly appreciated.

Travis

The upgrade.php file should be in your /install folder

And if there is no upgrade.php file in the install/ directory, you didn't upload all of the files from the install archive.

remember to delete the the install folder again, once you have upgraded

Get a windows platform for heck sakes

Windows? for what? :x

Sorry if this has been asked before but:

I'm currently on Version: 7.2.2/Linux and am about to upgrade to 7.3.1. Is the documentation located here https://www.ubbcentral.com/doc_upgrade7.php the latest?

Thanks

There isn't much change at all in the upgrade route within UBB7