Re: JBuilder6 and mm.mysql-2.0.11

2002-03-22 Thread Lonnie Wormley
TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82 com.borland.dx.dataset.DataSetException: The driver: org.git.mm.mysql.Driver

random (load-related?) unknown database errors

2002-03-22 Thread Jeff DeFouw
MySQL every so often will return unknown database errors for no apparent reason on a FreeBSD 4.4 (and earlier 4.x versions) server I maintain. This affects different user, scripts, and databases. One user says there is a big slowdown around each event, perhaps a load issue, but at least when I

Re[3]: group by timestamp field

2002-03-22 Thread Aleksandar Bradaric
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply

All threads used up!

2002-03-22 Thread Simon Green
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max

how to do when the table files become bigger and bigger

2002-03-22 Thread Buding Chen
Hi, all: I am doing a project that we will insert a lot of data to mysql by C API everyday, so the table files will become bigger and bigger, it will not only takea long time to query,but also lead to the file size limits. In order to query fast and avoid leading to the file size limits,

keeping given order in resulset

2002-03-22 Thread Mickael Bailly
Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the 'IN(...)' clause

Re: keeping given order in resulset

2002-03-22 Thread Georg Richter
On Friday, 22. March 2002 10:43, Mickael Bailly wrote: Hello ! I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders

Re: group by timestamp field

2002-03-22 Thread Jayasimhan A
Hi!! You can try select format_date(field2, '%m %d %Y)as timestamp, count(*), field1 from mad group by field1 all the best, Jayasimhan A - Original Message - From: cristian ditoiu [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, March 22, 2002 1:20 PM Subject: group by

Re: Boolean Fulltext in 4.0.2 bug

2002-03-22 Thread Alexander Belyaev
Hi, I know, many fulltext bugs fixed last two weeks, thanks! But this nice mysql4 feature are critical for us, we plan to use it in many projects... and we test it again and again... :) My test case: http://www.graphit.ru/fulltext402.tar.gz test.res - output from 4.0.2 cloned 2002-03-21. With

Re: keeping given order in resulset

2002-03-22 Thread Jayasimhan A
Try order by id. All the best, Jayasimhan A - Original Message - From: Mickael Bailly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 3:13 PM Subject: keeping given order in resulset Hello ! I got a table having an auto_increment field, let's say 'id'. tis

pruning

2002-03-22 Thread Vijay_T
Placed At : MAA Vijay T@SATYAM 03/22/2002 04:30 PM Hi I have to delete the unwanted things from my mysql db pls sugges me to go ahead thanks vijayt - Before posting,

Re: keeping given order in resulset

2002-03-22 Thread Mickael Bailly
Hello, there is no difference between select id, name from table where id in (5,3,7) and select id,name from table where find_in_set (id, 5,3,7); Or I didn't see it... anyway this doesn't solve my problem. Mickael On Friday 22 March 2002 11:32, Georg Richter wrote: On Friday, 22. March

Re: keeping given order in resulset

2002-03-22 Thread Mickael Bailly
Hello, the 'order by' clause just order my results by ascending value, but don't keep the order I gave in the 'IN(...)' clause.. So it doesn't solve my problem. Mickael On Friday 22 March 2002 12:08, Jayasimhan A wrote: Try order by id. All the best, Jayasimhan A - Original Message

MySQL hangs on reqular SQL-query

2002-03-22 Thread Jacob Nordgren
Hi all, I have a problem with a table in the database. I created it a while ago (a month maby) and then everything worked fine. Now however, every time I query the table the query hangs and I don't know why. I understand that it's difficult to tell me what the problem is based on that little

Optimizing tables

2002-03-22 Thread Vijay_T
Placed At : MAA Vijay T@SATYAM 03/22/2002 04:44 PM Hi how do i optimize mysql tables vijay - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL hangs on reqular SQL-query #2

2002-03-22 Thread Jacob Nordgren
Hi again, Little more information about the problem that I wrote about in my last email. As I said before, the database wont accept any query to that table. It just hangs. However I'm not sure of which query that is executed the first time the table hangs. I'm not sure if this matters. But

Re: Optimizing tables

2002-03-22 Thread Fournier Jocelyn [Presence-PC]
Hi, What about taking a look at the manuel before ? ;) http://www.mysql.com/doc/ Regards, Jocelyn Fournier - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 12:14 PM Subject: Optimizing tables

