need advice about security

Hi everyone, I use a MySQL database for the back end of our e-commerce site. We take credit as one method of payment and the last 8 digits of the card number are stored in the database. There is a web interface to the database from which I can get order information, but not the card number. I

Table full error ( I Know its in the manual.. I just don't get it)

Ok I get a table is full error... So how/where do I set the tmp_table_size ? or the BIG_TABLES option so that its started that way at system start-up? from what I gather the Big_Tables option writes ALL tmp tables to disk, is that correct? so I should use tmp_table_size instead (got 512 MB Ra

Re: Perl question

perldoc CGI::Push ;-) "Aaron E. Schlesinger" wrote: > E-mail me the code. Its late and I'm grumpy. I'll e-mail you back the answer > tommorow :) > > Aaron > > -Original Message- > From: Colin Faber [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 20:28 > To: Eric Fitzgerald >

RE: Perl question

E-mail me the code. Its late and I'm grumpy. I'll e-mail you back the answer tommorow :) Aaron -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 20:28 To: Eric Fitzgerald Cc: Ron Beck; Mysql Subject: Re: Perl question Try http-push Eric Fit

Mysql and NAS?

I've done quite a bit of searching but I've not run across any experiences with multiple Mysql servers running on separate computers using the same data files off a NAS server. Anyone? - Before posting, please check: http:

Compile error mysql 3.23.30 & bdb 3.1.17 on Win2000

Hello all, I am trying to build a mysql 3.23.30 with bdb 3.1.17 on Win2000. I have put in the HAVE_BERKELEY_DB macro flag in sql\mysqld.mak directory and include db.h and libdb31d.lib into compilation flag. However, I still get error like this: C:\mysql_src\sql>nmake -NOLOGO -f mysqld.mak

Re: mySQL performance

On Fri, 12 Jan 2001, Michael Zornek wrote: > So now that we should be getting some funds to buy a new tower what are the > most important specs? Should I get a dual processor, RAID hard drives, gig > of RAM. What's the best set up for a PHP/mySQL web server for approx 60,000 > page views and 1

mySQL performance

Ok, I'm starting to design a PHP/mySQL web site that will house about 6-8 tables, lot of relation stuff, very dynamic output to the web visitors. My worry is performance. By doing authentication via comparing a member's profile to the record he want to read in the db and all that other fun myS

Re: Perl question

Try http-push Eric Fitzgerald wrote: > Beyond the other suggestion, also remember to flush your STDOUT. > flush(STDOUT); > > - Original Message - > From: "Ron Beck" <[EMAIL PROTECTED]> > To: "Mysql" <[EMAIL PROTECTED]> > Sent: Friday, January 12, 2001 8:56 AM > Subject: Perl question > >

Congratulations!

The quote and link is from Linux User bulletin: it's been quite a week what with the National Security Association's (the *real* U.S. Secret Service) release of the alpha of their Linux distribution and and the press releases about a movie about an Open Source developer's struggle with a meglomani

Which tables have at least one record?

Hello, Please help in the proper sql select statement for the following. I have 15 tables. Each table includes a View column. I would like to return true values for the tables that have at least one row where View = "somevalue". For example, say I had only three tables, and table2 was the onl

mysql-3.23.30-gamma Compile Problem

Hi All. I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm using redhat 7 any ideas? c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/.libs

Re: 3.23.28-gamma Crash and data loss

We have replicated this crash over and over just now... Very strange. Yet with the 2.23.30 version, we dont lose the data and dont seem to get corruption. Here is exactly what happened... (This also crashed it in the first place, which lost all our data in the 2.23.28 version) We have a table

mysql.host doesn't exist error ... even though it does

i've been running mysql on a redhat linux machine for about two months w/o need for a restart. unfortunately this morning, the machine started acting really odd and i decided to perform a restart. when restarting, the system actually froze and i was forced to perform a hard restart. after restar

Re: MySQL C API multiple connections

