A issue of MySQL
Christopher Chan
cchan at outblaze.com
Fri Apr 2 17:34:51 UTC 2004
Richard Welty wrote:
> On Sat, 03 Apr 2004 01:18:15 +0800 Christopher Chan <cchan at outblaze.com> wrote:
>
>>Richard Welty wrote:
>>
>>>in the future, when making major database upgrades (be it MySQL or
>>>PostgreSQL or whatever), please use the backup and restore utilities
>>>supplied with the database rather than copying files willy-nilly. the
>>>latter is sure to cause problems sooner or later (obviously in your case,
>>>it was sooner.)
>
>
>>Heard of cdb? It is platform independent. One cdb file on Linux can be
>>read by cdb programs on FreeBSD or what not.
>
>
> that's nice. if all you need is a single key lookup, cdb is just fine.
>
> we were talking about relation and near-relational databases here.
er...no we were talking about the sensibility of copy a binary file from
one platform to another and using a compatible program to read it.
>
>
>>Mysql files are similar when using compatible versions of mysql server.
>
>
> again, that's nice. i'd have to go back and look it up, but as i recall,
> the original posting was about a bump from mysql 3.mumble to mysql
> 4.mumble. there are NO guarantees of internal file format compatibility
> when making major version bumps with any RDBMS, commercial or
> open source, that i have ever seen.
>
ah but there was. That's why we just upgraded our mysql server binaries
instead of going through the dump and stuff route.
More information about the fedora-list
mailing list