Hello,
Some information that will be helpful:
1. The UCSC Genome Browser software does not care which MySQL version is in use
2. The only case where the MySQL version is important is if the user is trying
to transfer our binary tables from:
rsync://hgdownload.cse.ucsc.edu/mysql/
3. MySQL 4 installations can not use the binary files from MySQL 5
installations
4. MySQL 5 installations *can* use MySQL 4 version binary files. The tables
should be converted in-place for optimal performance with the command:
alter table "<table name>" ENGINE=MyISAM;
Any MySQL installation questions can be answered at http://dev.mysql.com/
The exact parameters will depend upon your system and how it is administered.
Thanks,
Jennifer
------------------------------------------------
Jennifer Jackson
UCSC Genome Bioinformatics Group
----- "WANG Wuqi" <[email protected]> wrote:
> From: "WANG Wuqi" <[email protected]>
> To: "Hiram Clawson" <[email protected]>
> Cc: "Jennifer Jackson" <[email protected]>, [email protected], "WANG Wuqi"
> <[email protected]>
> Sent: Tuesday, October 6, 2009 1:11:04 AM GMT -08:00 US/Canada Pacific
> Subject: Genome browser MySQL database upgrade
>
> Dear Hiram,
>
> Now Our Genome browser mirror site is version v209, and MySQL database
> is version 4.1.22-standard,
> so we want to follow your changes to upgrade MySQL database to version
> 5.xx and genome browser to
> version v216.
>
> Could you tell me detail requirements for this upgrade, like MySQL
> information,
> where is download, enterprise or standard version?
>
> Do you have a guide for this database upgrade?
>
> Because we still use MySQL 4.1.22-standard, can we upgrade Genome
> browser to v216 from v209 first,
> then upgrade database again?
>
>
> Our server: Linux 2.6.9-67.0.22.ELsmp #1 SMP Wed Jul 23 17:30:51 EDT
> 2008 i686 i686 i386 GNU/Linux
>
>
> Thanks & Regards
>
> Wuqi
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
