Database: Difference between revisions From Online Manual

Jump to: navigation, search
(small version-specific)
mNo edit summary
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
SMF uses either a MySQL, PostgreSQL, or SQLite '''database''' to store all of the data on the forum.
All SMF [[post]]s, [[topic]]s, [[member]]s, settings, calendar entries, etc. are stored on the '''database'''.  [[Backup]] the database frequently in case it is damaged. See [[{{Latest docs}}Requirements and recommendations|Requirements and recommendations]] for more about the type of database you need
 
Forums using SMF 2.0 and up can use MySQL, PostgreSQL, or SQLite '''database''' to store all of the data on the forum, while SMF 1.0 and 1.1 forums may use only MySQL.
{{Version Specific
<noinclude>[[Category: SMF terminology]]</noinclude>
|version=1.1
|small=yes
}}
 
In SMF 1.1, the only supported database scheme is MySQL.
{{Version Specific
|version=2.0
|small=yes
}}
 
PostgreSQL and SQLite support with SMF was introduced in SMF 2.0.
 
 
Your '''database''' is where all of your posts, topics, members, settings and much more are stored. It is a wise idea to backup your forum database often. You should never back it up through the SMF ''[[Administration Center|admin panel]] > [[Forum Maintenance]] > [[Forum Maintenance#Backup Database|Backup Database]]''.
 
[[Category: SMF terminology]]

Latest revision as of 14:26, 10 April 2015

All SMF posts, topics, members, settings, calendar entries, etc. are stored on the database. Backup the database frequently in case it is damaged. See Requirements and recommendations for more about the type of database you need Forums using SMF 2.0 and up can use MySQL, PostgreSQL, or SQLite database to store all of the data on the forum, while SMF 1.0 and 1.1 forums may use only MySQL.



Advertisement: