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
>
