Setup and Configure ODBC Data Source Automaticaly

2001-12-10 Thread Francisco M Spinola
I have a database application in MS-Access running in Windows NT, that is in a network drive, and it has about 150 users. What i want to do, is centralize the database in a PC that would be the server, and place the MS-Access tables in a MySQL database, and the tables would be accessed from

RE: Annoying article about MySql

2001-12-10 Thread Greg_Cope
-Original Message- From: Richard S. Huntrods [mailto:[EMAIL PROTECTED]] I have database mysqldump outputs that were 15 megabytes (now 10 megs, as I removed some report storage from the system). I have restored my system from these dumps many, many times. I have 4 systems in use

[PERFORMANCE] MySQL/InnoDB-3.23.46a for Windows available now, fixes the slowness in .44 - .46

2001-12-10 Thread Heikki Tuuri
Hi! Windows binaries of MySQL-3.23.44 - .46 were accidentally compiled with UNIV_SYNC_DEBUG defined in the project file. That makes some InnoDB queries up to 10 times slower than they should be on Windows. Fixed binaries, named 3.23.46a, are now available for download at

MySQL redundancy/backup

2001-12-10 Thread Igal Rubinstein
Hello, I would like to hear your opinions, recommendations, ideas, etc., about the following subjects: I have two servers. Both of them have MySQL, PHP, Apache. The first server is used as SQL server and the second server is used as Web sever. The problem is that it is mission critical and very

HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
Hello. When I start the mysql database my load is nearly zero. After some time e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s are going wild till 90% user 10% system. Normaly this system could handle a lot of database operations. Here are some system information: -

HELP .. lot of load

2001-12-10 Thread Daniel Backhausen
Hello. When I start the mysql database my load is nearly zero. After some time e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s are going wild till 90% user 10% system. Normaly this system could handle a lot of database operations. Here are some system information: -

Database Syncronization

2001-12-10 Thread Ananth Rajaraman
Hi I have a similar database on the local and remote server. I want to syncronize the two. Please Help Ananth __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

Re: MySQL redundancy/backup

2001-12-10 Thread Benjamin Pflugmann
Hi. You can use the built-in replication feature to sync a MySQL instance on the web server (slave) with the database server (master). Then you always have a recent snapshot of the database. You can also use the database on the slave to make your backups. Temporarily halt replication, make your

Re: HELP... lot of Load

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote: Hello. When I start the mysql database my load is nearly zero. After some time e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s are going wild till 90% user 10% system. Normaly this system could

Re: Database Syncronization

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 02:17:07AM -0800, [EMAIL PROTECTED] wrote: Hi I have a similar database on the local and remote server. I want to syncronize the two. Please Help I would love to, if I knew what's the problem. You may want to have a look at replication in the fine manual:

SELECT QUERY Problem

2001-12-10 Thread Anatole
Hello, I often run into the problem of trying to join several tables and select just the most recent (or largest) item from a series of entries. For example. Table 1: names Id | name 15 | George 16 | Suzy Table 2 : scores_1 Id | score 15 | 85 15 | 60 15 | 70 15 | 95 Table 3 : scores_2 Id

AW: HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
Hi Benjamin. Thank you for your fast reply. I have another two small detailed questions. 1st: Do you think, if I compile the mysql source on my own it should be better ? I readed, that RedHat 7 has pre-compiled the mysql with an errorous version of gcc. ... so I would compile it on my own. 2nd:

Fwd: Re: newbie. can't run safe_mysqld

2001-12-10 Thread Kevin Donnelly
Hi Mike This command executes and immediately ends: safe_mysqld --log [2] 855 root@linux:/var/lib/mysql Starting mysqld daemon with databases from /var/lib/mysql 04 07:45:16 mysqld ended This command seems to run quite nicely: safe_mysqld --skip-grant-tables Now the manual

REPLICATION Question

