MySQL

Abstract

The MySQL plugin allows you to perform some maintenance tasks on your DotClear database through a web interface.

This release lets you:

Optimize

A MySQL database can be seen as a set of files. Each deletion or modification adds fragmentation to it.

The Optimize operation performs an OPTIMIZE TABLE request on every DotClear table in order to compact them.

On most setups, you do not have to use Optimize daily. Even if you often update your posts, it is enough to launch this procedure on a monthly basis.

Such a procedure has no impact whatsoever on your data's integrity. It is totally risk-free.

backup

One cannot repeat too often how important it is to make regular backups of your data.
With the Backup procedure, it has no more reasons to not become an automatism.

This procedure creates a complete "dump" of your DotClear database. We call "dump" a SQL script containing the instructions to recreate your DotClear database.
This file is gzip compressed to save space.

Should you wish to do so, this dump still can be used directly in phpMyAdmin.

Immediate download
This option allows you to select whether your wish the plug in to save the dump or to download it.
The default setting is to have it checked, you directly download the file on your computer and there is no local save on the server.
By unselecting it, the file will be saved to a mysql/ sub-folder in your DotClear share/ folder.

Restore

It is the opposite of the backup procedure. This one allows you to load a backup file in the eventuality of a problem with your MySQL database.

Hopefully, it should be the less used procedure of this plugin.

The restore runs every SQL request of the dump file. It means that every piece of data still to be found in your DotClear database will be overwritten.
The users accounts will be affected too.

Dumpfile to restore
Use the browse... button to select, on your hard drive, the SQL dump to restore.