Re: Question about slave server

2002-11-26 Thread Heikki Tuuri
Carl, - Original Message - From: Carl McNamee [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 11:10 PM Subject: Question about slave server sql,query In a replicated environment, are slave servers read only or can a user attach to one and

Re: Setting variables in XP

2002-11-26 Thread Heikki Tuuri
Peter, - Original Message - From: Peter Boivin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 11:25 PM Subject: Setting variables in XP I would like to put SET AUTOCOMMIT=0 in my.ini. When I put it under [mysqld], mysql will not start as a

RE: Question about slave server

2002-11-26 Thread Jennifer Goodie
If you don't care about the data being out of sync with the master and are not concerned with any problems it might cause, such as the slave thread stopping due to replication errors caused by out of sync auto_increment fields and the like. -Original Message- From: Heikki Tuuri

Left Join more than one table

2002-11-26 Thread vinita vigine Murugiah
HI I'm using ver 3:23:49 3:23:53, I thought A LEFT JOIN B USING (c) is Identical to A LEFT JOIN B ON A.c = B.c It seems it is NOT the case if you are joining more that ONE table one of them is EMPTY. Please see the following Example mysql select * from room;

mysqld-nt --local-infile=1 not working

2002-11-26 Thread Phuc Nguyen
Environment: MySQL = 3.23.53-max-nt Windows 2000 Pro SP3 Apache 2.0.43 PHP 4.3.0 dev Configure mysql startup as Manual in Windows 2000 Services. From command prompt, run E:\mysql\binmysqld-nt -local-infile=1 The mysqld server would run but still does not allow LOAD DATA LOCAL INFILE. Next run

Re: hello to new guy

2002-11-26 Thread Amer Neely
Hi, Ok, I guess I was confusing everyone. I thought this was a simple problem, we need a search engine to search through our data, I might be able to convert to csv, or I found another way... example... [ snip ] I think what Norm is trying to do (Norm correct me if I'm wrong) is search a

Re: MySQL/InnoDB-4.0.5 is released

2002-11-26 Thread Rebecca Bielecki
hi i have had a look for a download of this release (ie 4.0.5) and the latest release that i have been able to locate a download for is for 4.0.3. is there a url that anyone can direct me to to download 4.0.5 (or even 4.0.4) or are these commercial releases? thanks. - Original Message

Re: Lost root password.

2002-11-26 Thread Dr. Poo
I'm not sure if you've gotton your answer or not yet... (i have 150 more mailing list messages to go!) Try http://www.mysql.com/doc/en/Resetting_permissions.html On Monday 25 November 2002 06:05 pm, Jacek Mach wrote: Hello, I have made the mistake and now have no root access to mySQL.

Trying to install DBI

2002-11-26 Thread Scott Pippin
I get the following error when trying to do a 'make' after doing a perl Makefile.PL to DBI 1.1.8 cc -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -O -DVERSION=\1.18\ -DXS_VERSION=\1.18\ -I/usr/opt/perl5/lib/5.00503/aix/ CORE -DDBI_NO_THREADS Perl.c /bin/sh: cc:

Re: where to download v4.0.5 (was: MySQL/InnoDB-4.0.5 is released)

2002-11-26 Thread Benjamin Pflugmann
Hi. Please do not cross-post without a very good reason. Removed win32 list from CC. On Wed 2002-11-27 at 10:38:25 +1100, [EMAIL PROTECTED] wrote: hi i have had a look for a download of this release (ie 4.0.5) and the latest release that i have been able to locate a download for is for

RE: script

2002-11-26 Thread Adolfo Bello
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:51 AM To: Mysql maillist Subject: script Hi All. I have written a SQL script that should retrieve all the rows from a table that match a value given as parameter by the

Re: hello to new guy

2002-11-26 Thread Rodney Broom
From: Amer Neely [EMAIL PROTECTED] I think what Norm is trying to do... is search a DOS-based database using a script from Excite. The data has to be updated on the server, but in a format searchable by the script. Ohhh, that makes sence for his descriptions so far. Why not ask your ISP

Re: hello to new guy

2002-11-26 Thread Norm Lamoureux
Hi, You got part right, the database I use at home is Edibase for DOS, the program has been updated for Windows, too expensive for that and the web plug in ($5,000.00 I think) I am trying to port it over to a Windows Database. I downloaded the lastest version of MySQL the other day but it all

Re: hello to new guy

2002-11-26 Thread Rodney Broom
From: Norm Lamoureux [EMAIL PROTECTED] I downloaded the lastest version of MySQL the other day but it all looks greek to me, not like a database like ACCESS or Alpha Five. Now I'm with you! You're talking about a database being a program with a nifty front end for the users as well as a back

Building mysql w/ Intel's C++ compiler...

2002-11-26 Thread Chung Ha-nyung
Anyone have tried to build mysql with intel's c++ compiler? Does it build stable binaries and faster than the one built w/ gcc? query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com

Ïð½º

2002-11-26 Thread ºÂÑå¶ð
ÄãºÃ£º ÎÒ¹«Ë¾ÊÇÒÔ¾­ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾­ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢

Records missing from web query

2002-11-26 Thread Jim Esten
Situation.. main table in a relatively small database. Table contains approx 370K rows. Table is indexed on the unique identifier. New table, fresh import of clean data. Querying on a single field... run from the command line, returns 3 rows, run from phpMyAdmin, returns 3 rows. Identical query

YourSQL: a Mac OS X MySQL graphical client

2002-11-26 Thread Paul DuBois
Not sure if this has been mentioned here yet, but there's a graphical client named YourSQL available for Mac OS X. It runs native with an Aqua interface. Acts something like the DBTools and MySQLFront apps that run on Windows.

Re: Lost connection to MySQL server during query

2002-11-26 Thread Mark
- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 4:44 PM Subject: re: Lost connection to MySQL server during query Mark, Tuesday, November 26, 2002, 7:32:15 AM, you wrote: M Yes, again. :( Although reluctantly, I

=?unknown?q?=BFConoces?= verdaderamente el calostro bovinomysql@lists.mysql.com?

2002-11-26 Thread CALOSTRO
Saludos [EMAIL PROTECTED]! Intento informarte, mas no molestarte al invadir tu privacidad para presentarte algo que esta por encima de cualquier remedio o medicamento que conozcas. EL CALOSTRO BOVINO DE NUEVA ZELANDA. Puedes visualizarlo aqui http://www.hispa21.com/agente.asp?id=1310001 Te

re: re: Multi-Table Updates

2002-11-26 Thread ajitdixit
Hi , Result for Show Grants is as under SQL result Host: localhost SQL-query: SHOW GRANTS FOR aldixit@localhost; Grants for aldixit@localhost GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost' IDENTIFIED BY PASSWORD 'xx' GRANT SELECT ON `mysql`.* TO

Data base driven web page idea - need help!

2002-11-26 Thread Grant Cooper
I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of

Reg: Myisamchk

2002-11-26 Thread charitha
Hello all, In mysql tables if i want to exclude some tables to do myisamchk how can i do that. As if i use myisamchk *.MYI it is taking too much time to check all the tables. For that i can exclude some previous days dynamic tables and i can execute this How to do that??? Thanx in advance.

Re: sql password issue

2002-11-26 Thread John
I have been getting access denied and am stuck. How do i change the password for root in mysql? I am hosting on a third party site. The allow me to use phpmyadmin. Thanks --- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to

mysql load issue

2002-11-26 Thread Tim V
I have been trying to get mysql db to run but keep getting access denied. The error is: Warning: Access denied for user: 'mine@localhost' (Using password: YES) in /home/gulf/public_html/SiTeS_1/pUbS9_A/test/config.inc.php on line 106 Warning: MySQL Connection Failed: Access denied for user:

reg:time difference

2002-11-26 Thread Chandra
I need some help in finding the time/day difference as i want to know the session times is there a way/function to calculate time difference in mysql thanx heaps chandra __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

Re: sql password issue

2002-11-26 Thread A. Berger -- Onlynux
Hi John Do you email your provider? What did they say? Greetings Andres Berger -- Gerente de Marketing -- OnLynux Aloja tu Web $14.99 Anual -- www.onlynux.com/hosting -

<    1   2