[ensembl-dev] views on the new schema

[Andy Yates]

Hi Michael,

This is an issue if you're moving schemas from databases where the users are inconsistent. My suggestion would be to make the users consistent (at least in name). There is also a known issue if you move a view from one schema to another e.g. doing a database rename by moving the data files from one directory to another. This should not be a problem if you are using mysqldump to do renames

Andy

On 18 Nov 2011, at 09:55, Michael Paulini wrote:

> Hia,
> 
> just to share some experience of the new e65 schema:
> if you load a dump of a ensembl database with a view onto a MySQL server that doesn't contain the user that created the view, it will fail.
> So I made it a habit to pipe the SQL dumps through a
> s/ensadmin/MY_USERNAME/
> to prevent that.
> 
> Michael
> 
> _______________________________________________
> 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/

---
Andrew Yates                   Ensembl Core Software Project Leader
EMBL-EBI                       Tel: +44-(0)1223-492538
Wellcome Trust Genome Campus   Fax: +44-(0)1223-494468
Cambridge CB10 1SD, UK         http://www.ensembl.org/