====== Introduction ====== ====== Serveur ====== ===== Installation ===== ===== Configuration ===== old_passwords=0 max_connections=300 max_user_connections=150 innodb_buffer_pool_size=4096M query_cache_size=256M query_cache_limit=4M ===== Réplication des bases de données ===== ===== Sauvegarde des données ===== ==== Export ==== # mysqldump -p --add-drop-table --add-drop-database --all-databases > /mnt/save/mysql-dump.sql ==== Import ==== # mysql db_name < backup-file.sql ====== Client ====== ====== phpMyAdmin ======