Re: rotating table???

On Wed, Aug 28, 2002 at 05:33:57PM -0500, Naushit Sakarvadia wrote: Is it possible to limit size of table? For example I want xyz table to limit 1 GB and once it reaches 1 GB it should start overwriting oldest data. Is it possible to do this in Mysql? or is there any client that can

Mysql on a separate server from webserver

I have written previous websites where I used perl or PHP to access a Mysql DB wen bith the webserver and the Mysql db are on the same server. My questions is how different is it to access or connect to the Mysql database when the database is on a separate server(machine)? Thanks, Nestor A.

Re: Mysql on a separate server from webserver

Hi, I have written previous websites where I used perl or PHP to access a Mysql DB wen bith the webserver and the Mysql db are on the same server. My questions is how different is it to access or connect to the Mysql database when the database is on a separate server(machine)? Juste

Re: JAMES KADEH mysql !

James, I took the liberty of forwarding your requests to [EMAIL PROTECTED] I hope you don't mind. For those who are not familiar with poor James's situation, I offer (again) these links: http://home.rica.net/alphae/419coal/

Re: mysqlhotcopy problem - Segmentation fault

On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote: I have strange problem - I get Segmentation fault error when I am trying to execute mysqlhotcopy. When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it works. Meanwhile, on another server it works just

Re: looking for handler_read value

On Tue, Aug 27, 2002 at 05:40:48PM -0400, Marc Prewitt wrote: I'm trying to put together some statistics on our queries and am wondering what percentage of our queries involve a full table scan. The variable which kind of tracks this is Handler_read_rnd_next. However, since a query may

database migration

HI, I would like to know if there is a program/script that can migrate data from sybase ASE server to MySQL ??? Just tables - lots and lots of tables (about 12GB of data !!!) Many Thanks Tonino - Before posting, please

Re: Problem Installing mysql-3.23.52

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 28 August 2002 22:53, Carlos Oyarzún wrote: I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m using the following procedure: ./configure --prefix=/usr/local/mysql make make install The first two commands

Compiling DLL on windows: undefined reference errors during linking?

I have addressed this problem in the thread Re: developing clients in C with Dev-C++ on [EMAIL PROTECTED] Tor Erling Unander Trondheim, Norway == I am trying to compile a file on windows and build a DLL, this has worked before

Re: MySQL 4.0 on Debian

Hello On Thu, 1 Aug 2002, Quinten Steenhuis wrote: Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running into problems if I use alien to convert the RPMs. Yep, we're using 4.0.2 on Debian. You may want to grab MySQL .tar.gz instead of .rpm and install it somewhere into

granting grant option creates a (new) user ?!

MySQL : it seems that a user who has grant privilege can grant access to a(his) database to :another user although this other user doen't exist - in this case the other user is :newly created! can cause a mess in your usertable when you have a site with some :databases to administer

Help please - MySQL 3.23 stability / binary

Hi, I'm using: Tyan m/b, 2x U160 scsi disks, dual Athlon MP CPUs, 2Gb RAM + 2GB swap RH 7.3, 2.4.18-5smp kernel MySQL 3.23.51 (MySQL Linux tar.gz) binary used based on the comments on the download page about gcc 2.96 compiled versions resulting table corruptions, etc. I have a couple of

Re: granting grant option creates a (new) user ?!

Markus Reger wrote: MySQL : it seems that a user who has grant privilege can grant access to a(his) database to another user although this other user doen't exist - in this case the other user is newly created! can cause a mess in your usertable when you have a site with some databases to

Re: Help please - MySQL 3.23 stability / binary

From: borracho 138 [EMAIL PROTECTED] I've searched for more information on these issues, without luck. The system randomly spirals out of control - load avg increases very rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the server is fine, handling the busiest loads.

Connecting to another machine with myCC

Folks, I have a question about myCC. I can't connect to a local linux machine (ip 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using myCC. I've done the following: GRANT ALL ON test.* TO 'fred'@'192.168.0.230'; FLUSH PRIVILEGES; but, in my mysql.log I still get:

Re: RE: MS Access and mySQL