Serious performance problems when using InnoDB

2002-03-22 Thread Nico Sabbi
Hi, I'm using a db with few tables, one of which is reported below: CREATE TABLE `keywords` ( `keyword` varchar(128) NOT NULL default '', `codice` varchar(16) NOT NULL default '', `timestamp` int(11) NOT NULL default '0', `soundekw` varchar(32) NOT NULL default '', PRIMARY KEY

mysqldump : help needed very urgent

2002-03-22 Thread Chetan Lavti
Hi, I am using Mysql version 3.23.47-Max client and server and using Innodb table type. I am doing my database backup using the mysqldump utility. Once I have done with database backup, I am deleting all my database and again recovering(creating) the database using the dumped file. Now, the

Re: Access denied on use mysql;

2002-03-22 Thread Liyju Janardhan
--- Kathy Reyes [EMAIL PROTECTED] wrote: Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... ^ What do you mean? Can

Re: Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-22 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: Description: Take two tables (call them a and b), which have identical structures. Table a has no rows, table b has some (say 10) rows. If you do this: select * from a union select * from b limit 0,5 It works as expected. Now do this: select * from a

Re: JBuilder6 and mm.mysql-2.0.11

2002-03-22 Thread TAKAHASHI, Tomohiro
Hi, Lonnie Lonnie Wormley wrote: TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See com.borland.dx.dataset.DataSetException error code: BASE+82

RE: keeping given order in resulset

2002-03-22 Thread Roger Baklund
* Mickael Bailly I got a table having an auto_increment field, let's say 'id'. tis table has a varchar field too, let's say 'name'. Is there a way to do something like: select id, name from table where id in (5,3,7) AND that mysql orders the results the way I gave into the

Tables stops at row 126

2002-03-22 Thread Mikael_Jensen
Hi, I'm new to DB's and MySQL I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is field typeAllow

Re: mysql bug