Sinisa Milivojevic wrote: > > Hi! > > I made an error in my previous message. All three instances should be > like this: > > connX = mysql_init(NULL); > if (!mysql_real_connect(connX, ip2, user2, pass2, db2, 0, NULL, 0)) > error . > By the way it seems to me that in 3.23.XX series mys

fast index corruption... Help !

Hello, I posted message below a few hours ago. Since then, I have tried to find how fast indexes become corrupt. I have run a CHECK TABLE QUICK on different tables in my database and run a REPAIR TABLE when an error is reported followed by a CHECK TABLE a few seconds later. Here is the output

RE: RedHat 7 and MySQL - Can't start server

I found the error in the log file, it can't find 'host.ISM' Where do I tell it where to look? Here is a cut from the log file: mysqld started on Fri Jan 12 10:53:03 CST 2001 010112 10:53:03 /usr/sbin/mysqld: Can't find file: 'host.ISM' (errno:2) mysqld ended on Fri Jan 12 10:53:03 CST 2001

mysql.host doesn't exist error ... even though it does

i've been running mysql on a redhat linux machine for about two months w/o need for a restart. unfortunately this morning, the machine started acting really odd and i decided to perform a restart. when restarting, the system actually froze and i was forced to perform a hard restart. after restart

RE: Installation problem.

On Fri, 12 Jan 2001, Miguel Angel Solórzano wrote: > At 09:08 12/01/2001 -0500, Jenny Lie wrote: > Hi! > > I forget to say you in the last mails that you need to do > the login in the NT/W2k machine as Administrator privilege > or with an user which has the privilege to install services > in th

Help with a semi-complex query

I'm simplifying slightly, here's the basic tables: build --- idx int namechar(16) test_name idx int namechar(64) main_table idx int unsigned test_name_idx medint status char build int swipchar(11) I want to do the follo

problems when accessing from several clients

Hi all, When I access MySQL from several API clients, one of them quits with the error message: Query failed (Lost connection to MySQL server during query) Does any one know why?

Re: Index ? Key ?

Martin Thoma wrote: > Hello ! > > I'm a database-newbee. What I need is a column that makes the record > unique. The content should be generated autoamtically and it should be > able to get a lot of records (BIGINT would be nice). But I don't know if > I should use PRIMERY KEY, KEY, INDEX or UNIQ

Re: Help with an SQL statement

