I have an incorrect key file which mySQL politely suggests I should
repair. However, when I call isamchk I always get the message
isamchk: error: 22 when opening ISAM-table ''
on this particular computer (RedHat 7.1 with mySQL 3.23.33), no
matter which db I try to inspect or repair.
If I mov
Kenneth E. Lemons writes:
> a
> $queryInsert = "INSERT INTO studentInfo (lName, fName, misc)
> VALUES ('$lName', '$fName', '$misc')";
Since $misc is an array, this will give you a warning and you'll
get the string 'Array' in the quer
On Mon, 3 Sep 2001, Chris Cameron wrote:
> I'm sure this is disscused somewhere, but I'm not sure how I'd look for
> it.
>
> Is it possible to supply a thesaurus-like file for mysql so when you
> go "%oil%" it finds petrol gas and/or lubricant?
As far as I know, there is no way to do that native
Dear all.
about to load sharing DB server,
I'd like to use facility which automatically part and execute requests from client ,
such as : update -> Master?load ->Slave.
previously,
Client > Master --- Slave
^ update|--- Slave
|
Hello,
I have a problem with the Datagrid in visual basic 6 (sp5) where the
data in the date column asspeas as nothing if it is a date or if it
isnt a date.
I believe that its a problem with the conflicting data types, i was
wondering if its possible to get MySQL to convert a type (such as
I'm sure this is disscused somewhere, but I'm not sure how I'd look for
it.
Is it possible to supply a thesaurus-like file for mysql so when you
go "%oil%" it finds petrol gas and/or lubricant?
Does anyone know of a database that will do this?
Thanks,
Chris
---
I have installed mysql on a windows 98 machine and I want to be able to connect to
that server from another computer on my network. The other computer is a windows 2000
professional edition. Since I am new at this, I'd like to know if this is even
possible, and if so, any documentation detaling
>Description:
This busy mysql server will run well for about one week,
with 95% idle cpu. Then at some point it will get "stuck," so
that it is still very responsive, but cpu utilization changes
to 95% system cpu and 0% idle cpu.
When the server is in this condition and I use the ktr
Great thanks, I'll check it out.
Dave
On Mon, Sep 03, 2001 at 01:49:31PM -0700, Steve Edberg wrote:
> At 1:10 PM -0700 9/3/01, David Turner wrote:
> >A friend of mine mentioned something about perl stored procedures for
> >MYSQL. Has anyone heard about this? I have searched everywhere and only
>
--
After:
www-pws5: {18} % ./configure --prefix=/usr/local/WWW/www.jma.org/mysql --with-
mysqld-user=mysql --with-thread-safe-client --enable-assembler
and then 'make'
i got this long list of stuff, funished by errors:
[]
Making all in client
g++ -DUNDEF_THREADS_HACK -I./../i
On Mon, Sep 03, 2001 at 04:06:04PM -0700, Atle Veka wrote:
>
> We probably have about 50-60 dedicated mysql servers all running
> FreeBSD 3.2/4.[0-3]
FreeBSD 3.x and 4.{0,1,2} aren't the most stable platform for a
heavy-use MySQL server. 4.3 is the first version that appears to have
fixed the t
Hi, All.
Some body nows how I can get a SQL/92 and 99 information.
TIA
Mario Espinoza Ll.
Consultores STI, S.C.
[EMAIL PROTECTED]
Av. Guadalupe # 618, Col. Chapalita
Guadalajara, Jal.
México.
+52 3122-9004 Ext. 213
=
Steps I took to create a database connection (which does not work yet):
I downloaded the driver for mySQL & put it in my system DSN.
Then I went to Frontpage 2002's Tools, Web Settings, Database. I selected
'Network Connection to DB Server'. I selected mySQL driver, input my
server ip address &
Hi !!
)-Original Message-
)From: [EMAIL PROTECTED]
)[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey
)Sent: Saturday, September 01, 2001 8:13 AM
)To: [EMAIL PROTECTED]
)Subject: Re: MyODBC between MySQL-Server (Linux) and Linux-Client
)
)
)>
)> root@workstation3:/home/manuel > isql -v
At 10:59 PM +0200 9/3/01, Chris Hayes wrote:
>dear people,
>our ISP asks us to install MySQL ourselves on our own domain.
>This means i need to install it on
> /usr/local/WWW/www.domain.org/mysql
>(on FreeBSD 4.0.1) as a non-root user, using the usual username and password.
>
>If this is possible
Hi All--
We have a really busy mysql 3.23 server utilizing replication which dies
on a daily basis. The mysqld process itself doesn't die, but we have
monitoring tools that notifies us saying "Can't connect to mysql [..]
(60)" (60 = Operation timed out). The largest table has over 16 million
ro
Dear [EMAIL PROTECTED] ,
You can earn $46,000 or more in next the 90 days sending e-mail.
Seem impossible? Read on for details (no, there is no "catch")...
"AS SEEN ON NATIONAL T.V."
Thank you for your time and Interest.
This is the lett
Stephan,
REPLACE is logically handled as a DELETE + INSERT, but
internally it is often handled as an UPDATE. Probably
REPLACE is faster than UPDATE / INSERT, because you
save some communications overhead between the client
and the server.
Regards,
Heikki
>On Mon, Aug 20, 2001 at 11:00:59AM +02
http://www.mysql.com Fourth link on your right: MySQL++
j- k-
On Monday 03 September 2001 13:35, Neil Tompkins wrote:
> Hello,
>
> I'm looking to develop a Windows based application to work with mySQL. Is
> there any mySQL components available for mySQL or should I just use the
> stand
Hello,
I'm looking to develop a Windows based application to work with mySQL. Is
there any mySQL components available for mySQL or should I just use the
standard components with C++ Buider 5.
Thanks
Neil
-
Before posting, ple
So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 :
> How many types of triggers MySQL have? And what about stored procedures?
none and (close to) none.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects
I have a checkbox group in an HTML form that I want to use to
populate a MySQL set. The data seems to come into the php
array correctly, because when I do a test print loop the proper
values are displayed, but the data from $misc is not present
for the record in the MySQL database. How do I
dear people,
our ISP asks us to install MySQL ourselves on our own domain.
This means i need to install it on
/usr/local/WWW/www.domain.org/mysql
(on FreeBSD 4.0.1) as a non-root user, using the usual username and password.
If this is possible, which i assume it must be, WHERE can i find infor
At 1:10 PM -0700 9/3/01, David Turner wrote:
>A friend of mine mentioned something about perl stored procedures for
>MYSQL. Has anyone heard about this? I have searched everywhere and only
>seen posts related to POSTGRESQL. If they have this for MYSQL it would
>be really helpful.
That would be My
From: Philip Mak <[EMAIL PROTECTED]>
> Is there a good way that I can store an array in a single row using MySQL?
You can simply delimit the data some how. Perhaps with a pipe (|).
> I was taught that under a clean relational database design, arrays should
> be stored one element per row.
Go
FYI
-christian-
> Date: Sat, 25 Aug 2001 21:46:03 -0700
> From: Randolph Chung <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Reply-To: Randolph Chung <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> Package: myodbc2.50.37
> Version: 2.50.37-3
> Severity: important
>
> See attached build log. Look
Is there a good way that I can store an array in a single row using MySQL?
I was taught that under a clean relational database design, arrays should
be stored one element per row. However, this makes retrieving the entire
array less practical, especially when I have an array of arrays.
I've thou
From: Mike Yuen <[EMAIL PROTECTED]>
> The query I have is: select max(mid) from mboard;
> BUT I tried the following in PHP and it doesn't work:
>
> $myquery = "SELECT max(mid) FROM mboard";
> $myresult = mysql_query($myquery);
> $row = mysql_fetch_object($myresult);
> print "$row->mid is result
I have a table as such where mid is my auto increment primary key:
TABLE: mboard
mid
2
3
4
5
I'm doing this in combination with PHP4.
What I want to do is build a query that will allow me to get the largest mid
from the table (mboard) above.
The query I have is: select max(mid) from mboard;
BUT
Michael Rounds writes:
> The problem is, I am trying to setup phpmyadmin, which, when accessed,
> is unable to connect and gives a error of "MySQL said: Access denied for
> user: 'root@localhost' (Using password: NO)"
Have you configured phpmyadmin? I recommend using the 'advanced'
authentica
A friend of mine mentioned something about perl stored procedures for
MYSQL. Has anyone heard about this? I have searched everywhere and only
seen posts related to POSTGRESQL. If they have this for MYSQL it would
be really helpful.
Thanks, Dave
On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zaw
The problem occurs in the function my_strdup() in an repnz scans ... stuff.If you
give a input of more than 82 characters to mysql client as the database name the
client will overflow. This is not a big problem since it isn't setuid.
hmm... mysql -u user -phmm `perl -e 'print Ax100'`
Greetings,
I am pretty new to MySQL, and am trying to set it up on a Linux box.
(RedHat)
I am having a problem with logging into databases. I have a root
password setup, and am able to access the database "mysql" with the
command "mysql mysql -p"
The problem is, I am trying to setup phpmyadm
On 03-Sep-2001 Chris Thorpe wrote:
> I am (desperately) trying to update a field in table A with the result of a
> query on table B, as an example :
>
> REPLACE INTO TableA (Value) SELECT COUNT(data1) FROM TableB WHERE data1
> BETWEEN 2 AND 4
>
> I need to modify this so that the result is stor
I am (desperately) trying to update a field in table A with the result of a
query on table B, as an example :
REPLACE INTO TableA (Value) SELECT COUNT(data1) FROM TableB WHERE data1
BETWEEN 2 AND 4
I need to modify this so that the result is stored (for example) where
TableA.id=1, but at the mom
On Mon, Sep 03, 2001 at 06:18:34PM +, ahmed wrote:
> please can you give me a cooorect programme source using C APIs
> mysql to acces mysql database
http://www.dataloss.nl/software/dteq/ is such a thing.
Greetz, Peter
--
Monopolyhttp://www.dataloss.nl/monopoly.html
---
please can you give me a cooorect programme source using C APIs
mysql to acces mysql database
ahmed
Portail mobile DIALY! visitez www.dialy.net
DIALY! mobile portal visit www.dialy.net
--
Hello.
On Wed, Aug 29, 2001 at 12:01:07PM +0200, [EMAIL PROTECTED] wrote:
>
> Sorry to repost my question but I did not get any answer.
20 hours is hardly a period of time after which you should assume your
message has slipped through. Please avoid early reposting. The list
already gets a lot o
After doing that, I try to connect via DSN via ASP but I get this error::
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Can't connect to MySQL server on "24.254.141.32"(10061)
If someone can help, please do.
- Deryck H
- http://www.comp-u-exchange.com
--
At 12:25 03/09/2001 -0500, Deryck Henson wrote:
Hi!
>I get this every time I try to start up MySQLD.exe::
>
>Can't initialize InnoDB as 'innodb_data_file_path' is not set
>
This message is from InnoDB table. If you don't want the InnoDB
table, create the /windir/my.ini with the section and key be
an apostrophe
>Description: If I try to INSERT data containing an apostrophe into a
Field defined as mediumtext it works ok. However, if I try to insert the
same data into a Field defined as varchar, the INSERT fails. And, it not
only doesn't work...it does nothing at all...no error message of a
I get this every time I try to start up MySQLD.exe::
Can't initialize InnoDB as 'innodb_data_file_path' is not set
Someone help. Thnx!
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://
I get this every time I try to start up MySQLD.exe::
Can't initialize InnoDB as 'innodb_data_file_path' is
not set
Someone help. Thnx!
- Deryck H
- http://www.comp-u-exchange.com
=
I love the Screen Savers
__
Do You Yahoo!?
Get email ale
I have an incorrect key file with mySQL politely suggesting I should
repair it. However, when I call isamchk I always get the message
isamchk: error: 22 when opening ISAM-table ''
on this particular computer (RedHat 7.1), no matter which db I try to
inspect or repair. If I move the db files
Thanks for clearing that up with me...didn't know that.
--Tony
On 3 Sep 2001, Trond Eivind Glomsrød wrote:
> Tony Bibbs <[EMAIL PROTECTED]> writes:
>
> > 7.1 doesn't install php with mysql support enabled.
>
> Yes, we did.
>
> > FYI, redhat is doing this because postgres is no their prefered
>
Jeremy Zawodny wrote:
>
> On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote:
> > I have a slave server and a master server both running 3.23.38.
> >
> > Every once in a while the slave stops updating:
> >
> > | db1.tias.com | slave | 3306| 60|
> > spode-bin.0
Hi Sinisa,
Sinisa Milivojevic wrote:
> As an example, mysql server is a multi-threaded program and when
> compile --with-debug it uses DBUG function.
I know. As I said, one of my main problems is that MyODBC does not have
a --without-debug option.
>
> There are literally thousands and thousan
yes but not advisable. Check the archives for more info.
Cal
http://www.calevans.com
-Original Message-
From: Neil Davies [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 03, 2001 10:28 AM
To: [EMAIL PROTECTED]
Subject: images
I was wondering if it's possible to place image files
> From: Neil Davies [mailto:[EMAIL PROTECTED]]
>
> I was wondering if it's possible to place image files within mysql
> tables?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_15_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
I'm not sure if this will help, but have you considered ext3, or any of
those experimental file systems (although I believe they are pretty darn
stable, I know several places that use ext3). I haven't read much of the
specs on ext3, but by chance it might support huge directories like that.
Tony Bibbs <[EMAIL PROTECTED]> writes:
> 7.1 doesn't install php with mysql support enabled.
Yes, we did.
> FYI, redhat is doing this because postgres is no their prefered
> DBMS. Can't understand why they don't just compile support for both
> in.
We do compile in support for MySQL, but it's
Kalpesh Modha <[EMAIL PROTECTED]> writes:
> Does mysql work on rehat 7.1.
>
> I have installed it but can not get PHP, JAVA to access the
> database. I just get connection refused.
You need to install the php-mysql package, which contains the module
PHP needs to support MySQL.
--
Trond Eivi
I was wondering if it's possible to place image files within mysql
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Damned, I forgot to change the To: address again.
Sorry 'bout that.
BTW, does anyone else get lots of error messages from
[EMAIL PROTECTED]?
Oliver Krapp - etracker.de e.K. writes:
> I'm dealing with a large (think so) production mysql server. There are up to
> ~2500 small databases (each ~1-
Peter Duffy writes:
>
> Versions:
>
> Linux: Redhat 6.2, kernel 2.2.16-3 (using Terje Malmedal's coredump
> patch from http://www.movement.uklinux.net - there are a number of
> patches addressing the threaded coredump issue, but this one was
> specific for my kernel and it sure as hell did the b
> Is there a way to specify a starting value for an auto increment
> column?
Take a look at the CREATE TABLE syntax.
Peter
--
+---
| Data Architect
| your data; how you want it
| http://www.codebydesign.com
+---
-
You could make the table, then insert a row with the 1000 as the id, and
delete it after you get some other rows in there.
rather messy, but it works.
James
-
On Mon, 3 Sep 2001 09:14:46 -0500, Neil wrote:
-
> Hello:
>
> Is there a way to specif
Hello:
Is there a way to specify a starting value for an auto increment
column?
I tried this:
id INTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT
But, that did not work.
Thanks,
Neil.
--
Neil Aggarwal
JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com
C
Hello MySql,
I'm dealing with a large (think so) production mysql server. There are up to
~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is
growing and the CPU gets more and more loaded. A new behaviour is that
apache get sometimes out of clients, caused by bad response times
Hi,
I am using the INTO OUTFILE 'filename' function, to create .CSV output files
from my queries.
Whenever I do this, the table headings are removed from the output. Is
there a way to get the table headings displayed in the output file?
Andrew
-
I realise that this issue is very specialised, and I'm not sure which
mailing list would be best to host a thread based on it, so I'm posting
it here to start with: I'm happy to move it to another mysql list if
someone would like to suggest one.
Over the last year, I've been working on a multi-th
I'm trying to avoid the "Access Denied" messages when using "SELECT * FROM "
when only a subset of fields are accessible. What I'm looking for is a transparent
check of the permissions, replacing "*" with a list of fields for the associated
table. Alternatively, at the layer below "SHOW COLUMNS
[EMAIL PROTECTED] writes:
[SNIP]
Isn't it annoying when it refuses to send your mails to the list
and then lets through a ton of spam? Mysql mysql mysql. There. :-E
> Carl Schrader writes:
>
> > select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
> > '%TOMMY%' OR Notes LIKE '%TO
Sure it does, what version, what error?
brett
Kalpesh Modha wrote:
> Does mysql work on rehat 7.1.
>
> I have installed it but can not get PHP, JAVA to access the database. I just get
>connection refused.
>
> ANy ideas
>
> thanks in advance.
>
>
>
On Thu, Aug 16, 2001 at 08:56:33PM -0700, Lists Servers Email wrote:
>
> Does any know how to fix this database replication problem.
>
> Last Lines from Err File
>
> 010815 21:38:55 Slave thread exiting, replication stopped in log
> 'salem-bin.013' at position 6867
>
> 010815 21:38:55 Err
On Mon, Sep 03, 2001 at 12:50:39PM +0200, Stephan wrote:
>
> >> My problem with the REPLACE is that the documentation says that a
> >> REPLACE always does an DELETE and then an INSERT. In my case a lot
> >> of rows (99%) would be deleted in the index that only need an
> >> update. Is it a good
Paul Mallach writes:
> But I simply can't find a (good) query without using a subselect. The problem
> is that I have to check, wheter the live_from value ist the maximum for all
> the versions of this content-piece.
Since what you want to put in a subselect will return a
single value you cou
Hi Mysql,
E-Mail vom Montag, 3. September 2001, 12:14:42:
Hi Jeremy,
E-Mail vom Montag, 3. September 2001, 11:52:55:
>> My problem with the REPLACE is that the documentation says that a
>> REPLACE always does an DELETE and then an INSERT. In my case a lot
>> of rows (99%) would be deleted in
Hi!
> "mmokrejs" == mmokrejs writes:
mysql> update rep set low='nan' where id=148;
mmokrejs> Query OK, 1 row affected (0.07 sec)
mmokrejs> Rows matched: 1 Changed: 1 Warnings: 1
The above will just set '0' in the 'low' column.
(The string 'nan' converted to a number is 0)
You can ver
On Fri, Aug 31, 2001 at 10:10:52PM -0700, Jeff Dickison wrote:
> I am trying to get mysql-3.23.41 to compile under Solaris 2.6
> sparc with gcc 2.95.2 and have been running into some problems. Currently
> I am using this as my comfigure :
>
> ./configure --prefix=/usr/local/mysql \
> --w
Hi.
I'm thinking about a possible database schema for
a content management system that is supposed to use
MySQL as a backend. The system stores multiple
versions for each piece of content.
Content is referenced by a content-id (cid), each version
gets a version-id (vid). Each version has some m
On Wed, Aug 29, 2001 at 12:18:02PM -0400, Michael Eklund wrote:
>
> Am I the only one that thinks that mysql ought to replicate NOW,
> CURRENT_DATE, etc. as the time when those actual inserts happened
> not as NOW,CURRENT_DATE,etc.
Probably not.
> If you are replicating accross a distance (12,15
On Mon, Sep 03, 2001 at 10:44:57AM +0800, tpchan wrote:
> Dear all,
>
> I managed to set up 1-way master-slave replication using MySQL version
> 3.23.33. The replication process run fine.
>
> However I found out that the master-bin.001 sited on master server
> log file is growing every day. My q
On Fri, Aug 31, 2001 at 11:53:04AM +0200, Warren van der Merwe wrote:
>
> I have a triangluar replication system working 100%, A -- > B, B -- > C,
> C -- > A.
>
> What I know want to know is, is replication intelligent enough that
> if A had to sometimes connect to C, and replicate, and then the
On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote:
> I have a slave server and a master server both running 3.23.38.
>
> Every once in a while the slave stops updating:
>
> | db1.tias.com | slave | 3306| 60|
> spode-bin.005 | 912992502 | No|
Chris Andrew writes:
> I would like to replace the hardcoded integer value 1234567,
> with a "calculated" SUM figure.
>
> SELECT SrcIp,
> SUM(Packets),
> SUM(Packets)/1234567*100 AS Percentage
> FROM tblIp
> GROUP BY SrcIp;
Either divide it into two queries and use the result
of t
On Mon, Aug 20, 2001 at 11:00:59AM +0200, Stephan wrote:
> Hi all,
>
> my situation:
>
> I generate 300 rows at a time - they should be stored in the a mysql
> table.
>
> 99 % of the keys of these rows already exist in the table, so these
> rows need an update. The remaining 1 % have to be ins
Ofcourse you can use with access2000.
Create a text file by using export option in access2000.
Then use LOAD DATA in Mysql.
Ajay K. Ratra
[EMAIL PROTECTED]
"Neil Davies"
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Jari Aalto writes:
>>
>> I'm using
>>
>> Ver 3.23.41-max-debug for Win95/Win98 on i32
>>
>> And command
>>
>> mysqld-nt --install
>>
>> Displays error dialog box
>>
>> "Failed to install service"
>>
>> In Event
Hello helpful list!
For one of our customers we have to store russian and german text in a
database. Is is somehow possible to do this with one server instance or do I
have to split the data to be stored in two databases on two server
instances?
Thanks you very much,
Goeran Zaengerlein
---
Sehr geehrte Damen und Herren,
Zur Information für Lehrer der Sozialkunde, Religion, Geographie usw.: ein neuer
Documentarfilm über die Philippinen "Good Morning, Sir!" der beispielhaft auch für die
Lage in anderen Entwicklungsländern steht. Detaillierte Informationen auf der Webseite
http://
On Tue, Aug 28, 2001 at 11:39:54AM -0700, Sheena Sidhu wrote:
>
> I had 2 questions related to using BDB and mysql. I don't see any
> startup options for BDB, so can I safely assume that there are'nt
> any , so don't need a my.cnf file?
There are several. Look in the docs here:
http://www.mys
Thanks to everyone who replied - much appreciated.
Ok here is how it went :
1 Creating index first and loading table :saved 1 minute overall
2 Increasing key_buffer -> 100M :no difference
3 increasing myisam_max_sort_file_size-> 1000M and
myisam_sort_buffer_size->10
Hi,
How can I construct a query that would give me a percentage,
eg - I would like to replace the hardcoded integer value 1234567,
with a "calculated" SUM figure. The integer 1234567 is the SUM of
all the Packets in the whole table.
SELECT SrcIp,
SUM(Packets),
SUM(Packets)/12345
Anybody know how to startup mysql that come with Slackware 8.0.0
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hi
Actually, MySQL is new to me. But I am familiar with SQL Server. Can anyone
tell me the difference?
It seems to me that they support different interfaces?
Regards
-
Before posting, please check:
http://www.mysql.com/manua
I have a very large database which was made using Access2000.
Because of the difficulty Access has in manipulating the database
due to its scale I want to move the database to MySQL. However,
because of the size of the database I don't want to spend hours
doing it by hand so I want to use LOAD
On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote:
> Dear All,
>
> I have a question:
>
> How can build multi-master-host?
>
> I have 3 mysql hosts,I want to use mysql data replicate. thanks!
And you want all 3 to be masters?
If so, you need to configure them in a repl
Kalpesh Modha writes:
> I have installed it but can not get PHP, JAVA to access the database. I just get
>connection refused.
Are you trying to connect via TCP to a server started with
--skip-networking? Are you connecting to the right port?
Does it work when you use unix sockets instead of T
you using 7.0 or 7.1. If 7.0 try grabbing the rpms from the 7.1 image and
see if that works.
--Tony
On Sun, 2 Sep 2001, Mike wrote:
> Using RH 7 after a Plain setup I tried to install the rpm's version 37
> through 39 with the same error. Not a valid RPM. I tried both Gnome RPM
> and the comman
7.1 doesn't install php with mysql support enabled. You'll need to
install the source rpm, edit the php.spec file and do a rpm -bb php.spec
and install the resulting rpms.
FYI, redhat is doing this because postgres is no their prefered DBMS.
Can't understand why they don't just compile support f
On Sat, Sep 01, 2001 at 11:42:52AM -0400, Jocelyn Bernier wrote:
> Hi everybody,
>
> I am currently looking the transactional part of MySQL and I'm
> wandering which one is best to use in regard to efficiency and
> reliability. Which one is the most stable, etc?
While I have some of experien
On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote:
>
> How many types of triggers MySQL have? And what about stored procedures?
Zero and Zero, as explained in the docs.
If you need them today, I'd suggest looking at PostgreSQL. If you're
patient, they'll likely appear in MySQL someday-
On Fri, Aug 31, 2001 at 03:36:14PM -0700, Jeff Leung wrote:
[snip]
> Also, will ALTER TABLE table TYPE=MYISAM create a new temporary
> table to work with and then essentially insert all the rows into the
> new copy before removing the old table?
It will.
> (I am well past 50% capacity on the m
Does mysql work on rehat 7.1.
I have installed it but can not get PHP, JAVA to access the database. I just get
connection refused.
ANy ideas
thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
>> And should say that
>>
>> update rep set low='0.00' where id=148;
>>
>> solved my problem for command:
>> mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended
How many types of triggers MySQL have? And what about stored procedures?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
i can reproduce it on 3.23.32
create table test (id int(13),low float(10,2) )
insert into test values (1,1)
insert into test values (1,'nan')
id low
1 1.00
1 nan
doh..
-
Before posting, please check:
http://w
How many types of triggers MySQL have? And what about stored procedures?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Hi,
have met a following problem, I have on my Win32 work machine the Abria
softs merlin server package but the MySQL part of it keeps failing. You do
not have to do a thing and it fails, does not give out data anymore. I have
to close both Mysql and Apache for it to work again for a few momen
1 - 100 of 109 matches
Mail list logo