MySQL - Revision history

Xunil: /* charset! */

2015-12-15T17:33:28Z

charset!

← Older revision		Revision as of 17:33, 15 December 2015
Line 92:		Line 92:

	== charset! ==		== charset! ==

			* a good guide to debug: http://kunststube.net/frontback/

	* we all want utf now		* we all want utf now
	SET NAMES utf8;		SET NAMES utf8;

2014-04-01T13:37:28Z

Grant, utenti e privilegi

← Older revision		Revision as of 13:37, 1 April 2014
Line 61:		Line 61:
	GRANT SELECT ON test.* TO 'nagios'@'localhost' IDENTIFIED BY 'la password che vuoi';		GRANT SELECT ON test.* TO 'nagios'@'localhost' IDENTIFIED BY 'la password che vuoi';
	GRANT SELECT,DROP,CREATE,UPDATE,INSERT ON . TO user@localhost IDENTIFIED BY 'pass' ;		GRANT SELECT,DROP,CREATE,UPDATE,INSERT ON . TO user@localhost IDENTIFIED BY 'pass' ;

			* MySQL: “Access denied for user 'debian-sys-maint'@'localhost'.....
			GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'blablablaa';

	=== Select ===		=== Select ===
	SELECT		SELECT

2013-02-23T01:07:29Z

monitoriong

2013-02-08T16:48:37Z

>= 5.5

← Older revision		Revision as of 16:48, 8 February 2013
Line 142:		Line 142:
	=== re-sync slave ===		=== re-sync slave ===
	* http://blog.gurudelleccelsopicco.org/2009/09/howto-mysql-master-slave-resync/		* http://blog.gurudelleccelsopicco.org/2009/09/howto-mysql-master-slave-resync/

	~~== >= 5.5 ==~~

2013-02-08T16:48:09Z

Replication

← Older revision		Revision as of 16:48, 8 February 2013
Line 120:		Line 120:

	== Replication ==		== Replication ==
			*
			* http://www.lefred.be/?q=node/45

	* /etc/my.cnf		* /etc/my.cnf
Line 138:		Line 140:
	</syntaxhighlight>		</syntaxhighlight>

	=== >= 5.5 ===		=== re-sync slave ===
			* http://blog.gurudelleccelsopicco.org/2009/09/howto-mysql-master-slave-resync/

			== >= 5.5 ==

2012-11-13T11:59:41Z

Replication

← Older revision		Revision as of 11:59, 13 November 2012
Line 136:		Line 136:
	log-error=/var/log/mysqld.log		log-error=/var/log/mysqld.log
	pid-file=/var/run/mysqld/mysqld.pid		pid-file=/var/run/mysqld/mysqld.pid
			</syntaxhighlight>

			=== >= 5.5 ===


			<syntaxhighlight lang=bash>
			CHANGE MASTER TO MASTER_HOST='mysql-master' MASTER_PORT=3306 , MASTER_USER='replicator' , MASTER_PASSWORD='a password';
	</syntaxhighlight>		</syntaxhighlight>

2012-08-05T19:14:59Z

charset!

← Older revision		Revision as of 19:14, 5 August 2012
Line 89:		Line 89:
	SET CHARACTER SET utf8;		SET CHARACTER SET utf8;
	SET COLLATION_CONNECTION='utf8_general_ci;		SET COLLATION_CONNECTION='utf8_general_ci;

			=== conversion within MySQL ===
			ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

	=== conversion script ===		=== conversion script ===

2012-05-16T10:49:32Z

monitoriong

← Older revision		Revision as of 10:49, 16 May 2012
Line 36:		Line 36:

	multitail -e "(Connect\|Init)" -ev user /var/log/mysql/mysql.log		multitail -e "(Connect\|Init)" -ev user /var/log/mysql/mysql.log

			* logs:
			select @@log_error;

	== SQL ==		== SQL ==

2012-04-05T21:28:32Z

Backups

← Older revision		Revision as of 21:28, 5 April 2012
Line 148:		Line 148:
	Da uno all'altro		Da uno all'altro
	mysqldump -c --skip-set-charset --skip-opt --skip-add-drop-table dbname tab1 tab2 -uunutente -hunhost -p \| mysql dbname -p		mysqldump -c --skip-set-charset --skip-opt --skip-add-drop-table dbname tab1 tab2 -uunutente -hunhost -p \| mysql dbname -p

			* dump all to a gzip/bzip2 file, change the command to choose between compression methods
			mysqldump --all-databases \| gzip > mysqldump-all-databases.sql.gz
			* dump back up:
			gunzip < mysqldump-all-databases.sql.gz \| mysql -p

2012-04-05T19:06:36Z

Gentoo

@@ Line 112: / Line 112: @@
   emerge -pvtD dev-db/mysql
   emerge --config dev-db/mysql
 == Backups ==
   shell> mysqldump db_name > backup-file.sql