Mike, Use the following statement UPDATE COUNTER SET HITS = HITS + 1 WHERE keyvalue='69'; Further examples may be found using the link to the mysql manual below. Have a nice Day! D. Grubb. - Original Message - From: Mike Podlesny <[EMAIL PROTECTED]> To: mySQL Mailing List <[EMA

Re: MySQL Performance...

"Patrick FICHE" <[EMAIL PROTECTED]> writes: > I just wanted to know if my assertions are rigth and what are the common way > to solve this type of problems ? Store your results into a temporary table? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, Th

Index ? Key ?

Hello ! I'm a database-newbee. What I need is a column that makes the record unique. The content should be generated autoamtically and it should be able to get a lot of records (BIGINT would be nice). But I don't know if I should use PRIMERY KEY, KEY, INDEX or UNIQUE. Perhaps some could tell me t

Setting up MySQL Database hosted by ISP

Hello, My associate wants me to setup a MySQL database which will be hosted by his ISP. Unfortunately, they have no one (the ISP) that I can give me specific instructions on setting up the database. They know how to create it, but can tell me how to get our data/tables into it. I was

Help with an SQL statement

Thanks for everyone's help with the dat question now I would like to know if someone could help me with another question. I have a table called COUNTER and a field in the table called HITS in an SQL statement I would like to update this field by adding 1 to it's current value any ideas? Thanks,

RE: can't find mysql.sock error

Argh...if I had a nickel for every time this happens... Of courser after 10 more minutes of searching the manual, I found the solution. Still not sure why it defaults to /var/lib. For archives sake, here's the cut and paste... "You can also start safe_mysqld with the --socket=/path/to/socket o

Should I turn on compression in MyODBC in LAN evironment?!?

I wonder, is there a performance gain if compression is turned on the client side? My set-up: Front end: M$Access97 via latest MyODBC Back end: MySQL 3.23.30 on RH7 with PIII300 128Ram LAN is 100BaseT Full Duplex switched. Thanx

Installing MySQL on a WIN ME/WIN2K system

Hi Mailing-list. I'm about to kill myselfplease help. My problem: I'm tryin to install mysql-3.23.30-gamma-win on a dualboot system. Actually I want to install the db as a service under WIN2K running IIS5, but when I run mysqld-nt --install from d:\mysql\bin I get the message "Failed to in

RE: Installation problem.

Hi, Thanks! I did log in as Administrator. I'm running Windows NT Server 4.0 Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] http://www.onramp.ca -Original Mes

RE: Installation problem.

At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! I forget to say you in the last mails that you need to do the login in the NT/W2k machine as Administrator privilege or with an user which has the privilege to install services in the machine. Regards, Miguel >I did reboot the machine and it stil

Re: 3.23.28-gamma Crash and data loss

Well, we upgraded to 2.23.30 and tried to bring it up with the same seemingly corrupt datafiles. It tried to do a recovery (saw this in the error log), but died when it was looking for database directories that had long ago been deleted. It was like it was making its way through the entire db tr

RE: Installation problem.

At 09:08 12/01/2001 -0500, Jenny Lie wrote: Hi! >I did reboot the machine and it still can't do mysqld-nt --install. > >Anything I should do? The first step, I did run setup.exe, then in >c:\mysql\bin, I ran mysqld-nt --install, was that right? That is correct. What is your OS ? Regards, Miguel

can't find mysql.sock error

I know I'll probably get yelled at for something that is probably easy to fix but I have spent a few days searching the archives, manual, etc and I've been unable to find answers. When doing any kind of mysql command (e.g. mysql -D database.sql) I get this error: ERROR 2002: Can't connect to loc

[binlog duplicate entries]

>Description: while replicating MySQL database via creating binlog on one server and runing slave on another, connected via tcp/ip, we encountered situation when slave database containing duplicate entries. We found that number of entries in slave database diverges with time from

Help with a date select

I was wondering if anyone could help me. I have a table with a a bunch of fields and one of those fields is the DATE data type. I would like to write a SQL statement on the mySQL database that will return all if the items from the database that were stored there from today's date to six months a

Re: RedHat 7 and MySQL - Can't start server

I would suggest checking your errorlogs. They should be in your datadir. tail /.err that should tell you what the problem is. If you can't figure out how to fix it, you might want to copy and paste the last couple of lines from your logs in your email. Atle On Fri, 12 Jan 2001, John W Cunnin

Re: I need to tell MySQL that i have other database

Did you use mysqldump to save your databases? It is *highly* recommended that you do that instead of just copying the database files over. This way, you can just dump all the data back in and mysql will take care of everything :) If not, you can tell mysqld where to look for its databases: -h

Re: Perl question

Beyond the other suggestion, also remember to flush your STDOUT. flush(STDOUT); - Original Message - From: "Ron Beck" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 8:56 AM Subject: Perl question > > Hello all, > I have a procedure that queries my d

Re: third time asking help concerning charsets

Sometimes when people aren't answering a question, it isn't because they are ignoring you or consider your questions stupid. Sometimes it's because we don't know the answer. Your question has nothing to do with MySQL and everything to do with php. It doesn't like that charset. I have no clue o

Re: Locking records

MySQL doesn't have built in row-level locking, but they are chaning that. The best thing to do, for now, is to have a record_locked column, and set it to 1 if the record is in use. To lock the record, you would run a query like update table_name set record_locked = 1 where id = ??? and record

AW: Perl question

