Re: copy DB data from FreeBSD to Redhat9.0

[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 are all error I got:
# rpm -i MySQL-client-4.1.10-0.i386.rpm
warning: MySQL-client-4.1.10-0.i386.rpm: V3 DSA signature: NOKEY, key ID 
5072e1f5
       file /usr/bin/mysql from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysql_find_rows from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqlaccess from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqlbinlog from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqlcheck from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqldump from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqlimport from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/bin/mysqlshow from install of MySQL-client-4.1.10-0 
conflicts with file from package mysql-3.23.54a-11
       file /usr/share/man/man1/mysql.1.gz from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11
       file /usr/share/man/man1/mysqlaccess.1.gz from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11
       file /usr/share/man/man1/mysqladmin.1.gz from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11
       file /usr/share/man/man1/mysqldump.1.gz from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11
       file /usr/share/man/man1/mysqlshow.1.gz from install of 
MySQL-client-4.1.10-0 conflicts with file from package mysql-3.23.54a-11

Thanks
Sam
sam wun wrote:
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 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.
 

Hi, I got  the following error when execute mysql < mydata.sql:
# mysql < mysql_2005-03-01.Tuesday.sql
ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)

I have looked thru the mysqld script in /etc/init.d/ directory, but 
didn't get a cule about start up mysqld with unix sock.
You got any idea?

I also search for where mysql.sock is, but I couldn't find this file 
in the system. have I miss something in the mysqld start up script?
Thanks
Sam

Thanks
Sam


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]