MySQL - Revision history

Christoph: /* Automatic MySQL backup script */

2021-02-10T00:21:23Z

‎Automatic MySQL backup script

2021-02-10T00:16:36Z

‎Install and configure

2021-02-10T00:16:23Z

‎Install and configure

2015-05-06T21:49:16Z

2014-12-18T06:57:30Z

2013-01-15T23:49:23Z

‎Configuring

2012-02-11T21:23:41Z

‎Automatic MySQL backup script

2012-02-11T21:23:00Z

‎Starting and Stopping MySQL

2009-06-16T22:40:29Z

‎Database Administration Statements

2009-06-14T01:43:48Z

@@ Line 180: / Line 180: @@
 ==Automatic MySQL backup script==
 The simplest way to automatically backup your entire MySQL database(s) (say, once a day at 02h30) is to create a [[crontab|cron job]] like so:
-2 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /backup/dir/database_`date 'Y-%m-%d'`.sql.gz
+2 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /backup/dir/database_$(date 'Y-%m-%d').sql.gz
 ''Note: For more on the <code>mysqldump</code> command, visit [http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html mysqldump — A Database Backup Program] for extensive documentation.''

@@ Line 7: / Line 7: @@
 * Debian-based installs:
   $ apt-get update && apt-get -y install mysql-server
-  $ file `which mysql_secure_installation`
+  $ file $(which mysql_secure_installation)
   /usr/bin/mysql_secure_installation: Perl script, ASCII text executable
   $ mysql_secure_installation

@@ Line 15: / Line 15: @@
   $ mysql -uroot -pmysql_password -e "GRANT ALL PRIVILEGES ON wordpress.* TO 'wordpress'@'%';"
   $ mysql -uroot -pmysql_password -e "FLUSH PRIVILEGES;"
 ==User control==

@@ Line 245: / Line 245: @@
 * If <tt>LOCAL</tt> is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full pathname to specify its exact location. If given as a relative pathname, the name is interpreted relative to the directory in which the client program was started.
 * If <tt>LOCAL</tt> is not specified, the file must be located on the server host and is read directly by the server.
 ==Howto fix "Access denied for user 'MySQL_Instance_M'"==

@@ Line 74: / Line 74: @@
 mysql> FLUSH PRIVILEGES;
 </pre>
 ==== Datadir ====

@@ Line 92: / Line 92: @@
 * Starting
 <pre>
 shell> cd INSTALL-DIR
@@ Line 105: / Line 109: @@
 * Stopping
 <pre>
 shell> cd INSTALL-DIR
 shell> ./bin/mysqladmin -u root -p shutdown

@@ Line 196: / Line 196: @@
   ...
 etc. (see: [http://dev.mysql.com/doc/refman/4.1/en/client-utility-programs.html for more])
-−
 ====Third-party====
 *[http://mtop.sourceforge.net/ mtop] &mdash; monitors a MySQL server showing the queries which are taking the most amount of time to complete.