Well, this is a little off topic - but: - name your perl program to nph-yourname.pl (this will allow the non parse output) Start your perl-Script with: #!/usr/bin/perl $|=1; print "HTTP/1.0 200 OK\nServer: CERN/3.0\n"; print "Content-type: multipart/x-mixed-replace;boundary=magicalboundarys

Off list request for a mySQL solution

Hello, Jonas Norrman at mysql.com suggested that I write directly to this list with my request... I would appreciate if any responses would be sent directly to me at: [EMAIL PROTECTED] --- original message --- We are currently evaluating a hotel management software package which runs on Filemaker

Pre-installed MySQL from Redhat 7.0

Fellow travelers, I'm a MySQL debutant. I have no experience with it (other than not being able to get it to work on my Dell PowerEdge 1400 server running RedHat Linux 7.0). Is the RedHat Linux 7.0 distribution of MySQL a satisfactory or difficult one to use. Is it a good idea to buy a distributi

Perl question

Hello all, I have a procedure that queries my database and produces a line of output for each query. It then processes the data and performs another query. Everything works great interactively. I get the first processing message, wait a bit, get the next processing message, etc... However, wh

Re: index corruption and mysqld crash

Thank you for your help but there is no cron job that kills the process. I also got an answer that was not CC'd to the list that suggested me to install 3.23. I have installed 3.23 (mysqld Ver 3.23.30-gamma for pc-linux-gnu on i686) today since I had a lot of users complaining and could not spen

SQL , starting ?????????

ok , i have a real problem , i am using the "my sql" and , right on the begining , of all , right after installation , the book ask to creat a consection tables , so the book ask to go to the dir , "/usr/local/mysql" and type this line : scripts/mysql_install_db , but how do i make this line wor

RedHat 7 and MySQL - Can't start server

Hello All, When I try to start the server, with a fresh RPM install, this is what I get... [root@localhost bin]# /usr/bin/safe_mysqld & [1] 8438 [root@localhost bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Done/usr/bin/safe_mysqld

Mysql and swapping on Solaris

Hi, I have a Sun R220 single CPU with 512MB RAM. I start mysql using $bindir/safe_mysqld \ --datadir=$datadir --pid-file=$pid_file \ -O wait_timeout=180 -O key_buffer=256M -O max_connections=250 -O table_cache=512 -O sort_buffer=2M -O thread_cache=8 -O record_buffer=2M -O th

Re: query much slower when function used...?

> > okay, with gdb i can see that this column becomes a blob (thereby > > not allowing heap tables to be used - which has got to be costing > > me speed), is there any function i can use to 'cast' this column > > to a fixed length? > > hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do > t

Locking records

Hello ! I want to make something like: There is one server and seval clients, which all access the same database. The problem: If one user changes a record, no other user should be able to change it. Whats the general way to do it with MySQL ? Regards Martin

Re: MySQL C API multiple connections

Valerio Ferrucci writes: > John Dean wrote: > > > Hi > > I think you should check the API documentation > > Can you point me to some docs about this? > > > because you code example is > > wrong. Each connection should have its own initialized connection handle. > > You have only initi

Re: mysql-3.23.30-gamma Compile Problem

I have a problem , I install mysql and i have a mistake : install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/s un4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/ bin/perl: fatal: relocation error: file /usr/local/lib/perl5/site_perl/5.005

Re: I can't compile!

Tello, Fredy Ramiro writes: > Hi, I have developed a program using MySQL++ but I can't compile it. > > My MySQL home is /usr/local/mysql/ and my MySQL++ home is > /usr/local/mysql++/ > > I have tried compile the program with: gcc myprogram.cc > -I/usr/local/mysql++/include -L/usr/local/m

Re: MySQL C API multiple connections

Valerio Ferrucci writes: > Hi, > I'm building a MySQL C API client. I need to connect to different dbs > at the same time. My code is (approximately): > > // > MYSQL mysql, *conn1, *conn2; > > mysql_init(&mysql) > > conn1 = mysql_real_connect(&mysq, ip1, u

