groupInfo expandAfterMode 0 groupName MySQL snippetsTE2 abbreviation mysql:file:execute abbreviationMode 1 creationDate 2013-06-23T09:26:33Z flags 0 label Executing SQL Statements from a Text File modificationDate 2013-06-23T09:28:01Z plainText mysql %fillpart:name=Database%database_name%fillpartend% < %filltext:name=File% snippetType 0 useCount 0 uuidString 65CFD01F-C1C1-4B48-AC3E-03EFCCE2056B abbreviation mysql:users abbreviationMode 1 creationDate 2013-06-23T05:46:38Z flags 0 label List MySQL users modificationDate 2013-06-23T05:46:59Z plainText SELECT User FROM mysql.user; snippetType 0 useCount 0 uuidString 2213374E-6A37-4A29-8CBC-2F6F042BE0DF abbreviation mysql:repair abbreviationMode 0 creationDate 2012-03-16T06:19:33Z flags 0 label Repaid all MySQL tables modificationDate 2012-03-16T06:19:33Z plainText mysqlrepair snippetType 0 useCount 0 uuidString 01F5A284-C905-472C-A4E2-E5EA11CB3F66 abbreviation mysql:repair:table abbreviationMode 0 creationDate 2012-03-16T06:18:52Z flags 0 label Repair MySQL table modificationDate 2012-03-16T06:19:46Z plainText REPAIR TABLE %fill:table%; snippetType 0 useCount 0 uuidString E7444480-0846-457E-905C-6D427B60D09D abbreviation mysql:check abbreviationMode 0 creationDate 2012-03-16T06:15:35Z flags 0 label Database maintenance; check & optimize MySQL tables modificationDate 2012-03-16T06:15:35Z plainText mysqlcheck -o -A -p snippetType 0 useCount 0 uuidString F85F15AF-D4B8-49E7-9EF4-41B8912387BE abbreviation mysql:db:new abbreviationMode 0 creationDate 2012-03-16T06:06:52Z flags 0 label Create new MySQL database modificationDate 2012-03-16T06:07:37Z plainText CREATE DATABASE %fill:database%; snippetType 0 useCount 0 uuidString 7F037A0B-AEDA-415A-86A3-1DC395B595BC abbreviation mysql:import:file abbreviationMode 0 creationDate 2012-03-16T06:03:30Z flags 0 label Import data from external file into a specific database modificationDate 2012-03-16T06:06:35Z plainText mysql -u %fill:username% -p -h %fill:hostname% %fill:datbasename% < %fill:file%.sql snippetType 0 useCount 0 uuidString 000357EA-BE5A-4183-9E2C-F32971B62047 abbreviation mysql:conf:backup abbreviationMode 0 creationDate 2012-03-16T04:44:31Z flags 0 label Backup MySQL config modificationDate 2012-03-16T04:44:55Z plainText cp -p /etc/my.cnf /etc/my.cnf.bak snippetType 0 useCount 0 uuidString 9B46967F-F573-4F54-91AC-E508FEE1A977 abbreviation mysql:report abbreviationMode 0 creationDate 2012-03-16T04:24:08Z flags 0 label Run mysqlreport modificationDate 2012-03-16T04:24:08Z plainText perl mysqlreport --user %fill:mysqlusername% --password %fill:password% snippetType 0 useCount 0 uuidString BA1F2B4F-91F6-48AB-BCF7-25954B58A243 abbreviation mysql:report:download abbreviationMode 0 creationDate 2012-03-16T04:21:06Z flags 0 label Download mysqlreport modificationDate 2012-03-16T04:21:22Z plainText wget hackmysql.com/scripts/mysqlreport snippetType 0 useCount 0 uuidString B78F9C44-630F-4E9A-91CE-D0E1685D88D4 abbreviation mysql:user:privelages abbreviationMode 0 creationDate 2012-03-16T04:13:08Z flags 0 label List privileges granted to a MySQL user modificationDate 2012-03-16T04:13:08Z plainText SELECT * FROM mysql.user WHERE User='%fill:username%'; snippetType 0 useCount 0 uuidString 17B136FB-81C3-47B1-A363-35E1DAD63C29 abbreviation mysql:grant:safe abbreviationMode 0 creationDate 2012-03-14T00:02:09Z flags 0 label MySQL GRANT (Drupal; safe) modificationDate 2012-03-16T04:58:03Z plainText GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `%fill:database%`.* TO '%fill:username%'@%'fill:hostname%' IDENTIFIED BY '%fill:password%'; FLUSH PRIVILEGES; snippetType 0 useCount 0 uuidString EE859CFC-7B5A-417F-BE5B-42ED246F1E79 abbreviation mysql:grant:all abbreviationMode 0 creationDate 2012-03-14T00:00:36Z flags 0 label MySQL GRANT ALL Privelages modificationDate 2012-03-14T00:03:49Z plainText GRANT ALL ON %fill:database%.* TO %fill:username%@%fill:hostname% IDENTIFIED BY '%fill:password%'; FLUSH PRIVILEGES; snippetType 0 useCount 0 uuidString 4C1F5F34-25E1-4F9C-AEA4-3C4C4000A869 abbreviation mysql:dump abbreviationMode 0 creationDate 2012-01-02T16:50:10Z flags 0 label Export "dump" data to SQL file modificationDate 2012-03-16T06:05:07Z plainText mysqldump -u %fill:username% -h %fill:hostname% -p %fill:dbname% > %fill:dbname%_%Y%m%d-%H%M%S.sql snippetType 0 useCount 0 uuidString 1ABE5A42-E369-4419-A7C4-0DC99FDFF52A abbreviation mysql:dump:gzip abbreviationMode 1 creationDate 2012-01-02T16:46:47Z flags 0 label Export and compress "dump" data to SQL file lastUsed 2012-03-03T01:52:03Z modificationDate 2012-03-16T06:05:14Z plainText mysqldump -u %fill:username% -h %fill:hostname% -p %fill:dbname% | gzip -9 > %fill:dbname%_%Y%m%d-%H%M%S.sql.gz snippetType 0 useCount 2 uuidString F5A7F01E-0D9F-4AF1-BA5C-4B30E437C353 abbreviation mysql:import:file:new abbreviationMode 1 creationDate 2012-01-02T16:44:22Z flags 0 label Import data from external file lastUsed 2012-03-13T23:44:31Z modificationDate 2012-03-16T06:04:14Z plainText mysql -u %fill:username% -p -h %fill:hostname% < %fill:file%.sql snippetType 0 useCount 0 uuidString 2959C995-021C-4DFE-8468-8A365A90CB76 abbreviation mysql:import:sql abbreviationMode 1 creationDate 2012-01-02T16:41:49Z flags 2 label Import data from external file (SQL) modificationDate 2012-03-16T06:04:29Z plainText SHOW DATABASES; DROP DATABASE %fill:dbname%; CREATE DATABASE %fill:dbname%; USE %fill:dbname%; SOURCE %fill:file%.sql; snippetType 3 useCount 0 uuidString 2957845C-8320-4FF2-BF55-74B6E1E21CA3 abbreviation mysql:sql:format abbreviationMode 1 creationDate 2012-01-02T16:40:16Z flags 2 label Fromat SQL column results nicely modificationDate 2012-03-16T06:05:32Z plainText %clipboard\G snippetType 3 useCount 0 uuidString DF62CBC3-23D5-4006-B51B-4E6CA5A959CC abbreviation mysql:version abbreviationMode 1 creationDate 2012-01-02T08:20:24Z flags 2 label Get MySQL version modificationDate 2012-03-16T06:05:46Z plainText mysql -v snippetType 3 useCount 0 uuidString 0EDE4ACE-89A2-4FC5-BDED-BF8A17D75F3A abbreviation mysql:root:password:reset abbreviationMode 1 creationDate 2011-12-31T01:37:25Z flags 2 label Chage the root user password for MySQL modificationDate 2012-03-16T06:05:55Z plainText /usr/local/mysql/bin/mysqladmin -u root password ’%fill:password%’ snippetType 3 useCount 0 uuidString A2C164DE-EDB0-40A9-B0D3-E07CF12EF382