Importing SQL File Error (Website Move)

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , , , , , ,

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • 06/17/2014 at 8:53 pm #294108
    Alaina
    Guest

    Hello!

    I was trying to move my website from WAMP to my staging url. However, when I went to import the SQL document to phpMyAdmin, it couldn’t import the Connections tables. This is the error I received:
    #1214 – The used table type doesn’t support FULLTEXT indexes

    Is there something I’m doing wrong or is there no way to import the connections files from my localhost/WAMP?

    Let me know if you need more information.

    Thanks!

    06/18/2014 at 8:59 am #294164
    Steven Zahm
    Keymaster

    @ Alaina

    Sound like the version of MySQL installed on the server is an older version. Switch the default storage engine to MyISAM before you import. Older versions of MySQL the storage engine needs to be MYISAM instead of InnoDB so FULLTEXT indexes can be supported.

    Hope that helps!

    07/13/2014 at 3:47 pm #296920
    Alaina
    Guest

    Thanks for your reply! It does help, but I don’t know if I know enough to go in and make these changes. I may just have to re-enter the information.

    07/13/2014 at 4:20 pm #296921
    Alaina
    Guest

    I actually figured it out! Now, however, nothing is showing up in the plugin on the WP Dashboard.

    Thoughts?

    07/14/2014 at 11:28 am #296933
    Steven Zahm
    Keymaster

    @ Alaina

    Are the tables using the same prefix as the other tables in your WordPress database? The default is wp_. If the table prefixes do not match, then nothing will show up on the dashboard.

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

You cannot reply to this support topic. Please open your own support topic.