| Author |
 Topic  |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
 Posted - 16 October 2009 : 12:47:30
|
| Hi all, we have a Mysql database and I just backed it up because were doing some work on our site, we have a fairly busy forum 130,000 posts and 250,000 archived posts. When I backed the forum up it was 125meg is that right? Seems massive to me. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 16 October 2009 : 12:52:09
|
| Cheers Ruirib. |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 October 2009 : 15:03:35
|
| Would also depend on how you backed it up. For phpmyadmin, it gives you a number of options on backing up your mysql data. Did you back up to a sql file or something else? |
Support Snitz Forums
|
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 17 October 2009 : 01:24:07
|
| Well its the first time I have ever backed it up, I used SQL Administrator, simply using the back up feature. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 October 2009 : 01:32:53
|
| MySQL Administrator will back up your database to an sql file. So yeah that size sounds about right. |
Support Snitz Forums
|
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 17 October 2009 : 12:35:28
|
| Thanks, I have noticed that the iplog is 0.9gb, is there a way to only keep a certain history of IP's via the forum admin? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 17 October 2009 : 13:21:49
|
| Cheers, I don't have ipgate installed, I guess I will have to install it. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 October 2009 : 14:50:16
|
| I think rui was assuming iplog table is related to the ipgate mod. If you don't have ipgate mod installed, what mod uses the iplog table? |
Support Snitz Forums
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 October 2009 : 15:17:57
|
As far as I know, FORUM_IPLOG is a table created by IPgate. If you are not using it, you can just delete the existing records using a SQL statement, in phpmyadmin:
DELETE * FROM FORUM_IPLOG
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 17 October 2009 : 15:18:06
|
| No idea.....now we had ipgate installed before you brought out a updated version of the forum, I guess thats what is in iplog..in this case would it be ok to just delete that from the database or should I leave well alone? bearing in mind I really don't have a clue what I am doing. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
