replication problem, empty Binlog_do_db ?

2004-05-27 Thread matthew zeier
Running 4.0.20-standard-log on Fedora Core 1 on two boxes. Running with a largely untouched my-huge.cnf - innodb configs uncommented. Followed http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html to setup replication. On the master I see: mysql> show master status; +-+

Re: Are Views Supported?

2004-05-27 Thread Greg Willits
On May 27, 2004, at 11:16 PM, Jake Johnson wrote: I was wondering when or will views be supported? http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

Are Views Supported?

2004-05-27 Thread Jake Johnson
Hello, I was wondering when or will views be supported? -- Jake Johnson http://www.plutoid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is MySQL.com using MnoGoSearch for searching its site???

2004-05-27 Thread Greg Willits
On May 27, 2004, at 10:17 PM, mos wrote: As most people already know, MySQL has FullText indexing built into it, so why is mysql.com using MnoGoSearch? (There is an icon "Powered by MnoGoSearch" on the search page.) 1) Is there something wrong with MySQL's FullText search for handling a lot of

Why is MySQL.com using MnoGoSearch for searching its site???

2004-05-27 Thread mos
As most people already know, MySQL has FullText indexing built into it, so why is mysql.com using MnoGoSearch? (There is an icon "Powered by MnoGoSearch" on the search page.) 1) Is there something wrong with MySQL's FullText search for handling a lot of data? 2) Is MnoGoSearch better? 3) Why is

Re: query to see if db exists...........mysql_query( myQuery)

2004-05-27 Thread Jim Winstead
On Thu, May 27, 2004 at 03:59:46PM -0400, Bono, Saroj AA R62 wrote: > I am going to use mysql_query() and want to find out if a certain > database exists. If mysql_real_connect() fails there are many errors > that could account for this. The database may exist , and I cant take > the error return

GRANT temporarily removes passwods until FLUSH

2004-05-27 Thread temp18
>Description: Using the GRANT command causes the password to be deleted until 'FLUSH PRIVILEGES' is executed. This is a security problem. >How-To-Repeat: New 4.1 BINARY install; installed as noted in instructions. No users except root exist. Execute MySQL> GRANT SELECT ON bugg.* TO 'cwolf'@'%';

Mysql Scenario

2004-05-27 Thread tachu
WOuld the following scenario be possible I currently have about 1.2 Tb of data that i need to transform into mysql and be able to server a very high amount of pages from a discussion board. would i be able to place the mysql/data directory in a main server with huge storage and then have several

RE: FW: Could not start MySQL after reinstall - Can't open privil ege tables: Table 'mysql.host' doesn't exist

2004-05-27 Thread MICHAEL_WU
Ok, I found the cause which caused the problem. I wiped out the whole installation directory but the c:\my.cnf file was modified incorrectly. Sine I would like to use innoDB, I had to created database subdirectories manually. I did that but I specified datadir by mistake: datadir = e:/mysql411/d

Client Apps Using a Config File

2004-05-27 Thread Lou Olsten
If I understand the docs correctly, I can use a config file on my client machine for the given mysql client apps such as the mysql command line tool. What if I'm using a 3rd-party app? Will the libraries somehow know to read the config file or would the app have to take manual steps to do it?

Re: Duplicate does not exist

2004-05-27 Thread Robert J Taylor
fr0g wrote: Good evening all. I'm facing a problem with a specific table and the uniques that it has. I have a table, hosting data of peoples names. Some of it's columns are, name_english, surname_english, name_original, surname_original, name_greek, surname_greek. I have as unique each combinatio

MySQL not finidng/using NON-system OpenSSL

2004-05-27 Thread OpenMacNews
hi all, i'm building MySQL-4.0.20 from source on OSX 10.3.3 fwiw, my build env includes: gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1640) autoconf --verautomake (GNU automake) 1.8.2 autoconf (GNU Autoconf) 2.59 ltmain.sh (GNU libtool) 1.5.6 (1.1220.2.94 2004/04/1

Duplicate does not exist

2004-05-27 Thread fr0g
Good evening all. I'm facing a problem with a specific table and the uniques that it has. I have a table, hosting data of peoples names. Some of it's columns are, name_english, surname_english, name_original, surname_original, name_greek, surname_greek. I have as unique each combination of columns

building 4.0.20 on Solaris2.7-x86 - make errors after configure

