What is the database?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
DuncansOneLove
Registered User
Posts: 31
Joined: Wed Mar 24, 2004 12:49 am
Location: www.closetoblue.net/jay
Contact:

What is the database?

Post by DuncansOneLove »

Hiya,

What is the database for what why does it keep getting bigger in size?
ronniel
Registered User
Posts: 2
Joined: Mon Mar 22, 2004 1:01 pm
Location: In a mid-life crisis!
Contact:

Post by ronniel »

It holds the data in your Forum which is changing eg. posts, signatures and the like.
wuddk
Registered User
Posts: 568
Joined: Sat Sep 27, 2003 3:51 pm
Location: #RPGzone.dk or Denmark :P
Contact:

Post by wuddk »

All posts ( even this one ) is stored in the mysql database.

Your information like, password, username, location and so on, is also stored in the database.

The folder in the FTP server, is only "creating" the site layout, and stuff like that :)
Please, do not PM me for support | support template | Proud to be able to help inhere
DuncansOneLove
Registered User
Posts: 31
Joined: Wed Mar 24, 2004 12:49 am
Location: www.closetoblue.net/jay
Contact:

Post by DuncansOneLove »

Ok so what happens if i restore the database?
User avatar
DiamondBack
Registered User
Posts: 766
Joined: Mon Jan 26, 2004 8:33 pm

Post by DiamondBack »

Did you back up a DB and now want to restore it?
ALWAYS REMEMBER TO BACKUP ANY FILE YOU ARE GOING TO EDIT ! ! !

I recommend isphost.org for free phpbb installations
DuncansOneLove
Registered User
Posts: 31
Joined: Wed Mar 24, 2004 12:49 am
Location: www.closetoblue.net/jay
Contact:

Post by DuncansOneLove »

Not that i know of. I dunno how. Does it like delete all the posts and everything?
User avatar
DiamondBack
Registered User
Posts: 766
Joined: Mon Jan 26, 2004 8:33 pm

Post by DiamondBack »

It is best not to tinker with your DB unless you are moving your forum to a new server.
ALWAYS REMEMBER TO BACKUP ANY FILE YOU ARE GOING TO EDIT ! ! !

I recommend isphost.org for free phpbb installations
DuncansOneLove
Registered User
Posts: 31
Joined: Wed Mar 24, 2004 12:49 am
Location: www.closetoblue.net/jay
Contact:

Post by DuncansOneLove »

So why does it keep getitng bigger? Is this using more space on my host?
ElbertF
Registered User
Posts: 527
Joined: Thu Mar 11, 2004 9:41 pm
Location: Australia
Contact:

Post by ElbertF »

Every new message is stored in your database, that's why it's consuming more and more space! And yes, it's using the space on your host. You can use "auto pruning" to automaticly delete old posts, and save space.
DuncansOneLove
Registered User
Posts: 31
Joined: Wed Mar 24, 2004 12:49 am
Location: www.closetoblue.net/jay
Contact:

Post by DuncansOneLove »

Yeh i know that. What happens if you restore the database though?
flogger12
Registered User
Posts: 14936
Joined: Tue Nov 25, 2003 2:13 am

Post by flogger12 »

restoring the database is only used if you lose it for some reason like a server crash, or something. or if you change hosts, you can reinstall the board on the new host and restore the old database to the new one to get all your old members, posts, etc. back.

you have to create a backup of your database before you can restore it using that backup.
it is a good idea to backup your database on a regular basis. when you do this you will have a file to keep on your computer. if the need arises you can then use that file to restore from.

everytime someone posts a message, or signs up at your board, your database will increase by the size of that message or sign up info, usually just a few bytes each.

hope this clears some of it up for you,
robert
Locked

Return to “2.0.x Support Forum”