Re: MySQL (mysql-5.0.54)

2008-05-06 Thread Juan Eduardo Moreno
Hi, Please, you must set up the log-bin for enable replication : Example ( in your my.cnf ) --log-bin=mysqld-bin The mysql signal 4 error appear when you install erroneus your environment. I recommed reinstall your MySQL in your OS. Regards, Juan On 5/6/08, Kaushal Shriyan <[EMAIL PROTECTED]>

MySQL (mysql-5.0.54)

2008-05-06 Thread Kaushal Shriyan
Hi I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I see the below information in the mysqld.err file ## 06 6:30:13 [Warni

RE: Sun to buy Mysql - mysql press release

2008-01-16 Thread Brett Harvey
http://mysql.com/news-and-events/sun-to-acquire-mysql.html -- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz); /Lasso Professional Alliance Member

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Tom Brown
Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. thanks both - that did t

RE: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Logan, David (SST - Adelaide)
To: mysql@lists.mysql.com Subject: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Prasanna Raj
Hi Tom, Use -q option on mysqldump ;) -q Won't buffer query, It will dump directly to stdout. --Praj On Tue, 14 Mar 2006 11:56:42 + Tom Brown <[EMAIL PROTECTED]> wrote: > Hi > > Trying to dump a complete db where 1 of the tables contains about 88 > million rows - When the dump runs o

MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

2006-03-14 Thread Tom Brown
Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from ser

Possble broken Debian MySQL (mysql-dfsg-4.1 4.1.10a-2)?

2005-04-09 Thread J. Wren Hunt
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'm pretty sure this is more of a Debian package probem rather than a MySQL issue, but for any Debian MySQL users out there here goes: PROBLEM: The problem I'm getting trying to apt-build source mysql-server-4.1 after running the ./configure scrip

Re: [MySQL] mysql/snort/webmin/permissions

2005-03-20 Thread Mark Sargent
.1.3, “How to Report Bugs or Problems” <http://dev.mysql.com/doc/mysql/en/bug-reports.html>. The basic commands you must execute to install and use a MySQL binary distribution are: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /|/path/to/my

Re: [MySQL] mysql/snort/webmin/permissions

2005-03-19 Thread Mark Sargent
s or Problems” <http://dev.mysql.com/doc/mysql/en/bug-reports.html>. The basic commands you must execute to install and use a MySQL binary distribution are: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /|/path/to/mysql-VERSION-OS|/.ta

Re: [MySQL] mysql/snort/webmin/permissions

2005-03-18 Thread Ashley M. Kirchner
Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. -- H | I haven't lost my mind; it's backed up on tape somewhere. +-

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > 5 is a number of version. MySQL-Max is a name of MySQL server, where > Max means that this MySQL server supports InnoDB and BDB storage > engines. So this make MaxDB another product > > Could anyone post a corre

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Victoria Reznichenko
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > On Tue, 9 Mar 2004 10:52:38 +0100 > "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > >> > I'm running: >> > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) >> > ps says I'm running mysql-max >> > mysql21397 0.0 1.7 71216 16064 pts/8 S

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
On Tue, 9 Mar 2004 10:52:38 +0100 "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > > I'm running: > > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) > > ps says I'm running mysql-max > > mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 > > /usr/sbin/mysqld-max > > > > that

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Martijn Tonies
Hi, > I'm running: > mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) > ps says I'm running mysql-max > mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 > /usr/sbin/mysqld-max > > that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support st

mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? but this fail create procedure pippo begin select 1

Re: Backup MYSQL & MYSQL 4.1

2003-10-22 Thread Victoria Reznichenko
Timotius Alfa <[EMAIL PROTECTED]> wrote: > > How to install Mysql 4.1, I always failed to do that ? pls help me If you have any problem with installation, describe it more detailed. > > and how to backup database in mysql ? You can use mysqldump, mysqlhotcopy programs, BACKUP TABLE and SELEC

Backup MYSQL & MYSQL 4.1

2003-10-22 Thread Timotius Alfa
How to install Mysql 4.1, I always failed to do that ? pls help me and how to backup database in mysql ? thank you - Do you Yahoo!? The New Yahoo! Shopping - with improved product search

RE: [mysql] MYSQL

2003-10-10 Thread Andy Eastham
ROTECTED] > Sent: 10 October 2003 00:25 > To: [EMAIL PROTECTED] > Subject: Re: [mysql] MYSQL > > > On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote: > > PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE > RECOMMENDED HARDWARE > > CONFIGUR

Re: [mysql] MYSQL

