RE: installation problem of MySQL on OS Lion

2015-07-30 Thread Divesh
Share error log file -Original Message- From: Martin Mueller martinmuel...@northwestern.edu Sent: ‎29-‎07-‎2015 21:05 To: mysql@lists.mysql.com mysql@lists.mysql.com Subject: installation problem of MySQL on OS Lion I installed MySQL on a Mac Pro running OS Lion. The installation

installation problem of MySQL on OS Lion

2015-07-29 Thread Martin Mueller
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit

Install problem on MySQL Enterprise Monitor on linux

2012-10-17 Thread Bheemsen Aitha
I tried to install the mysql monitor, but stumbled on some problems. Here is what I did. 1. Installed a second instance of mysql server on one of our servers into a different folder rather than into the regular folder because there is already another instance of mysql server running on the same

facing problem in MYSQL

2012-07-28 Thread Ajay Bansal, System Officer
Dear Sir/Mam, we are facing the problem in our server, kindly help us to solve our problem. mysqlbug script is attached with this mail. hope for your positive response ASAP. -- Regards Er. Ajay Bansal System Officer District Sessions Court, Amritsar +919988460582 |

Re: facing problem in MYSQL

2012-07-28 Thread Prabhat Kumar
Hi Ajay, there is no attachment.. On Sat, Jul 28, 2012 at 1:17 PM, Ajay Bansal, System Officer so...@indianjudiciary.gov.in wrote: Dear Sir/Mam, we are facing the problem in our server, kindly help us to solve our problem. mysqlbug script is attached with this mail. hope for your

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK -

Re: Problem with mysql

