Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 11 to 11 | ||||||||
(as root, connected to mysql database) select host, user, password from user; | ||||||||
Added: | ||||||||
> > | SHOW VARIABLES LIKE 'version'; | |||||||
show databases; show tables; describe table_name; |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Deleted: | ||||||||
< < | http://www.mysql.com/ | |||||||
Small, fast database for simple tasks like providing services to web servers. | ||||||||
Added: | ||||||||
> > | People who are concerned about Oracle's actions are moving to MariaDB: https://mariadb.org/ | |||||||
http://dev.mysql.com/doc/
|
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 13 to 13 | ||||||||
show databases; show tables; | ||||||||
Changed: | ||||||||
< < | describe table; | |||||||
> > | describe table_name; | |||||||
Debugging "access denied" errors: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html | ||||||||
Added: | ||||||||
> > | Character Encoding
http://www.bluebox.net/about/blog/2009/07/mysql_encoding/
Amazon RDS uses latin1 encoding by default, you need to explicitly configure UTF-8: http://matthew.mceachen.us/blog/howto-configure-an-amazon-rds-instance-to-use-utf-8-925.html
mysql> show table status like 'tablename' \GNote that Ruby's mysql gem doesn't respect the table's encoding, but mysql2 does. | |||||||
Replication
troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 17 to 17 | ||||||||
Added: | ||||||||
> > | Debugging "access denied" errors: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html | |||||||
Replication
troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 24 to 24 | ||||||||
show master status; | ||||||||
Changed: | ||||||||
< < | show slave status; | |||||||
> > | show slave status \G; | |||||||
Mac OSX |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 17 to 17 | ||||||||
Changed: | ||||||||
< < | Replication Troubleshooting | |||||||
> > | Replication | |||||||
Changed: | ||||||||
< < | http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html | |||||||
> > | troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html purge binary logs: http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html show master status; show slave status; | |||||||
Mac OSX |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 17 to 17 | ||||||||
Added: | ||||||||
> > | Replication Troubleshooting http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html | |||||||
Mac OSX
/Library/StartupItems/MySQLCOM/MySQLCOM |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Changed: | ||||||||
< < | http://www.mysql.com/doc/en/index.html - manual | |||||||
> > | http://dev.mysql.com/doc/ | |||||||
mysql --host=host --user=user -p database |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 17 to 17 | ||||||||
Changed: | ||||||||
< < | MAC | |||||||
> > | Mac OSX | |||||||
/Library/StartupItems/MySQLCOM/MySQLCOM | ||||||||
Line: 30 to 30 | ||||||||
Maatkit http://www.maatkit.org/ - need to look into these tools, they look useful. | ||||||||
Added: | ||||||||
> > | OurDelta An alternative distro with some useful patches applied: http://ourdelta.org/ | |||||||
\ No newline at end of file |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 22 to 22 | ||||||||
/Library/StartupItems/MySQLCOM/MySQLCOM
Installs into /usr/local/mysql by default.
\ No newline at end of file | ||||||||
Added: | ||||||||
> > | Deadlocks You'll get lots of them: http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html Maatkit http://www.maatkit.org/ - need to look into these tools, they look useful. |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Line: 17 to 17 | ||||||||
Added: | ||||||||
> > | MAC | |||||||
Changed: | ||||||||
< < | -- TobyCabot - 20 Mar 2004 | |||||||
> > | /Library/StartupItems/MySQLCOM/MySQLCOM
Installs into /usr/local/mysql by default. | |||||||
\ No newline at end of file |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
mysql --host=host --user=user -p database (as root, connected to mysql database) select host, user, password from user; show databases; show tables; describe table;-- TobyCabot - 20 Mar 2004 |