2003-10-09 Thread Bill Kendrick
On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote: > PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE > CONFIGURATION TO RUN MYSQL SERVER. THANKS. I think this depends on how big the database will be, how much it will be hit, etc!!! I've heard of MySQL

Re: Lookup used Version of MySql && MySql Foreign Keys and Referencial Integrity

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200: > I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the > used version. What is the command to do that? (according to mysql.info > it is Version 3.23.42. ) SELECT VERSION(); -- If you cc me or remove the list(s) completely I'll

Lookup used Version of MySql && MySql Foreign Keys and Referencial Integrity

2003-06-28 Thread Vince Veggus
Hello, I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) Are foreign keys and referencial integrity supported by MySQL Version 3.23.42. ? If yes - why is the second "insert into" com

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote: % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is "*" (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some id

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted -- ...and then [EMAIL PROTECTED] said... % % On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: % % >...and then [EMAIL PROTECTED] said... % >% ... % >% Most things I've read say to establish a "mysql" user -I take it this % >% is to ru

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a "mysql" u

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a "mysql" user -I take it this % is to run the daemon(mysqld?) under?

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
. Hope this helps. Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 8:12 PM To: MySQL List Subject: running mysql (mysql users) I wish to attempt to clarify one of my earlier questions: Most things I've read say to establi

Re: running mysql (mysql users)

2002-12-15 Thread Ryan McDougall
TR, Ok first I would like to say that I have just recently started using MySQL so I feel your pain and I hope my explination helps you out. The mysql user your referring to is probably the user that is should be used to run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm no

running mysql (mysql users)

2002-12-14 Thread tlr7425
I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a "mysql" user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also,

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Gelu Gogancea
ugust 16, 2002 8:19 PM Subject: Re: Strange network error using mysql,mysql c api > On Fri, 16 Aug 2002, Victoria Reznichenko wrote: > > > K> do someone know what should be the problem? > > K> Server is Win2K and has latest mysql server installed client is the one > >

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
On Fri, 16 Aug 2002, Victoria Reznichenko wrote: > K> do someone know what should be the problem? > K> Server is Win2K and has latest mysql server installed client is the one > K> from RedHat 7.3 (3.23.49) (=`mysql_config --version`) > > > Do you always get this error or you got it just once?

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Victoria Reznichenko
Krata, Friday, August 16, 2002, 5:10:20 PM, you wrote: K> Hi, K> i am using mysql c api to send some queries to mysql server which is on K> another computer (100MBit almost next to the client) K> in my code i am doing this K> if (mysql_real_query(mysql,query,strlen(query))) K>

Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
Hi, i am using mysql c api to send some queries to mysql server which is on another computer (100MBit almost next to the client) in my code i am doing this if (mysql_real_query(mysql,query,strlen(query))) { fprintf(stderr,"In query : \"%s\"\n",query);

Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
Hi, i am using mysql c api to send some queries to mysql server which is on another computer (100MBit almost next to the client) in my code i am doing this if (mysql_real_query(mysql,query,strlen(query))) { fprintf(stderr,"In query : \"%s\"\n",query);

Re: [MySQL] MySql can support Multi-Lingual??

2001-04-09 Thread 혀니
¹è¼ÒÁ¤ wrote: > Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun. > > Would you help me for MySql? ^^: > > I will develop some web-sites by Japanese, Chinese, English etc. > These sites will service at one server, one O/S. > > Many reference sites say: > "Japanese site will servi

Re: mysql/mysql++ fail on sun-solaris-sparc with segfault

2001-04-09 Thread Sinisa Milivojevic
HI! This is due to a bug in connection.cc. Rebuild MySQL++ with this source and you will have no more problems like this. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*|

mysql/mysql++ fail on sun-solaris-sparc with segfault

2001-04-09 Thread Ivan Kurmanov
EMAIL PROTECTED] >Organization: RePEc, http://repec.org >MySQL support: none >Synopsis: >Severity: critical >Priority: high >Category: mysql mysql++ >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Environment: Li

mysql/mysql++ fail on sun-solaris-sparc with segfault

2001-04-08 Thread Ivan Kurmanov
MySQL support: none >Synopsis: >Severity: critical >Priority: high >Category: mysql mysql++ >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Environment: Library used: Mysql++ 1.7.8 System: SunOS irwell 5.6 Generic_105181-20 sun

[MySQL] MySql can support Multi-Lingual??

2001-04-06 Thread 배소정
Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun. Would you help me for MySql? ^^: I will develop some web-sites by Japanese, Chinese, English etc. These sites will service at one server, one O/S. Many reference sites say: "Japanese site will service very well at Japanese