Mary, Wednesday, August 28, 2002, 7:49:22 PM, you wrote: MS see my message re--- index problem MS ok when I do explain in this , it is not using an index for the MS AdminCoverage_writingagents table... MS SELECT admincoverage_writingagents.WritingAgentID, MS

Re: Re: load data into table from file or how to set the local-infile=1

Mertens, Wednesday, August 28, 2002, 6:52:12 PM, you wrote: MB On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: Put into my.cnf file : [mysql] local-infile=1 or start mysql client with --local-infile=1 option. MB I tried the first option and it works when use the following command to MB

Re: CREATE TABLE adds ZEROFILL

martin, Wednesday, August 28, 2002, 10:12:13 PM, you wrote: m Description: m I am porting MySQL to Linux/Alpha. On some occasions m the CREATE TABLE statement adds ZEROFILL for int(11) m fields. If you don't know this problem, let me know m so I can try to fix it.

delete rules in mysql

Dear All! Can we use delete rules such as delete on cascade in MySQL or I will have ti handle this on the client side? Regards sql, mysql, query - Before posting, please check:

CygWin layer into win32 MySQL 4

Hi! I would like to ask you this for my curiosity: into mysql 4.02 win32 it exist a cygwin posix emulation layer, it's used for the client or for the server app? Cygwin emulation layer it's very slow into win32, can you translate cygwin calls into direct win32API's (without cygwin)? TNX

Re: Connecting to another machine with myCC

Hi, Try another tool named My Database Manager. You can download the site br.geocities.com/burbello. Greedings Alexander - Original Message - From: Fred Tsang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 7:38 AM Subject: Connecting to another machine with

auto_increment fields

How many auto_increment fields can I have in a database? Thanks ilyas filter:mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Errcode: 13

Description: problem installing MySQL-3.23.52-1 How-To-Repeat: shell rpm -Uvh MySQL-3.23.52-1.i386.rpm MySQL ## Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv

Re: Help please - MySQL 3.23 stability / binary

From: borracho 138 [EMAIL PROTECTED] Many thanks for the reply - nice to know that I'm not the only one with this issue(!) Seems like my problem is related to 2 areas: - I'm concerned about the lack of memory 'freeing' with the system, but a kernel upgrade may fix that Don't have this

Digest, please!

I've read the info file and the non-existant FAQ file so I've done my homework. Yet, I can't seem to get this listserv to accept a digest command; I keep getting bounced. Does mysql list support receiving by digest?? If so, how? Thanks! -Dave

Re: load data into table from file or how to set the local-infile=1

It shoul d be running as user mysql . Mertens Bram wrote: On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: As it says in the documentation, If the LOCAL keyword is specified, the file is read from the client host. If LOCAL is not specified, the file must be located on the server. That

Re: Errcode: 13

Liisa, Thursday, August 29, 2002, 3:46:09 PM, you wrote: LK Description: LKproblem installing MySQL-3.23.52-1 LK How-To-Repeat: LK shell rpm -Uvh MySQL-3.23.52-1.i386.rpm [skip] LK ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13) [skip] It's a permission problem.

Re: delete rules in mysql

Chugh, Thursday, August 29, 2002, 2:18:26 PM, you wrote: CS Can we use delete rules such as delete on cascade in MySQL CS or I will have ti handle this on the client side? Yes, you can use ON DELETE CASCADE and ON DELETE SET NULL with InnoDB tables:

request for support with mysql_store_result() and mysql_field_count() with vbscript

general outline of situation; my office is moving away from microsoft (resistance is NOT futile!!! go slashdot!), and establishing web-based customer service systems. i'm currently establishing a customer table, that links to a contact table. each customer will be listed once; to be the customer

MYSQL Signal 16

Does anyone know what a signal 16 from a MYSQL thread means ? 020829 5:56:56 Warning: Got signal 16 from thread 1204584 thanks Adam - Before posting, please check: http://www.mysql.com/manual.php (the manual)

How to compile embedded MySQL on Windows

Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for version 4.0, so I should have

Re: MYSQL Signal 16

