StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20808218
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-12-27T21:42:11.390
FavoriteCount
0
LastActivityDate
2013-12-30T16:34:14.737
LastEditDate
2013-12-30T16:34:14.737
LastEditorUserId
2250252
OwnerUserId
2250252
ParentId
20800457
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
Most obvious posibilities: <ul> <li>error in my.cnf -- I would need to see exactly what is in your my.cnf file</li> <li>my.cnf is in the wrong location</li> <li>mysql server doesn't read my.cnf because of the command-line settings</li> <li>mysql server overrides the settings from my.cnf with the command-line settings</li> </ul> Show what's in your my.cnf file, what's its path, and how exactly you restart the server, and I will ellaborate on my answer. UPDATE: You shouldn't use value "2" on UNIX (or any system that has case-sensitive file system) From the manual (<a href="http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html</a>): <blockquote> If you are using MySQL on only one platform, you do not normally have to change the lower_case_table_names variable from its default value. However, you may encounter difficulties if you want to transfer tables between platforms that differ in file system case sensitivity. For example, on Unix, you can have two different tables named my_table and MY_TABLE, but on Windows these two names are considered identical. To avoid data transfer problems arising from lettercase of database or table names, you have two options: Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you do not see the names in their original lettercase. Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect. Exception: If you are using InnoDB tables and you are trying to avoid these data transfer problems, you should set lower_case_table_names to 1 on all platforms to force names to be converted to lowercase. </blockquote> What are you trying to accomplish? Why do you want to set it to 2?
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUpdating variables in my.cnf
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMarjeta
UserOwnerUserId
1. USMarjeta
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POUpdating variables in my.cnf
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COI've updated the question with my.cnf content and also its location. I've tried both `/etc/init.d/mysql start or stop` and MySQL Workbench to restart servers. You mention about **command-line settings**, how to verify these settings?
 singulars
 PostPostId
 PO
 UserUserId
 USKaushik
2. COSome people start the server with a script or through a command line. If you start it as a service, you don't have any command line parameters; only my.cnf
 singulars
 PostPostId
 PO
 UserUserId
 USMarjeta

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.