2004-05-27 Thread gwadm
>Description: make v3.77 (and same with 3.8) aborts with these errors make[2]: Entering directory `/usr/local/mysql-4.0.20/readline' rm -f libreadline.a false cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o complete.o bind.o isearch.o display.o signals.o util.o

query to see if db exists...........mysql_query( myQuery)

2004-05-27 Thread Bono, Saroj AA R62
I am going to use mysql_query() and want to find out if a certain database exists. If mysql_real_connect() fails there are many errors that could account for this. The database may exist , and I cant take the error returned from the failed query to mean the db isnt there and should be created. S

Re: Libraries and header files/MySQL Devel RPM

2004-05-27 Thread Carlos Sunden
nevermind mates, it is. --- Carlos Sunden <[EMAIL PROTECTED]> wrote: > Hello > Libraries and header files RPM download at > http://dev.mysql.com/downloads/mysql/4.0.html > is the mysql-devel package, right? > Thanks! > Carlos > > > - > Do you Yahoo!?

RE: Feature Request: UPDATE 'error codes' or mysql_affected_rows() to be more "accurate"

2004-05-27 Thread Daevid Vincent
Well, my "hack" (which is sort of like what you suggest) is to change my primary key from just an auto_increment 'id' field to a combination of two other fields (mac/scanner_id) that I know must be unique. Then I rely upon the fact that mySQL will not allow a duplicate PK. (I did say it was a hack)

Re: Changing Password on Latest MySQL, etc

2004-05-27 Thread Carlos Sunden
Dear All, The mysql client & mysql-devel packages did it. Was able to change the password which I did with a very easy one. Now when I want to change the existing password & it fails. It does not let me. Thanks agaiN! --- Carlos Sunden <[EMAIL PROTECTED]> wrote: > Ok. > So far I got advises to in

MySQL Connector/J 3.0.13 (Production) Has Been Released

2004-05-27 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.0.13, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.0.13 is a bugfix release for the production tree that is suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.

Re: MySQL Benchmark.

2004-05-27 Thread JG
At 11:02 AM 5/27/2004 -0700, you wrote: Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on production machines. Only one of those issue

Re: How to Enable Full Query Logging?

2004-05-27 Thread Egor Egorov
"Robinson, Eric" <[EMAIL PROTECTED]> wrote: > Hi, > > I included the following statement in my.ini: > >log=3Dc:\log.txt > > I then executed some queries. > > The file log.txt only shows the following: > > MySql, Version: 4.0.13-nt-log, started with: > TCP Port: 3306, Named Pipe: MySQL

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread RV Tec
Err... I guess I owe Jeremy Zawodny an apology for mistyping his name. I promise next time I won't type without reading. His site is at http://jeremy.zawodny.com/. And I really recommend his book "High Performance MySQL". Sorry for the typo, Zawodny! RV Tec -- MySQL General Mailing List For li

Re: UTF-8 settings and woes (update)

2004-05-27 Thread robert kuzelj
hi mark, What happens if you explicitly specify the table character set to be 'utf-8'? (i.e. you're relying on the database default character set to take care of that for you right now)... 'CREATE TABLE foo CHARACTER SET utf8' the same. All I can say is that with the testcase I posted, it is shown

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread RV Tec
Eric, > I am sure all FreeBSD users are sick and tired of saying this. USE > 4.10 > Lots of people blindly follow version numbers but 5.x is a lot different > than 4.x in ways I don't yet feel comfortable with using on production > machines. Only one of those issues is with benchmark numbers

Re: Select

2004-05-27 Thread Egor Egorov
"MYSQL" <[EMAIL PROTECTED]> wrote: > Is it possible to write a SELECT statement that will select all columns but 1 or 2 > certain > ones? Nope. > > I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would > like to > be able to do somehting like SELECT * (NOT Col12,Col

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread Eric
Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on production machines. Only one of those issues is with benchmark numbers, but that i

Re: MySQL Benchmark.

2004-05-27 Thread RV Tec
JG, > I am a FreeBSD user, but after having run benchmarks for > the past 2 weeks, I think you'll be surprised when you see > the results from Linux. > > Linux will outperform *BSD by nearly double when it comes to > MySQL. That's what I expect and hope for. Although, I thought that FreeBSD wou

Select

2004-05-27 Thread MYSQL
Hi, Is it possible to write a SELECT statement that will select all columns but 1 or 2 certain ones? I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would like to be able to do somehting like SELECT * (NOT Col12,Col13), if that makes any sense. Thanks

Re: Textfile to table

2004-05-27 Thread Haplo
I will try that. Thanks. - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Haplo '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "'Paul '" <[EMAIL PROTECTED]> Sent: Thursday, May 27, 2004 1:28 PM Subject: RE: Textfile to table > How is the data delimited? You may be

RE: Textfile to table

2004-05-27 Thread Victor Pendleton
How is the data delimited? You may be able to use the LOAD DATA INFILE command. -Original Message- From: Haplo To: [EMAIL PROTECTED] Cc: Paul Sent: 5/27/04 12:23 PM Subject: Textfile to table Hi, I am trying to add this info into a table and I know there is a way to do it without using t

Re: MySQL Benchmark.

2004-05-27 Thread JG
Facing this new scenario, I am going to give Linux a shot -- definitively, this one is going to outperform OpenBSD. Using the same hardware, and the same options (as possible). Does anyone have a hint for this? Again, thanks a lot! Best regards, RV Tec I am a FreeBSD user, but after

Textfile to table

2004-05-27 Thread Haplo
Hi, I am trying to add this info into a table and I know there is a way to do it without using the insert command on every line of data. 201 200 NJ Jersey City INSERT INTO categories VALUES ('201', '200', 'NJ', 'Jersey City'); there are way too many lines to do by manual inserts. Any com

Re: UTF-8 settings and woes (update)

2004-05-27 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 robert kuzelj wrote: > hi mark, > >> If you specify UTF-8 as the characterEncoding connection property, then >> that is the transform that is used from client -> server. The transform >> that is used from server -> client is whatever character set the

Re: UTF-8 settings and woes (update)

2004-05-27 Thread robert kuzelj
hi mark, If you specify UTF-8 as the characterEncoding connection property, then that is the transform that is used from client -> server. The transform that is used from server -> client is whatever character set the column in the table is set to when you created the table (or conversely if you us

How to Enable Full Query Logging?

2004-05-27 Thread Robinson, Eric
Hi, I included the following statement in my.ini: log=c:\log.txt I then executed some queries. The file log.txt only shows the following: MySql, Version: 4.0.13-nt-log, started with: TCP Port: 3306, Named Pipe: MySQL Time Id CommandArgument 040527 9:31:57 1 C

Re: Looking for a C API if it exisits

2004-05-27 Thread Brian Reichert
On Tue, May 25, 2004 at 03:36:08PM -0600, Sarix wrote: > Cause when I do my web end to all this life > is easy cause I can do $name = $row['Name'] and it works for PHP so I > figured there has to be an API that would do that.. But I can't seem to find > it in the documention. Is there something tha

about mysql_query()

2004-05-27 Thread HSY
In C API, after running mysql_query(), I want to stop this query by mysql_kill(). But I can not get the specific process (query) ID. How could I solve this problem? mysql_list_processes() return a list of all processes (quries) running on the server. But it is possible that different user may runn

Libraries and header files/MySQL Devel RPM

2004-05-27 Thread Carlos Sunden
Hello Libraries and header files RPM download at http://dev.mysql.com/downloads/mysql/4.0.html is the mysql-devel package, right? Thanks! Carlos - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger

help reading test-select

2004-05-27 Thread rmck
Hi, I was running the test-select under the /usr/local/mysql/sql-bench dir and was wondering if someone could help break it down for me ( Or at least the "Testing big selects on the table" section ) Thanks : [EMAIL PROTECTED] sql-bench]# perl test-select --password='d'

MySQL Benchmark.

2004-05-27 Thread RV Tec
Folks, Following some advices, I have decided to give FreeBSD a shot. So, I got one test machine (P4 2.0GHz, 512MB), installed FreeBSD 5.2.1 on one disk, and OpenBSD 3.5 on the other (both 40GB 7200RPM IDE disks) -- so I could compare the results. MySQL (4.0.20) is compiled from source, u

Re: slow insert into select statement

2004-05-27 Thread SGreen
Something I have done in the past (with another DB system) was to put indexes on my temp tables. I have just gone over my copy of the MySQL docs and I don't see where that is NOT allowed so I think its fair game to try it. You have two options to do this: Create the temp tables then populate them

MySQL clustering support for Windows

2004-05-27 Thread Nandan Telang
I wished to use MySQL clustering for application development that is Windows-based. Since the binaries aren't available as yet, I tried using the source distribution (tried to build using cygwin) but it gave a number of errors. Is there any other way of installing MySQL 4.1 with Windows ( that ha

Re: Defaul of NOW()

2004-05-27 Thread Scott Plumlee
I didn't think you could have a DEFAULT of NOW() because it's not a true static value. Seems I read that in one of Paul DuBois' books. Jim Winstead wrote: On Wed, May 26, 2004 at 06:20:22PM -0700, Scott Haneda wrote: I have a field in mysql 4, using InnoDB Field is timestamp 14 and defualt is se

Re: Foreign Key Constraints

2004-05-27 Thread Martijn Tonies
Hi, > > Why not? What's wrong with this: > > > > BORROWER > > BorrowerID > > > > BOOKS > > BookID > > BorrowerID (nullable) > > > > FK from Books.BorrowerID to Borrower.BorrowerID > > > > I haven't checked, but this _should_ be possible. > > > > With regards, > > Its a foreign key, you can not nul

Re: Feature Request: UPDATE 'error codes' or mysql_affected_rows() to be more "accurate"

2004-05-27 Thread Steve Meyers
http://dev.mysql.com/doc/mysql/en/INSERT.html INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expr, ... ] If you specify the ON DUPLICATE

Re: Foreign Key Constraints

2004-05-27 Thread Jeff Smelser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote: > Why not? What's wrong with this: > > BORROWER > BorrowerID > > BOOKS > BookID > BorrowerID (nullable) > > FK from Books.BorrowerID to Borrower.BorrowerID > > I haven't checked, but this _should_

Re: Changing Password on Latest MySQL, etc

2004-05-27 Thread Carlos Sunden
Ok. So far I got advises to install the MySQL-client package & the mysql-devel RPM. Will do that & report back. I wouldn't think all that was needed when the MySQL-server-rpm was installed. The functionality to assign a password should be there. I'm such a newbie at this, thanks to all again! Ca

Re: Foreign Key Constraints

2004-05-27 Thread SGreen
You could create a special "borrower" account to signify that it is not loaned out and assign that to the book. If this is for a library system (multiple branches) you could create one account for each branch. That way you would know where the book is at all times, "borrowed" or not ;-) Shaw

RE: Defaul of NOW()

2004-05-27 Thread Victor Pendleton
Only constant values are allowed as default values. If this is the first timestamp column it will be updated on insert and with every update. -Original Message- From: Scott Haneda To: MySql Sent: 5/26/04 8:20 PM Subject: Defaul of NOW() I have a field in mysql 4, using InnoDB Field is tim

Re: Problems with "Order By" (phpMyAdmin)

2004-05-27 Thread Michael Kruckenberg
David Blomstrom wrote: I'm working on an add/edit form, illustrated by the screehnshot at http://www.geoworld.org/addedit2.gif I decided to arrange the rows by ID, rather than alphabetically. So I opened the table in phpMyAdmin, clicked Operations, then changed "Order by" from a field named SCode t

Re: FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist

2004-05-27 Thread Robert J Taylor
Did you change the permissions for the files to include read/write/change for the user/account MySQL uses on your system? This doesn't require deleting, as far as I recall Windows permissions... Oh, can you verify that the file host under directory mysql DOES exist? If so, it's really most like

FW: Could not start MySQL after reinstall - Can't open privilege tables: Table 'mysql.host' doesn't exist

2004-05-27 Thread MICHAEL_WU
Since the database I created was not critical, I could simply throw it away. Therefore, delete the whole MySql installation directory and unzip the alpha release zip file again to create the installation directory tree. However, the following error persists: Fatal error: Can't open privileg

Re: slow insert into select statement

2004-05-27 Thread nyem
Thanks for all the feedback. Here's my latest attempt: SELECT @start:=NOW(); SELECT @date1:=DATE_SUB( CURDATE(), INTERVAL 1 MONTH); SELECT @date2:=CURDATE(); LOCK TABLES rptPricingTEST READ, rptPricingTEST a READ; CREATE TEMPORARY TABLE tmpLatestDates SELECT commodity, MAX(PricingDt)

Re: BLOB's - General Guidance

2004-05-27 Thread Robert J Taylor
Joshua J. Kugler wrote: There is one instance in which it is *not* convenient to store in seperate files: when you are exporting to another machine (maybe a sub set of data from an internal server to an external web server) or doing replication. Very true. We use MySQL to store our blobs for

Problems with "Order By" (phpMyAdmin)

2004-05-27 Thread David Blomstrom
I'm working on an add/edit form, illustrated by the screehnshot at http://www.geoworld.org/addedit2.gif I decided to arrange the rows by ID, rather than alphabetically. So I opened the table in phpMyAdmin, clicked Operations, then changed "Order by" from a field named SCode to ID. When I clicked t

Re: error restoring and dumping

2004-05-27 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 27 May 2004 02:56 pm, Victoria Reznichenko wrote: > OPTION is a reserved word in MySQL: > http://dev.mysql.com/doc/mysql/en/Reserved_words.html > > Use backticks to quote column names: `option`. > > > -- > For technical support contra

Re: Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist

2004-05-27 Thread Robert J Taylor
Check permissions on the mysql\data directory and files/folders below for the MySQL process/user (sorry for not knowing the right Windows terminology, I'm not a Windows user). HTH, Robert J Taylor [EMAIL PROTECTED] michael_wu[§d§»¹F] wrote: Hello, I run into a problem after re-installing myS

Re: ERROR 2013

2004-05-27 Thread Egor Egorov
Mauricio Pellegrini <[EMAIL PROTECTED]> wrote: > I'm using MySql 4.0.18 on Linux (SuSE 8.2) > and I'm getting this error > > ERROR 2013: Lost connection to MySQL server during query > > a few seconds after launching > the following command > > LOAD DATA LOCAL INFILE '/root/hc.

Problems with "Order By" (phpMyAdmin)

2004-05-27 Thread David Blomstrom
I'm working on an add/edit form, illustrated by the screehnshot at http://www.geoworld.org/addedit2.gif I decided to arrange the rows by ID, rather than alphabetically. So I opened the table in phpMyAdmin, clicked Operations, then changed "Order by" from a field named SCode to ID. When I clicked t

Re: BLOB's - General Guidance

2004-05-27 Thread Joshua J. Kugler
There is one instance in which it is *not* convenient to store in seperate files: when you are exporting to another machine (maybe a sub set of data from an internal server to an external web server) or doing replication. j- k- On Wednesday 19 May 2004 01:01 pm, Greg Willits said someth

Re: Changing Password on Latest MySQL, etc

2004-05-27 Thread Victoria Reznichenko
Carlos Sunden <[EMAIL PROTECTED]> wrote: > > Installed the MySQL-server-4.0.20-0.i386.rpm on a RHL8 system > > Initialized the grant tables and then did: > /usr/bin/mysqladmin -u rt password ACTUALPASSWORD > And got: > -bash: /usr/bin/mysqladmin: No such file or directory > > What gives mates? >

Could not start MySQL after reinstall - Can't open privilege tabl es: Table 'mysql.host' doesn't exist

2004-05-27 Thread michael_wu[吳宏達]
Hello, I run into a problem after re-installing mySQL 4.1.1 today. When I tried to start the service on my Windows2K, I got the following error: 040527 15:37:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist Can some one tell me how to solve the pro

Re: Foreign Key Constraints

2004-05-27 Thread Martijn Tonies
Hi, > On Wednesday 26 May 2004 11:22 pm, [EMAIL PROTECTED] wrote: > > Hi, I am trying to use the foreign key constraints from InnoDB > > and creating indexes is a requirement for foreign key. > > The problem is that by creating index for my foreign key, > > it does not allow my foreign key to have

Re: error restoring and dumping

2004-05-27 Thread Victoria Reznichenko
Fajar Priyanto <[EMAIL PROTECTED]> wrote: > > Hi all, > I'm trying to move my Mambo (content management) database from one server into > another. > > In the old server, the mysql version is 4.0.13, while in the new one it's > 4.0.15. > > The error was when restoring: > ERROR 1064 at line 141: Yo

Re: Foreign Key Constraints

2004-05-27 Thread Robert J Taylor
[EMAIL PROTECTED] wrote: Hi, I am trying to use the foreign key constraints from InnoDB and creating indexes is a requirement for foreign key. The problem is that by creating index for my foreign key, it does not allow my foreign key to have null or blank values which my records will have. For eg.

Re: Optimization

2004-05-27 Thread Egor Egorov
"Abdul Aziz" <[EMAIL PROTECTED]> wrote: > > How can we optimize MySQL queries, plz define easy method > comparing as well as better performance for data retrieval. > The following chapter of the manual will be helful to you: http://dev.mysql.com/doc/mysql/en/Query_Speed.html -- For t

Re: Foreign Key Constraints

2004-05-27 Thread Colin Bull
[EMAIL PROTECTED] wrote: Hi, I am trying to use the foreign key constraints from InnoDB and creating indexes is a requirement for foreign key. The problem is that by creating index for my foreign key, it does not allow my foreign key to have null or blank values which my records will have. For eg.

Re: Optimization

2004-05-27 Thread daniel
try using explain > > > Hi All, > > How can we optimize MySQL queries, plz define easy method > comparing as well as better performance for data retrieval. > > Regards: > aaziz > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://l