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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
