Re: Why Replication stops ?

- Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "hemanth" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 11:45 PM Subject: Re: Why Replication stops ? > On Wed, Mar 26, 2003 at 01:00:33PM +0530, hemanth wrote: > > Hi Jeremy, > > > > Many Th

Re: Why Replication stops ?

On Wed, Mar 26, 2003 at 01:00:33PM +0530, hemanth wrote: > Hi Jeremy, > > Many Thanks for your support. You're welcome. That's what this list is all about (usually). > May I know about ur participation in this IT industry. Yes, you may. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Li

Passing data between the web to an Intranet

Has anyone ever simply tried to pass information direct from the web into a secure Intranet mysql DB rather than to a web DB? I am thinking down one of three lines. 1) I use PHP to send an email with the data in it and update our internal DB manually (the worst case) 2) I use PHP which takes data

Re: Why Replication stops ?

Hi Jeremy, Many Thanks for your support. May I know about ur participation in this IT industry. Regards, HEMANTH On Wed, 2003-03-26 at 12:24, Jeremy Zawodny wrote: > On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > > Hi there, > > > > I am using MySQL 3.23.41 datab

Re: linux problem installation

Hi, On Tue, Mar 25, 2003 at 04:46:52PM +0200, tsvicka wrote: > I installed the mysql-standard-4.0.12-pc-linux-i686 binary installation according to > the installation instructions, but when I run the .bin/safe_mysqld --user=mysql & > it gave me: > mysqld ended. > > I looked in the log file and i

linux problem installation

HI I installed the mysql-standard-4.0.12-pc-linux-i686 binary installation according to the installation instructions, but when I run the .bin/safe_mysqld --user=mysql & it gave me: mysqld ended. I looked in the log file and it is written: Fatal error: Cant open privilege tables: Cant find file:

Re: MySQL Daemon wont start

Hi, On Wed, Mar 26, 2003 at 02:46:15PM +0800, Toto Gamez wrote: > i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql > daemon started but dies i tried to check the log and says: > 030326 14:35:46 mysqld started > 030326 14:35:47 /usr/libexec/mysqld: Can't find file:

Re: Why Replication stops ?

Hi, On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > I am using MySQL 3.23.41 database in 2 Systems. > Getting replication done in MySQL is really cool. > > But I often face MySQL replication issue. > Replication is getting stopped. > > kindly let me know what could be the re

BUG: Load data infile & replication - 3.23.56

Replication doesn't seem to be replicating LOAD DATA INFILE correctly in 3.23.56. Starting with a master and slave that were in sync, I imported a file: --- MASTER mysql> select count(*) from list where sourceID=0; +--+ | count(*) | +--+ |0 | +--

MySQL Daemon wont start

i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql daemon started but dies i tried to check the log and says: 030326 14:35:46 mysqld started 030326 14:35:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030326 14:35:47 mysqld ended how do I c

Re: Why Replication stops ?

On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > Hi there, > > I am using MySQL 3.23.41 database in 2 Systems. > Getting replication done in MySQL is really cool. > > But I often face MySQL replication issue. > Replication is getting stopped. > > kindly let me know what could

Why Replication stops ?

Hi there, I am using MySQL 3.23.41 database in 2 Systems. Getting replication done in MySQL is really cool. But I often face MySQL replication issue. Replication is getting stopped. kindly let me know what could be the reasons ? And also kindly let me know if there is anyway to autom

Re: Problem using DBI with MySQL and SSL

On Mon, 24 Mar 2003, Casella, Richard A wrote: > I am having a problem getting this to work and the documentation > I have found doesn't seem to be helping, hopefully someone out there > can help me. > > I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured > MySQL exactly as the m

RE: sum() using group, and duplicates problems...

On 25-Mar-2003 Black, Kelly W [PCS] wrote: > > On 25-Mar-2003 Black, Kelly W [PCS] wrote: >>> Hello. >>> >>> Sorry for the long post. This has been a big problem for me, and I >>> hope someone will help... >>> >>> I have a long standing problem with an MySQL query. >>> Or perhaps a couple of

Re: fulltext search

At 09:03 PM 3/25/2003, you wrote: On Monday 24 March 2003 04:04 pm, Brian McCain wrote: > Maybe they should set up some way to donate via PayPal. I'm sure there are > plenty of developers around the world who'd be willing to chip in $10 here > or $20 there in order to be able to use fulltext search

