RE: MYSQL on RedHat 7.1.
Most likely that there is a problem with where PHP and Java are looking for the socket. One more possibility (I don't know for Java, but for PHP) - you need to install a php-mysql (or mysql-php) package. Regards, Milos Rackov From: Kalpesh Modha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: MYSQL on RedHat 7.1. Hello. I am trying to get mysql working on RedHat 7.1 and it works fine however, when I try to make a local connection from either Java or PHP. I get a connection refused message. Whats missing ? Thanks for your help in advance. Regards Kal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 2013: Lost connection to MySQL server during query
I had a similar problem recently. Try checking the /etc/hosts file to see if the hosts/IPs are matching the current config. Regards, Milos Rackov -Original Message- From: Kurt Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: ERROR 2013: Lost connection to MySQL server during query Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the host_name not set up for access message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, better network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL backup
Hello, Anybody has any experiences as how to best backup the databases? It should be a part of an automated process, and should happen in such a way as to secure that database integrity is preserved, even upon restoring. So I cannot just backup the files of the databases, because they might be written to at the time. Dumping the databases might also not be feasible, since the databases are sort of linked to some configuration files, so a clash might occur between what is in the database and what is in the backed up configuration file. Any solutions? The platform is Red Hat Linux, and my idea for backup is dump/restore pair. Any third party software that does the trick? Best regards, Milos Rackov
MySQL backup
Hello, Anybody has any experiences as how to best backup the databases? It should be a part of an automated process, and should happen in such a way as to secure that database integrity is preserved, even upon restoring. So I cannot just backup the files of the databases, because they might be written to at the time. Dumping the databases might also not be feasible, since the databases are sort of linked to some configuration files, so a clash might occur between what is in the database and what is in the backed up configuration file. Any solutions? The platform is Red Hat Linux, and my idea for backup is dump/restore pair. Any third party software that does the trick? Best regards, Milos Rackov