2010-01-11 Thread Ananda Kumar
use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; regards anandkl On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes sq...@dahl-stamnes.netwrote: On Monday 11 January 2010

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 09:55, Ananda Kumar wrote: use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; I just found the cause of the problem... /etc/nsswitch.conf. It

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I read you solved your problem,

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
(Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I have checked that, and reverse DNS is OK - both resolve to 192.18.2.22 I

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote: (Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? I

Problem with mysql

2010-01-10 Thread Jørn Dahl-Stamnes
Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u root -p grant all on . to 'root'@'r2-d2' idenfified by 'secret-password';

Re: Problem with mysql

2010-01-10 Thread sureshkumarilu
...@dahl-stamnes.net Subject: Problem with mysql Sent: Jan 10, 2010 3:20 PM Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u

Re: Problem with mysql

2010-01-10 Thread Jørn Dahl-Stamnes
by 'secret-password'; --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq...@dahl-stamnes.net Subject: Problem with mysql Sent: Jan 10, 2010 3:20 PM Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some

Re: Problem with mysql

2010-01-10 Thread Mihamina Rakotomandimby
Jørn Dahl-Stamnes sq...@dahl-stamnes.net : I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche Developpement

Problem with MySQL user

2009-09-16 Thread John Oliver
I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to

RE: Problem with MySQL user

2009-09-16 Thread Gavin Towey
: Problem with MySQL user I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up

Re: Compile problem (was: MySQL Community Server 5.1.35 has been released)

2009-06-09 Thread Joerg Bruehe
Dave, do you really consider it helpful to do reply all to a release announcement, trying to send it to the announce and packagers list, including a full quote of the announcement text, and using the original subject line, when you are asking for help about a compile problem? Dave Shariff

Re: Problem compiling mysql-5.1.33

2009-04-08 Thread walter harms
most likely a missing include it should have at least: #include sys/time.h #include sys/resource.h Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem schrieb: make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I.

Problem compiling mysql-5.1.33

2009-04-04 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable default-file in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I believe that, different mysql configuration file for different mysql instance is a better idea. In your case, if any thing goes wrong with my.cnf Then, it is going to effect all mysql instance (either restart mysql server or any other way). It has a lots of disadvantages. You might

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, I use the script mysql_multi to stop and the start several, or all, instances. At the end, to work with more ease, I will create scripts to connect to each instance and in the script force the variable prompt at the connection seems easy Thanks for all !!!

Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
I need advice. I have three instances of MySQL on a single server. How can I change the MySQL prompt depending of the instance on which connecting ? If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf

Re: Problem with MySQL prompt

2008-12-22 Thread Claudio Nanni
Ciao Stefano, how do you connect to the different instances? if you use different operating system users or different mysql home directories just put in the home directory of each user a .my.cnf file (or my.cnf in the mysql home) with just the prompt setting in the [mysql] section. NOTE: in the

Re: Problem with MySQL prompt

2008-12-22 Thread Warren Young
Stefano Elmopi wrote: If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. This is because the client reads from my.cnf

Re: Problem with MySQL prompt

2008-12-22 Thread Krishna Chandra Prajapati
Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi

Re: Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
Thanks for the all answers !!! It's ok, even if I have three different my.cnf for my three instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log =

Re: Problem with MySQL prompt

2008-12-22 Thread Simon J Mudd
prajapat...@gmail.com (Krishna Chandra Prajapati) writes: You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance.

Problem with mysql passive connections

2007-09-27 Thread Toke Herkild
Hi all, I've a server where between 1-2 there comes a high load from less than 1k queries there's a jump to 60+k queries. It all started after adding more RAM to the server. Anyone seen this before ? Regards, Toke Herkild -- MySQL General Mailing List For list archives:

startup problem on mysql 5.0.45

2007-08-02 Thread MASSIMO PETRINI
After a shutdown regular on my mysql master, when the mysql process startup apper the error below 070802 16:07:08 [Warning] The syntax for replication startup options is deprecat ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 070802 16:07:10 InnoDB:

Re: keyboard-ONLY problem with mysql-client and UTF8; compilation flags?

2007-06-11 Thread Tommy Nordgren
On 10 jun 2007, at 20.47, tAndRead wrote: Hi all, snip when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with

keyboard-ONLY problem with mysql-client and UTF8; compilation flags?

2007-06-10 Thread tAndRead
Hi all, I have compiled mysqld 5.0.37 with utf support: ( configure --with-charset=utf8 --with-extra-charsets=none) utf8 is the default in my.cnf: ( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 ) mysqld acknowledges it: mysql show variables like charac%;

keyboard-ONLY problem with mysql-client and UTF8; compilation flags?

2007-06-10 Thread tAndRead
Hi all, I have compiled mysqld 5.0.37 with utf support: ( configure --with-charset=utf8 --with-extra-charsets=none) utf8 is the default in my.cnf: ( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 ) mysqld acknowledges it: mysql show variables like charac%;

Problem installing MySQL 5.0.24a from RHEL RPM on Centos Linux VPS box

2006-09-20 Thread Vasudev Ram
Hi list, I'm trying to install MySQL 5.0.24a RHEL RPM on a Centos Linux VPS box. uname -a output on this box: Linux my.host.com 2.6.9-022stab078.14-enterprise #1 SMP Wed Jul 19 14:35:02 MSD 2006 i686 athlon i386 GNU/Linux It already has MySQL 4.1 RHEL installed on it - I checked this with rpm

Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006-06-05 Thread MySQL Nexeia
I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works fine on mysql-5.0 but it give error with

Re: Subquery Problem With mysql-4.0 (Works with mysql-5.0)

2006-06-05 Thread Pooly
2006/6/5, MySQL Nexeia [EMAIL PROTECTED]: I face one problem with mysql4.0 I've two tables, one called company and the other called favorites. The relation between those two tables is CO_ID on the company table and MASTER_CO_ID on the favorites table. When I run the following query it works

Re: InnoDB Memory Problem causing mysql to crash

2006-05-12 Thread sheeri kritzer
: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default

Re: InnoDB Memory Problem causing mysql to crash

2006-05-08 Thread Dobromir Velev
- Original Message - From: sheeri kritzer [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections

Re: InnoDB Memory Problem causing mysql to crash

2006-05-05 Thread sheeri kritzer
Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used the default binlog_cache_size value of 32K plus your settings) MySQL could use up to 4.991913 G of memory.

Re: InnoDB Memory Problem causing mysql to crash

2006-05-05 Thread Heikki Tuuri
: mailing.database.myodbc Sent: Friday, May 05, 2006 10:50 PM Subject: Re: InnoDB Memory Problem causing mysql to crash Well, according to my calculations: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB (I used

InnoDB Memory Problem causing mysql to crash

2006-05-04 Thread Dobromir Velev
Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the last month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB

problem accessing mysql from PHP

2006-03-10 Thread Nestor
I am getting this error and I do not know why? Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can access mysql from the command line and I can access it from mysql Administrator. When I run a php program I get an error. I

Re: problem accessing mysql from PHP

2006-03-10 Thread SGreen
Nestor [EMAIL PROTECTED] wrote on 03/10/2006 02:33:50 PM: I am getting this error and I do not know why? Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can access mysql from the command line and I can access it from

Problem installing mysql on Debian linux

2006-02-25 Thread Tselemegkos Grigorios
Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was: checking for FIONREAD in sys/ioctl.h... yes checking for TIOCSTAT in

Re: Problem installing mysql on Debian linux

2006-02-25 Thread Sam Tran
On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix /home/grtsel/mysql and the output error was:

Re: Problem installing mysql on Debian linux

2006-02-25 Thread Tselemegkos Grigorios
:34 PM Subject: Re: Problem installing mysql on Debian linux On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote: Hi, I'm trying to install mysql 4.0.25 from source on Debian linux without root privileges. The problem comes when i execute the configure command. I typed: configure --prefix

Problem installing MySQL 5.0

2006-01-03 Thread Francesco Vincenti
Hello everybody, This is the first time I try to install MySQL 5.0, I think I followed the steps showed by the documentation in the right way, but when I run the command: rpm -i MySQL-server-Version-.i386.rpm I get back the error: error: Failed dependencies: perl(DBI) is needed by

Re: Problem installing MySQL 5.0

2006-01-03 Thread Chander Ganesan
You can force the installation (--nodeps) when installing the RPM package. Even if you build DBI (and not install it from RPM) it won't be in the RPM database, and you'll get the same error. You should be able to get a FC2 RPM for the DBI module - download that RPM and install it, then

Re: Problem installing MySQL 5.0

2006-01-03 Thread Francesco Vincenti
-Uvh --nodeps perl-DBI-1.50-1.i386.rpm and the installation finished without problems. Then, I installed both MySQL-server-standard-5.0.18-0 .rhel3.i386.rpm, with which I have had the problem, and MySQL-client-standard-5.0.18-0.rhel3.i386.rpm and all went in the right way. Greetings Francesco

Re: Problem installing MySQL on Mac OSX 10.4.3

2005-12-05 Thread Brent Baisley
Those message are kind of odd, even on a messed up system. I would first run the repair privileges in the disk utility for good measure, then delete all traces of MySQL and just start over. MySQL should be in /usr/local/mysql. To remove it just type: sudo rm -R /usr/local/mysql Then try

Problem installing MySQL on Mac OSX 10.4.3

2005-12-02 Thread Ton Kuypers
Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the

Re: Problem with MySQL 5 on OS X Tiger

2005-12-01 Thread Gleb Paharenko
Hello. Some tips from the manual could be helpful. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html untz wrote: Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger...

Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread untz
Hello there, I just downloaded the MySQL 5 Community Edition for OS X Tiger... Ran the installer and it installed everything to /usr/local/ ... Updated my .bash_profile by creating a MYSQL_HOME variable and appending that MYSQL_HOME/bin to the PATH variable... Now, the problem is that when

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Lachlan Mulcahy
Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Michael Stassen
Lachlan Mulcahy wrote: Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no

Problem with mysql-administrator-1.1.5, s.o.

2005-11-24 Thread Wolfgang Bogenrieder
Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running under Windows NT Sp6. Starting the tools I get the error message, like procedure GetFileSizeEx not found in Kernel32.dll. Suppose you have to define #ifdef NT while compiling, or similar

Re: Problem with mysql-administrator-1.1.5, s.o.

2005-11-24 Thread Gleb Paharenko
Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: Hallo, ich have a problem with mysql-administrator-1.1.5 and mysql-query-browser-1.1.17 running

Help! Problem moving MySQL data dir to a larger file system

2005-11-07 Thread Daniel C. Mahoney
I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a

Re: Help! Problem moving MySQL data dir to a larger file system

2005-11-07 Thread David Logan
Hi Daniel, Check your permissions. Your mysqld process is probably trying to create the log file but can't and is telling you via the error code 13 message $ perror 13 System error: 13 = Permission denied $ Regards Daniel C. Mahoney wrote: I'm running MySQL (--ersion says mysql Ver 14.7

Re: Problem starting MySQL With Moved Data Directory

2005-10-25 Thread Gleb Paharenko
Hello. and restarted MySQL with /etc/init.d/mysql start, I get the following: Starting MySQL database server: mysqld. Checking for crashed MySQL tables in the background. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]'

Problem starting MySQL With Moved Data Directory

2005-10-22 Thread Hal Vaughan
I'm using MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of Debian, just to clarify). I had a setup of a program I've been working on for several years that is on a RAID. I changed MySQL's data directory so it will be on the same RAID and backed up, along with all my other data

possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Martijn Tonies
Hello Andrew, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Roger Baklund
Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL|

RE: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
- insert into 'double' column problem with mysql 4.1 Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
' column problem with mysql 4.1 Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6

re: solution found for my.cnf problem in mysql 5.0.6

2005-06-06 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I followed the steps in http://lists.mysql.com/internals/25364 and fixed my script, so, it would appear that the script is bad for the max version of mysql 5.0.6, for Solaris 8. - -- Love is mutual self-giving that ends in self-recovery. Fulton Sheen

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-10 Thread Joerg Bruehe
Hi Jon, all! Jon Earle wrote: Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-09 Thread Jon Earle
Joerg Bruehe said: Still, this seems to be a problem with the header files supplied / used by gcc. Are you sure you used the fixincludes script? Hi Joerg, I tried your suggestion as per: cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/ mv include inc cd install-tools export

Re: Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-07 Thread Joerg Bruehe
Hi! Jon Earle wrote: Hi all! I'm having trouble building the latest stable on AIX 5.1. My env is as follows: Relevant GNU tools: [[...]] gcc-3.3.2-4.aix5.1.ppc.rpm [[...]] I admit I did not use gcc on AIX for quite some time. Results in the following error: ... checking term.h usability... no

Problem compiling mysql 4.1.11 on AIX 5.1

2005-05-06 Thread Jon Earle
Hi all! I'm having trouble building the latest stable on AIX 5.1. My env is as follows: Relevant GNU tools: autoconf-2.58-1.aix5.1.noarch.rpm automake-1.7.9-1.aix5.1.noarch.rpm binutils-2.14-3.aix5.1.ppc.rpm bison-1.875-2.aix5.1.ppc.rpm flex-2.5.4a-6.aix4.3.ppc.rpm gcc-3.3.2-4.aix5.1.ppc.rpm

Problem With Mysql Ms Access with Time

2005-04-14 Thread Osvaldo Sommer
Hi: I have this data: ventas_encabezado_historico_sat Query VEH_EMPRESA VEH_TIENDA VEH_FECHA VEH_STATUS VEH_TOTAL VEH_HORA DLC T01 6/1/2003 V 30 8:31:05 AM DLC T01 6/1/2003 V 114.28 8:38:44 AM DLC T01 6/1/2003 V 63.2 8:41:13 AM DLC T01 6/1/2003 V 8.75 8:42:47 AM dlc T01 6/1/2003 V 12.35

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-29 Thread Matt Wagner
It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-28 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file

A complex normalisation problem in MySQL 4.0.20 (innodb engine)

2005-03-21 Thread symbulos partners
Dear friends we have a problem here. We have 3 tables - table language (id int not null auto_increment primarykey, languageName tinytext) - table country (id int not null auto_increment primarykey, defaultName tinytext, defaultLanguage tinytext) - table countryToLanguage ((languageID int,

Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)

2005-03-21 Thread SGreen
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 08:08:53 AM: Dear friends we have a problem here. We have 3 tables - table language (id int not null auto_increment primarykey, languageName tinytext) - table country (id int not null auto_increment primarykey, defaultName

Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)

2005-03-21 Thread symbulos partners
I don't think so. You already have the country's name in it's own language on the countryToLanguage table, don't you? What name in which language is the defaultName column supposed to represent? If you can define what the *contents* of that field is supposed to be, then you should be able to

Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)

2005-03-21 Thread SGreen
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 10:25:27 AM: I don't think so. You already have the country's name in it's own language on the countryToLanguage table, don't you? What name in which language is the defaultName column supposed to represent? If you can define what

Authorizing Problem in MySQL 4 with Mandrake 10

2005-02-23 Thread Prabath Ranasinghe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is localhost and user is root.I entered the root password. Here is the log :-

Re: Authorizing Problem in MySQL 4 with Mandrake 10

2005-02-23 Thread Bastian Balthazar Bux
Prabath Ranasinghe (by way of Prabath Ranasinghe [EMAIL PROTECTED]) ha scritto: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hash: SHA1 Hi All, I installed a fresh copy of Mandrake Linux 10.0 with MySQL. I tried to login to MySQL server ,But it says that authorization is failed. My hostname is

RE: Authorizing Problem in MySQL 4 with Mandrake 10

2005-02-23 Thread mel list_php
different. maybe this can be helpful: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html From: Prabath Ranasinghe [EMAIL PROTECTED] (by way of Prabath Ranasinghe [EMAIL PROTECTED]) Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Authorizing Problem in MySQL 4 with Mandrake 10

offtopic: Problem initialize MySQL DataSource for WebSphere App. Server 6

2005-02-18 Thread juleni
Hello, I have problem to configure MySQL datasource for WebSphere Application Server 6 (WAS6) from admin console. 1.) I have configured new JDBC Provider for MySQL (4.0.20a) as following: Name: MySQL JDBC Provider Class path

RE: Data loss problem with mysql

2004-11-24 Thread ravi.ramachandra
thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 1:28 PM To: Ravi T Ramachandra (WT01 - EMBEDDED PRODUCT ENGINEERING SOLUTIONS) Cc: [EMAIL PROTECTED] Subject: Re: Data loss problem with mysql On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote: Dear all, We are running mysql 4.0.17

Data loss problem with mysql

2004-11-23 Thread ravi.ramachandra
Dear all, We are running mysql 4.0.17 on linux environment. Our database resides on external disk connected via FC cables. We recently noticed a loss of data in the following scenario. Inserted a row in a table in a separate transaction by a java application, queried a row in the table in a

Re: Data loss problem with mysql

2004-11-23 Thread andy thomas
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote: Dear all, We are running mysql 4.0.17 on linux environment. Our database resides on external disk connected via FC cables. We recently noticed a loss of data in the following scenario. Inserted a row in a table in a separate transaction by a

Problem installing Mysql 4.1 on Fedora 2

2004-11-16 Thread ofz
Hi: When i tried to install Mysql using the rpm on a Fedora 2 .. i received this error: shellrpm -i MySQL-server-4.1.7-0.i386.rpm warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5error: Failed dependencies: MySQL conflicts with mysql-3.23.58-9

Re: Problem installing Mysql 4.1 on Fedora 2

2004-11-16 Thread Spenser
I had the same problem. It just won't seem to upgrade. You need to uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first. Enter something like this: rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9 When it's done, then install version 4.x On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED]

problem runnig mysql with a particular collation

2004-09-07 Thread sara nasiri
hello everyone, i have problem running mysqld with particular charset and collation, i test two cases: I use mysql-4.1.3-beta , and Fedora Core 2 for my tests 1) ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_turkish_ci make;make install ; in this case

