The backups of SQL bases
: These backups only work on MyISAM tables. InnoDB tables are not compatibles with the snapshot system that we use.
The backups of your bases are automatically carried out:
- one of the last night (at about 4am),
- one of the last week (from the Sunday backup).
You may access to these backups by modifying the name of the base in phpMyAdmin:
- [name_of_the_base]-n for the night backup,
- [name_of_the_base]-s for the weekly backup.
The SQL server, the user name and the password of the base remain the same as the ones of your base.
Warning: You can only 'SELECT' on theses backups, you have no write-access.
For example:
sql base
Name of the sql base:
mysite
Sql server:
sql2
User name:
mysite
Night sql backup
Name of the sql base:
mysite-n
Sql server:
sql2
User name:
mysite
Weekly sql backup
Name of the sql base:
mysite-s
Sql server:
sql2
User name:
mysite
How to recover these backups?
You can follow the procedure at the following address:
How to save a data base?