2002-03-22 Thread Sinisa Milivojevic
Thank you for your bug report. This bug is now fixed in 3.23.50, which will very soon be available. This is a patch that fixes a bug : --- 1.12/sql/item.ccWed May 23 02:32:52 2001 +++ 1.13/sql/item.ccFri Mar 22 14:03:42 2002 @@ -59,12 +59,28 @@ } } -bool Item::eq(const

querying check constraints

2002-03-22 Thread Sukhdev Sethi
Hi, I have created a table as below: create table myTable ( Field1 int auto_increment not null, Field2 varchar(25) not null, Field2 enum('Fair','Good','Excellent'), primary key (Field1)) auto_increment=1 I would like to know how to query the table for only the enum values I have

Re: Tables stops at row 126

2002-03-22 Thread Georg Richter
On Friday, 22. March 2002 14:04, [EMAIL PROTECTED] wrote: Hello, I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is

ERROR 2005: Unknown MySql Server Host 'host' (11001).

2002-03-22 Thread Chuck Amadi
Hi there, I have gone thru the pdf doc's etc and i have been playiing around with devshed articles as well as being a db programmer using PostgreSql v7 on my Linux Box and that horrible thingy called M$ Access 2000 ( The non-cocurrent issue) on my Win98 Box. Nevertheless i have been ok so far

Re: Access denied on use mysql;

2002-03-22 Thread Victoria Reznichenko
Kathy, Thursday, March 21, 2002, 7:48:10 PM, you wrote: KR I just gave up, everything that I tried did not work. KR I killed mysql and then KR started with safe_mysql --skip-grant-tables KR then I was able to connect to mysql without an error. KR But when I tried to KR Grant all on mysql.*

pruning

2002-03-22 Thread Victoria Reznichenko
Vijay, Friday, March 22, 2002, 1:00:24 PM, you wrote: V I have to delete the unwanted things from my mysql db Use DELETE statement. You can find description of it in the manual: http://www.mysql.com/doc/D/E/DELETE.html V thanks V vijayt -- For technical support contracts, goto

Compile time issue?

2002-03-22 Thread Victoria Reznichenko
Aragon, Thursday, March 21, 2002, 10:35:06 PM, you wrote: AA I have compiled mysql-3.23.49 from source distribution on a NetBSD AA 1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine, AA no-errors. Starts and Stops fine no-errors. But when I go to run mysql or AA

Re: Server startup error on Linux

2002-03-22 Thread Egor Egorov
Rance, Thursday, March 21, 2002, 9:30:26 PM, you wrote: RH I issued the chown command as indicated by Andreas RH but it doesnt help RH I still get the Table mysql.hosts doesnt exist RH I know that all the tables created by mysql_install_db are infact owned by RH mysql RH but the server daemon

Optimizing tables

2002-03-22 Thread Egor Egorov
Vijay, Friday, March 22, 2002, 1:14:33 PM, you wrote: V how do i optimize mysql tables I think chapter 4.4.6.10 Table Optimization in MySQL manual will be useful for you. Look at: http://www.mysql.com/doc/O/p/Optimisation.html V vijay -- For technical support contracts, goto

load data local - strange message. ERROR 1148

2002-03-22 Thread Egor Egorov
Art, Friday, March 22, 2002, 7:10:24 AM, you wrote: AL I ran into the same problem you did. After some searching on the web, this AL is what I came up with: AL First save the text file in the directory corresponding to the database you AL are currently using (menagerie). So the file will be

Where can I get max backlog?

2002-03-22 Thread Egor Egorov
í¼ø¹Î, Friday, March 22, 2002, 8:48:56 AM, you wrote: I've set backlog of mysql to 100. And now I need to increase it. But I don't know how many backlog my OS can support. Where can I get that information and how can improve it. Although I use Red Hat 7.2, other OS's informations are also

RE: Tables stops at row 126

2002-03-22 Thread Roger Baklund
* [EMAIL PROTECTED] I encountered a problem with my pictures-DB which I with PHP. The table's stops at row 126, all photos I store in DB afterwards all get the ID 127. I don't know if it's php or MySQL causing this. My table structure is field typeAllow Nulls Key

RE: ERROR 2005: Unknown MySql Server Host 'host' (11001).

2002-03-22 Thread Roger Baklund
* Chuck Amadi Nevertheless i have been ok so far upto now! The problem is that when i try to run mysql server i get the following error ERROR 2005: Unknown MySql Server Host 'host' (11001). Setup - Mysql v3 O/S Win 98 utilising the mysqladmin mysqlManager I have tried from ms-dos

getting a bit confusing -

2002-03-22 Thread Chuck Amadi
Hi me again , regarding my situation i was able to get a responce via mysql \r library(eexample db) localhost thus used the select cmd select * from members; and everthings fine . From the manual it does mention that certian installations allow user to connect as anonymous unamed user to

RE: help with index/query

2002-03-22 Thread Salada, Duncan
Using select Url from table where Ref like 'foo' gives these results: 1 row in set (2 min 11.54 sec) Using select Url from table where Ref = 'foo' gives these results: 1 row in set (8 min 47.69 sec) The same foo was used for each one of those queries. I believe the time problem

Compiling on apache.

2002-03-22 Thread Stephane JEAN BAPTISTE
I have a problem with compiling mysql on HP-UX. I can't compile because it doesn't know that I have gcc. I have this error with ./configure : checking for gcc... cc checking whether the C compiler (cc -Ae -D_REENTRANT ) works... yes checking whether the C compiler (cc -Ae -D_REENTRANT ) is a

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Andrew Hazen
There might be a better way but here's a suggestion: When I needed to switch from an Access db to mysql I couldn't find any docs about exporting the table structures from Access to mysql, so I documented the Access db and manually built the same table structures in mysql. Then export the Access

Re: Server startup error on Linux

2002-03-22 Thread Rance Hall
Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) exerpt from .err file follows 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended exerpt from

All threads used up

2002-03-22 Thread Simon Green
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max

Re: Can you Change Nulls in the MySQLDump from \N?

2002-03-22 Thread Keith C. Ivey
On 21 Mar 2002, at 12:11, David M. Peak wrote: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output files. If you don't care about the distinction

Windows 95 / Latest stable MySQL server start

2002-03-22 Thread Winstone, Paul
I know I'm new to this and despite checking FAQs and the manual, am having difficulties getting MySQL to work properly under Windows 95. Unfortunately, I don't have a choice of operating system, even though I'm developing for Windows NT/2000. Anyway I have started the server with mysqld, a fact

Re: Rotation of binary logs on replication master?