RE: completely resetting root account

There are many things "short of wiping the hard drive" that you can try. I just had this happen and was able to find the answer quickly on www.mysql.com IE: http://www.mysql.com/doc/en/Resetting_permissions.html Just read, step back, think, then try something. You shouldn't need to rebuild ever

completely resetting root account

Okay, so this question may not indicate I'm smart enough to administer MySQL and I should slowly back away from the keyboard, but here goes... When using phpMyAdmin, I attempted to duplicate the root account, which had access to everything. I accidentally selected the wrong radio button, which

Re: Problem starting 4.0.12 server

Does the mysql user have permission to write to /var/lib/mysql? -jeff On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote: > >Description: > Just installed the rpm files for Linux x86 downloaded from the web. > After installing rpm files, server won't start. The error (from the log) is: >

Re: fulltext search

On Monday 24 March 2003 04:04 pm, Brian McCain wrote: > Maybe they should set up some way to donate via PayPal. I'm sure there are > plenty of developers around the world who'd be willing to chip in $10 here > or $20 there in order to be able to use fulltext searching on InnoDB > tables. > > I know

Problem starting 4.0.12 server

>Description: Just installed the rpm files for Linux x86 downloaded from the web. After installing rpm files, server won't start. The error (from the log) is: 030325 21:23:41 mysqld started 030325 21:23:41 Can't start server : Bind on unix socket: Permission denied 030325 21:23:41 Do y

RE: mysqladmin -u root -h myhost password 'new-password' fails

You guys probably need to start mysql with the --skip-grant option and fix the allow tables... See the mysql.com website or google.com for "lost password" "mysql" -Original Message- From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:09 PM To: [EMAIL PROTECTED]

RE: mysql install---help please