Is there a way to merge/replicate between MySQL and MSSQL?

I have a production MS SQL server and want to keep a copy on a MySQL DB on the webserver (for speed and redundancy). I have searched the archives, docs, and altavista and cannot find exactly what I am looking for. Ultimately, I would like to be able to have the databases merge/replicate between

RE: Installation problem.

I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? Thanks for your time. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #3

RE: MySQL C API multiple connections

Valerio, It seems to me, that you need to init (mysql_init) serveral times; I have not tried this but I would try the following: MYSQL conn1, conn2, conn3; conn1 = mysql_init(NULL) if ( mysql_real_connect(conn1, ip1, user1, pass1, db1, 0, NULL

Re: MySQL C API multiple connections

John Dean wrote: > Hi > I think you should check the API documentation Can you point me to some docs about this? > because you code example is > wrong. Each connection should have its own initialized connection handle. > You have only initialized one data structure i.e. mysql, which is passed >

New configure.in check doesn't work

>Description: One of the configure checks is faulty. Specifically, this one: # Check 3rd argument of getthostbyname_r ac_save_CXXFLAGS="$CXXFLAGS" AC_CACHE_CHECK([3 argument to gethostname_r routines], mysql_cv_gethostname_arg, AC_LANG_SAVE AC_LANG_CPLUSPLUS if test "$ac_cv_prog_gxx" = "

I need to tell MySQL that i have other database

Hi, I have been looking for in the manual but i didn't find anything, that how i tell to MySQL tha i have a databases. I had Linux SuSE 6.4 in my box and i decide to change it to Mandrake 7.2, so i made a backup in a windows box of the databases. Now i have Mandrake 7.2 with MySQL and how i tell

I can't compile!

Hi, I have developed a program using MySQL++ but I can't compile it. My MySQL home is /usr/local/mysql/ and my MySQL++ home is /usr/local/mysql++/ I have tried compile the program with: gcc myprogram.cc -I/usr/local/mysql++/include -L/usr/local/mysql/lib/mysql -o myprogram but I obtain many err

Re: choose a free databse management

There are mnay free RDBMS around besides MySQL This includes: Postgresql mSQL (mini SQL) Oracle 8i is free for Linux The learning curve from any RDBMS eg: from Postgresql to MySQL or Oracle to MySQL because they are ANSI SQL compliant. On Fri, 12 Jan 2001, you wrote: > Hi everybody, > > I

MySQL C API multiple connections

Hi, I'm building a MySQL C API client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(&mysql) conn1 = mysql_real_connect(&mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d", con

Re: mysqldump core dumping mysql

Marcos Krzisch writes: > Hi! > >I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. > I've tried different options, now I'm currently running: > > mysqldump -F -l -q -O max_allowed_packet=16777216 db > > but sometimes mysql core dumps. > > Thanks for any

MySQL CAPI and Multiple connections

Hi, I'm building a C API MySQL client. I need to connect to different dbs at the same time. My code is (approximately): // MYSQL mysql, *conn1, *conn2; mysql_init(&mysql) conn1 = mysql_real_connect(&mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d", con

mysqldump core dumping mysql

Hi! I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. I've tried different options, now I'm currently running: mysqldump -F -l -q -O max_allowed_packet=16777216 db but sometimes mysql core dumps. Thanks for any idea!

Re: Do HEAP tables use table locking?

Steven Roussey writes: > Hi! > > Do HEAP tables use table locking? > > Sincerely, > > Steven Roussey > Network54.com > http://network54.com/?pp=e > > Hi! Yes, they do. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*

RE: 3.23.28-gamma Crash and data loss

The MySQL team recommended upgrading to 3.23.29 gamma, especially if using Berkeley DB. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTE

size limitations

i could find some informations about increasing the size of the databases, but not about limitations to the size. how would it be possible to set a limitation in the size of the databases at the creation time so that a user couldn-t build any databases greater than, say, 20 MB? i just couldn-t f

Re: mysql security issue, overflow

Hi! On Jan 12, João Gouveia wrote: > Hi, > > I believe i've found a problem in MySql. Here are some test's i've made in > 3.22.27 x86( also tested on v3.22.32 - latest stable, although i didn't > debug it, just tested to see if crashes ). Confirmed up to latest 3.23 This will be fixed ASAP! Th

buffer problem

Hi,, >From a java file,I am opening a table reading it and writing to a text-file. But when I am opening that text file,it is incomplete.Every time it stops at 8192 bytes. please help me. bye prakash

Error 1146

When I try to dump a file with Create table and insert into when i try to dump it into the DB I get this error error 1146 at line 1: table 'dbname.tablename' doesn't exist I tried it on a different server and it worked fine. -

Mysql

I Am running mysql to connect my linux mail database to MS Access database. This all is not working anymore the mysql.sock is broken can this be

Re: Can\'t connect to local Mysql server (111)

Supposed that the problem is that localstatedir is not having /usr/local/var having a file mysql.sock. may be which is not started. give ps -e and check for the process. if it is existing then killall mysqld. Then give the command at /usr/local/bin/safe_mysqld --log --log-update & to send it t

Re: mysqldump of one table?

hi mysqldump -u (username) -h (hostname) -p databasename tablename>filename password then upload the same whereever required mysql -u (username) -h(hostname) -p databasename > hi > > > > i want to dump the contents of one table into a text > > file ... can you tell me what i've done wrong ? >

Please help

This is my problem. I use JDBC and I'm connect my code with my table. If i use database test, it' ok but if i use another db (ex : link ) i 've an error : SQLException: General error: Access denied for user: '@localhost' to database 'mysql' SQLState: S1000 VendorError: 1044 java.lang.NullPo

Re: Number of Tables..?

> What is the largest number of table per database does MySQL support? http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_4_0 / Carsten Carsten H. Pedersen Keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq

MySql - Ultradev

> > Subject: MySql - Ultradev > From: David Raza > Date: Wed, 13 Dec 2000 15:55:48 - > > I was wondering if anyone has managed to use Dreamweaver

mysql security issue, overflow

Hi, I believe i've found a problem in MySql. Here are some test's i've made in 3.22.27 x86( also tested on v3.22.32 - latest stable, although i didn't debug it, just tested to see if crashes ). On one terminal: spike:/var/mysql # /sbin/init.d/mysql start Starting service MySQL. Starting mysqld