Re: I have a problem with MySQL.

2004-08-31 Thread Philippe Poelvoorde
If you give more details maybe someone on the list will be able to help. Astghik Barseghian wrote: Hello Philippe, I am trying to use DBMail from MySQL to send and receive messages but I get an SQL sytax error. Could you please tell me is there any way to use the mentioned component, or how can I

RE: Problem running MySQL in high school lab

2004-08-31 Thread SGreen
O'Bryan [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 8:09 PM To: [EMAIL PROTECTED] Subject: Problem running MySQL in high school lab I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had

Problem running MySQL in high school lab

2004-08-30 Thread Todd O'Bryan
I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't start the server, but I fixed that, and now mysqld works fine. Unfortunately, if you then mysql -u root, after a

RE: Problem running MySQL in high school lab

2004-08-30 Thread Donny Simonton
: Monday, August 30, 2004 8:09 PM To: [EMAIL PROTECTED] Subject: Problem running MySQL in high school lab I'm trying to teach my students how to use MySQL, and have installed it on all the lab machines along with Cygwin. Originally, I had the permissions set wrong and my students couldn't

Re: Dependency problem with MySQL rpm's (Fedora Core 1)

2004-08-23 Thread Egor Egorov
Frank Perez [EMAIL PROTECTED] wrote: I am trying to install MySQL 5.0.0 on a fresh install of Fedora Core 1, however I am running into a little trouble and I was hoping someone could give me a little insight on what I might be doing wrong. I am able to install the 'server', 'clients', and

Dependency problem with MySQL rpm's (Fedora Core 1)

2004-08-22 Thread Frank Perez
Hello everyone, I am trying to install MySQL 5.0.0 on a fresh install of Fedora Core 1, however I am running into a little trouble and I was hoping someone could give me a little insight on what I might be doing wrong. I am able to install the 'server', 'clients', and 'devel' packages with no

Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Martin Rytz
Hi All I am very confused about MySQL 4.1.3. I have problems with the character set and the collation. Under 4.0.20 I had never such problems. I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql. Then I loaded my data within a script with load data infile into my

RE: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Donny Simonton
This is not a mysql problem, it is a phpmyadmin problem. You must be using 2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I have complained to them about it, but not exactly sure what they are going to do. Donny -Original Message- From: Martin Rytz

Permissions problem with MySQL 4.1.3 | Update: Same with 5.0.1

2004-08-10 Thread Elie `woe` BLETON
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I also tried the 5.0.1 MAX binaries looking for a solution to my previously posted problem of permissions (see at the bottom of the message for the previous post). According to the hostname.err file: 040810 13:31:44 mysqld started

  1   2   3   4   5   >