BACK to www.laymusic.org

I have got the schema (roughly) into the mysql database on
http://www.laymusic.org.

When I try to get the data in from the postgresql dump, I get:

$ mysql -pjsb1750 laymusi_musicpublish
ERROR 1064 at line 3: 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 ‘COPY piece (id, title, composer_id, copyright, Directory_name,

So I’m going to have to research mysql sql, or see if some kind person
has written a script to turn pg_dump output into mysql input.

The answer turns out to be that you run pg_dump with the –inserts
option. So the data is now in the mysql database; now I have to check
it, and modify abc2db.py to put the data into the mysql database, and
db2html.py to get the data out of the mysql database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s