>It sound like you are using a version of MySQL that had a replication
>bug in it. I suspect that if you upgrade to 3.23.33 the problem will
>go away.
>
>Jeremy
No, Master is 3.23.33, and slave is 3.23.32
The manual says "Shutting down the slave(cleanly) is also safe,
as it kee
At this point, there's only 1 row in companies, and 8 in contacts.
table typepossible_keys key key_len ref rowsExtra
companies system PRIMARY,comp_id 1 Using filesort
contactsALL cont_comp_id_idx
On Sat, Feb 24, 2001 at 11:33:40PM -0500, Mark Chalkley wrote:
>
> I have a question about index usage. I've got a query that's
> showing up in the -slow log (it's taking less than long_query_time
> seconds, but I've got --log-long-format set), indicating that it's
> not using an index, and I don
I just installed the new version of MySQL on my Redhat Linux 7.0 box and
when I try to connect with a web browser I get:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111)...
Error
When I log in as root in Linux, I can execute c
On Sun, Feb 25, 2001 at 01:58:39AM +, Peter Skipworth wrote:
>
> Sorry for going slightly off-topic...I realise this is more a Perl
> question , but suspect someone here might know the answer.
>
> I'm halfway through writing a module (it's at alpha stage) to cache
> mysql/DBI query results, e
i'm newbie.
how come i can create but cannot drop? (errno: 21)
i am root.
mysqladmin asks if i am sure... i say 'yes' and i get the same (can't
rmdir. errno: 21)
TIA
-
Before posting, please check:
http://www.mysql.com
I have a question about index usage. I've got a query that's showing up in the -slow
log (it's taking less than long_query_time seconds, but I've got --log-long-format
set), indicating that it's not using an index, and I don't understand why.
Given two tables:
CREATE TABLE c1 (id INT(8) NOT N
On Sun, Feb 25, 2001 at 09:49:43AM +0900, ÇãÁ¤¼ö wrote:
>
> If slave went down, while master worked and some update made on
> master. after slave restart, slave could not get update information
> and slave's data unchanged.
It sound like you are using a version of MySQL that had a replication
bu
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote:
>
> I'm trying to understand MySQL indexing but am having trouble
> understanding the differnences (and when to use each) between
> Primary Key, Key, Unique, an Index. Can you help?
Index and Key are the same.
A Primary Key is a U
Marcus Ouimet wrote:
> One quick question, I am trying just replace part of the entry ie:
> change:
> /image/covers/009.jpg
> to
> image/covers/09.jpg
>
> I have tried to update products set 'image/covers' where
> products_image like '/images/covers%'; but it seems to replace the whole
> field
On Fri, Feb 23, 2001 at 03:05:19PM -0500, Sander, Ryan wrote:
> I doing a newspaper site. My database has a different table for each
> category (local, sports, etc). All of the columns are the same for each
> table (Headline, byline, body, etc). Is there any way to search all of the
> tables at
Many thanks. Problem is cured
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
To: "Cory Whitesell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 4:26 PM
Subject: Re: Stumped
> > This should be very simple, but for some reason, my
One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set products_image='image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not leave the trai
I doing a newspaper site. My database has a different table for each
category (local, sports, etc). All of the columns are the same for each
table (Headline, byline, body, etc). Is there any way to search all of the
tables at once (since they all have the same columns)?
To further illustrate.
Sorry for going slightly off-topic...I realise this is more a Perl
question , but suspect someone here might know the answer.
I'm halfway through writing a module (it's at alpha stage) to cache
mysql/DBI query results, either within RAM using shared memory or to disk
using Storable. Testing alrea
Hi...
If slave went down, while master worked and some update made on master.
after slave restart, slave could not get update information and
slave's data unchanged.
What Can I do for
this situation?
Thank you for advanced
answer!
---
M
First let me explain what I am trying to do. I want to archive many many
messages into a mysql database. The format is pretty simple... either the
message is a parent, or it is a reply. The problem is that some of the
queries are taking 5-10 seconds, which is not acceptable for my application.
The
I posted this problem before and heard nothing, but this time I
compiled mysqld to debug and have posted some of the debugging output.
The following worked fine under 3.23.8. It fails miserably
under 3.23.32 - also 3.23.33 but I used 3.23.32 for the output
below. It seems that mysqlimport reads
> This should be very simple, but for some reason, my query does not return the
>desired results
> I have the following two tables:
>
> CREATE TABLE Rank (
> Rank CHAR(40) NOT NULL PRIMARY KEY,
> ReportsTo CHAR(40) NULL
> );
>
> CREATE TABLE ROSTER (
> EntryNumber INTEGER NOT NULL AUTO_
Seperate out your query string into a variable and do it like this:
$query = "select a,b,c,d from table sometable "
. " where something=somevalue and "
. " otherstuff = 'bbb' ";
if (!$results=mysql_query($query)) die (mysql_error());
- Original Message -
From: "WCBaker" <[EMAIL
Hi All!
I have a need to make a LONG insert command. Does anyone have an example
of something like this:
$result1=MYSQL_QUERY("INSERT INTO test(dataA,dataB) VALUES
('$dataA','$dataB')");
but SPREAD over more than one line?I can't seem to get the quotes and
backslashes right for some unknow
This should be very simple, but for some reason, my query does not return the desired
results
I have the following two tables:
CREATE TABLE Rank (
Rank CHAR(40) NOT NULL PRIMARY KEY,
ReportsTo CHAR(40) NULL
);
CREATE TABLE ROSTER (
EntryNumber INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
Hi everyone,
I've got a problem with my MySQL-Database that I've been dealing with
for nearly two weeks now and I don't seem to get a clue of what it's
about. My webspace-provider (Schlund & Partner in Germany:
http://www.schlund.de) doesn't have a solution either, nor have some of
my expert-frien
Hi!
Does the skip_counter bug is fixed or how to fix it ?
Thanks
Jimmy
Visitez mon site web:
http://www.llimzsoft.com/
__
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur,
Hello list
I've just installed mysql-3.23.33 with db-3.2.9a (linux on a ppc) and
still have dog slow bdb tables with data errors.
How fast are bdb tables really, for those where they work? Doing 3
queries/sec is not a real option for me.
Note that I had to change the makefile in db-3.2.9a/build
Is there mysql 's BDB table version download for
Windows 95 - NT ?
-
Regards
Yusuf Incekara
Avukatpro Limites Sirketi
http://www.avukatpro.com
for Mysql & Visual Basic Samples
http://www.avukatpro.com/mysql.html
---
Hi folks,
after having carefully tuned all statements within a larger web based
application rewriting SQL statements and optimizing them by adding indices,
there are still two statements left, which are awkward concerning
performance. Maybe I am just too blind to see how to get them working
fast
Dear Mysql,
After unpacking Mysql mysql-3.23.33.tar on solaris x86 with gcc 2.95. i run configure
with
CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" CXX=gcc CXXFLAGS="-O6
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DHAVE_CURSES_H"
./configure --prefix=/us
Did you set up the database with the scripts/mysql_install_db command?
Brady...
Original Message Follows
From: David Richards <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: MySql Install problems
Date: Sat, 24 Feb 2001 01:59:56 -0500
>Description
I have installed MySql version
Get the New Riders MySQL book. It is a very good tutorial and reference on
MySQL. You should also look at the online documentation.
The setup and configuration of MySQL is very simple. In addition, my
preliminary test show that it is very fast. I have almost 500,000 records
stored and loo
Hi, I have Downloaded Binary distribution and when I runned
/usr/local/mysql/configure it told me that I did not needed to do that, that
is a binary distribution and that it was going to start the mysqld for me
along with some initialization tables or data from
/usr/local/mysql/data. But when I t
Danie Weideman schrieb:
>
> I played around with fread PHP function but with no-luck
how about fopen(),
or
$fp=fsockopen( "$host", 80,);
$anfrage="GET $seite HTTP/1.0\r\n");
etc.
IrmundThum
-
Before posting, please check:
Karl Stubsjoen schrieb:
>
> Hello,
> I need some help. Does anyone see what I'm doing wrong here:
>
> create table MeetScores (
> MeetScoresId default 100 not null auto_increment,
> Thanks!
test:
create table MeetScores (MeetScoresId DEFAULT '100' not null
auto_increment,primary key (MeetScore
Ward, Brian writes:
> Any idea why the create or edit table don't seem to do anything? I select
> them and nothing happens?
>
Explanation is simple.
One is on TODO and second one is in the works.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /
Hi all,
I'm trying to get a query to work but am having no luck. It seems so
simple, it should work, but obviously, I'm doing something wrong.
Table: Employees
Fields: FirstName
LastName
EmployeeID
Table: Sales
Fields: SubTotal
EmployeeID
What I want to do is
Hello,
I need some help. Does anyone see what I'm doing wrong here:
create table MeetScores (
MeetScoresId default 100 not null auto_increment,
meet varchar(5) not null default '',
sess varchar(3) not null default '',
GymnastNumber integer not null default 0,
Gymnast varchar(30) not null default
Hello,
I'm trying to understand MySQL indexing but am having trouble understanding the
differnences (and when to use each) between Primary Key, Key, Unique, an Index. Can
you help?
Thank you!
Check the archives, we had this discussion a few weeks ago and someone came
up with a good solution.
Cal
http://www.calevans.com
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 24, 2001 9:05 AM
To: MySQL Masters
Subject: Random record from
Hi!
I have posted a message about INSERT DELAYED
crashing the 3.23.33 server build from tar ball
on FreeBSD 4.2-STABLE using
--felide-constructors
--fno-exceptions
--fno-rtti
to make it work on high loads. However, with
or without mentioned compiler params i could never
do any INSERT DELAYED on
Artem Koutchine writes:
> Hi!
>
> I have posted a message about INSERT DELAYED
> crashing the 3.23.33 server build from tar ball
> on FreeBSD 4.2-STABLE using
> --felide-constructors
> --fno-exceptions
> --fno-rtti
> to make it work on high loads. However, with
> or without mentioned
Hackley, Susan writes:
> Help I ran into this problem while compiling.
>
> root @
> fwnau060.usco.com:/root/mysqlgui/fltk-1.0.10
> => make
> === making src ===
> Compiling Fl.o.
Can someone help me with the following command? The slashes seem to be
causing a problem. It doesn't find /images/covers?
update products set products_image='images/covers' where
products_image='/images/covers%';
-
Before posti
Could someone help me out with the following line I think the slashes are
causing the problem but I am not sure:
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear MySQL masters,
Can I select a random record from a table. After doing a query on a table
can i retrieve a record randomly. Is there a way in MySQL to achieve this.
If, can you please send me details.
thanks
Sheni R Meledath
[EMAIL PROTECTED]
-
Christopher McClan writes:
> Hello,
>
> The staticly compiled mySQL gui, comes up with the following when I start
> mysqlgui :
>
> Can't connect to local mySQL server through socket (111)
>
> I'm doing this as root, I have set a password, and managed to create a
> databse (using mysq
Hi,
I`m setting up a email system, the same type of system as Yahoh Groups,
Topica etc.. I`m just in need of some advise as to how best to handle my
tables. At the moment I have the following tables setup..
Lists - Stores info about the list
ListOwners - Stores all List Owners info
Members
Dear All,
I remember that in Access it is possible create query that transform a table
(field value becoming column name).
For example from a table like
Student Name ExaminationGrade
Marc 1st spring 12
Marc
Mark Chalkley writes:
> According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater
>than 3 chars in length are converted to type VARCHAR. I understand the space
>efficiency issues involved here, but when the column is used in an index, doesn't
>that impose a performa
Steven Roussey writes:
>
> Some clarification. On this table there are a lot of indexes, but there is
> one unique/primary key, and it is that one that the replace should be
> checking for. The other indexes have the same fields in different places
> though. Table key def is something like t
Hi All
Thanks for the info but I need to be able to read a selected file from client
host and write this to te db.
I use this to get the file from client
Picture:
this gets the path and file name. When doing a insert the best I can do is to
save path+file name into db field.
I played around
hey...
i'm getting a weird problem... i'm running a mysql 3.23 server on a dual-processor
machine with 2 GB RAM. The number of tables are very few.. and so are the records.
I've configured max_connectins as 2000 and i'm using PHP 4.0.4pl1 to access the
database. I'm using persistent conn
Hi!!!
I am interested in learning MySQL from beginnning. I do not have knowledge any other
database even.
I have to start from scratch. Can you please guide me for the same? How to start ?
BIG THANKS IN ADVANCE.
Regards,
Anand...
Hi...
I Have a Master(version 3.23.33) and
one Slave(version 3.23.32)
When I shutdown the slave,
And make some change Master.
then I restart the slave.
But, Slave didn't catch the change on Master.
bug or feature?
thank you for advanced answer.
Sir,
i Like to work on Mysql, in Windows 95 or Windows Nt,
i saw ur site, it is nice, what should i download from the
net , because lot of softwares are there
and also i like to work in Php - server side on Pws or iis
as web server . is there is any dll or api for this .
are u provi
Hi,
Adding XML support to mySQL is no big deal if your`re talking about very
structured data sets like
Joe
Montana
not bad at all
If you got to handle a lot of these, than its easy to write an external XML
I/O filter
which even could handle the attributes. The result would be a simple f
Hello Heikki,
Friday, February 23, 2001, 6:51:33 PM, you wrote:
HT> Peter and Sander,
HT> relevant questions, I will try to answer them.
>>Good questions - I have a few more :)
>>A) why does it seem to use fixed-size storage units. (The files)
HT> I have copied the concept of a tablespace con
Hi,
Could anyone please let me know how I can transfer data from excel to a mysql
database? If it is possible. The data is stored in an excel file on my PC. And I want
to transfer the contents (about 500 records with 20 fields) of this excel file to a
mysql table on a remote linux server.
These RPM's tend to set you up to run mysql automatically upon
boot.
Instead of trying to run mysql, just log into it:
%> mysql -h localhost -u root -p
then it will prompt you for root user password. Enter it and off
you
go.
~Shilo
--- David Richards <[EMAIL PROTECTED]> wrote:
> >Descrip
Hello 'mysql',
I found your address on http://lists.mysql.com.
I'm a freelance programmer from British Columbia, Canada,
with a college degree (well, almost) in computer science,
and four years experience. I'm currently looking for
programming contracts that I can fulfill over the Internet.
59 matches
Mail list logo
