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

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]

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

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

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 on the

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 3543176 bytes

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

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

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

2005-03-20 Thread Mark Sargent
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|/.tar.gz | tar xvf - shell ln -s

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

2005-03-19 Thread Mark Sargent
://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|/.tar.gz | tar xvf - shell ln -s /|full-path-to-mysql

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.

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: 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 stored

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 *should* support

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 S10:32 0:00

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 correct 5

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: 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 SELECT ..

RE: [mysql] MYSQL

2003-10-10 Thread Andy Eastham
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 CONFIGURATION TO RUN MYSQL SERVER. THANKS. I think this depends on how big the database

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

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

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
: 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 establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created

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

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 run the

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

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,

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: 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 { K

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? well i

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Gelu Gogancea
_ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Krata [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 16, 2002 8:19 PM Subject: Re: Strange network error using mysql

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

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

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 /*/ /*/ /*/ \*\_ |*|

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 service very

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

2001-04-08 Thread Ivan Kurmanov
.org MySQL support: none Synopsis: synopsis of the problem (one line) 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_10518

[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