Marc Cousin wrote: > On Wednesday 13 June 2007 10:18:44 Berner Martin wrote: >> Hello >> Dos someone have already do a migration of the Catalogue from a PostgreSQL >> to y MySQL? Or know how it has to work? I tried to dump Postgres so that he >> dump only the Data and use INSERT in stead of COPY. Then I grep only the >> lines with Inserts. I create the bacula-tables with the script >> (make_mysql_tables) and try to insert the Data dumped from Postgres. But >> the Tables in MySQL seams to have different Names then in PostgreSQL at >> lest different upper/lower case. >> >> thanks for any help >> >> Berner Martin > > I don't see any way to get past the case sensitivity problem, except by > replacing all table names with their mysql versions in the dump (a simple > perl or sed script will do the trick)
You can actually tell MySQL to be case insensitive on table names with the lower_case_table_names variable. http://www.mysql.org/doc/refman/5.0/en/identifier-case-sensitivity.html -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
