Step-by-step import of Omeka to MySQL?


Newbie here. Can someone please help me with step-by-step importation of the Omeka .zip file to MySQL DB?

“If you have command-line access to your server, you can upload the Omeka .zip file and unzip it on the server.”

I tried using the “data import” tab in the Work Bench, and received the error:

ERROR at line 1: ASCII ‘\0’ appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII ‘\0’ is expected

I’m not sure how to do that, and googling the problem produced posts instructing to unzip the file first. However, after I unzip, it seems impossible to upload an entire folder.


You wouldn’t import any SQL manually to install Omeka, you just fill in credentials for your database and navigate to the installation on the web and we’ll present an installer that will create all the necessary tables and data in MySQL.