List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:March 2 2005 1:06pm
Subject:Re: copy DB data from FreeBSD to Redhat9.0
View as plain text  
Hello.

Use -U --force --nodeps options. 


sam wun <sam.wun@stripped> 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 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
>>>
>>
>>
> 
> 


-- 
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



Thread
copy DB data from FreeBSD to Redhat9.0sam wun24 Feb
  • Re: copy DB data from FreeBSD to Redhat9.0sam wun24 Feb
    • Re: copy DB data from FreeBSD to Redhat9.0Gleb Paharenko25 Feb
      • Re: copy DB data from FreeBSD to Redhat9.0sam wun1 Mar
        • Re: copy DB data from FreeBSD to Redhat9.0Gleb Paharenko1 Mar
          • Re: copy DB data from FreeBSD to Redhat9.0sam wun2 Mar
            • Re: copy DB data from FreeBSD to Redhat9.0sam wun2 Mar
              • Re: copy DB data from FreeBSD to Redhat9.0sam wun2 Mar
                • Re: copy DB data from FreeBSD to Redhat9.0Gleb Paharenko2 Mar
  • Re: copy DB data from FreeBSD to Redhat9.0Gleb Paharenko25 Feb