| Author |
 Topic  |
|
cioto
New Member
Italy
95 Posts |
 Posted - 21 February 2004 : 12:25:32
|
Hello frinds, this is not a high-tech question.
Do you suggest me to do a backup of my snitz forum?
How can I do that? From the ftp or I can use some of the admin options?
The forum has been running for more than a year, with thousands of topic, but I fear some tech problem, so I'in thinking about doing a backup.
Thanks! |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
cioto
New Member
Italy
95 Posts |
Posted - 21 February 2004 : 14:57:53
|
Yes, it is Access.
But which one is the database file? |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 12:25:35
|
hmmm... they are all .asp files!
No .mdb file! |
|
|
|
Rasco
Advanced Member
Germany
3192 Posts |
Posted - 22 February 2004 : 12:29:14
|
| Maybe the file is in your database folder, otherwise look into your config.asp to see where it is. |
German Snitz Forum
|
|
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 12:43:17
|
Really thanks boys, you are so faaast!!
Ok, database found, it was in another folder (mdb-database).
It's 41 Mb!!!! Quite big!!!
So, if i want to make a backup, copying the database only, will i save ther users too? I mean the list of all the users.
Thanks for now!! |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 22 February 2004 : 12:44:10
|
Yes !
btw, your database size seems a little big considering the users and posts, have you ever compacted the database ? |
Edited by - wii on 22 February 2004 12:46:11 |
|
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 12:46:12
|
Cool!!
I have 4 "subforums", are they all included in this single file? |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 22 February 2004 : 12:47:19
|
| Yes, all forums, users and posts are included. |
|
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 12:55:04
|
No, never compacted.
How can i do that? Have I to put the forum offline while doing that?
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 22 February 2004 : 13:00:14
|
| The code does it for you. Just go into admin options and select the option to compact (it might be under the archive menu ... I can't quite remember). |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 22 February 2004 : 13:01:18
|
1. login as admin.
2. go to admin_config_features.asp and enable Archive Functions (if you havenīt already).
3. go to admin_forums.asp
4. click on Compact Database
5. close the forum
6. compact
7. re-open the forum
Thatīs it !!! if you havenīt done this before, you should notice an improvement of the performance of the forum. |
|
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 13:02:57
|
So the forum will be automatically closed. How long you think it will stay closed, considering the size of the forum?
Have I to stay connected while this is done? (I have just a modem, not a flat connection)
You are really kind  |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 22 February 2004 : 13:04:56
|
| Not more than 2 minutes or so...stay connected ! |
Edited by - wii on 22 February 2004 13:05:37 |
|
|
|
cioto
New Member
Italy
95 Posts |
Posted - 22 February 2004 : 13:24:28
|
Administrative Forum Archive Functions - Compact DB
Microsoft JET Database Engine error '80004005'
Unspecified error
/forum/admin_compactdb.asp, line 108
It gave me this error after 2 minuts of compacting.... |
|
|
|
Topic |
|
Topic Locked
