[ensembl-dev] mart_transcript_variation.txt

[Stuart Meacham]

Hi Kiran,

To get the table defs of particular tables so you can recreate them in 
MYSQL you need to do something like:

mysqldump -h ensembldb.ensembl.org -P 5306 -uanonymous 
--lock-tables=false --no-data homo_sapiens_variation_62_37g 
transcript_variation > ./ens_table_defs.sql

mysql -u<dba> -p <database_name> < ./ens_table_defs.sql

depending on the table and species you are interested in, you can do 
multiple tables by simply adding them to the list AFTER the database 
name. Be aware that the above will drop any tables of the same name 
already in your database so as always test on a non-production system.

Hope that's helpful.

Cheers

Stuart


On 19/05/11 07:13, Kiran Mukhyala wrote:
> Hello again,
>
> I need the definition of the mart_transcript_variation temp table to
> create my mart databases. Could you please provide the SQL to create it?
>
> Thank you in advance!
>
> -Kiran
>
>
> On Mon, May 2, 2011 at 1:40 PM, <rhoda at ebi.ac.uk
> <mailto:rhoda at ebi.ac.uk>> wrote:
>
>     Hi Andrea
>     The mart_transcript_variation table is a temporary table used solely for
>     the creation of the mart databases and has been erroneously added to the
>     download section. Please ignore this table and apologies for any
>     confusion
>     caused.
>     Regards
>     Rhoda
>
>
>      > Hello
>      >
>      > The human and cow variation downloads for e!62 include data for a
>     table
>      > called mart_transcript_variation but the definition for this table is
>      > not in the sql file. Neither is this table mentioned on this page
>      >
>      > http://www.ensembl.org/info/docs/variation/variation_schema.html
>      >
>      > thanks
>      >
>      > _______________________________________________
>      > Dev mailing list Dev at ensembl.org <mailto:Dev at ensembl.org>
>      > List admin (including subscribe/unsubscribe):
>      > http://lists.ensembl.org/mailman/listinfo/dev
>      > Ensembl Blog: http://www.ensembl.info/
>      >
>
>
>
>     _______________________________________________
>     Dev mailing list Dev at ensembl.org <mailto:Dev at ensembl.org>
>     List admin (including subscribe/unsubscribe):
>     http://lists.ensembl.org/mailman/listinfo/dev
>     Ensembl Blog: http://www.ensembl.info/
>
>
>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/