Zoeken


afdrukken pdf Nederlands
The backups of SQL bases

WARNING : 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?