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
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
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
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;
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
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
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
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.
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:
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
-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
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
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
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
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
ÄãºÃ£º
ÎÒ¹«Ë¾ÊÇÒÔ¾ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢
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
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.
- 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
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
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
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
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.
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
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:
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.
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
-
101 - 127 of 127 matches
Mail list logo