Take the 2-minute tour ×
Stack Apps is a question and answer site for apps, scripts, and development with the Stack Exchange API. It's 100% free, no registration required.

I have the SODDI v.11 utility (although the screen says v.10)

I also have the SODD from 092011.

When I try to import the SF/MSF data, I get:

Table 'SF.VoteTypes' doesn't exist.

It creates the SF database and the following tables:

  • posttags
  • posttypes
  • votetypes

I've also dropped the votetypes table and created the same table as VoteTypes (case sensitive), and get the same error.

share|improve this question

migrated from stackoverflow.com Dec 3 '12 at 22:46

This question came from our site for professional and enthusiast programmers.

1 Answer 1

The case sensitivity in the error message turns out to be the culprit.

I had to disable case sensitive table names in MySQL on a linux host. In the my.cnf, add lower_case_table_names = 1. Restart MySQL. This bypasses the case sensitivity of the underlying file system for storing the MySQL data.

I was on the right track by trying to maually create the table with case sensitivity, but the doc shows that the database is dropped and created, so any change I had made was dropped.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .