Mohamed Sourane
Directeur Général
ServeU SARL
98, Route Nationale Mtsapéré
97600 Mamoudzou
Tél/Fax : (0269) 63.02.70
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : dimanche 13 juin 2004 19:02
À : [EMAIL PROTECTED]
Objet : Re: Protected Mail Request
Firs
Hi Dave,
> I am getting the above error (the number is wrong - manual says this is
> 1249) on a statement of the form
>
> (SELECT species_table.species_id,count(*) as c FROM species_table INNER
JOIN
> checklist_table USING (species_id,subspecies_id,name_id) GROUP BY
> species_id,source HAVING c=1
I am getting the above error (the number is wrong - manual says this is
1249) on a statement of the form
(SELECT species_table.species_id,count(*) as c FROM species_table INNER JOIN
checklist_table USING (species_id,subspecies_id,name_id) GROUP BY
species_id,source HAVING c=1)
UNION
(SELECT spe
Hi,
I just like to know what is the best way to dump the databases to flat
files as some of the tables on my system are up to 1.4G and the whole
database size is over 2.5G . I trying to set up a cron job that will
back up the table everyday and my main consern is the size of the tables
and the
How about an HTML meta tag refresh set at 20 minutes.
>>This may be slightly off-topic, apologies if so but I was wondering if
>>anyone could point me in the right direction.
>>
>>I'm currently storing applications from a web site into our mysql DB, our
>>client has a web-based backoffice. He has
Hi all.
I'm writing an app in Perl / Gtk2, and I'm having trouble with DBI's
last_insert_id() function.
I have so far:
eval {
$sth->execute (@bind_values) || die $dbh->errstr;
};
# If the above failed, there will be something in the special
variable $@
if ($@) {
> We've had some cases where an OPTIMIZE TABLE failed because we ran out
> of disk-space (error message "28 when fixing table"). All subsequent
> operations gave us an error 144 ("Table is crashed and last repair
> failed"), resulting in partial backups and partially updated databases.
> What I'd
Right, subqueries require 4.1. In 4.0.17, you could do this with 2 queries
and a temporary table:
CREATE TEMPORARY TABLE owners_temp SELECT COUNT(*) as c
FROM pet GROUP BY owner HAVING c>1;
SELECT COUNT(*) FROM owners_temp;
DROP TABLE owners_temp;
There may be a better way, but that sh
First, you really should add a gallery_keywords relationship table to
replace the galleries.keywords column. Aside from the difficulties you are
already having, I don't think any solution with the current scheme will be
able to make full use of indexes, if at all. In other words, without an
i
Thanks - this did not work for me as I am on 4.0.17 - presumably this works
on 4.1 (seems to need the SubQuery feature)? If so I will upgrade
immediately!
From: Yayati Kasralikar <[EMAIL PROTECTED]>
To: Dave Torr <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: How to COUNT rows when they
Following query does what you want:
SELECT COUNT(*) from (SELECT COUNT(*) as c FROM pet GROUP BY owner
HAVING c>1) as temp
-Yayati
Dave Torr wrote:
Probably simple but I can't figure it out!
THe manual section 3.3.4.8 has the example
SELECT owner, COUNT(*) FROM pet GROUP BY owner
which is fine.
Ken Easson wrote:
Hello,
I am trying to retrieve a cross join of two tables. Table one contains an id
column, table two contains a column that can list up to three id's from
table one.
SELECT dix_ondemand_genre.id, dix_ondemand_shows.genre,
id IN(dix_ondemand_shows.genre) as test
FROM dix_on
Probably simple but I can't figure it out!
THe manual section 3.3.4.8 has the example
SELECT owner, COUNT(*) FROM pet GROUP BY owner
which is fine. Now what I want to do is count the number of rows this
returns. Actually of course this is trivial - I can just count how many
owners there are.
Wha
--- Martin Gainty <[EMAIL PROTECTED]> wrote:
> What happens if you
> SELECT DATABASE();
> ???
Nothing.
However, I've been tweaking this and that, and
everything suddenly started working again. I THINK it
was a problem in my PHP after all, and there were no
error messages because my script doesn'
John...the skip-counter is perfect!! My Slave B is now back up and
running again. Thanks again for your prompt help!!
*** REPLY SEPARATOR ***
On 6/14/2004 at 3:54 PM John McCaskey wrote:
>Give the below a shot:
>
>slave stop;
>set global sql_slave_skip_counter=1;
>slave start
What happens if you
SELECT DATABASE();
???
-M
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 14, 2004 6:51 PM
Subject: Tracking Down a Ghost Database
> I'm not sure if I'm wrestling with a 1) PHP problem,
> 2) MySQL problem, o
Give the below a shot:
slave stop;
set global sql_slave_skip_counter=1;
slave start;
Good luck.
John A. McCaskey
-Original Message-
From: Henry Chang [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 3:34 PM
To: [EMAIL PROTECTED]
Subject: How to Fix Broken Replication
I have MyS
I'm not sure if I'm wrestling with a 1) PHP problem,
2) MySQL problem, or 3) operator error.
I have a really a page with a really nice script for
querying my database. I've previewed a variety of
pages, and everything was working fine.
Suddenly, everything went dead. My pages still preview
correc
I have MySQL replication setup between Master A and Slave B.
Everything was working fine, until one day replication was broken.
Status on the slave shows the following error message:
Last_error: Error 'Can't drop database X. Database doesn't exist'
on query 'DROP DATABASE X.
I suspect a
Ok final question on this for today, is it possible to move data into MySQL
through odbc from excel or any other data source come to think of it?
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: 14 June 2004 21:52
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED];
I am trying to install the RPM and get a couple of errors saying the
libsqlclient.so.10 RPM is missing. I have tried to search for this but
cannot find the proper package for it. Any help would be appreciated!
Sincerely,
Chris Dietzler
AT&T Enhanced Network Services
--
MySQL General Mailing Li
Thank you agsain not sure if I am following this correctly but will go and
search for some reading thank you once again... is this the right thisng you
refer to?
OLE DB Provider for mySQL
oConn.Open "Provider=MySQLProv;" & _
"Data Source=mySQLDB;" & _
"User Id=myUsername;" &
It seems to me that you are trying to use EXCEL as some type of live data
entry form. That would require "binding" an excel sheet to your data
source (through ADO through ODBC to the MySQL server). There are many
examples of this type of binding. You didn't say, but I assume that your
EXCEL is ru
Renato Cramer wrote:
Hello All,
I'm using MySQL 4.1.0, InnoDB tables and Win2K.
I need set read_only=1 and want do via option file, it's possible?
According to
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
*
read_only
...
This variable was added in MySQL 4.0.14.
*
I already trie
> Hello All,
>
> I'm using MySQL 4.1.0, InnoDB tables and Win2K.
> I need set read_only=1 and want do via option file, it's possible?
>
> According to
> http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
> *
> read_only
> ...
> This variable was added in MySQL 4.0.14.
> *
>
> I alr
Thanks you for repying, I was expecting a reply such as this and I am not
prpared fully, here goes.
I assumed that the ease with which data can be pulled using Myodbc from MySQL
and chnaged within excel could simple be used to 'UPDATE' the selected
recordset. Clearly this is not the case.
I am w
John:
A couple of suggestions. First, a better way to identify duplicate files in to
use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file is
residing on the server. It would be a good idea to store the md5 sum in the table.
I think your problem can be solved with
CREATE TEMP
Lee Denny wrote:
Hello,
This may be slightly off-topic, apologies if so but I was wondering if
anyone could point me in the right direction.
I'm currently storing applications from a web site into our mysql DB, our
client has a web-based backoffice. He has to refresh his screen every 20
minutes to
Dyego Souza Dantas Leal wrote:
Hello guys..
I want use SSL connections to my replication servers with mysql...
This support works on 4.0 ?
This support works on 4.1 ?
This support is very tested ?
On Windows... i can use SSL to replicate my server ? when ?
According to the manual, SSL support was a
I don't have enough information to answer your question. What platform are
you on? What language/DB library are you using to call the ODBC driver? The
answers you seek may be in the documentation for the particular
language-library combination you are using.
Eventually it all boils down to 3 dif
Leonardo Francalanci wrote:
I have a similar problem with a list of union(s) (see my email, one
hour before yours).
It seems there is something in the way mysql parses the string
that makes it crash. I tried with version 4.1.2 as well, but
it keeps on crashing.
Due to the architecture of the parser
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 12 June 2004 09:12 am, François Schiettecatte wrote:
> Hi
>
> I am running into an interesting issue with replication speed. The
> setup I have is very simple, one master and one slave. The master
> processes a lot of inserts and updates al
Hi All
I have a puzzle or more like a mental block that needs some sensible thought
inputs please.
If I odbc inot mysql and pull out records and make chnages how do I put the
changes back into mysql ?
Hope there is a simple response to this
Andrew
--
MySQL General Mailing List
For list archi
In my last post I noted that I am using Opta driver. Wrong. That was my Ms
SQL driver. I am using
mysql-connector-java-2.0.14-bin
Sorry for confusion.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
--
Assuming both scenarios only had one connection open for all the
statements,
you probably will see a savings. You will need to benchmark your
situation.
You will need MySQL 4.1 or greater and your ODBC driver will need to
support
this version as well.
Ed
-Original Message-
From: Paul McN
RE -
I have a situation where, within a PHP loop, I am creating over one
hundred SQL statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one
mysql_query() statement, and therefore only execute mysql_query() 5
times for 100 statements, as opposed to sendin
Andy...
What you say at the very end "Do you save by not making as many
connections?" made me think that you are creating and dropping a connection
*FOR EACH INSERT/UPDATE*. This is not necessary and will contribute
greatly to the amount of time it takes for you to process your records.
All yo
Yes,
Linux RH9 2.4.08
When I run the /opt/lampp/lampp start
command, Apache starts, SSL, starts and another service, mysql seems to
start. But when I try to connect to mysql with admin or cc or other
tools, so I can setup databases and tables, it tells me mysql is not
running.
Then I issue /opt/l
Yes, you can save using multiple statements. We send
hundreds...thousands of statements in a single batch in our machine
automation application. The communication cost is relatively fixed (with
in reason), where the actual work to be done (mostly inserts) was very
fast for us in our table schemas.
Hi there,
I'm using MySQL 4.0.18 and finding that DROP TEMPORARY TABLE is performing
an implicit commit, as is documented.
The problem is that I have a complex query in a Java function, and I need to
call it a number of times to get the overall, which I also want to do as a
single transaction so
While doing a "Load table from master", "show slave status"
will hang (like it is locked, but processlist will not show
it as locked) on MySQL 4.0.20... is this a bug or a feature?
I don't remember earlier versions doing this.
Also: I still experience mysql crashes after loading a few large
table
Hello,
Can somebody tell me the exact version of MySQL ( i
think its one the 3.23.x series) from which ` around
objects were allowed.
Karam
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
[EMAIL PROTECTED] wrote:
Dear All,
Still this time I used MySQL 4.0.15 and now I have installed the
4.1.2-alpha. it OR WITH ME. Can anybody help me to solve
I have 3 problems with them?
1.
I can't set password for users. If I set password I can't login into
database, I get the next message:
Curtis Seyfried 2 wrote:
I just installed mysql using Xampp, an installer for Apache, Mysql, PHP
installation.
Everything else works fine, but mysql will not start with the Apache
It is not clear what you mean by "mysql will not start with the Apache
startup." Apache and MySQL are separate server
Dear Marko,
It does look like the result of a gap lock, but notice that I used both
primary keys in the where clause of my update query, therefore it should
only match (and update) 1 row. From my understanding (correct me if I'm
wrong, my knowledge of how mysql works is gleaned from the mysql docs
Hi all,
We've had some cases where an OPTIMIZE TABLE failed because we ran out
of disk-space (error message "28 when fixing table"). All subsequent
operations gave us an error 144 ("Table is crashed and last repair
failed"), resulting in partial backups and partially updated databases.
What I'd
I have a similar problem with a list of union(s) (see my email, one
hour before yours).
It seems there is something in the way mysql parses the string
that makes it crash. I tried with version 4.1.2 as well, but
it keeps on crashing.
> -Messaggio originale-
> Da: Chambon [mailto:[EMAIL PRO
Hi,
Using Mysql 4.0.20-standard-log since a few days
I encontred an error that I had never seen before.
Here is what I have done :
1_ create an innodb table :
create table Test (JobStatus varchar(32) ) type = innodb;
2_ Run the following request :
select JobStatus from Test where
(((
Testing another time the mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing the MySQL mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello All,
I'm using MySQL 4.1.0, InnoDB tables and Win2K.
I need set read_only=1 and want do via option file, it's possible?
According to http://dev.mysql.com/doc/mysql/en/Server_system_variables.html:
*
read_only
...
This variable was added in MySQL 4.0.14.
*
I already tried put of both modes
I still have this problem... should I submit a bug?
-Messaggio originale-
Da: Leonardo Francalanci [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 2 giugno 2004 14.19
A: [EMAIL PROTECTED]
Oggetto: R: R: R: R: R: query string too long?
> Test it on 4.1.2 and let me know if these queries will
Hello,
This may be slightly off-topic, apologies if so but I was wondering if
anyone could point me in the right direction.
I'm currently storing applications from a web site into our mysql DB, our
client has a web-based backoffice. He has to refresh his screen every 20
minutes to see the latest
Hello guys..
I want use SSL connections to my replication servers with mysql...
This support works on 4.0 ?
This support works on 4.1 ?
This support is very tested ?
On Windows... i can use SSL to replicate my server ? when ?
Tnks in advance,
InnoDB,SSL,MySQL,SQL,HELP
I followed what you said up until the last sentence. Which kind of remote
connection are you trying to make? I was under the impression that you had
an Access front end that you are trying to connect to a MySQL backend. If
that's the case you need to make sure that your MySQL server on the Linux
Hi,
Using Mysql 4.0.20-standard-log since a few days
I encontred an error that I had never seen before.
Here is what I have done :
1_ create an innodb table :
create table Test (JobStatus varchar(32) ) type = innodb;
2_ Run the following request :
select JobStatus from Test where
(((
Hi Michael,
This seems to be better than executing a batch file.
But still, its not efficient as large database restorations would
require innumerable queries to be executed.
Wish MySQL had a non-proprietary SQLDMO like API !!
Regards,
Nawal Lodha.
-Original Message-
From: Michael Lofti
[EMAIL PROTECTED] wrote:
I am running MySQL 3.23 and want to setup replication. I execute the
following command(copied from MySQL document) on the master server:
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY
'slavepass';
And it return the following message:
ERROR 1064: You
I am running MySQL 3.23 and want to setup replication. I execute the
following command(copied from MySQL document) on the master server:
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY
'slavepass';
And it return the following message:
ERROR 1064: You have an error in your
I just installed mysql using Xampp, an installer for Apache, Mysql, PHP
installation.
Everything else works fine, but mysql will not start with the Apache
startup. When I try to do a manual startup of my sql I get the following
error message
ERROR 2002: Can't connect to local MySQL server through
Dear All,
Still this time I used MySQL 4.0.15 and now I have installed the 4.1.2-alpha. I have 3
problems with it OR WITH ME. Can anybody help me to solve
them?
1.
I can't set password for users. If I set password I can't login into
database, I get the next message:
'1251 - Client does
\. is the MySQL CLI/monitor SOURCE command.
read your file in one statement at a time and execute it (search for
unquoted/unescaped ;'s at the end of the statements)
--On Monday, June 14, 2004 11:32 +0530 Nawal Lodha <[EMAIL PROTECTED]>
wrote:
Hi all,
I wish to restore an sql file in a mysql da
Hello,
do any body can help me, i have problem with mysql syntax may be.
Let's first explain. I have two servers that i store filename, size
... in records of video camera files.
I have one database with two tables:
Servers and Files;
Servers contain:
ServerID, ServerName, User, Password, LastConne
I get this error on the slave:
040614 10:19:07 Error reading packet from server: bogus data in log
event (server_errno=1236)
040614 10:19:07 Got fatal error 1236: 'bogus data in log event' from
master when reading data from binary log
040614 10:19:07 Slave I/O thread exiting, read up to log 'd
64 matches
Mail list logo