Hi, I don't know if this help you too much. Signal 16 is SIGUSR1.In Linux (and Unix) environment are signals which can be used like User Defined Signal. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

RE: performance tunning 4.x

Hi, Start by looking at the MySQL documentation: http://www.mysql.com/doc/en/Query_Cache.html Read the entire 6.9 section. It offers quite a bit of information on how the cache operates, how you should configure it and so on. Regards, Iikka likka, I read it too but I have a

Re: How to compile embedded MySQL on Windows

Tobias Eriksson wrote: Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for

Installing mysql 4.0.3 with linux threads on freebsd

Hi people, I have a FreeBSD server where I installed mysql 3.23 with linux threads from a port collection, the procedure was simple enough (WITH_LINUXTHREADS=yes make). All my attempts then to build it from sources were unsuccessfull, however it was not important consdering that it could be

Re: request for support with mysql_store_result() and mysql_field_count() with vbscript

Hi, If i understand well, you wish to use MySQL C API function in VBScript.It's not possible in this way. But why you don't wish to use ADO? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

RE: performance tunning 4.x

Hello, A MySQL developer would be able to answer to these questions more accurately, but I'll try to answer _logically_. So don't bet a million dollars on the correctness of my answer. NOTE: The query cache does not return stale data. When data is modified, any relevant entries in the query

Re: mysqlhotcopy problem - Segmentation fault

Yes, both run 3.23.49a - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:24 AM Subject: Re: mysqlhotcopy problem - Segmentation fault On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail

like problem

i need this consult select a.name from table1 a, table2 b where a.name like '%b.name%'; but i have a problem because Mysql not recognize the value of b.name - Before posting, please check: http://www.mysql.com/manual.php

Stored Procedureish Advise needed

Hello gang, I have an application (radius) that is logging network activity to MySQL. When a users completes a network session an accounting insert query is made for that session showing the session length. The application has the functionality to SUM all session times for a user and determine

Re: MySQL 4.0 stable release

On Tue, 27 Aug 2002, Dean Ellis wrote: The annoying thing about it, for me, is that MySQL 4.0 has been perfectly stable and perfectly usable for us until 4.0.3, which so far has yet to produce a usable client library. I keep pulling from CVS and recompiling, hoping that one day soon I'll

Java and Mysql, problem with String encoding

Hello, I have an applet that uses mysql. I have added support for greek and for data that are already in mysql, it works fine. When I add other from my applet it prints . Another thing is that I construct a table from the resultSet using two (String) vectors. The table headers come out

RE: like problem

that would be because b.name is inside the ' ' and it is taken as a constant. -Original Message- From: Jorge Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:10 AM To: [EMAIL PROTECTED] Subject: like problem i need this consult select a.name from table1 a,

How to apply the mysql++ api patch

Hi I need to use the mysql c++ api in combination with gcc 3.0. I have downloaded the patch but I have trouble applying it. I've tried the patch tool but that did not seem to understand the patch file. Is there a solution or do I need to manually change every single file mentioned in the

RE: like problem