2002-03-22 Thread Guy Davis
On Thu, 2002-03-21 at 13:07, Shawn McCool wrote: /usr/local/bin/mysql -hhostname -uusername -ppassword -e flush logs; I guess I wasn't clear that I wanted old binary logs removed. I don't want to have to manually worry about disk space due to ever increasing binary logs. It seems to me FLUSH

RE: querying check constraints

2002-03-22 Thread Rick Emery
I don't understand your question -Original Message- From: Sukhdev Sethi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 7:20 AM To: [EMAIL PROTECTED] Subject: querying check constraints Hi, I have created a table as below: create table myTable ( Field1 int auto_increment

Re: Serious performance problems when using InnoDB

2002-03-22 Thread BD
At 05:53 AM 3/22/2002, you wrote: Hi, I'm using a db with few tables, one of which is reported below: CREATE TABLE `keywords` ( `keyword` varchar(128) NOT NULL default '', `codice` varchar(16) NOT NULL default '', `timestamp` int(11) NOT NULL default '0', `soundekw` varchar(32)

Unix Jobs?

2002-03-22 Thread Jonathan Hilgeman
I'm currently working as a e-commerce web programmer specializing in PHP, MySQL, and Apache systems. I've had experience on FreeBSD and Linux systems, and now the company I work for seems to be being bought out at which point, several of us may lose our jobs. Now, I've been searching all over

Re: outer joins

2002-03-22 Thread ds
Hi, did you get any answer ? I'm having the same problem. If i wanted all results from table1, even if they don't appear in table2 i would do like: SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... But how to join SELECT . FROM table1 LEFT JOIN table2 ON

Re: mysql bug

