Advanced Settings - WowBB Administration Panel

WowBB Administration Panel

Warning:
While backup, export, restore or rebuild is in progress, do NOT close your browser window, and do nothing that could interrupt the ongoing process such as visiting another page or hitting the Refresh button. It is normal for these procedures to take a long time to finish especially when your database is big.

Backup Database:
Since databases can get quite big especially when you have a large number of users or posts, it is recommended that you do not include the search index in the backup as it can be created after restore. In addition, using gzip compression can greatly reduce the backup size.

Include search index
Compress with gzip

Backup

Export Table:
Creates a tab-delimited text file from the database table of your choice that can be opened with many popular programs such as Microsoft Excel.

Column Names

Export

Restore Database:
Allows you to restore a backup. Please keep in mind that all existing data in your database will be replaced with the data in your backup. If your backup does not contain the search index, please rebuild the search index after restore. Important: If your backup is larger than 2M then you should manually restore the backup via telnet or SSH.

Restore

Rebuild Search Index:
Use this to rebuild the search index after restore if your backup does not contain it.

Rebuild

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
SELECT * FROM wowbb_user_groups WHERE user_group_id=1
1	SIMPLE	wowbb_user_groups	const	PRIMARY	PRIMARY	2	const	1	NULL
0.0001 seconds

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
SELECT session_id FROM wowbb_sessions WHERE last_visit >= '2010-09-06 21:51:22' AND ip='38.107.191.81'
1	SIMPLE	wowbb_sessions	range	last_visit	last_visit	8	NULL	3	Using where
0.0003 seconds

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
SELECT COUNT() AS users_online FROM* wowbb_sessions WHERE last_visit >= '2010-09-06 21:51:22'
1	SIMPLE	wowbb_sessions	range	last_visit	last_visit	8	NULL	4	Using where; Using index
0.0001 seconds

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
SELECT log_id, max_online FROM wowbb_visitor_log WHERE log_date='2010-09-06'
1	SIMPLE	wowbb_visitor_log	ref	log_date	log_date	3	const	1	NULL
0.0003 seconds