CMap - oracle dumps of Gramene maps?

[Ken Youens-Clark]

On Mar 30, 2005, at 10:53 AM, Gregory Brown wrote:

> On the Gramene ftp site there are 3 types of files with map data. I  
> first found the tabbed files named by map set.  If I understand  
> correctly, these files can be loaded into any database (mysql, oracle,  
> postgres) as long as the tables are defined and the map set is  
> manually defined via the CMap web interface.  I actually forgot where  
> I found these files.

These files can be loaded into any db because they are used by the  
"cmap_admin.pl" administrative script to import data in CMap's  
tab-delimited format.  The data in this file gets put in various  
tables, so it wouldn't be suitable for direct import into any db.

> The second file is cmap16.dmp.gz  which is the mysql version 4.1.7  
> export of all the current CMap data.  I loaded this file simply and  
> fairly quickly with something like  "mysql -u gregb -p CMAP <  
> cmap16.dmp.sql" after first removing some mysql version 4.1 specific  
> statements.  This type of file is what I was looking for to load into  
> an oracle database. This file is found at  
> ftp://ftp.gramene.org/pub/gramene/CURRENT_RELEASE/data/database_dump/ 
> mysql-dumps/
>
> The third file type I found at Gramene was the complete CMap table  
> dumps that can be loaded using MySQL's "mysqlimport" command you  
> mention below.  This is the cmap16.tgz file at  
> ftp://ftp.gramene.org/pub/gramene/CURRENT_RELEASE/data/database_dump/ 
> mysql-dumps/
>
> I just noticed that Mysql version 4.1 has support for "mysqldump  
> --compatible=oracle ..." exports.  Supposedly I could export my mysql  
> CMap db in an oracle compatible format and then import that file into  
> oracle.  I have to upgrade to the newest version of mysql first and  
> then I will try that.  Has anyone any experience with this new export  
> option?

If you can't use the "cmap16.tgz" tab-delimited dump for Oracle, then I  
would recommend upgrading your MySQL to get the Oracle compatibility  
from mysqldump.  I wasn't aware of that option.  How great is it that  
MySQL plays nice with Oracle!  :-)

If you continue to have problems, I might suggest you look into my  
"sqlt-dumper" utility to create dumper scripts from SQL DDLs.  It's  
part of the SQLFairy package ("SQL::Translator" on CPAN):

	http://sqlfairy.sourceforge.net/

I'm sure we can help you get the Gramene db mirrored into Oracle.  We  
used to use Oracle, and moving from one RDBMS to another can be  
painful, but it can be done!

ky