#sauvgarde BDD mysqldump #http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/ backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql ou bunzip2 < db_filename.sql.bz2 | mysql -u root -p target_db_name Different mysqldump group options: –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locksptions –skip-add-drop-table –no-set-names –skip-disable-keys –skip-add-locks avec gzip backup : mysqldump -u -p --quick [database_name] | gzip > database_name.gz