This shows you the differences between two versions of the page.
en:linux:mysql [2011/01/15 22:06] matthieu [Script mysql dump] |
en:linux:mysql [2011/10/04 21:42] (current) matthieu |
||
---|---|---|---|
Line 79: | Line 79: | ||
Another way is the reconfigure the package : | Another way is the reconfigure the package : | ||
>dpkg-reconfigure mysql-server-5.1 | >dpkg-reconfigure mysql-server-5.1 | ||
+ | |||
+ | ===== Make mysql available remotely ===== | ||
+ | |||
+ | By default, Mysql is only listening on 127.0.0.1. To make it available to other computers, comment the following line inside ///etc/mysql/my.cnf// : | ||
+ | bind-address = 127.0.0.1 | ||
===== Script mysql dump ===== | ===== Script mysql dump ===== | ||
Line 100: | Line 105: | ||
* /etc/mysql/ | * /etc/mysql/ | ||
* /var/lib/mysql/ | * /var/lib/mysql/ | ||
+ | * /var/log/mysql/ | ||
dump mysql : | dump mysql : | ||
* /etc/cron.d/exportdb | * /etc/cron.d/exportdb |