Re: copy DB data from FreeBSD to Redhat9.0

2005-03-02 Thread Gleb Paharenko
Hello. Use -U --force --nodeps options. sam wun [EMAIL PROTECTED] wrote: Hi, I have installed the server and started up successfully. mysql.sock file is written to /var/lib/mysql/ directory as well. Now I found that I also need to install mysql 4.10-1 client. However there

Re: copy DB data from FreeBSD to Redhat9.0

2005-03-01 Thread Gleb Paharenko
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

Re: copy DB data from FreeBSD to Redhat9.0

2005-03-01 Thread sam wun
Gleb Paharenko wrote: 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

Re: copy DB data from FreeBSD to Redhat9.0

2005-03-01 Thread sam wun
sam wun wrote: Gleb Paharenko wrote: 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

Re: copy DB data from FreeBSD to Redhat9.0

2005-03-01 Thread sam wun
Hi, I have installed the server and started up successfully. mysql.sock file is written to /var/lib/mysql/ directory as well. Now I found that I also need to install mysql 4.10-1 client. However there is already mysql3 installed in the system. How can I remove the old version in Redhat? Here

Re: copy DB data from FreeBSD to Redhat9.0

2005-02-28 Thread sam wun
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

Re: copy DB data from FreeBSD to Redhat9.0

2005-02-25 Thread Gleb Paharenko
Hello. After finished copied the data over to Redhat, MySQL4.1 can't start. The What is in the error log? I don't want to rebuild the entire database from scratch in Redhat Do you mean that you don't want to use mysqldump? But usually it is a preferred way. sam wun [EMAIL

Re: copy DB data from FreeBSD to Redhat9.0

2005-02-25 Thread Gleb Paharenko
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

copy DB data from FreeBSD to Redhat9.0

2005-02-24 Thread sam wun
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

Re: copy DB data from FreeBSD to Redhat9.0

2005-02-24 Thread sam wun
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