Differences
This shows you the differences between two versions of the page.
|
en:linux:mysql [2011/01/15 22:06] matthieu |
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 93: | Line 98: | ||
| 55 23 * * * root /home/scripts/export_db.sh | 55 23 * * * root /home/scripts/export_db.sh | ||
| - | :!: It's recommanded to protect the access to the exported datas : | + | :!: It's recommended to protect the access to the exported datas : |
| chmod og-rx -R /home/scripts/dump_mysql/ | chmod og-rx -R /home/scripts/dump_mysql/ | ||
| 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 | ||
