[ensembl-dev] denied access to ensembl_compara alignment tables on public server

[Stephen Fitzgerald]

Hi Lel, populate_new_database.pl seems to use mysqldump as the first step 
in the copying process, you can disable locking with:

--single-transaction
or
--lock-tables=false

Try adding this to the copy_dna_dna_alignements sub

change 
" --skip-disable-keys --insert-ignore -t $old_dbname";

to

" --skip-disable-keys --insert-ignore --lock-tables=false -t $old_dbname";

See if it works.

Cheers,
Stephen.


On Wed, 3 Sep 2014, Lel Eory wrote:

> Dear Developers,
>
> I try to load some sequence alignments into a limited compara_master DB with 
> the populate_new_database.pl script, but the public Ensembl mysql server does 
> not allow me to do this. It returns with:
> Got error: 1044: Access denied for user 'anonymous'@'%' to database 
> 'ensembl_compara_75' when doing LOCK TABLES. Are the locks there on these 
> tables to prevent overloading the system? Is there any other way to get 
> alignment data with the populate_new_database.pl script (apart from 
> setting-up a local instance of the compara DB limited to the alignments)?
>
> Thank you.
>
> Kind regards,
> Lel
>
> -- 
> The University of Edinburgh is a charitable body, registered in
> Scotland, with registration number SC005336.
>
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: 
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
>
>