Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
doc:veille:mysql [2007/01/19 11:08] lehobey |
doc:veille:mysql [2008/11/24 12:00] (Version actuelle) lehobey |
||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
====== Autour de MySQL ====== | ====== Autour de MySQL ====== | ||
- | ===== Plusieurs ===== | + | ===== 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://erci.no-ip.com/origine/divers/mysql/multiple-servers.html | ||
* http://www-css.fnal.gov/dsg/external/freeware/mysql_updInstall.html | * http://www-css.fnal.gov/dsg/external/freeware/mysql_updInstall.html | ||
- | ===== En cachot ? ===== | + | ==== En cachot ? ==== |
* http://www.securityfocus.com/infocus/1726 | * http://www.securityfocus.com/infocus/1726 | ||
* http://mysql.ifrance.com/archive/index.php/t-1017.html | * http://mysql.ifrance.com/archive/index.php/t-1017.html | ||
Ligne 14: | Ligne 20: | ||
* (bof) : http://www.cyberciti.biz/tips/howto-setup-lighttpd-php-mysql-chrooted-jail.html | * (bof) : http://www.cyberciti.biz/tips/howto-setup-lighttpd-php-mysql-chrooted-jail.html | ||
- | ===== Frontaux ===== | + | ==== Frontaux ==== |
* http://packages.debian.org/unstable/gnome/emma | * http://packages.debian.org/unstable/gnome/emma | ||
- | ===== Commandes ===== | + | ==== Commandes ==== |
* http://dev.mysql.com/doc/refman/5.0/en/create-database.html | * http://dev.mysql.com/doc/refman/5.0/en/create-database.html | ||
Ligne 23: | Ligne 29: | ||
* http://dev.mysql.com/doc/refman/5.0/en/mysqlaccess.html | * http://dev.mysql.com/doc/refman/5.0/en/mysqlaccess.html | ||
- | ===== Problèmes / limitations / plaintes ===== | + | * 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://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/ |