Re: ssh connecting with a mysql client I get: ERROR 2013

Gleb Paharenko wrote: Hello. Can you connect using the mysql command line client program? "leegold" <[EMAIL PROTECTED]> wrote: ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and trying connect via the ssh

Re: Mysql Performance

Vasiliy Boulytchev wrote: Brent, Would you be so kind to throw out some links to "tweaking" mysql to run to its full performance. I am googling right now for the answeres. Is there books you would recommend? THANKS High Performance Mysql (oreilly) MySQL enterprise solution

Re: MySQL Books

Kieran Kelleher wrote: This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641&camp=14573&link_code=as1

Re: Ini (cnf) file location

Roland Carlsson wrote: Hi! I've got a Mac OS X server with a preinstalled mysql from Apple. My problem is that I can't find the ini (cnf) file witch the documentation so very non-windows-friendly shall be located in C:\Windows. Could anyone please tell me where mysql excpects to find the ini (cnf)

Re: 4.1.7 serious problems

Sasha Pachev wrote: So all I have to do, using the binary, is to take the mysqld file and replace my old one (from 4.1.3 to 4.1.7, for example). And for the source, I compile in another directory, then take the mysqld file and replace my old one? Is that documented somewhere? Do not forget to

Re: Optimizing MySQL

Shaun wrote: Thanks for your help Dathan, I will make the required changes. I just have one other problem. I'm not sure what queries don't use an index. I've attmepted to turn on the slow-queries-log, but nothing ever shows up in the file. Here's what I have in the my.cnf [mysqld] skip-locking se

Re: 4.1.7 serious problems

Sasha Pachev wrote: It can be even simpler than that, if you stay withing the same branch. Just replace mysqld and share/english/errmsg.sys ( or share//errmsg.sys if you want them in your native language) with the files from the new version. This is for the source, binary or both? Sorry to as

Re: 4.1.7 serious problems

Sasha Pachev wrote: I did compile it from source, with the flags used for the binaries, and now it does work. I'm totally confused now. Is it easy to upgrade from source? With the binary, I could have two separate directories and I would symlink the one I tested (most recent version) and cou

Re: Low-end SATA vs. SCSI

Gary Richardson wrote: If you are talking about the WD Raptor's -- stay away. Out of 6 we used, 3 failed. Do a few googles and you'll hear the same from other users. On the other hand, the do fly. Raid10 them them on a 3ware 9500 and you'll be amazed. I agree on the 3Ware... Exceptionnal cards. To

Re: 4.1.7 serious problems

Sasha Pachev wrote: Ugo Bellavance wrote: Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon

Re: Which PHP for MySQL 4.1

Jay Blanchard wrote: [snip] I would like to migrate my MySQL servers from 4.0 to 4.1. As I use PHP as well as Java with these servers I wonder what PHP 4 version would be compatible with MySQL 4.1. Has anyone used MySQL 4.1 with PHP yet? [/snip] PHP 4 is compatible with MySQL 4.1. My caution to y

Re: 4.1.7 serious problems

Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon MP. Are you using the same mysqld binary on b

Re: 4.1.7 serious problems

Heikki Tuuri wrote: Ugo, - Original Message - From: "Ugo Bellavance" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, November 05, 2004 3:42 PM Subject: Re: 4.1.7 serious problems Gleb Paharenko wrote: Hi. There were several posts in list like yours. D

Re: 4.1.7 serious problems

Gleb Paharenko wrote: Hi. There were several posts in list like yours. Do you use InnoDB tables? Try to increase values of key_buffer_size, read_buffer_size and so on. InnoDB is enabled but no InnoDB table is used yet (coming soon). However, it crashes with only 1 client connected. There is stil

Re: 4.1.7 serious problems

Anders Green wrote: There are differences, starting with 4.1.5, with the user/schema administration, that need to be updated/massaged. Perhaps that is your problem? I don't think so, everything works perfectly on my test server, which is very similar. Thanks, Maybe. :) Anders +===

4.1.7 serious problems

Hi, I've upgraded one of my servers (test) to 4.1.7 this week, all went ok. Now I'm trying to upgrade another server (production) from 4.1.3 to 4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem. OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone). First, since I could

Replication error

.23 | 79 | | | +--+--+--+--+ 1 row in set (0.00 sec) Thanks -- Ugo Bellavance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slave behing nat firewall

Hi, I'm trying to set this up: Master (in DMZ) => Firewall (nat with port forward 3306 to slave) => Slave. Is that possible? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Hi all.

> -Message d'origine- > De : Andy Fletcher [mailto:[EMAIL PROTECTED] > Envoyé : Tuesday, January 27, 2004 4:42 AM > À : [EMAIL PROTECTED] > Objet : Hi all. > > > I am just starting to work with SQL and Mysql server language > and am embedding some queries into another program I am deve

Re: netstat

