SmartFAQ is developed by The SmartFactory (https://www.smartfactory.ca), a division of InBox Solutions (https://www.inboxsolutions.net)

How do I maintain a database?
With great care.

Seriously though - this is hard to answer without knowing what kind of connection to the database you have. If it's on a hosted web server you most likely only have access to it through PHPMyAdmin or a similar tool.

If it's your own server you can use pretty much any type of tool to connect to the database to perform maintenance tasks.

The most important thing to take care of, if your site is of any value to you, is backin up the database. If your web host doesn't back up your database then you need to do it manually. How to do this also differs depending on what access you have to the host.

PHPMyAdmin has functions that allows you to backup an entire database. It's a bit cumbersome to do it this way but it's a lot better than nothing.

Otherwise you shouldn't need to fiddle with the XOOPS database on your own, the admin interface takes care of that.


The comments are owned by the author. We aren't responsible for their content.


Login

Who's Online

232 user(s) are online (1 user(s) are browsing XOOPS FAQ)


Members: 0


Guests: 232


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Feb 29
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Did you know ?

MySQL 4.1 upwards uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients, including PHP 4.

Random question

What are kiovi, spaw, tiny editor, xoopseditor, fkceditor etc? What do they do? What is the difference between them? How do we use them?