Re: Cannot connect from WInXp MYSQL server - help - cont.

2003-01-26 Thread Scott Lewis 
I ahve upgraded to gcc v 3.2.7:-

Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with:
../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info
 --enable-shared --enable-threads=posix --disable-checking --host=i386-redha
t-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

I have also added the line:=
set-variable = thread_stack=256K// Thats a uppercase 'K'

in my my.cnf file

Same bloady error.

Ideas?

Scott


- Original Message -
From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
To: Scott Lewis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 10:48 PM
Subject: Re: Cannot connect from WInXp  MYSQL server - help


 Scott,

 most probably, you've got a glibc problem on your Red Hat box. Try
 upgrading to a newer version of glibc, and if the problem (mysqld dies
 when trying to connect from anywhere else than localhost) has gone, I
 was right :)

 (There was a very similar question a couple of days ago on this list. I
 don't know if the Red Hat problem is exactly the same as the SuSE
 problem I could solve by updating glibc, but the symptom is the same.)

 Regards,
 --
   Stefan Hinz [EMAIL PROTECTED]
   Geschäftsführer / CEO iConnect GmbH http://iConnect.de
   Heesestr. 6, 12169 Berlin (Germany)
   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

 - Original Message -
 From: Scott Lewis [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, January 25, 2003 6:51 PM
 Subject: Cannot connect from WInXp  MYSQL server - help


  OK,
 
  I have a mysql server running on my home server. The main os is
 Redhat8.
 
  I know that Mysql is running on port 3306 as its showing as listening.
 I
  ahve opened the tcp port for boh internal and external connections -
 fione.
  I ahve also disbaled it to test aswell.
 
  Anyway - I have loaded several MYsql clients on my winxp pro pc on my
 home
  LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try
 and
  connection I get the error:-
 
  Lost connection to mysql durring query.
 
  In the loags it says:-
 
  Number of processes running now: 1
  mysqld process hanging, pid 2522 - killed
  030125 17:49:36  mysqld restarted
  /usr/libexec/mysqld: ready for connections
 
 
  So - its killing the pid, which I assume is my connections.
 
  Any ideas on what to look for.
 
  Scott
  www.toptravelsites.net
  www.myeyes-youreyes.co.uk
 
 
 
  -
  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





-
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

Backing up mysql databases

2003-01-26 Thread Scott Lewis 
Whats the best way to backup the mysql databses.

I was thinking along the lines of adding something to my crons cript that
will backup all the databases, permissions etc and copy then to an external
hard drive, which I do at the moment for other files

Can anyone advise?

Scott
www.toptravelsites.net
www.myeyes-youreyes.co.uk



-
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

Is there anything like Query Analyser for MySQl

2003-01-26 Thread Scott Lewis 
I was wondering, is there a program simialar to MS SQL server - Query
Analyser, where you can write sql queries to query MySQl databases?


Scott



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

2003-01-26 Thread Scott Lewis 
As you can tell - very new to Mysql.

I was wondering, has anyone some links to howto or even better examples of
databases and webpages that I can install, and see the web interaction with
webpages  and  a mysql database.

Looking at going down that road as exaaples would help.

Scott



-
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

Cannot connect from WInXp MYSQL server - help

2003-01-25 Thread Scott Lewis 
OK,

I have a mysql server running on my home server. The main os is Redhat8.

I know that Mysql is running on port 3306 as its showing as listening. I
ahve opened the tcp port for boh internal and external connections - fione.
I ahve also disbaled it to test aswell.

Anyway - I have loaded several MYsql clients on my winxp pro pc on my home
LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try and
connection I get the error:-

Lost connection to mysql durring query.

In the loags it says:-

Number of processes running now: 1
mysqld process hanging, pid 2522 - killed
030125 17:49:36  mysqld restarted
/usr/libexec/mysqld: ready for connections


So - its killing the pid, which I assume is my connections.

Any ideas on what to look for.

Scott
www.toptravelsites.net
www.myeyes-youreyes.co.uk



-
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