yes, but select a.name from table1 a, table2 b where a.name like '%'b.name'%'; is an error - Original Message - From: Mary Stickney [EMAIL PROTECTED] To: Jorge Martinez [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:26 PM Subject: RE: like problem that would

RE: like problem

ok try this select a.name from table1 a, table2 b where a.name like '%'+ b.name + '%'; -Original Message- From: Jorge Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 11:48 AM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: like problem yes, but select a.name

Re: Stored Procedureish Advise needed

In the last episode (Aug 29), John Gruber said: I have an application (radius) that is logging network activity to MySQL. When a users completes a network session an accounting insert query is made for that session showing the session length. The application has the functionality to SUM all

Re: Installing mysql 4.0.3 with linux threads on freebsd

Please don't hijack threads; you replied to a message titled performance tunning 4.x. In the last episode (Aug 29), Varshavchick Alexander said: I have a FreeBSD server where I installed mysql 3.23 with linux threads from a port collection, the procedure was simple enough

Re: like problem

Hi, Mary gives you a sugestion about how can you use field(b.name) in this case. You can try this : select a.name from table1 a, table2 b where a.name like CONCAT('%',b.name,'%'); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail

Re: like problem

How about select a.name from table1 a, table2 b where a.name like concat(%,b.name,%); You might want to read chapter 6.3 in the mysql manual: http://www.mysql.com/doc/en/Functions.html HTH, Jed On the threshold of genius, Jorge Martinez wrote: yes, but select a.name from table1 a, table2 b

RE: like problem

I'm doing this in the command line of mysql for linux. I tried your suggestion and the results was bads. it assume that I write a.nombre like '%' and shows all registers. any suggestion?? thanks - Original Message - From: Mary Stickney [EMAIL PROTECTED] To: Jorge Martinez [EMAIL

RE: like problem

muchas gracias!! you are a genius. it's all, I can to continue working thanks Sandra - Original Message - From: Jed Verity [EMAIL PROTECTED] To: Jorge Martinez [EMAIL PROTECTED]; Mary Stickney [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:08 PM Subject: Re: like

Re: Stored Procedureish Advise needed

Hi, Some what it seems to be like store procedure for MySQL you can find on: http://www.fastflow.it/mylua/ For trigger you don't have alternative.You must write a simple application which monitoring your Internet Sessions and writing in MySQL DataBase. Regards, Gelu

Java and Mysql, problem with String encoding

Thank you for your answer. I have to apologise for my bad post(I work 1 week on this problem and it was a desperite try). I have done what you suggested, but it partly works. Without useUnicode=true I didn't get anything right. With useUnicode=true I did get the data that were already in my

RE: Mysql on a separate server from webserver

Something like this: $site::dbName= 'DBI:mysql:test:10.10.2.20'; for a database called test on 10.10.2.20 Then add the user for the web machine (assuming it's 10.10.2.10) to the authorized list: Grant select on test.* to [EMAIL PROTECTED] identified by 'password'; Flush privileges;

Trouble configuring Tomcat 4.0.4 JNDI connection to MySQL

I'm having trouble connecting to MySQL using JNDI with Tomcat. I have deleted my server.xml and started with a fresh copy. First, I made sure I could connect to MySQL with a regular JDBC connection. Next, I added a JDBC Realm using MySQL. That works fine. Finally, I added a JDBC resource and

DATES and WHERE

I'm a bit confused here.. dates are not my strong point.. I have a table with a date column in it (DATE datatype) a few values: mysql select dte from images\G *** 1. row *** dte: 2002-08-29 *** 2. row

user password self management -- how?

This is actually a bit of a general-database question, since I'm sure it has the same or similar repercussions regardless of which RDBMS you use, but I'm curious: is it possible to safely allow users to maintain their own passwords to a database? [and if so, how?] I'm sure I can do this

Re: Java and Mysql, problem with String encoding

John Deligiannis wrote: Hello, I have an applet that uses mysql. I have added support for greek and for data that are already in mysql, it works fine. When I add other from my applet it prints . Another thing is that I construct a table from the resultSet using two (String) vectors.

weblogic integration problem

I am trying to create a mysql connection pool in Weblogic 6.1 using the JConnector driver and failing. All I get is no suitable driver which usually means that the URL and properties aren't right for the driver I'm using. I defined the pool as: name: MysqlPool URL:

RE: DATES and WHERE

Short answer YES you have to have them why because 2002-08-29 = 1965 -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 1:30 PM To: [EMAIL PROTECTED] Subject: DATES and WHERE I'm a bit confused here.. dates are not my strong point.. I

MySQL and Service Pack 3

Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Marc

What's data/*-bin.*?

What are all these rei-bin.* files in this MySQL data directory? Are they needed? They're taking up a lot of disk space. They seem to be some sort of log. horderei.aaanime.net.pid rei-bin.008 rei-bin.016 linkwars rei-bin.001 rei-bin.009 rei-bin.017

Re: MySQL and Service Pack 3

Hello, Reinstall your MySQL service using mysqld((-max)-nt) --install SP3 somehow manages to remove the service registration in some cases. Regards, Iikka On Thu, 29 Aug 2002, Marc Hus wrote: Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to

Re: user password self management -- how?

Hello. On Thu 2002-08-29 at 11:38:17 -0700, [EMAIL PROTECTED] wrote: [...] I'm sure I can do this programmatically by having my program connect to the database using the root user/password, but that means embedding the password in the program [i.e., viewable with string...] so once a user

Re: MySQL and Service Pack 3

At 14:29 29/08/02 -0500, Marc Hus wrote: Hi, Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Some users had reported

RE: MySQL and Service Pack 3

Well I just tried that and it keeps saying The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe I really don't understand it though, It ran great before the inevetible Service Pack Upgrade :( --Marc Hus -Original Message- From: [EMAIL PROTECTED]

RE: MySQL and Service Pack 3

Hello, No problem with my version of mysql. w2k server sp3 installed while running mysql 3.23.51-max-nt-log. John -Original Message- From: Marc Hus [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 12:29 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySQL and

RE: MySQL and Service Pack 3

Yeah, I tried that too. About 5 times with each and every version you have. It worked so wonderful before and I just don't understand why it wants to act up now :( Going to be a real pain to have to reformat that server to get it to work --Marc Hus -Original Message- From: Miguel

Re: What's data/*-bin.*?

At 16:03 -0400 8/29/02, Philip Mak wrote: What are all these rei-bin.* files in this MySQL data directory? Are they needed? They're taking up a lot of disk space. They seem to be some sort of log. horderei.aaanime.net.pid rei-bin.008 rei-bin.016 linkwars

Re: MySQL and Service Pack 3 - OT comment

This might explain how I lost my secondary IDE controller. I just unistalled SP3 to resolve my issue. On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote: Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST) From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= [EMAIL PROTECTED] To: Marc Hus [EMAIL

RE: Connecting to another machine with myCC

Sorry everyone, I must've forgotten to set the password with an 'identified by' clause, or I needed to grant to *.*: grant all on *.* to fred@192.168.0.230 identified by 'fred'; it works now. thanks! Fred -Original Message- From: Alexander Burbello [mailto:[EMAIL PROTECTED]] Sent:

OPTIMIZE TABLE, is it safe?

I have several large MyISAM tables that are frequently updated by certain events in the application. I find that the queries get considerably slower over time, and I run OPTIMIZE TABLE to defragment the datafiles. The user comments on http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html seem to

limiting the user

Hi everyone, I am running a FreeBSD server with MySQL 3.23 I want to let my virtual users create/drop tables and limit the size of each table, and also the number of tables they can create. Can someone please tell me how I can do this? Is it possible wit applications such as webmin, or

Problem with Tables...

I have a problem with MySQL. I am trying to insert data using INFILE, and it works, except that it ALWAYS stop at 255 (autoindex) and will not go any further, either by manual insert or textfile insert. I am running MySQL 3.23.38-max-nt on a Windows 2000 Server. Is this a known issue?

Re: MySQL and Service Pack 3

Do you have any copyright / DRM-enable-able content on your machine? I thought the understanding within the nt administrator community was to boycott sp3 until M$ revised their EULA to revert ownership back to the organization / person who paid the money for the hardware it runs on... Sorry; it

Aborted connection(Got an error reading communication packets)

Hi , We are getting following message multiple times in mysqldb.err file:-- 020829 13:46:39 Aborted connection 9556 to db: 'storageprofiler' user: 'root' host: `localhost' (Got an error

MySQL 4.0 and LIKE %string%

Quote from the How MySQL Uses Indexes document: MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE %string% and string is longer than 3 characters, MySQL will use the Turbo Boyer-Moore algorithm to initialise the pattern for the string and then use this pattern to

Security problem

*This message was transferred with a trial version of CommuniGate(tm) Pro* I installed Mac OS X 10.2 this last weekend and since then I've been having some problems with the security on the MySQL files. I thought that I had everything fixed, but now when my web users try and update or insert

RE: MySQL 4.0 and LIKE %string%

That optimization is for fields without an index AFAIK. Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual)