Changes between Version 36 and Version 37 of InstallationGuidelines/MySQL

Timestamp:

09/06/10 19:15:53 (15 years ago)

Author:

Fran Boon

Comment:

Admin section inc Backups

InstallationGuidelines/MySQL

@@ -79 +79 @@
 Possibly useful tips:
  * http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/
+
+== Administration ==
+Command line access:
+{{
+mysql -u root -p
+<password>
+show databases;
+\r <database>
+show tables;
+select *;
+}}}
+Dump a database to a text file (for import into another server):
+{{{
+mysqldump <database> > <database>.sql
+}}}
+Restore:
+{{{
+mysqladmin --user=root create <database>
+mysql <database> < <database>.sql
+}}}
+or
+{{{
+mysql -p
+create DATABASE <database>;
+\u <database>
+\. <database>.sql
+}}}
+
+=== Backups ===
+http://sourceforge.net/projects/automysqlbackup
+{{{
+cp automysqlbackup-2.5.1-01.sh /root/automysqlbackup.sh
+chmod +x /root/automysqlbackup.sh
+vi /root/automysqlbackup.sh
+USERNAME=root
+PASSWORD=<password>
+DBHOST=localhost
+DBNAMES="sahana"
+BACKUPDIR="/var/spool/mysql"
+}}}
+or:
+ * Use mysqlshow to extract all MySQL database names
+ * Then mysqldump to export each database to an individual flat file.
+
 == Troubleshooting ==
 Can view the list of expensive queries by editing /etc/mysql/my.cnf and uncommenting/adding: