UBB.Developers Forums General Discussion Suggestions and Feedback Upgrade

ok guys i got a wierd question i got an old copy of wwwthreads 5.0.9 unnning and i want to upgrade it to 5.1.5 the latest version i know all i got to basicly do is copy over the files now as far as the data base what do i do do i need to create a new one or can i just import that one ????

In your upgrade package you will receive some files called altertable*.pl or altertable*.php depending on the version you're running. These files can be executed by you, on the command line or through the broswer (again, depending on the language version you're running), and they contain all the code necessary to alter the structure of your tables to suit the upgraded version and convert all the data to be compatible with the new table structures.

In your case, the two files you'd be looking at running are, in the perl example:

altertable-5.0.9-5.1-pro.pl
altertable-5.1.1-5.1.2-pro.pl

similar files exist if you're running the php version.

Then, after you update your tables, all the new files you copied over should work fine.

As with any major change to your database, ALWAYS back up your data in case of error.

mysql -hyourhost -uusername -p mydatabase > /path/to/mydumpfile.sql

---------
Shalazar
www.charisma-carpenter.com

Ooooppss

"mysql -hyourhost -uusername -p mydatabase > /path/to/mydumpfile.sql"

That should be:

mysqldump -hyourhost -uusername -p mydatabase > /path/to/mydumpfile.sql

I think you forgot the dumo in that command....right?

Brew
OldHouseForums.network

Brew -

Thanks for your proof-reading skills. Can't believe I missed that part. If I could edit my previous post to make it correct, I would, but it won't let me. I got so used to running my dumps through a cron script, and restoring by hand with the mysql command, I guess I just got used to one over the other.

mysqldump -hyourhost -uusername -p mydatabase > /path/to/mydumpfile.sql

Sorry! And thanks again for catching that :)

---------
Shalazar
www.charisma-carpenter.com

That's alright Shalazar look at what I did.....

Here I was.....pointing out a small typo and what did I do?

Mis-spelled dump..!

I spelled it dumo.........

LOL

Brew
OldHouseForums.network

Don't forget to visit the support library. There are several docs in there, among others the one that explains upgrades.

http://www.wwwthreads.com/support/index.html

- Six
[email protected]
mYth productions