Difference: MySqlNotes (9 vs. 10)

Revision 1008 Jul 2013 - TobyCabot

Line: 1 to 1
 
META TOPICPARENT name="DatabaseTips"
http://www.mysql.com/
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' \G

Note 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

View topic | History: r12 < r11 < r10 < r9 | More topic actions...
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding The Caboteria? Send feedback