Sorry you would use the name of the system, or the ip like so... (in pseudo terms) mysql -u yourpersonaluserid -p -h thehostiuse.com or mysql -u yourpersonalloginid -p -h ipaddress (such as 203.12.34.56) sql query ~KB -Original Message- From: katherine bjork [mailto:[EMAIL PROTECTED] Se

RE: Maybe OT: Anyone Familiar w/ Dreamweaver MX: PHP Web Development?

I don't use Dreamweaver so I have no clue what the interface is like. But basically the php function mysql_connect or mysql_pconnect will be somewhere in the page. It takes the username, host, password ect. as arguments. You script might be set up with variables that hold these defined at the to

how to remove mysql

How do I remove mysql from my mac. I tried the script on the entropy website but it only works on version older than 4.x. I can seem to find any documentation regarding removal on the products website either. Katherine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Maybe OT: Anyone Familiar w/ Dreamweaver MX: PHP Web Development?

Well, MySQL is involved to the extent that the "Web Development" of the title does involve MySQL database-driven applications. So, is anyone familiar with this book. I'm in one of the last chapters and I am hopelessly lost trying to find the proper places to input my username, password, and db

Re: Spanish

> I need , obtain the month in spanish, $B%=(Bhow can do it...? (B> (B> NOTE: Linux is in spanish , and mysql also. (B (BWorst comes to worst, you could always build a small table of the month (Bnames in Spanish and index the table by the month number. (B (B-- (BJoel Rees <[EMAIL P

Re: mysqladmin -u root -h myhost password 'new-password' fails

Karl, yes, same problem here. Looking at the user table it seems the entry is there, but mysqladmin failed. I also attempted to set by hand the password using update table. The update succeeded, but then when I used mysql -u root -h -p and typed in the password, mysql also denied access saying t

mysqladmin -u root -h myhost password 'new-password' fails

>Description: I installed the 4.0.12-max binary distribution for x86-linux (got the same behavior with -standard). This was a brand new installation. When I ran scripts/mysql_install_db, it tells me: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin

Re: Creating fulltext index never completes...?

> ... > It dawned on me that perhaps the problem had to do with double-byte > characters, What language is this text in? Is it by chance a language that does not use whitespace to delimit words? -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mys

Re: Your professional opinion Please...

On Tue, 2003-03-25 at 18:11, Brian wrote: > > What mechanism do you recommend? > > Something in perl, python or php? > Well... I tend to be a Perl bigot so I'd choose Perl. I would do a couple of things. 1) I'd develop a list of words to ignore such as "and", "if" ,"but" etc. etc.. This may

VC dump

when I attempt to run your sample I get \WindowsMySQL\lib\debug\libmysql.lib : fatal error LNK1106: invalid file or disk full: cannot seek to 0x3e74f746 All disks have 1gb + free so its not a disk full.. I have seen this error happen when someone puts a corrupted library on their site so... Is ther

Re: MYSQL ending right after starting

On Tue, Mar 25, 2003 at 06:31:55PM -0500, [EMAIL PROTECTED] wrote: > We recently upgraded to mysql 4.0 on Mandrake 9. When typing > safe_mysqld & mysql starts then immediately stops saying mysqld daemon ended. > There are no other processes running. Tried installing 3.23 and the same >

RE: mysql install---help please

Try /usr/local/mysql/bin/mysql -u userid -p -h hostname password: mysql> Regards, Kelly Black Linux was very clearly the answer, but what was the question again? -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:16 PM To: katherine bjo

RE: Your professional opinion Please...

Brian, Here's Some hints on how to accomplish an efficiant way to index the data Regular Expressions: ([\w\d]{5,64}) -Matches all Word and Mumeric data in a given string Database Tables files : [int id][char*255 fil

RE: MYSQL ending right after starting

We recently upgraded to mysql 4.0 on Mandrake 9. When typing safe_mysqld & mysql starts then immediately stops saying mysqld daemon ended. There are no other processes running. Tried installing 3.23 and the same thing. Reinstalled 3.22 and it stays started. What is not allowing mysql

Re: Your professional opinion Please...

- Original Message - From: "James E Hicks III" <[EMAIL PROTECTED]> To: "Joe Lewis" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Cc: "Brian" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 8:56 AM Subject: RE: Your professional opinion Please... > > I'd use MySQL, Apache, and UDMSEA

Re: Your professional opinion Please...

- Original Message - From: "Joe Lewis" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Cc: "Brian" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 8:42 AM Subject: Re: Your professional opinion Please... > Peter L. Berghold wrote: > > On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian

RE: mysql install---help please

You said that you changed the password to the password you wanted, but in all the examples you are trying to access the server without a password. Try using the -p flag so it prompts you for your password, then type in whatever you set the password to be. -Original Message- From: katherin

Re: Your professional opinion Please...

> On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: > > I have a client with approximately 2 gigabytes of un-indexed > > document files (includes text and graphics). > > He wants to be able to enter a few parameters and bring up > > a list of all... > If they are flat text files this shoul

Re: Your professional opinion Please...

Hi Nick: - Original Message - From: "Nick Arnett" <[EMAIL PROTECTED]> To: "Brian" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 7:47 PM Subject: RE: Your professional opinion Please... > > I have a client with approximately 2 gigabytes of > > un-indexed doc

mysql install---help please

Tried for the second time to install mysql on my mac and again a problem during the install related to the password. I typed in /usr/local/mysql/bin/mysqladmin -u root password 'new-password' and changed 'new-password' to the password I wanted. Got the --> on the next line but nothing else so

RE: Permission Setup

Try using GRANT ALL ON Security.* TO newbuddy@'%' INDENTIFIED BY 'password'; Regards, Kelly Black Linux was very clearly the answer, but what was the question again? -Original Message- From: Terrance Win [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 12:57 PM To: [EMAIL PROTEC

Re: Permission Setup

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Terrance Win wrote: Dear Stefan, Sorry for incomplete information and also thank you for your help. Here is the recent condition .. --- mysql>status; - mysql Ver 12.18 Distrib 4.0.

RE: Allowing a user to change their password

>From the command line a user would type SET password = PASSWORD('newpassword'); If you have an application this works as a straight executed command. I do agree with confirming old password before changing if using an application. This works for any connected user without granting anything extra.

Re: Allowing a user to change their password

I suggest you to make a special application for this operation. With three-tier architecture for example and your application ask the current passord to make sure that they are the legal user before your sql query change their password through your application. --- "Shawn P. Garbett" <[EMAIL PROTEC

Re: Permission Setup

Dear Stefan, Sorry for incomplete information and also thank you for your help. Here is the recent condition .. --- mysql>status; - mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98(i32) Connection id: 338 Current datab

Re: connect to mysql server

Sidar, > how do i create a user that can connect to any database from any host on my lan mysql> GRANT ALL ON *.* TO 'youruser'@'192.168.%' IDENTIFIED BY 'secret'; Assuming your network has IP addresses starting with 192.168. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

connect to mysql server

how do i create a user that can connect to any database from any host on my lan :-) Sidar Lopez Cruz - Cero Riesgo, S.A.

Re: You are not owner of thread xxxx

Mark, > Is there a way for root to kill a user's thread without using that > user's password? You could use: mysql> SHOW PROCESSLIST; ++---+---+--+-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info

Re: You are not owner of thread xxxx

On Tue, Mar 25, 2003 at 12:15:05PM -0800, Mark wrote: > hi, > Is there a way for root to kill a user's thread without using that > user's password? root can kill any thread, by default. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zaw

You are not owner of thread xxxx

hi, Is there a way for root to kill a user's thread without using that user's password? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Permission Setup

Terry, > I 've a problem with permission setup. In my newly install MySQL > server; First, I log into as 'root' and create a database, lets say 'myDB'. > Then I Grant a user name 'admin' with password to that database'myDB' in > hostname 'network.srv'. Then I log out from root account. L

Permission Setup

Dear Experts, I 've a problem with permission setup. In my newly install MySQL server; First, I log into as 'root' and create a database, lets say 'myDB'. Then I Grant a user name 'admin' with password to that database'myDB' in hostname 'network.srv'. Then I log out from root account. I

RE: sum() using group, and duplicates problems...

On 25-Mar-2003 Black, Kelly W [PCS] wrote: > Hello. > > Sorry for the long post. This has been a big problem for me, and I > hope someone will help... > > I have a long standing problem with an MySQL query. > Or perhaps a couple of sql query problems... > > Firstly I have been told I cannot u

Re: mysql_query to return immediately when connection lost

Hi, In this case i guess is better to execute mysql_ping() before mysql_query(). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Mess

Re: mySQL with C

At 7:46 -0500 3/25/03, David Matthews wrote: Actually I meant using the mySQL API with C :\ You can download a chapter on using the C API from: http://www.kitebird.com/mysql-book/ At 02:39 PM 24/03/2003 -0800, Brian McCain wrote: If you mean a tutorial for compiling MySQL from source using gcc3

Re: fulltext search

On Mon, Mar 24, 2003 at 03:04:00PM -0800, Brian McCain wrote: > > Maybe they should set up some way to donate via PayPal. I'm sure > there are plenty of developers around the world who'd be willing to > chip in $10 here or $20 there in order to be able to use fulltext > searching on InnoDB tables.

Re: Trouble with MySQL4, host field in show processlist

Hi, I opened today a bug report for a similar bug here : http://bugs.mysql.com/bug.php?id=189 This problem only happens with DELAYED thread. Regards, Jocelyn - Original Message - From: "Sasa Ugrenovic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 5:37 PM Su

RE: Speed of SELECT ... LIMIT #,#?

> -Original Message- > From: Nick Arnett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 25, 2003 8:48 AM ... > Just noticed something odd, though, with the MySQLdb SSCursor. > When close() > is called, it does a fetchall(), getting any records that you hadn't > retrieved, trying to load

Re: Trouble with MySQL4, host field in show processlist

Sasa, > Now, it all works great, but the host field, in show processlist > command, don't work correctly. > It don't display correct info from where the query has came. > Example: mysql>> show processlist; > ++--+-+--++--+

Re: MyCC

Dave, > I've noticed something with MySQL Control Center. Today I wanted to browse > an entire table, which has roughly 35,000 rows. I unchecked the "limit to > 1000" box in the General Options and double-clicked on the table. Once MyCC > started to display the table, my free memory dropped to

sum() using group, and duplicates problems...

Hello. Sorry for the long post. This has been a big problem for me, and I hope someone will help... I have a long standing problem with an MySQL query. Or perhaps a couple of sql query problems... Firstly I have been told I cannot use sum() on a value while using group by "parm" because it's n

MyCC

I've noticed something with MySQL Control Center. Today I wanted to browse an entire table, which has roughly 35,000 rows. I unchecked the "limit to 1000" box in the General Options and double-clicked on the table. Once MyCC started to display the table, my free memory dropped to 4 MB and perfor

RE: load data infile question

Just an update... I was able to work around the problem by giving "insert" privileges to the user for the WHOLE database. This is definitely not optimal because I only wish this user to be able to insert into one table in the database. But as soon as I gave the user insert privileges for the who

RE: Your professional opinion Please...

> I'd use MySQL, Apache, and UDMSEARCH. It provides the web interface for > the google search engine (Apache and UDMSearch), while connecting to > MySQL. If you want, the re-indexing can occur using a cron, and then by > making apache serve the documents from the root and doing the fancy > in

RE: Speed of SELECT ... LIMIT #,#?

> -Original Message- > From: Joseph Bueno [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 25, 2003 1:36 AM .. > If you want to speed it up, you have to make it use an index. > You need to add a WHERE or an ORDER BY clause. > Have you tried : > SELECT Message_ID, Body FROM Body_etc ORDER

Trouble with MySQL4, host field in show processlist

Hi, My first post here l;) Ok, here it goes. I recently installed MySQL4 and transfered all my databases there. Now, it all works great, but the host field, in show processlist command, don't work correctly. It don't display correct info from where the query has came. Example: mysql> show proc

Re: Your professional opinion Please...

Peter L. Berghold wrote: On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all [snip] I'd leave them as flat text fil

Re: embedded group function

Hu, > SELECT MAX(COUNT(*)) That makes no sense. COUNT(*) will list the number of rows in your table, whereas MAX(column) will list the hightest value of in your table, like that: mysql> SELECT COUNT(*) FROM t; +--+ | COUNT(*) | +--+ |4 | +--+ 1 row in set (0.00 s

Re: Encode Function

Did you check the source? Sean Biganski wrote: Any know what algorithm MySQL uses for its encode/decode functions?? Sean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Encode Function

Any know what algorithm MySQL uses for its encode/decode functions?? Sean

Re: mysql_query to return immediately when connection lost

Hi, In this case I do have a DNS server. Any other hint please? I strongly need mysql_query to return immediately if connection is lost with the server. Any configuration parameter or similar on MySQL? Need to reconfigure something in the OS? Thanks. Pedro Gelu Gogancea wrote: > Hi, > > This is

Re: embedded group function

Hi, you can use something like this select count(*) as co from ... group by ... order by co DESC limit 0,1 HTH Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ - Original Message - From: "Hu Qinan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 16

Re: mySQL with C

Actually I meant using the mySQL API with C :\ At 02:39 PM 24/03/2003 -0800, Brian McCain wrote: >If you mean a tutorial for compiling MySQL from source using gcc3.2, try >here: > >http://www.mysql.com/doc/en/Installing_source.html > >-Brian McCain > >- Original Message - >From: "David Mat

Using LOAD DATA IN FILE or SOURCE with MyODBC.

Hello all, I am thinking about produceing a small app that will use MyODBC on a windows machine to connect to a MySQL server on a remote FreeBSD machine. I already have something that will open an MS Access database and output either a MySQL syntax or CSV file and before i start

embedded group function

All, I tried to use SELECT MAX(COUNT(*)) FROM ... GROUP BY ... in MySQL. But an error occured: Invalid use of group function. Is it necessary to create a temporary table to store the COUNT(*) results, and then get the MAX from it?

Re: Your professional opinion Please...

On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: > I have a client with approximately 2 gigabytes of un-indexed document files > (includes text and graphics). > > He wants to be able to enter a few parameters and bring up a list of all If they are flat text files this should not be too big

Re: java.sql.SQLException: Update failed, possible duplicate entry

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wileynet wrote: Here is another beginner question of sorts I imagine. I receive this error. java.sql.SQLException: Update failed, possible duplicate entry I've got this code in a .jsp page. <% String ref=request.getHeader("Referer");%> <% count.ad

Re: java.sql.SQLException: Update failed, possible duplicate entry

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wileynet wrote: Here is another beginner question of sorts I imagine. I receive this error. java.sql.SQLException: Update failed, possible duplicate entry I've got this code in a .jsp page. <% String ref=request.getHeader("Referer");%> <% count.ad

Restoring a DB

If I have a file, mydb.mbk that was created with mysqldump, how do I recreate/restore the DB? Do I run a command line using "mysql" with a switch and "mydb.mbk"? Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED]

Spanish

Title: Mensaje Hello:     I need , obtain the month in spanish, ¿how can do it...?   NOTE: Linux is in spanish , and mysql also.   Thanks, regards   Carlos Rodrigo [EMAIL PROTECTED] www.amyc2000.com 

Re: mysql_query to return immediately when connection lost

Hi, This is usually happened becuase you don't have configured a DNS server in your network. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -

mysql_query to return immediately when connection lost

Hello, My client uses mysql_query to access a remote server. When the connection is lost (cable disconnected), mysql_query doesn't return immediately and I need a fast error return. I have tried executing mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, &connectTimeout); (connectTimeout=1), always

Re: mysqld immediately stops

Miso Simovic schrieb: when i try to run the MySQL server, this happens: [EMAIL PROTECTED] root]# /usr/bin/safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql 030324 21:09:10 mysqld ended 1) You have to "be" in the /usr directory and type ./bin/save_mysqld 2) This will block

Re: mysqld immediately stops

# [EMAIL PROTECTED] / 2003-03-24 21:15:46 +0100: > i've got MySQL installed from RPM. > when i try to run the MySQL server, this happens: > [EMAIL PROTECTED] root]# /usr/bin/safe_mysqld > Starting mysqld daemon with databases from /var/lib/mysql > 030324 21:09:10 mysqld ended > > why does it sto

Try to compile development source. mysql1-4 Aborts in MAKE...

From: swi To: [EMAIL PROTECTED] Subject: Try to compile development source. mysql1-4 Aborts in MAKE... >Description: Screen output is attached at the bottom. I aborts in MAKE, Might have a problem with Libtool, but can't figure out. >How-To-Repeat: See screen output. (Foll

Re: InnoDB Foreign Keys

# [EMAIL PROTECTED] / 2003-03-24 23:49:59 +0100: > this is what Mysql Reference Manual tells me about creating foreign > keys. > I understood how to use them, except for the restrict here ---\ > | > [CONSTRAINT symbol] FOREIGN KE

RE: Cannot Update MYSQL Database

I think you probably need to do one of the following; Insert into info set referer = ? Or Insert into info (referer) values (?) But I could be wrong. -Original Message- From: jsp [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March 2003 07:17 To: 'Tomcat Users List' Cc: [EMAIL PROTECT

Re: Deleting a large group of numbered records

Hi, I would use the following sql delete from table where id in (value1,value2, ...) But if the list is to big you might want to inrease the "max_allowed_packet" configuration variable Also you can write a simple script to read the values from the file. Here is an example in PHP $fp=fopen("fi

Re: Speed of SELECT ... LIMIT #,#?

If you want to speed it up, you have to make it use an index. You need to add a WHERE or an ORDER BY clause. Have you tried : SELECT Message_ID, Body FROM Body_etc ORDER BY Message_ID LIMIT N,M Of course, I assume that Message_ID is indexed ;) Regards, Joseph Bueno Nick Arnett wrote: -Original

Re: AW: InterBase vs. Mysql

Despite of this When I see your picture on: http://www.mysql.com/company/management.html I think you were the one to explain the relation between MySQL and Firebird.to me on CeBIT 2002 :-) Bernhard - Original Message - From: "David Axmark" <[EMAIL PROTECTED]> To: "Bernhard Döbler"

Re: building MySQL on Alpha-Dec-OSF4 with gcc

On 24 Mar 2003 at 10:37, Dan Nelson wrote: > In the last episode (Mar 24), Ralf Hupfer said: > > I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- > > DEC-OSF4 workstation. > > > > CC="cc -pthread" CXX="cxx -pthread -O" ./configure > > --with-named-thread-libs="-lpthread -lm

documentation on new MySQL 4.1 features

Hi, I have just downloaded + compiled the latest bitkeeper version of MySQL 4.1 and of the MySQL manual (bk://mysql.bkbits.net/mysqldoc). I would like to test the new features, especially the new charset/unicode support, R-trees etc., but I fail to find any detailed documentation on it. http://ww