Hello,
So glad that this forum exists. I'm in the process of creating an Omeka site hosted on Dreamhost, but my one-click installation has not worked out like I'd hoped. In trying to import the db.ini file through the phpMyAdmin on Dreamhost, I encounter an error message that reads:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Database Configuration File' at line 1
I have no background with SQL to figure out what might be wrong with the file. I've copied the text here (minus the sensitive info). Many thanks to anyone who can give me some feedback.
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Database Configuration File ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;
; Omeka requires MySQL 5 or newer.
;
; To configure your database, replace the X's with your specific
; settings. If you're unsure about your database information, ask
; your server administrator, or consult the documentation at
; <http://omeka.org/codex/Database_Configuration_File>.;
[database]
host = "mysql-1.coloredconventions.org"
username = "xxxxxx"
password = "xxxxxx"
dbname = "coloredconventions_org_5"
prefix = "omeka_"
charset = "utf8"
port = "3306"