Welcome to Geeklog, Anonymous Friday, September 20 2024 @ 02:31 am EDT

Geeklog Forums

Doing an upgrade...some questions


Status: offline

ScottMcW

Forum User
Chatty
Registered: 09/22/02
Posts: 42
Hi all,

I'm finally upgrading from 1.3.7r1 to 1.3.8r3. I'm also ditching IMHosted (avoid them like the plague, btw) and going to a new host. I have the Forum and Menu plugins installed.

So, what's my best plan of attack? Should I:

a) Do a fresh install at the new host and then run some sql update scripts

or b) Install 1.3.7r1 on the new host, and do an official upgrade from there?

Any help will be appreciated!

Thanks,

Scott
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
For an upgrade, you will have to replace all the files anyway.

So I would do a backup of the database on the old site, upload the 1.3.8-1sr3 files on the new host, import the database backup and run the install script (in upgrade mode).

bye, Dirk
 Quote

Status: offline

ScottMcW

Forum User
Chatty
Registered: 09/22/02
Posts: 42
Thanks Dirk, that's the way I'll do it.

I see that my gl_user_stats table is about 67MB. Is there any reason why it would be horrible to not bring that over? Can I get away with just creating the structure of that one?

Thanks!

Scott
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by ScottMcW: I see that my gl_user_stats table is about 67MB.

That's for the stats plugin, I assume - of which I don't know anything about. Try asking the author.

bye, Dirk
 Quote

Status: offline

geKow

Forum User
Full Member
Registered: 01/12/03
Posts: 445
I just emptyed that table before I moved. In my case my (old) host-server denied the sql backup, because the gl_stats where so big.

You should maintain your user stats using the sql files in the archive to delete the months you don't need anymore. btw: I think this is a real disadvantage of the user stats plugin, the lack of a webinterface

geKow
 Quote

Status: offline

ScottMcW

Forum User
Chatty
Registered: 09/22/02
Posts: 42
aha! Thanks for the clarification Dirk! I was able to move along quite well without that table. *phew*

Looks like the upgrade is going pretty smooth. Thanks again for all the great help and support from everyone!
 Quote

Status: offline

ScottMcW

Forum User
Chatty
Registered: 09/22/02
Posts: 42
Just wanted to post again that I killed over 210,000 rows of data that had collected in that stats table since May of 2003! I guess I missed the part of the instructions on that Plugin that tells you to clean the stats out once in awhile. MAJOR speed increase!

Thanks again!

Scott
 Quote

All times are EDT. The time is now 02:31 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content