2001-12-10 Thread Sobolyev Oleg
Hi everybody. Does anybody know how to rotate log files (log_bin) _correctly_ while I have master\slave relationship has been started? The problem is that while I try to do any of rotating procedures (by logrotate or manual mysqladmin ... flush-logs) I loose master from slave (Slave wrote:

Connection pool

2001-12-10 Thread ga.moreno
Hello to all. First, I'm sorry, but my englis is very, very bad. My problem is the next: I'm using Poolman to create a conecction pool in Tomcat 4 to access a MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver, JDBC throws this exception: java.sql.SQLException: Transaction

Re: Database Syncronization

2001-12-10 Thread Kevin Donnelly
On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote: You may want to have a look at replication in the fine manual: http://www.mysql.com/doc/R/e/Replication.html A lot of info there! But it seems to apply mainly to v4. I'm not sure of Ananth's situation, but what I want to do is have

Re: HELP... lot of Load

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:41:34AM +0100, [EMAIL PROTECTED] wrote: Hi Benjamin. Thank you for your fast reply. I have another two small detailed questions. 1st: Do you think, if I compile the mysql source on my own it should be better ? I readed, that RedHat 7 has pre-compiled the

Re: PHP+MYSQL: unable to select database

2001-12-10 Thread Kevin Donnelly
One of three issues: 1 - the db is not set up correctly; 2 - the user is not set up correctly; 3 - the PHP script is not calling the db properly - this could be due to wrong syntax, misnaming of the db table, or incorrect username parameters. You would need to post some more info, in particular

AW: SELECT QUERY Problem

2001-12-10 Thread Daniel Backhausen
Hi. Try this one: SELECT MAX(score) FROM scores_1, scores_2 WHERE Id = 15 Greetz - Daniel Backhausen -Ursprungliche Nachricht- Von: Anatole [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 11:32 An: [EMAIL PROTECTED] Betreff: SELECT QUERY Problem Hello, I often run

Re: Database Syncronization

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:12:58AM +, [EMAIL PROTECTED] wrote: On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote: You may want to have a look at replication in the fine manual: http://www.mysql.com/doc/R/e/Replication.html A lot of info there! But it seems to apply

is type casting available

2001-12-10 Thread sreedhar
hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. thanks in advance. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: SELECT QUERY Problem

2001-12-10 Thread Aleksandar Bradaric
Hi, Table 1: names Id | name 15 | George 16 | Suzy Table 2 : scores_1 Id | score 15 | 85 15 | 60 15 | 70 15 | 95 Table 3 : scores_2 Id | score 15 | 50 15 | 55 15 | 60 15 | 45 What I want to end up with is a selection that would pick up George and his highest score on score_1

Re: Annoying article about MySql

2001-12-10 Thread M. A. Alves
On Sat, 8 Dec 2001, Admin wrote: I was just reading an annoying article from a user who was moving from MySql to Postgres because of stability problems and because of problems restoring large MySql data-dumps. . . . I would be grateful to hear your opions and experiences, good or bad. I

AW: is type casting available

2001-12-10 Thread Daniel Backhausen
Hi. Best and simpliest way ist to use phpMyAdmin for such changes. Greetz - Daniel Backhausen -Ursprüngliche Nachricht- Von: sreedhar [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 12:43 An: mysql Betreff: is type casting available hi all, how can i cast a variable

Re: is type casting available

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 05:13:21PM +0530, [EMAIL PROTECTED] wrote: hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In

The problem with engine.

2001-12-10 Thread robertix
When I try to do anythithing with MySQL, I always see Ignoring query to other database on my screen. When I type status, the computer prints: All updates ignored to this database. after Current user. Could anybody help me ? robertix

Re: Can't start up MySql

2001-12-10 Thread Kevin Donnelly
Can you give some more info? Eg what is Fink, what distro are you using, how can you install if you don't have perms for the directory, etc. Kevin On Saturday 08 December 2001 15:17, Espen Isaksen wrote: I installed MySql through Fink but now that I try to start up I type mysqld at the

GUI Client for Redhat 7.2

2001-12-10 Thread Mark Selby
Help! I'm at a loss as to a GUI that I can run and just edit the damn data in a grid format (there's millions of tools to modify the database structures.) I'm on RedHat 7.2 so KMysql isn't supported. If anyone has found a good one, I'd love to know (similar to pgaccess is absolutely fine -

Re: is type casting available

2001-12-10 Thread sreedhar
hi Benjamin, thanks, here shortname is varchar and pcallid is integer. i need shortname and pcallid as ' callno' of length 6. pcallid starts from 1 .. 999. to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and pick last 3 characters and concat with shortname. simply

Can't import dump file OS X

2001-12-10 Thread ollie
Hi all, I'm having a problem importing a dump file in Mac OSX. I created the dump from phpMyAdmin, and tried to import it in these 2 ways with the following results: From mysql command line: Mysql database_name dumped_file; Result: ERROR 1064: You have an error in your SQL syntax near

Re: PHP+MYSQL: unable to select database

2001-12-10 Thread Kevin Donnelly
Hi Josep We have to be clear about definitions. You seem to be making a couple of mistakes here: 1 - guestbook.sql is not the db, but probably a script to create the db (you can check by opening it in a text-editor - it will probably have a CREATE TABLE statement at the top, then the field

example using temporary tables

2001-12-10 Thread Bennett Haselton
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html says that for some sub-queries you can create temporary tables, but I couldn't find any examples in the tutorial that show the use of a temporary table. Are there any? Or, if you're feeling generous, could you just tell me how to do this

Re: Parallel queries in PHP program

2001-12-10 Thread Kevin Donnelly
So far as I know, yes. You need to set up two different connection strings, though, and reference those in the different queries. Kevin On Friday 07 December 2001 08:14, Ares Liu wrote: Can I implement parallel queries to mySQL by using sevial query sentences in a single PHP file? Who

mysqlclient linking questions

2001-12-10 Thread Hans Zaunere
I use the -lmysqlclient command line argument to gcc under Linux. It compiles fine and everything works great. However, if I move the compiled binary to another system, which doesn't have the mysql client libs installed, when I try to start the program, I get: error while loading shared

Re: efficient DELETE query - 2 tables

2001-12-10 Thread Etienne Marcotte
mySQL can't do subselects afaik Etienne Harlan Feinstein wrote: Rory I want to write an efficient query that will delete all records Rory from one table when they show up in another table (pending Rory shipments -- shipped shipments). I can't do it with this: mysql DELETE from

Re: Annoying article about MySql

2001-12-10 Thread Etienne Marcotte
http://www.phpbuilder.com/columns/tim2705.php3 especially: http://www.phpbuilder.com/columns/tim2705-res.php3 those aren't from the latest releases of both DB, but gives a good idea. Someone in replies said that the mysql that dies is not normal and some config was probably not done

Re: Newbie!

2001-12-10 Thread Etienne Marcotte
Please use a more descriptive subject, you have better chances to have replies (a lot filter out subjects having only question newbie, etc Etienne Angel Gabriel wrote: Thanks for reading this. I'm new to the whole world of linux, and MySql, but I decided to get my hands dirty, and learn

Re: Problem

2001-12-10 Thread Etienne Marcotte
Please use a more descriptive subject... I don't use Solaris and therefore cannot help you at all with your problem. Plus a lot of users filter out subjects problem newbie question since they are usually a lost of time to read and often not related to one of their strong subject. Etienne

[OT] Undescriptive subjects.

2001-12-10 Thread Etienne Marcotte
PLEASE can everybody use a descriptive subject? Especially on a monday morning, I have over 250 messages, I really appreciate to read and learn from other's problems, but when it talks about solaris install I can't care less, I do filter subjects, but too often they are totally unhelpful. Is

Re: example using temporary tables

2001-12-10 Thread Dr. Frank Ullrich
Hi, Bennett Haselton wrote: --snip select * from user left join MYTEMP on user.ID = MYTEMP.userid where MYTEMP.userid IS NULL; I bet that this approach will fail because you want the join to show you records that aren't there. But it will show you something, and it will show you more if you

Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
Hi all, Is there any limitation in creating full-text indexes on MyISAM tables? Currently, I have a table like this: CREATE TABLE IF NOT EXISTS mytable ( UId BIGINT(20) NOT NULL AUTO_INCREMENT, Title VARCHAR(255) NOT NULL, Field1 TEXT, Field2 TEXT, Field3

Re: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Sergei Golubchik
Hi! On Dec 10, Al Caponi wrote: Hi all, Is there any limitation in creating full-text indexes on MyISAM tables? Currently, I have a table like this: CREATE TABLE IF NOT EXISTS mytable ( UId BIGINT(20) NOT NULL AUTO_INCREMENT, Title VARCHAR(255) NOT NULL, Field1 TEXT,

Should I give on Linux and go back to Microsoft???

2001-12-10 Thread Dr. Randy Frid
I knew that would get your attention. But it may become reality because I don't seem to have the skill to solve this problem as I'm a Linux novice and my Win2K install works perfect. It would be a shame to give up on Linux in favor of Microsoft but it works on Microsoft. I have run out of

Fresh Install Already Contains Password--What is it?

2001-12-10 Thread Kurt Tappe
Our brand new, fresh install of 3.23.46 won't let us set the password for the root user because one seems to already be set. Even after wiping the ...mysql/data/mysql directory clean and rerunning mysql_install_db, we still get an Enter password: prompt when attempting to set the root user

RE: Fresh Install Already Contains Password--What is it?

2001-12-10 Thread Chris Bolt
Our brand new, fresh install of 3.23.46 won't let us set the password for the root user because one seems to already be set. Even after wiping the ...mysql/data/mysql directory clean and rerunning mysql_install_db, we still get an Enter password: prompt when attempting to set the root user

RE: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
Hi Sergei! Thanks for the reply! That was fast :) -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:48 PM To: Al Caponi Cc: MySQL Mailing List Subject: Re: Limitation of Full-Text indexing in MyISAM table? Hi! On Dec 10, Al

RE: Fresh Install Already Contains Password--What is it?

2001-12-10 Thread Kurt Tappe
At 8:19 AM -0700 12/10/01, Chris Bolt wrote: Our brand new, fresh install of 3.23.46 won't let us set the password for the root user because one seems to already be set. Even after wiping the ...mysql/data/mysql directory clean and rerunning mysql_install_db, we still get an Enter password:

RE:Reply to:: Should I give on Linux and go back to Microsoft???

2001-12-10 Thread Gary Roediger
What version of MySQL?? - older versions ( I think around version 3.2.22 and earlier ) you could not run on the same system as MySQL was running and use the TCP socket (3306) - your programs had to use the socket file. For some API packages interfacing to MySQL - they used the TCP socket and

Re: are my queries bloated?

2001-12-10 Thread Erik Price
On Saturday, December 8, 2001, at 12:53 PM, Arjen G. Lentz wrote: Re-order the list of tables in the FROM, and put the subprojectweb.subproject_name = 'shoeshine.com' bit first after the WHERE, that will also make it clearer for you to read. Is this just for my own personal clarity? I

Bug report mysql 3.23.45

2001-12-10 Thread Peter Zaitsev
Hello mysql, Running Linux 2.4.x SMP/innodb. This query works OK. mysql explain SELECT cp.counter_id, tg.tbl, cs.host - FROM counter.table_groups AS tg, counter.counterproperty AS cp, counter.servers AS cs - WHERE tg.tblid=cp.tblid AND tg.server=1 AND cs.SERVER_ID=tg.server limit

Re: FIND_IN_SET

2001-12-10 Thread Wiliam Stephens
Hi I've got the following SQL statement for a MySQL database: SELECT * FROM gd_records WHERE FIND_IN_SET('$value',$field) What I want to know is how do I replace $value with a number of the position of the SET field? Ugh, I'll try and explain this more clearly. I've got the following

Re: Re: Problem with GROUP BY ... DESC

2001-12-10 Thread Michael Widenius
Arjen == Arjen G Lentz [EMAIL PROTECTED] writes: Arjen Hi, Arjen - Original Message - Arjen From: AJ [EMAIL PROTECTED] Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) The problem that has cropped up I have is that in all GROUP BY column DESC statements, the DESC is now

Problem shutting down MySQL Server gracefully

2001-12-10 Thread Intekhab Choudhury
Hi, I recently installed 3.23.46 Binary for HP-UX replacing my 3.xx.42 (basically, replaced the symbolic link /usr/local/mysql to look at the 3.23.46 untar directory. -- Here's a an output: $/usr/local/mysql#su# bin/mysqladmin -u root -p version Enter password: Server version

Re: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Sergei Golubchik
Hi! On Dec 10, Al Caponi wrote: Hi Sergei! Thanks for the reply! That was fast :) -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:48 PM To: Al Caponi Cc: MySQL Mailing List Subject: Re: Limitation of Full-Text

Re: [OT] Undescriptive subjects.

2001-12-10 Thread Etienne Marcotte
Thanks, I will definitively look for that But the blocking should be done by the mailing list, making a reply like the one for omitting mysql or database in the message. the message could just ask to put a more descriptive subject. because if every user filters out topics, then the person

Re: [OT] Undescriptive subjects.

2001-12-10 Thread Gordan Bobic
On Monday 10 Dec 2001 14:08, Etienne Marcotte wrote: PLEASE can everybody use a descriptive subject? I've got an additional idea - how about configuring the mailing list remailer to put something like [MySQL-General] or [MySQL-Internals] in the subject line? For some of us who are on

RE: Database Syncronization

2001-12-10 Thread Jonathan Hilgeman
If you use PHP, you can use my utility dbUtils at http://php.sitecreative.com - it has functions for synchronizing databases. - Jonathan -Original Message- From: Ananth Rajaraman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 2:17 AM To: [EMAIL PROTECTED] Subject: Database

Re: [OT] Undescriptive subjects.

2001-12-10 Thread Robert Cross
Gordan Bobic wrote I've got an additional idea - how about configuring the mailing list remailer to put something like [MySQL-General] or [MySQL-Internals] in the subject line? For some of us who are on multiple lists, it gets really hard to work out what is what without reading the whole lot.

Index of SET Field

2001-12-10 Thread Wiliam Stephens
Hi How can I create an index of a SET field so that a FIND_IN_SET can search for a column number rather than name? Is this even possible in MySQL? It might seem like a bug? Thanks. Wiliam Stephens Web Developer http://www.fbagroup.co.uk

RE: MYSQL running under WIN98

2001-12-10 Thread Jonathan Hilgeman
I suggest installing FoxServ, which installs a combination of Apache, PHP, and MySQL. Does it without a hitch. Great for development systems. - Jonathan -Original Message- From: Dan Wolfe [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 6:24 PM To: [EMAIL PROTECTED] Subject:

Re: Index of SET Field

2001-12-10 Thread Etienne Marcotte
I think you are missing something. From the Manual: FIND_IN_SET(str,strlist) Returns a value 1 to N if the string str is in the list strlist consisting of N substrings. A string list is a string composed of substrings separated by `,' characters. If the first argument is a constant

Re: Index of SET Field

2001-12-10 Thread Wiliam Stephens
Hi Thanks for your reply. I've got the field res_places_sl. It's a SET field that consists of the following options: 'Wales','North','South' I was using FIND_IN_SET('Wales',res_places_sl); to access all records that were categorised under 'Wales' which worked great. Now, I want to be able

Re: Should I give on Linux and go back to Microsoft???

2001-12-10 Thread Kodrik
If you are a beginner and are using red hat why don't use the mysql rpms. It does everything for you. When you compile php, be sure you have the right path for mysql (I think that is your error in this case). Finally, be sure you entered the user right for the connection, with the host

killed by SIGSEGV

2001-12-10 Thread matt
Hey list, thanks to all those who gave me useful information regarding my problem with mySQL. I intend to upgrade my kernel from 2.4.4 to 2.4.12, and then see if there is any change. If not then I'll try changing mySQL for the binary version from the site. I plan to install to

Re: Index of SET Field

2001-12-10 Thread Etienne Marcotte
read http://www.mysql.com/doc/S/E/SET.html for the set, how it works internally... humm.. is that what you want? : mysql CREATE TABLE test( - id INT UNSIGNED AUTO_INCREMENT, - place SET(Whales,North,South); - PRIMARY KEY (id)); Query OK, 0 rows affected (0.00 sec) [insert some

Connection Problem - We're almost there...

2001-12-10 Thread Dr. Randy Frid
I recently wrote in that I've tried everything in the book to connect to MySQL but I'm still getting the infamous socket (111) error. I've had a few good suggestions and I think we are almost there. Here's where I am. With MySQLGUI trying to connect, I changed the host from localhost to

mysql round problem

2001-12-10 Thread Attila Soki
hi, is this bug already in buglist, maybe in newer verisons of mysql is already corrected? if yes then please let me know please from what version. the probmlem: select round(9.065,2) ++ | round(9.065,2) | ++ | 9,06 | ++ why not 9,07

Re: mysql round problem

2001-12-10 Thread Ryan Fox
From : http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fun ctions ROUND(X) Returns the argument X, rounded to the nearest integer: mysql select ROUND(-1.23); - -1 mysql select ROUND(-1.58); - -2 mysql select ROUND(1.58); - 2 Note that the

Re: mysql round problem

2001-12-10 Thread Dibo Chen
The rounding rule I learnt many years ago said, rounding in 1 if previous digit is odd but discarding it if even. so 9.065 - 9.06, 9.055 - 9,06, ... Attila Soki wrote: hi, is this bug already in buglist, maybe in newer verisons of mysql is already corrected? if yes then please let me

news group

2001-12-10 Thread Won Lee
Is this MySQL mailing list available via a news group? Won - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Re: mysql round problem

2001-12-10 Thread Etienne Marcotte
That rule is usually to try and get at the end the most accurate value, if your numbers are evenly distributed your final value will be closer to the good one. So if your values will never have the rounding digit odd so you'll always be discarting half the smallest digit.. at the end of multiple

Re: efficient DELETE query - 2 tables

2001-12-10 Thread Kelly Firkins
I would love to give proper credit to the individual who created this, but alas, I cannot remember where I stumbled upon it. When I needed to do some cleaning, I did \T from the mysql app to write to a file... then ran the script SELECT CONCAT('DELETE FROM post WHERE threadid = ',

Connection Pool

2001-12-10 Thread GABRIELMORENO
My problem was the next: I'm using Poolman to create a conecction pool in Tomcat 4 to access a MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver, JDBC throws this exception: java.sql.SQLException: Transaction Isolation Levels are not supported. params:

Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-10 Thread A. Clausen
The replication server functions perfectly, but the slaves are not updating. A. Clausen [EMAIL PROTECTED] - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, December

Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-10 Thread kadvani
Had a question on Whether or not MySQL Editor supports Db2 Version 5.0. Kumud Advani Sears Canada Inc Architect Council - Corporate Data WareHouse Tel : (416) 510 - 6217 - Before posting, please check:

question using mysqladmin with apache on win32 (w2k)

2001-12-10 Thread MOWE (Michael Owens)
Quick question for someone if they can pass along a little knowledge from their experiences: I am dabbling in MySQL and Apache on a Win2K box and most of it seems to work fine. The one thing I can't figure out is that when WinMySQLAdmin launches at startup, I am not able to use the functions of

Re: mysql round problem

2001-12-10 Thread Shankar Unni
Attila Soki wrote: select round(9.065,2) ++ | round(9.065,2) | ++ | 9,06 | ++ why not 9,07 ?? Most C compilers today defer things like round() to the floating-point unit on the CPU. Most CPUs these days implement IEEE754 as

Re: mysql round problem

2001-12-10 Thread Etienne Marcotte
maybe you can add a small value to be sure it rounds up. select round(9.065+.001,2); Always add 1 at the digit after the one you want to keep:) so 9.065 can also be a variable... Etienne Shankar Unni wrote: Attila Soki wrote: select round(9.065,2) ++ |

new user basic questions

2001-12-10 Thread bradbury_joe
I am new to dababases in general and have a few questions. I have been building a database in mysql using sql commands in msdos but would like to use Visual Basic from here on out to edit the database. After completion of the database I need to use it for a program that will also be editing the

Re: mysql round problem

2001-12-10 Thread Etienne Marcotte
[EMAIL PROTECTED] wrote: [blabla because there is no sql in my text] You have written the following: Good point well then the best is two smaller than the highest resolution you have. if all your data has 4 digits after the . you'll be ok with a epsilon 2 digits smaller since

Re: mysql round problem

2001-12-10 Thread Dibo Chen
Etienne Marcotte wrote: maybe you can add a small value to be sure it rounds up. select round(9.065+.001,2); The rounding in 1 on odd and 0 on even is dealing only 5, to make the round more accurate or even, as you mentioned. 6-9 always round in 1 while 1-4 always round in 0. select

Re: question using mysqladmin with apache on win32 (w2k)

2001-12-10 Thread Kelly Firkins
Unless I'm off my rocker, the WinMySQLAdmin program is a windows executable and has nothing to do with Apache. When you're in it, click on the My.ini Setup tab and enter the necessary username/password required to connect to your MySQL installation and save that configuration. Then

Re: new user basic questions

2001-12-10 Thread Rodney Broom
From: [EMAIL PROTECTED] I am new to dababases in general... Learn SQL (which it sounds like you've done). It's almost always going to be the standard tool between various database vendors and APIs. ...would like to use Visual Basic ...to edit the database. I won't make any MickySoft vs.

Re: Connection Problem - We're almost there...

2001-12-10 Thread Sinisa Milivojevic
Dr. Randy Frid writes: I recently wrote in that I've tried everything in the book to connect to MySQL but I'm still getting the infamous socket (111) error. I've had a few good suggestions and I think we are almost there. Here's where I am. With MySQLGUI trying to connect, I changed the

Re: new user basic questions

2001-12-10 Thread Kelly Firkins
I am new to dababases in general and have a few questions. I have been building a database in mysql using sql commands in msdos but would like to use Visual Basic from here on out to edit the database. After completion of the database I need to use it for a program that will also be editing the

RE: new user basic questions

2001-12-10 Thread Todd Williamsen
Welcome to the Club! Connecting to a mySQL database would be the same way in VB6 as MS SQL or Access, via ODBC. You should download myODBC from mysql.com. On Microsoft Oses it is easier to develop apps via ODBC because its like saving you 5-10 lines of code to write. If it's a web

adding space fill to field

2001-12-10 Thread Jeff Small (NWCC)
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21) and only using 18 characters, how do you fill in the rest with forced spaces? - Before posting, please check:

Kill Thread

2001-12-10 Thread Karl J. Stubsjoen
Hello, I need to kill a thread. I've issued a command which has locked a table (delete from table where id = 9) was the command and it is taking a very very long time. Now I'd like to kill that thread. However, I can't read the the thread ID because the ID scrolls out of view in my little

Re: Kill Thread

2001-12-10 Thread Shakeel Sorathia
try using mysqladmin with a grep command, or redirect it's output to a file. something like this should do it. mysqladmin -u user -p processlist | grep delete deleteprocess.out then less the file and you will be able to scroll thru the output. hope this helps.. --shak Karl J. Stubsjoen

Re: adding space fill to field

2001-12-10 Thread Rodney Broom
From: Jeff Small (NWCC) [EMAIL PROTECTED] ...how do you fill in the rest with forced spaces? char pads, but you may not want to alter your database. Why do you ~have~ to have 21 bytes? Can the device you're pulling this data into be modified to handle things more intelegently? Another

Re: Kill Thread

2001-12-10 Thread Kelly Firkins
I'd pipe the process list contents to a file, then look at the file via a text editor eg. \T c:\processes.txt show processlist; \t Kelly try using mysqladmin with a grep command, or redirect it's output to a file. something like this should do it. mysqladmin -u user -p processlist | grep

Default 1 == Default 16777216 ?

2001-12-10 Thread Philip Molter
I have a 3.23.45 database running with InnoDB tables. When I do this: create table test_default ( testint int not null default 1 ); desc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra |

need help with mysql rpms

2001-12-10 Thread Raymond Norton
I need to remove a previous version of mysql and install the newest. When trying to remove the previous version it complains about dependencies . I don't know what to do about it, so I end up with a successful install of the new version. Any help would be appreciated rpm -e mysql-3.23.36-1

Re: Default 1 == Default 16777216 ?

2001-12-10 Thread Dave Burgess
You wouldn't happen to be crossing an architecture boundary, would you? Say from a Macintosh client to a PC server, or a PC client to a Sun Server? 16777216 Decimal = 100 Hex which would make perfect sense if there was an 'endism' problem. Philip Molter wrote: I have a 3.23.45 database

Re: Show slave status permissions

2001-12-10 Thread Michael Eklund
What permissions do you need to have to issue a show slave status command? Thanks, database,sql,query,table -- Michael Eklund System Administrator Netmechanic, Inc. [EMAIL PROTECTED] http://www.netmechanic.com

connecting to mysql from different computer

2001-12-10 Thread Dan
I can connect to mysql with Perl when I have the perl script on the same computer, but as soon as I move the perl script to a different machine it won't work. I replaced localhost with the IP address of the machine on which mysql is on, but that didn't work either. Does anyone have an

Re: adding space fill to field

2001-12-10 Thread Robert Alexander
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21) and only using 18 characters, how do you fill in the rest with forced spaces? Take a look at the LPAD() and RPAD() functions. HTH /Rob ~ Robert Alexander, Alpha Geek,

Re: connecting to mysql from different computer

2001-12-10 Thread Rodney Broom
From: Dan [EMAIL PROTECTED] I can connect... on the same computer ...different machine it won't work. I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on

Searching for partial dates

2001-12-10 Thread jeff
I inherited a large table (50 million records) with the date stored as an integer in the format (mmddyyy). The dates go back to the 1800's and in the 1990's so the year is either 8xx or 9xx. I need to be able to search by partial dates. For example, some searches need to pull every record for

Re: need help with mysql rpms

2001-12-10 Thread Kelly Firkins
try just upgrading the RPMs using rpm -ivh -- Kelly Firkins [EMAIL PROTECTED] I need to remove a previous version of mysql and install the newest. When trying to remove the previous version it complains about dependencies . I don't know what to do about it, so I end up with a

  1   2   >