Question: Converting to MySQL
0
bravobih • 30 wrote:
When trying to start Galaxy with MySQL database instead of PostgresQL after several upgrades numbers on step 29 -> 30... Migration script to add column for a history slug. I get the following result (at the end of the trace):
File "/home/galaxy/galaxy-dist/eggs/MySQL_python-1.2.3c1_5.1.41_static-py2.6-linux-x86_64-ucs4.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
sqlalchemy.exc.OperationalError: (OperationalError) (1060, "Duplicate column name 'slug'") '\nALTER TABLE history ADD slug TEXT' ()
How can I get over this step? Is there any DB structure that I can insert with mysqladmin or mysql ?
Hi,
unfortunately, I have no clue about MySQL I just can recommend you to use PostgreSQL. MySQL has a few issues, especially with datatypes that seems to be problematic for a few users.
(I'll first echo Bjoern in saying that Postgres is certainly preferred)
That said, starting with a fresh mysql database, this should not happen. I'm setting up a mysql database now to test with, but can we get a few more details as well? You said you're 'converting to mysql' in the title. Does that mean you first manually migrated the data somehow?