MySQL Forums
Forum List  »  MyISAM

Table Name Length Limit
Posted by: Bruce Greenblatt
Date: July 05, 2006 06:25PM

I have a table name that has 62 characters and is created OK. But, it appears to break master/slave replication. Somehow, the table does not get created in the slave db. An example of the errors that I see in the slave log is:

Slave: Error 'Table 'arkivio_sss.ark_rpt_others_data_usage_history_in_time_bucket_by_ext_latest' doesn't exist' on query. Default database: 'arkivio_sss'. Query: 'delete from ark_rpt_others_data_usage_history_in_time_bucket_by_ext_latest where gvid=1', Error_code: 1146

1146 is the error that I get when the table doesn't exist. MySQL is supposed to support 64 character table names. Other tables seem to be replicated just fine. Does the 64 character limit include the .MYD extension? Does it include the DB name?



Edited 1 time(s). Last edit at 07/05/2006 06:26PM by Bruce Greenblatt.

Options: ReplyQuote


Subject
Views
Written By
Posted
Table Name Length Limit
24715
July 05, 2006 06:25PM
9676
July 09, 2006 09:47PM
6727
July 14, 2006 09:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.