2002-03-22 Thread Timo Maier
Hi Sinisa! Thank you for your bug report. Thank /you/ for MySQL (: tam -- eCS 1.00, Ducati 750SS '92 up and running http://tam.belchenstuermer.de/ - Before posting, please check: http://www.mysql.com/manual.php (the

Re: MySQL, MyODBC and MS Access

2002-03-22 Thread jake williamson 28
hello mark, been doing this quite a bit recently but i cheat a bit... 1st step is to export the table from access as a text file - delimited by comma's. if you load up phpMyAdmin (available at http://www.phpwizard.net/projects/phpMyAdmin/), create your database and then mimic the table set up

Database thrash/load spikes under RedHat 7.1

2002-03-22 Thread Christopher Manly
Hi, We just moved our operation to a new hosting company, and in the process went from an old version of Slackware linux running MySQL 3.22.xx to systems running RedHat 7.1 and MySQL 3.23.37. When I do a large LOAD DATA INFILE or something else that puts a tidbit of strain on the database,

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Chuck Roberts
I'm doing something similar, with an Access front-end and mysql back-end. -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS

how to use checker to debug mysql applications

2002-03-22 Thread mysql-return-103913-archive=jab . org
Hi, is there any way to debug a c-programm that uses the mysql c-api? I want to use checker for memleak checking but it seems to be impossible to compile the mysql client libraries using checker. The reason seems to be some assembly language parts. All other libraries I need compile. Did anybody

Re: Optimizing tables

2002-03-22 Thread William R. Mussatto
Ok this works on myisam tables, but what about InnoDB On Fri, 22 Mar 2002, Egor Egorov wrote: Date: Fri, 22 Mar 2002 15:38:03 +0200 From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Optimizing tables Vijay, Friday, March 22, 2002, 1:14:33 PM, you wrote: V how do i

Re: still no umlauts in mysql --experts help needed

2002-03-22 Thread sascha mantscheff
Am Freitag, 22. März 2002 11:58 schrieben Sie: Egor: Thanks for the hint. I browsed the manual for readline(3) and for /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all other programs and from the bash command-line - only in mysql they don't work. Where else

Re: Can you Change Nulls in the MySQLDump from \N?

2002-03-22 Thread David M. Peak
Well I was able to fix the problem by doing a Select into Outfile and specifying in my select list and using IF... thanks - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: David M. Peak [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 4:24 PM

Problem with 3.23.22

2002-03-22 Thread Kuntrynet Office
I recently installed MySQL version 3.23.22 on a Linux server. It used to run fine. The problem is when I run a php query on a database it returns the error Cannot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Hmm. My mysql.sock file is located in /tmp/mysql.sock.

FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable. I have a database driven website which has several hundred visitors per day. After viewing my logs on a daily basis, I see a Unknown database error appear from time to time. Now, I also have

Re: Problem with 3.23.22

2002-03-22 Thread Shawn McCool
you can create my.cnf file with the contents [mysqld] socket=/var/lib/mysql/mysql.sock and put it in path. In case you need to know where the my.cnf file should be put, execute: mysqld --help | grep my.cnf or with your command line mysql binary do mysql -uusername -p -S=/tmp/mysql.sock

Re: Problem with 3.23.22

2002-03-22 Thread Martin Burke
This happened on our server, and we had to reload the grant table (mysqladmin reload). Also, the mysql directories were owned by root so we had to chown them to the mysql user. I hope that helps, Martin Kuntrynet Office wrote: I recently installed MySQL version 3.23.22 on a Linux server.

Remote connection to MySQL Server using MS Access 2002

2002-03-22 Thread Charles McGrotty
Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL database. I have tried putting an IP address in that I found by lookup of the domain name, and I entered the database name and password, but I get an error saying connection from

Re: FreeBSD+MySQL

2002-03-22 Thread Andrey Kotrekhov
äÏÂÒÙÊ ÄÅÎØ. I have the same problem. We increase max number of users in the kernel config and recompile. The problem is solve at most. Try to increase max number of open files in kernel. Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable.

Re: Server startup error on Linux

2002-03-22 Thread Egor Egorov
Rance, Friday, March 22, 2002, 4:53:41 PM, you wrote: RH here goes (not that it will give you any better information than I did RH already but since you asked...) RH exerpt from .err file follows RH 020318 14:30:48 mysqld started RH 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host'

Re: Unix Jobs?

2002-03-22 Thread Alex Menendez
try: http://www.justunixjobs.com http://www.dice.com -amen PS If you know php, you can learn asp easy. On Fri, 22 Mar 2002, Jonathan Hilgeman wrote: I'm currently working as a e-commerce web programmer specializing in PHP, MySQL, and Apache systems. I've had experience on FreeBSD and

Re: FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
Andrey Kotrekhov wrote: äÏÂÒÙÊ ÄÅÎØ. I have the same problem. We increase max number of users in the kernel config and recompile. The problem is solve at most. Try to increase max number of open files in kernel. Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My

Re: FreeBSD+MySQL

2002-03-22 Thread Dan Nelson
In the last episode (Mar 22), Ozette Brown said: Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232 kern.maxfilesperproc = 8232 So,

Re: JBuilder6 and mm.mysql-2.0.11

2002-03-22 Thread launi
On Fri, 22 Mar 2002, TAKAHASHI, Tomohiro wrote: Hi, Lonnie Lonnie Wormley wrote: TAKAHASHI, Tomohiro wrote: Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? Here is the stack trace: See

Re: Remote connection to MySQL Server using MS Access 2002

2002-03-22 Thread Ken Anderson
There are other windows front ends to mysql, but this one is the best: http://ems-hitech.com/mymanager/ Are you sure the server allows remote connections? Ken Charles McGrotty wrote: Hi, Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I can connect to a remote MySQL

mysql datbase backups

2002-03-22 Thread Kathy Reyes
I am still a new to mysql. What is the syntax for backing up a table and how do I make it no-lock while doing so. I need the tables to still be able to be written to. I know that this will make my backup a little unaccurate but that doesnt really matter... Kathy Reyes Live Technology

RE: Connecting to a remote MySql server

2002-03-22 Thread Paul Gilbert
You have written the following: Hi! I am running Apache on Linux and MySql database is running on a windows200 server. Is there a way to connect to that database using the IP address ? Thanks for your help! Paul - Before

Post installation problems in MySQL

2002-03-22 Thread srividya subramanian
Sir/Madam I installed the binary version of (MySQL) mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. The steps followed to install are: tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. cd mysql-3.23.49a-pc-linux-gnu-i686 ./configure scripts/mysql_install_db cp

Re: FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
Dan Nelson wrote: In the last episode (Mar 22), Ozette Brown said: Andrey, Thank you for the reply. I read somewhere that when checking your maximum file descriptors your kern.maxfiles should be greater than kern.maxfilesperproc. My settings are: kern.maxfiles = 8232

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Mark Stringham
Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Todd Williamsen
Your client won't drop Access in favor of a faster, more secure database like mySQL? Why is your client stuck on Access? The data can be dumped and make the GUI web based to look just like the Access one... Stick in on a Intranet server, and lock it down... I would rather have that than a slow,

Re: Compiling on apache.

2002-03-22 Thread Michael Stassen
You have to tell it to use gcc. It doesn't look like you're following the directions for compiling on HP-UX. See http://www.mysql.com/doc/H/P/HP-UX_10.20.html or http://www.mysql.com/doc/H/P/HP-UX_11.x.html If you need help after that, specify your version of HP-UX, version of MySQL,

Problem with replication

2002-03-22 Thread Jim Lucas [jimmysql]
After much stress, I finally found the answer to my problem. Here is the error message that I was getting: 020322 11:54:29 Slave: Failed reading log event, reconnecting to retry, log 'bend149-bin.002' position 2407727 020322 11:54:29 Slave: reconnected to master '[EMAIL

problems running ./configure

2002-03-22 Thread Richard Reina
I am not sure what the heck the problem is. I'm trying to install mysql (client) on a RH 7.2 box. When I run ./configure --without-server I get a bunch of messages about mysql passwords being changed and mysql daemon being started -- sorry I can't include the exact messages but I have no

Re: Access denied on use mysql;

2002-03-22 Thread Brian Reichert
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote: mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has

Please Help. Problem installing

2002-03-22 Thread Richard Reina
I am not sure what the heck the problem is. I'm trying to install mysql (client) on a RH 7.2 box. When I run ./configure --without-server I get a bunch of messages about mysql passwords being changed and mysql daemon being started with databases from /install directory -- sorry I can't

Re: FreeBSD+MySQL

2002-03-22 Thread Dan Nelson
In the last episode (Mar 22), Ozette Brown said: Dan, I guess I'm not hitting my systems openfile limit because I do not see file table full in my /var/log/messages. Here's the other info you inquired about: m1# sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles kern.maxfiles:

MySQL oddity

2002-03-22 Thread Steven Gearhart
Below is a table declaration in a database I just created. The oddity is the 2 fields, CL_FIRST_TS and CL_LAST_TS, are automatically marked as Required in the table's Validity Checks listing. This means that I have to add a value to both of them each time I insert a new record. They are involved

MySQL Tip: Faster Updates

2002-03-22 Thread BD
This *might* make your updates a bit faster. I don't think MySQL optimizes updates this way (it would be nice if it did.) Depending on your data it may be possible to eliminate updating some of the rows if the row already has the new value. As strange as this seems, something as simple as:

Re: Server startup error on Linux

2002-03-22 Thread Rance Hall
Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server

--extended-insert vs. performance

2002-03-22 Thread Martin MOKREJ
Hi, sorry to bother you with this, but one thing one might look into is: When table was dumped with --extended-insert option, that the server importing the table does NOT perform well. In the output from `vmstat 1` each second there's a lot of I/O, and at least on linux 2.4.19-pre1 it runs

encode invalid characters for mysql in c++

2002-03-22 Thread Eric Mayers
I'm looking for a function that will take a string or char* of 256bit ascii (or other stuff) and convert it into something that can be inserted into a varchar type in mysql. Then when the data gets pulled out it would be converted back. I know I need to convert quotes and some control

Re: Access denied on use mysql;

2002-03-22 Thread alan4100
mysql Brian, Fine...lots of typing.:)

How to quickly Update a table based on tally from another

2002-03-22 Thread BD
I'm coming up empty on this one and it should be quite simple. Maybe because it's Friday?? I have 2 tables, Dept and Employee. I want to count the # of employees in each dept and store it in the corresponding Dept row. To do the tally it is simply creating a temporary table: drop table if

Re: hi

2002-03-22 Thread blue man
--- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire

Re: outer joins

2002-03-22 Thread Bob Hall
On Fri, Mar 22, 2002 at 04:37:07PM +, ds wrote: Hi, did you get any answer ? I'm having the same problem. If i wanted all results from table1, even if they don't appear in table2 i would do like: SELECT . FROM table1 LEFT JOIN table2 ON (table1.id=table2.id) ... But how to

Segmentation fault and core dump at daemon startup

2002-03-22 Thread Der Rudi
Description: Whenever I try to start up the daemon it gives a 'Segmentation fault core dumped' message and shuts down. How-To-Repeat: Just try to start the daemon up Fix: ? Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED]