Can I access/create InnoDB tables in the database

  • Resolved Atxwebdesigner

    (@nuevesolutions)


    7 years ago

    Hi Team,
    I have a WordPress website on my server. I have installed CVCRM plugin on that site. I have configured database name, MySql server, and user credentials. When I click on check requirements button in the connection setting page I am getting an error like this ( Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server). Can you please look into it and let us know that what is the issue with my website?. We installed CiviCRM WP Plugin version 4.1.0

Viewing 3 replies - 1 through 3 (of 3 total)
  • MC3

    (@mc3)

    CiviCRM requires InnoDB support. It sounds like your MySQL server is not configured to provide this. If you have control over your MySQL server you should be able to enable this. If you don’t have control talk to your hosting provider to get it enabled. Best practice is to have a separate database for CiviCRM.

    Thread Starter Atxwebdesigner

    (@nuevesolutions)

    Thanks a lot to respond quickly. But I have enabled the InnoDB and configured as the default engine. Still, I am getting the same error. I tried in different servers by creating a separate database, But in all server, I am getting the same issue. I went through file permissions and given 775 for directories and 664 for files but no luck. I used Heroku server and created a ClearDB, On that server also I got the same error. I chatted with Heroku team and finally they said that this is not a problem with InnoDB, may be a problem with file permissions.

    Plugin Author Christian Wach

    (@needle)

    @nuevesolutions This is the support forum for the CiviCRM WordPress Member Sync plugin. Please post general CiviCRM support issues on StackExchange. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can I access/create InnoDB tables in the database’ is closed to new replies.