Re: copy DB data from FreeBSD to Redhat9.0

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