Hello.
> I also want to copy the user accounts in MySQL5.0 db over to MySQL4.1 in
> Redhat as well.
All user accounts and rights are stored in the tables of mysql database.
And fields of grant tables in 4.1.x version just a subset of fields in
5.0.x. You should set the values of fields in 4.1.x version to values of
corresponding fields in 5.0.x. For example you may store 5.0.x mysql
database under different name in 4.1.x and then move accounts using
SQL statements.
sam wun <sam.wun@stripped> wrote:
> sam wun wrote:
>
>> Hi,
>>
>> I just fresh install mysql4.1 in Redhat9.0.
>> I have another MySQL5.0 installed in FreeBSD5.3, and just tried to
>> copy all data in /var/db/mysql/ from FreeBSD5.3 to /var/db/mysql/data/
>> in Redhat9.0.
>> After finished copied the data over to Redhat, MySQL4.1 can't start.
>> The DB data in MySQL5.0 in the FreeBSD box has database and tables
>> with indexes.
>> I don't want to rebuild the entire database from scratch in Redhat,
>> how can I "transfer" all db files from FreeBSD to Redhat and in
>> another version of MySQL?
>>
> I also want to copy the user accounts in MySQL5.0 db over to MySQL4.1 in
> Redhat as well. I supposed this is sort of data backup, but more generic
> than that because it is copying data between different version of MySQL,
> and from higher version to a lower version of MySQL.
>
> Sam
>
>> Thanks
>> Sam
>>
>>
>>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