Adam Hardy wrote: I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat (

RE: large SQL statements

> -Message d'origine- > De : brent [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 22, 2004 4:50 PM > À : [EMAIL PROTECTED] > Objet : large SQL statements > > > Everyone, > > I downloaded Backup Watcher for MySQL today and am trying a > few tests. I > created one backup from a

RE: setting a variable

> -Message d'origine- > De : Mikael Fridh [mailto:[EMAIL PROTECTED] > Envoyé : Friday, January 16, 2004 4:19 AM > À : Ugo Bellavance > Objet : Re: setting a variable > > > On Thursday 15 January 2004 19.51, Ugo Bellavance wrote: > > > > No probl

RE: Mysql 4.1.1 and PHP

> -Message d'origine- > De : I.P. [mailto:[EMAIL PROTECTED] > Envoyé : Friday, January 16, 2004 6:41 AM > A : [EMAIL PROTECTED] > Objet : Mysql 4.1.1 and PHP > > > > Hi. > > I would like test mysql 4.1.1 with php but, i cann't connect > to it. I have > error when use password :( > >

RE: setting a variable

> -Message d'origine- > De : Tobias Asplund [mailto:[EMAIL PROTECTED] > Envoyé : Wednesday, January 14, 2004 1:53 PM > À : Ugo Bellavance > Cc : [EMAIL PROTECTED] > Objet : Re: setting a variable > > > On Wed, 14 Jan 2004, Ugo Bellavance wrote: > >

RE: MySQL GPL License Question

> -Message d'origine- > De : Computer Mail [mailto:[EMAIL PROTECTED] > Envoyé : Wednesday, January 14, 2004 2:45 PM > À : [EMAIL PROTECTED] > Objet : MySQL GPL License Question > > > I understand some of the GPL but I am a little > confused on this issue: > > If I create a program that

RE: setting a variable

Sorry, 4.0.16, not 4.0.17, if it changes anything. > -Message d'origine- > De : Ugo Bellavance > Envoyé : Wednesday, January 14, 2004 12:07 PM > À : [EMAIL PROTECTED] > Objet : setting a variable > > > mysql 4.0.17 on redhat 9 or debian 3.0 > &

setting a variable

mysql 4.0.17 on redhat 9 or debian 3.0 mysql> show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql> set global log=on; ERROR 1193: Unknown system variable 'log' W

RE: BUG IN MYSQL

> -Message d'origine- > De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 6:05 PM > À : [EMAIL PROTECTED] > Objet : BUG IN MYSQL > > > I've submitted this problem three times now, and been ignored > all three > times. http://bugs.mysql.com/ >

RE: Broadcast to search available MySQL Server in Network?

> -Message d'origine- > De : Manfred Süsens [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 7:58 AM > À : [EMAIL PROTECTED] > Objet : Re: Broadcast to search available MySQL Server in Network? > > > Yes, I tried to find the port 3306, but MySQL doesn't answer! Maybe it

RE: Perl Modules!!!

> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 9:43 AM > À : [EMAIL PROTECTED] > Objet : Perl Modules!!! > > > Hello: > > I need some advise. I am trying to learn and install MySQL, > RH9 distro. My > question is about Pearl

RE: MySQL Control Center!!!

> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 9:24 AM > À : [EMAIL PROTECTED] > Objet : MySQL Control Center!!! > > > Hello: > > I have been reading MySQL Control Center. There are screen > shots but I have > not been able

RE: Remote access FROM a secure server

> -Message d'origine- > De : Amer Neely [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 01, 2004 3:07 PM > À : Larry Brown > Cc : MySQL List > Objet : Re: Remote access FROM a secure server > > > Larry Brown wrote: > > Have you tried to telnet to port 3306 on the server from > y

RE: Installation Question

> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 01, 2004 12:16 PM > À : '[EMAIL PROTECTED]' > Objet : RE: Installation Question > > > > Dan: > > Thank you fast reply on New Year Day. > > The only reason I was trying to install the so

RE: How to backup MySQL databasee?

> -Message d'origine- > De : florence florence [mailto:[EMAIL PROTECTED] > Envoyé : Tuesday, December 30, 2003 1:46 PM > À : [EMAIL PROTECTED] > Objet : How to backup MySQL databasee? > > > > Hi, > >Can somebody teach me how to do MySQL server backup? > Any answer will be

RE: problem

> -Message d'origine- > De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED] > Envoyé : Tuesday, December 30, 2003 11:23 AM > À : [EMAIL PROTECTED] > Objet : problem > > > > i have a follow problem, please, help-me > > [EMAIL PROTECTED] db]# mysql --user=root --password=xx

RE: Problem Installation

> -Message d'origine- > De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED] > Envoyé : Tuesday, December 30, 2003 10:43 AM > À : Mikhail Entaltsev > Cc : [EMAIL PROTECTED] > Objet : Re: Problem Installation > > > > Thanks, I installed, but i don't to connect!! > bash>mysql > b

RE: Log Files in MySQL

> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Envoyé : Monday, December 29, 2003 8:12 PM > À : [EMAIL PROTECTED] > Objet : Log Files in MySQL > > > I think I am confused. I have many bin index files, but I > have not gotten rid of them. > > I read somewh

RE: backup

> -Message d'origine- > De : Rick [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, December 27, 2003 6:33 AM > À : [EMAIL PROTECTED] > Objet : backup > > > i guys!! im newbie, how can i backup a mysql database? what > do you recommend > me? > mysqldump to begin > > -- > MySQL General

RE: Hot standby database question

> -Message d'origine- > De : Jim Richardson [mailto:[EMAIL PROTECTED] > Envoye : Thursday, December 25, 2003 10:18 AM > A : [EMAIL PROTECTED] > Objet : Hot standby database question > > > > I would like to set up two systems, a primary, and a backup, in > physically seperate locations.