Sorry to have bothered the list, for anyone's info...
You have to have the CDF files on `all' servers, not just the MASTER in
order for the mysqlimport to work.
Robert B.
On Tue, 29 Oct 2002, zxcv wrote:
>
> Hello all,
>
> I have a cron job that:
>
> 1 - t
Hello all,
I have a cron job that:
1 - truncates some working tables [WORKS | BOTH]
2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY]
3 - truncates a selection of production tables [WORKS | BOTH]
4 - select from working into production tables [WORKS | BOTH]
Step 4 doesn't work on
Hello all,
MySQL 3.23.51
Apache 1.3.26
In my php connection to MySQL I send a message if there is a problem.
Today for the first time in 3 years of MySQL/Apache use I received the
following error message:
[26-Sep-2002 15:49:14] ERROR: Couldn't connect to the DB while drawing the
main page qui
OS: Compaq Tru 64 4.0F
Compiler: GNU GCC 3.0.4 - libstdc++.3.0.4
MySQL 3.23.49
MySQL Protocol 10 - libmysqlclient.so.10.0.0
After upgrading apache/php with the new 3.23.49 libs all of my previously
working 'C' mysql applications have died. This is okay on one hand cause I
am moving them to 'php'
An Oracle DB programmer reviewed a query that I wrote and told me that
putting constants at the beginning of the query would make it slower. I
thought I'd go to the experts on MySQL and be told the truth one way of
the other.
Example query:
SELECT
TABLE1.COL,
TABLE2.COL
FROM
Thanks... That's exactly what I was looking for. Simple and elegant.
Rob.
On Tue, 18 Dec 2001, Roger Baklund wrote:
> Asuming all dates are 20xx:
>
> mysql> select
> @d:='01-DEC-18',@d2:=concat('20',mid(@d,1,2),'-',field(mid(@d,4,3),
> 'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OC
Our programming crew does not give us (Web Services) access to Oracle. We
of course don't care kuz' mySQL suits us fine. But now we have run into a
pickle. They are handing us text cdf files for import. One of the fields
they are giving us is in the following condition:
02-SEP-02
We need to do
> set SQL_BIG_TABLES = 1;
You also will have to keep in mind that now that a filesystem is being
used for the MySQL work you'll need the room to do it. In some cases the
default MySQL install uses '/var/tmp' for it's chalkboard which in some OS
installations, referring to UNIX of course