Re: mysqldump of one table?

> hi > > i want to dump the contents of one table into a text > file ... can you tell me what i've done wrong ? > > i tried : > > mysqldump --opt --tables studenttable > myfile.txt > mysqldump --opt --databases [studenttable] > myfile.txt > mysqldump --opt database [studenttable] > myfile.txt

Re: Lazy

From: "Neil Davis" <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 6:58 PM > Guys, > > Amen. When I was 13 and got my first commodore 64, I decided to teach myself > BASIC. All I had was the manual. (the MySQL manual is the library of > If it is documented somewhere, and can be produced

Re: mysqldump of one table?

Just had a quick look at the mysqldump command myself and I don't see the --opt or --database switches anywhere. I think if you tried mysqldump mystudentdatabase studenttable > myfile.txt may do the trick. - Original Message - From: "anna soobrattee" <[EMAIL PROTECTED]> To: "mySQL Ma

user function recommended?

Hi, This is a WHERE clause I have to dynamically create everytime I do a query to my geographic database. It's fairly obvious: every object in the database is checked against a bounding box, which is a Rectangle with x=minx, y=miny, width=maxx, height=maxy: public static final String createR

Re: Problem With NOT IN Sql Statement...

sub selects are not yet supported. - Original Message - From: "Nanjunda BM Prasad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 14:57 Subject: Problem With NOT IN Sql Statement... > Hi, > I am having a problem with the sql statement when i am trying to > e

mysqld process hanging

Hi, everybody, please help me MySQL version 3.22.32 O/S : Linux server 2.2.16-3smp error log - Number of processes running now: 1 mysqld process hanging, pid 1378 - killed mysqld restarted on Fri Jan 12 17:17:39 KST 2001 /usr/local/mysql/libexec/mysqld: ¿¬°á Áغ

mysqldump of one table?

hi i want to dump the contents of one table into a text file ... can you tell me what i've done wrong ? i tried : mysqldump --opt --tables studenttable > myfile.txt mysqldump --opt --databases [studenttable] > myfile.txt mysqldump --opt database [studenttable] > myfile.txt but all these resul

Problem With NOT IN Sql Statement...

Hi, I am having a problem with the sql statement when i am trying to execute on MySql the sql statement is : Sqlnew1 = "Select count(EM_Code) as EmpNew FROM employeemaster" Sqlnew2 = " WHERE ((EM_dateofJoining <= '1998-03-30' and EM_dateofLeaving >= '1998-

Re: choose a free databse management

No it isn't the only free database around. There are others like postgres. It is the fastest database around but it does lack functionality. Some functionality was sacrificed for speed, others are still in development but it gets better with each new version. It has the best support I've ever c

Help me please

I create a connection with Java and mm.mysql-1.0. I 'm running and this the complier messages : SQLException: General error: Access denied for user: '@localhost' to database 'link' SQLState: S1000 VendorError: 1044 java.lang.NullPointerException at conectiondb.ConnectionDB.(ConnectionDB.jav

mysql windows

Platform: Windows 98 Mysql version: Mysql 3.22.34-shareware Web server: Apache I am running a PHP code. When I run the program for two times there is no problem then it alerts database not found. Then I stop mysql and run again then it runs properly for two times again. I don't know if the prob

load balancing, high-availability setup

I want your comments regarding a replication and high-availability setup. This is the setup: Load balancer +---+ | Foundry | | ServerIron | | | +---+ / \ / \

choose a free databse management

Hi everybody, I have to choose a database management in order to save a little database (15 tables of 10 000 rows max.) Does someone tell me if mysql is the only free database management? If it doesn't why do you think mySQL is better than other (which are free)? thanks for your help, gaetan

Re: Parameters, WindowsNT Service

At 09:48 12/01/2001 +0100, Alain Vigne wrote: Hi! >Hi ! >How can i set parameters for my mysql server daemon when i start it as a >Windows NT service ? Use the my.cnf or my.ini file. Regards, Migue >- >Before posting, please

buffer problem

Hi,, >From a java file,I am opening a table reading it and writing to a text-file. But when I opened it,it is incomplete.Every time it stops at 8192 bytes. please help me. bye prakash

Re: Please read the manual

From: "Ralf R. Kotowski" <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 11:05 PM > No flames needed. This is a serious discussion. :-) > So I guess the question would be were do we find people that could > translate it to a manner so that mere mortals can understand it. We already ha

Parameters, WindowsNT Service

Hi ! How can i set parameters for my mysql server daemon when i start it as a Windows NT service ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: FIX [PHP-INST] Problem with PHP/Apache/MySQL on fresh RH7 install

Heres a Brilliant idea for you Some people arent into the stage of building from source yet The idea of the list is to HELP.. Your post did nothing but waste bandwith. as this one will Point being.. IF you build from source it lists nothing about how to install the shared libs, or why you need t

Re: ERROR 1044

Franck ABELLI writes: > To change the root password i connected to mysql: bin/mysql > mysql>connect mysql localhost > mysql>UPDATE user set Password='***' where User='root'; > ->No problems > mysql>SELECT User,Password FROM user; > -> to verify if the pass was set... it was. > > then i stopped my

  1   2   >