#888 Database backup

[Wes Groleau]

Add an option to the backup page to backup the actual database. Possibly based on the open source code in Nucleus ( http://www.nucleuscms.org ). What the Nucleus code does, if invoked from the administrator's page,
is to create a file containing all the SQL to restore the database.

For each table, there is a DROP TABLE IF EXISTS, then a CREATE TABLE, then all the INSERTs needed to exactly duplicate the data that was there at the time of backup.

The only thing nucleus is missing is a command at the beginning to set the correct default character set. If you are rebuilding a damaged database, you don't need that, but if you create a new one, the PGV setting (presumably UTF-8) is probably not the default.

[Alain]

Logged In: YES
user_id=1651401
Originator: NO

Hi,
What about this request feature?

In addition, it would be great to autotomize the database backup with frequency parameters (every days, every week, every mondays or tuesdays or ...., at determined hour. The name of the backup would be based on the date and the time of the backup.

thanks