Hello.
> I used the following command backup database:
> mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
> --quote-names --opt
>
> I don't think this command backup user account info.
>
If you add --all-databases option it would also dump the mysql database.
I've tried to import the mysql database from the 5.0.2 to 4.1.10. It works
fine, You may try just to restore the dump file with mysql < dump_file.sql
command. Don't forget to execute FLUSH PRIVILEGES.
sam wun <sam.wun@stripped> wrote:
> Gleb Paharenko wrote:
>
>>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.
>>
>>
>>
>>
>>
> Hi, thanks for your help. I just able to backup all the database (with
> their tables I believe) from mysql 5.0.
> And now I stuck at restoring the database and their tables as well as
> user accounts rights to mysql4.1.
> I used the following command backup database:
> mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
> --quote-names --opt
>
> I don't think this command backup user account info.
>
> 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
