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.
LayMusic.org 