====== Autour de MySQL ====== ===== Sauvegarde ===== * http://tretkowski.de/blog/archives/394-Debian-package-of-mylvmbackup.html * http://lenz.homelinux.org/mylvmbackup/ * Par PHP : http://matthewhelmke.net/index.php/2008/02/01/31-automatic-mysql-backups-using-php ===== Divers ===== ==== Plusieurs ==== * http://erci.no-ip.com/origine/divers/mysql/multiple-servers.html * http://www-css.fnal.gov/dsg/external/freeware/mysql_updInstall.html ==== En cachot ? ==== * http://www.securityfocus.com/infocus/1726 * http://mysql.ifrance.com/archive/index.php/t-1017.html * Debian * http://forum.debian-fr.org/viewtopic.php?p=28418 * (bof) : http://blog.blackdown.de/2005/03/13/updated-mysql-chroot-script/ * (bof) : http://www.cyberciti.biz/tips/howto-setup-lighttpd-php-mysql-chrooted-jail.html ==== Frontaux ==== * http://packages.debian.org/unstable/gnome/emma ==== Commandes ==== * http://dev.mysql.com/doc/refman/5.0/en/create-database.html * http://dev.mysql.com/doc/refman/5.0/en/mysqladmin.html * http://dev.mysql.com/doc/refman/5.0/en/mysqlaccess.html * http://www.think-underground.com/index.php?post/2008/04/13/Mysql-%3A-creer-un-utilisateur-et-lui-donner-des-droits-limites ==== Problèmes / limitations / plaintes ==== * http://www.davidpashley.com/blog/2007/01/09#create-index * http://use.perl.org/~Smylers/journal/34246 ==== Comptes utilisateurs ==== * http://www.debian-administration.org/articles/39 * http://dev.mysql.com/doc/refman/5.0/fr/user-account-management.html * http://dev.mysql.com/doc/refman/5.0/fr/adding-users.html * GRANT : http://dev.mysql.com/doc/refman/5.0/fr/grant.html * http://dev.mysql.com/doc/refman/5.0/fr/default-privileges.html ==== Synchronisation ==== * http://blog.thierrynardoux.com/index.php?2005/08/27/244-synchronisation-de-deux-serveurs-mysql ==== Sécurité (Debian) ? ==== * http://etbe.blogspot.com/2007/04/mysql-security-in-debian.html ==== mytop ==== * http://debaday.debian.net/2007/12/26/mytop-a-top-clone-for-mysql/ ==== Plus grosse table ===== * http://www.sourcecode.de/content/how-determine-largest-table-your-mysql-database ==== proxy ==== * http://tretkowski.de/blog/archives/419-Init-Script-for-MySQL-Proxy-in-Debian.html ==== Mots de passe en PHP ==== * https://www.comefrom.de/blog/index.php?/archives/4-Changing-MySQL-user-password-with-PHP.html ===== Ressources ===== * http://www.j0k3r.net/mysql-administration-mysql-3.html * Création : http://www.enricozini.org//2007/tips/create-mysql-db.html ==== Documentations ==== * http://www.linux-pour-lesnuls.com/adminmysql.php ===== PhpMyAdmin ===== * http://www.phpmyadmin.net/home_page/index.php * Base distante : http://www.linux.com/feature/130016 * http://pagesperso-orange.fr/philippe.baucour/pratiquer/mysql/configurationeasyphp.html ===== PhpMinAdmin ===== * http://phpminadmin.sourceforge.net/