Hi All,
I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this
usage?
mysqlbinlog --user=root --host=127.0.0.1 master-bin.001.
I am repeatedly getting errors like master-bin.001 file not found in
Linux . When I give the full path of the master-bin.001 its working.
There is a m
Hi,
I have the following statement:
echo "$tenureid";
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = "select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid'";
$result = mysq
sorry for this late reply rory
i just got back to work ..
i am trying to connect to 192.168.x.y
but the jerk connects to 192.168.xx.xxx
the other ip
yeha it connects to an ip . not the loop back adrs
am i supposed to connect to loop back adrs thinggy ?
im all screwed with th
Hi Gabriel,
No, you can't currently modify compressed tables.
For in memory tables, are you aware of the HEAP type for non-critical
data?
You're probably talking regular permanent tables, though. For those, the
OS will use all free memory (that programs aren't using) to cache file
data after it'
I've been searching the Lotus site and have gotten kind of lost. Does
anybody have any experience using Lotus Notes as a front end to a MySQL
database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I
barking up the wrong tree?
Thanks.
Randy
--
MySQL General Mailing List
For list arch
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
/usr/local/mysql/bin/mysqladmin -u root password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
The first worked, but i get
So, we just got this handy dandy new G5 with 4GB of RAM and I'm trying
to get it to store as much of our 4.3GB database in RAM as possible.
I've tuned most of the usual parameters (query cache, tmp table size,
sort buffer, key buffer, record buffer, table cache, myisam sort
buffer, etc.) but th
If the are a UNIX CGI plant then they probably run PERL which then you
can use DBI; this is much different then writing HTML since PERL by
itself can't include raw imbedded html. So, I suggest using PHP it
should be easier for you to make a transition to then a pure old fashion
CGI script.
Look be
On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote:
> PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE
> CONFIGURATION TO RUN MYSQL SERVER. THANKS.
I think this depends on how big the database will be, how much it will be
hit, etc!!!
I've heard of MySQL
Dont worry
The indians will put 3 more of us out of work by tommorrow am!
-M
- Original Message -
From: "John Nichel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 6:45 PM
Subject: Re: web interface...
> Martin Gainty wrote:
> > There are about 1000 people
Dora wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
What are your thoughts?
Thanks
PHP... http://www.php.net
And if PHP isn't doable, Perl.
--
By-Tor.com
It's all about the
On Thu, 9 Oct 2003 18:41:42 -0400, Dora <[EMAIL PROTECTED]> wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
Add PHP to your list of skills. There is so much documentation
on t
PLEASE, I'M A STUDENT AND I´D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE
CONFIGURATION TO RUN MYSQL SERVER. THANKS.
_
Voce quer um iGMail protegido contra vírus e spams?
Clique aqui: http://www.igmailseguro.ig.com.br
Ofertas imperdíveis
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
What are your thoughts?
Thanks
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Thursday, O
Martin Gainty wrote:
There are about 1000 people on this list that can put a web front end for
you
Something to think about..
-Martin Gainty
Who am I missing? I only counted 997.
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives: http://li
Thank you. I'd like to do it myself though.
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 6:40 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: web interface...
There are about 1000 people on this list that can put a web front
There are about 1000 people on this list that can put a web front end for
you
Something to think about..
-Martin Gainty
- Original Message -
From: "Dora" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 6:21 PM
Subject: web interface...
>
>
> Hi
>
> I have us
DROP TABLE IF EXISTS t;
CREATE TABLE t (ts TIMESTAMP, i INT);
INSERT INTO t (i) VALUES(0);
SELECT * FROM t;
At this point, the timestamp field is un-interpretable. SELECT returns
-00-00 9:01 AM
UPDATE t SET i = i + 1;
SELECT * FROM t;
Returns the same thing; -00-00 9:01 AM. JFYI, none of
-->-Original Message-
-->From: Dora [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, October 09, 2003 3:18 PM
-->To: [EMAIL PROTECTED]
-->Subject: web interface...
-->
-->
-->Hi
-->
-->I have used other relational databases but am new to my sql. Where
can
-->I find documentation on how to co
Hi
I have used other relational databases but am new to my sql. Where can
I find documentation on how to connect my database to a web page?
Thanks
Hi
I have used other relational databases but am new to my sql. Where can
I find documentation on how to connect my database to a web page?
Thanks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 09 October 2003 06:06 pm, Dan Anderson wrote:
: Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of
: a row that was just inserted? I'm using PHP, I don't know if that makes
: a difference?
:
: Something like:
:
: INSER
Here's the link to the on-line manual page that will help you.
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 5:06 PM
To: [EMAIL PROTECTED]
Subject: Getting the value of a row you ju
Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of
a row that was just inserted? I'm using PHP, I don't know if that makes
a difference?
Something like:
INSERT INTO foo (bar) VALUES ("bar");
SELECT last_insert(id) FROM foo;
Also, are there any problems with using this in an
At 14:53 -0700 10/9/03, Scott Brown wrote:
I am running MySQL 4.1 in a sandbox, trying to test some code against it.
No matter what, even when no value is explicitly applied, or the
field is not explicitly named in a SQL statement, the TIMESTAMP
column refuses to update.
I have tested this with
I am running MySQL 4.1 in a sandbox, trying to test some code against it.
No matter what, even when no value is explicitly applied, or the field is
not explicitly named in a SQL statement, the TIMESTAMP column refuses to
update.
I have tested this with several programs written in 3 different la
I recently got a redhat 9 server with mysql
3.23.54-log (what does the -log mean BTW?). Every time
I start mysql it maxes out the cpu in a few minutes.
Nothing is even connecting to mysql at this point, and
SHOW PROCESSLIST doesn't show anything (except it's
own query). Any idea what the problem is
\"As I understand it, and I confess I am not totally sure I do, sql injection is more
of a problem in your page code than what database (/version) you run.\"
Absolutely. As I show at http://www.vbmysql.com/articles/sqlinjection.html SQL
Injection is a flaw in the front-end code, and you are at
Cheap books -> http://www.bookpool.com
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 4:16 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: Re: Which is the best MySQL book?
At 02:03 PM 10/9/2003, you wrote:
>Is there one that's especi
"You need a license if you sell a product designed specifically for use
with MySQL or that requires the MySQL server to function at all."
Actually, could someone from MySQL clarify this bit for future reference?
If my application includes a standardized method of access such as ODBC, or
provides t
At 02:03 PM 10/9/2003, you wrote:
Is there one that's especially outstanding?
Thanks,
jim
--
Jim,
MySQL Cookbook also by Paul Dubois is also a good read. I got both
books (including MySQL 2nd Edition) at a 30% discount off the list price
plus another $10 off with a coupon plus free s
I think I got it
What look like what is happening happening is that your page is running the insert
when you present the form to the user, which is why the php variables are empty. when
they submit the page, you are inserting the correct values. To test this, load the
page up, do not subm
Goto www.devshed.com some nice resources there, from introductions to
advance topics.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Casper Matthee [mailto:[EMAIL PROTECTED]
-->Sent: Th
MySQL the definitive guide to using, programming, and administering
mySQL, version 2 by
Paul Dubois, who is active on this list.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Anderson
As I understand it, and I confess I am not totally sure I do, sql injection is more of
a problem in your page code than what database (/version) you run.
--ja
On Thu, 9 Oct 2003, Dwight Trumbower wrote:
> Are there any SQL injection threats for MySQL less than 4.1?
>
> Dwight Trumbower
>
> T
Hi all
I am new to the programming world so please forgive!!!
Would like to get to get my hands on any info (Tutorials and such) to
help me on me way whith SQL and Php
Would appreciate any help... links / text / whatever...
Thanx
Casper
South Africa
Casper Matthee
Consultant
IT3 Educ
Are there any SQL injection threats for MySQL less than 4.1?
Dwight Trumbower
T Systems Corp
Custom Database Solutions
[EMAIL PROTECTED]
920-667-4438
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Oct 09, 2003 at 03:03:59PM -0400, Anderson, James H [IT] wrote:
> Is there one that's especially outstanding?
>
I haven't read it front to back, but I have an affinity for New Rider's
"MySQL" by Paul DuBois. (It's where I picked up PHP, and has been a useful
reference for me these days,
usually, to release memory is used mysql_free_result().
You do that ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
Is there one that's especially outstanding?
Thanks,
jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 12:23 PM 10/9/2003, you wrote:
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15?
If so, are the main advantages of using INNODB tables the added features
of transactions, cascading deletes, and it's other more robust features?
Any thoughts on any disadvantages of
procs memoryswap io system
cpu
r b w swpd free buff cache si sobibo incs us
sy id
0 1 0 5232 93140 26732 3736888 0 0 157510 388 343 11
1 88
0 1 0 5232 88552 26748 3741348 0 0 892 6 327 269 1
Adam,
It works! I also had to run the initialization script...
Thanks very much for the help.
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installatio
Pako,
That blows my theory.
Regards,
Adam
-Original Message-
From: Pakó Géza [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:32 PM
To: Fortuno, Adam
Subject: Re: Error: "unable to execute query" - Problems using Win32 MySQL
ODBC driver
i dont use odbc. i only need libmysql
Hmm, that is weird. Actually, I had the same issue (sort of). I was grabbing
some data from a MySQL instance on an OS X workstation. I had shared the
tables in Access via ODBC. I'd start to update the MySQL DB and get an ODBC
error. Usually I'd get about 93 rows done (out of 1000 or so).
You're ge
This is probably my mistake somewhere, but perhaps someone
could shed some light on the matter:
I have an app, compiled with the mysql c apis, that
is leaking memory. I know this by fine-tuned debugging
using mallinfo.
The memory that is being leaked is allocated by calls
to mysql_real_query(), and
Sounds like a plan. Actually, MySQL ships with OS X Server - sounds like
your using the desktop version, which doesn't include it.
Over lunch I threw 4.0.15 on a G4 running 10.2.6 - love that new installer.
I had no issues.
- Downloaded it.
- Ran the installation package
- kicked-off MySQL via my
Adam,
Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything
special when I downloaded and installed the latest version. I assumed that anything in
need of doing would be taken care of during package install. I guess that was just
wishful thinking. I'll make the o
On Thu, Oct 09, 2003 at 01:23:39PM -0400, Don Vu wrote:
> Hi guys,
>
> Do both MyISAM tables and INNODB tables support foreign keys in
> 4.0.15?
No.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: u
The online manual at http://www.mysql.com/doc/en/Replication_Options.html
says that these two variables:
max-relay-log-size=#
relay-log-purge=0|1
exist to control the size of the relay log. But when I try to start my
slave server
with:
set-variable = max-relay-log-size=192MB
set-variable = rel
hello,
Im writing a db software using delphi7 & mysql(3.23.41) (with standard dbexpress and
data access components)
The problem is: sometimes i get the error message "unable to execute query", and the
connection breaks.
i only saw this occur on UPDATEs or INSERTs, but every time a different li
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15?
If so, are the main advantages of using INNODB tables the added features
of transactions, cascading deletes, and it's other more robust features?
Any thoughts on any disadvantages of INNODB to MyISAM? I know that
INS
James:
Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain
with the timeout and all.
Anyway, at first blush I agree with you. When you installed mysql did you
give mysql (or whatever account that runs MySQL) rights to the
/usr/local/mysql/data directory? Make root the owne
I installed all the stuff as root, so /home/mysql and beyond are root owner
and group. Should I have to change to mysql user and group?
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 2:57 AM
Subject: Re: Errors
Hello, list,
What is a "good" setting for max_connections on a Windows machine with 1GB
RAM, Dual Athlons, RAID, etc...
The default of 100 seems a bit lean, we would like to increase this number,
but don't have any experience history with MySQL to draw upon.
The docs say that 500-1000 is good
I am developing a small program for a small computer firm.
Now I wonder when I have to buy the corporate licens?
And when to use the free GPL-licens one.
http://www.mysql.com/products/licensing-examples.html
"You need a license if you sell a product designed specifically for use
with MySQL
Adam,
Well, you were right about there being logs :) (I hadn't looked into the data dir
since it required root and I was reluctant to setup a root user--live and learn.)
031009 11:12:10 mysqld started
031009 11:12:11 InnoDB: Operating system error number 13 in a file operation.
InnoDB: See htt
Hello
I am developing a small program for a small computer firm.
Now I wonder when I have to buy the corporate licens?
And when to use the free GPL-licens one.
My application ´saves some data in the database and I have done NO change in the
cource code of the free version of MySQL.
Should I or
On Thu, 2003-10-09 at 16:33, pete M wrote:
> $new_id = mysql_query('select last_insert_id()');
>
> your can also user it within a query - eg
>
> $sql = ' insert into related table parent_id, data , data2) values
> (last_insert_id(), 23, 45);
>
Is there also a similar way of getting the last er
Crystal was pulling the data through MyODBC, Mascon was just used for
inserting the image into the database.
hth
danny
On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote:
> I want to ask you one thing:
> Is your Crystal Report accessing the database through the Mascon Utility
> or
I'm trying to move a bugzilla database from a MySql 3.23.54 -> 3.23.56
database on a new machine.
I have exported the database with the following
mysqldump -u root -p --add-drop-table bugs > bugs.dump.sql
moved the file to the new machine and done
mysql -u root -p bugs < bugs.dump.sql
a
As I read the documentation, ALTER TABLE my_table DISABLE KEYS only
works on MyIsam tables. When I run the command against an InnoDB
database, however, I get no indication of a problem. I get the usual
Query OK message. So, can I temporarily disable keys on an InnoDB
database (say while doing a lar
James,
Yea, I have to agree its not starting.
Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql
Emilio-
I ran into this problem just yesterday using some PHP code. The problem was in
control logic. I executed the insert within an if statement, but failed to see
that there was another mysql_query statement outside the if block. This caused
the same insert to happen again.
Basically, in ps
Hopefuly someone will be able to save me, before I destroy my system too bad. I am
trying to compile mysql 4.1.0 alpha with openssl support. I know I have everything
needed installed on my system, gcc 3.2.2, and two copies of openssl. I originaly
tried installing with the rpm, to hopefuly be
Hello All,
I have two system, we shall call then system A (OLD) and system B (NEW), running
MySQL that I want to combine their tables. The system B is the newer and most
accurate. The table structure is the exact same. Some of the rows in system B (NEW)
tables are also in system A (OLD). For
I want to ask you one thing:
Is your Crystal Report accessing the database through the Mascon Utility
or it uses MyODBC?
I think the main problem to me is how Crystal Report is accessing the
database.
I will try to access the database using ADO and see if there is any change.
Thanks
Emery
--
Hi,
i suppose you do the necessary GRANTS on the master (before executing LOAD
DATA FROM MASTER) as :
- file
- super
- reload
- select (on all tables you want to load)
If not do this, and try again
You can check if you are using only MyISAM tables with the client console by
:
> show table status f
Adam,
Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's
not running:
1. when I issue "mysql -h localhost test" I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
2. when I issue "ps -auxww|grep mysql
From: Egor Egorov <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Trouble acquiring proper AVG with TIME
Date: Thu, 9 Oct 2003 17:24:14 +0300
"Charles Warren" <[EMAIL PROTECTED]> wrote:
>
> I've searched the manuals and any websites I can find but am still at a
loss
> on how to calculate wh
are you doing this insert in any sort of loop? if you emailed yourself the
final query, or printed it on the screen and then ran it directly into
mysql...do you get the same results?
Jeff
James,
Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?
So you're doing the following
# (1) Going to the mysql directory.
cd /usr/local/mysql
# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
sudo mysqld_safe -
Hi,
I wanted to add some new user defined functions (UDF) to mysql 4.0.12-standard-log.
I read in the manual that it is possible if you can start with the option
--with-mysqld-ldflags=-rdynamic.
Then I found that my distribution is most likely build with --disable-shared, which
makes me believe
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement:
$sql
[EMAIL PROTECTED] wrote:
> --
> mysql> select * from msg where Author=6213 and (Saved='s' or Saved='n')
> order by ID;
> Empty set (0.00 sec)
> ---
> mysql> select COUNT(*) from msg where Author=6213 and (Saved='s' or
> Saved='n') order by ID;
> +--+
> | COUNT(*) |
>
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is
the server won't start and there don't seem to be any logs available to help diagnose
the problem. I've tried both
sudo safe_mysqld
Starting mysqld daemon with databases from /usr/local/my
Here is my my.cnf (had to zip it, my Windoze would not let me attache
it??).
As far as I know, im only using MyISAM (thats the standard version
right), but how do I check this?
Best regards
Søren
-Original Message-
From: Thierno Cissé [mailto:[EMAIL PROTECTED]
Sent: 9. oktober 2003 16:2
Hi,
can you indicates your configuration about :
- my.cnf
- all tables type your using in the master (MyISAM, INNODB, BDB)
This may help to see what goes wrong .
Regards
Thierno 6C - MySQL 4.0.15
- Original Message -
From: "Søren Neigaard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Se
"Charles Warren" <[EMAIL PROTECTED]> wrote:
>
> I've searched the manuals and any websites I can find but am still at a loss
> on how to calculate what I thought was going to be an easy 'Average' of Call
> Times.
>
> Situation. Have a table which is updated daily for users metrics and have
>
I am running it on a production server for about two weeks. So far it has been very
stable.
--ja
On Thu, 9 Oct 2003, boka wrote:
> Bob Brands wrote:
>
> > No, its supported by version 4.1
>
> MySQL 4.1 -- Alpha release (use this for new development) ... is this
> stable enough to use it on
Emilio,
Can you supply the full insert statement? Also, is this happening for all users, or
one in particular? I ask, as I've seen issues with web app users double-clicking the
submit button causing similar issues
> -Original Message-
> From: Emilio Ruben Estevez [mailto:[EMAIL P
--
mysql> select * from msg where Author=6213 and (Saved='s' or Saved='n')
order by ID;
Empty set (0.00 sec)
---
mysql> select COUNT(*) from msg where Author=6213 and (Saved='s' or
Saved='n') order by ID;
+--+
| COUNT(*) |
+--+
| 191 |
+--+
1 r
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press submit the page
use the INSERT INTO db then when i check the data in the database i can
see the record that the user entered and a second record that is all in
Thanks for your help, just what I needed.
I will play around but if you have a chance and know how, how would I order
the results by count? (ie. highest counts first..)
-Original Message-
From: Mike Knox [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 5:09 AM
To: '[EMAIL PROT
I have posted the message with the subject "Serious problem with
replication", but nobody seems to know what to do?
Now I have even tried to completly uninstall MySQL (with rpm -e), delete the
"/var/lib/mysql" dir, and reinstall MySQL with "rpm -i
MySQL-server-4.0.15-0.i386.rpm".
Then I create my
Hello,
This sql query works fine with mysql 4.0.15, but it gives an error with
mysql 3.23.49:
SELECT officiele_naam, rechtsvorm, activiteit1, activiteit2, adres, postnummer,
gemeente, Biogarantie, Hefboom, Netwerk_Vlaanderen, Vibe, Fair_Trade, NULL , Vosec,
Solidr, Demeter, Europees_Ecolabel, B
Thank you for the ideas. Very helpful.
Thanks
Emery
- Original Message -
From: "Danny Haworth" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 12:01
Subject: Re: Ideas on Compression Protocol
> We used compression on a project wi
Bob Brands wrote:
No, its supported by version 4.1
MySQL 4.1 -- Alpha release (use this for new development) ... is this
stable enough to use it on production systems ?
btw. is there any workaround for this functionality in 3.23.58 ?
greetz
boka
--
MySQL General Mailing List
For list archives:
Hi boka
Nope sub-selects to my understanding ar only supported from version 4.1
onwards (still in beta I think)
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
- Original M
No, its supported by version 4.1
gr.
- Original Message -
From: "boka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 11:54 AM
Subject: MySQL 3.23.58 and sub-seletcs
> Hi !
>
> Are sub-selects supported by MySQL 3.23.58, because below query does not
> wor
Hi!
On Oct 07, Dathan Vance Pattishall wrote:
> I have to drop the FULLTEXT INDEX added to a set of dbs containing a
> TEXT field with an average of 6K of text added to each row, at a growth
> of 250K rows added a day to a set of 100 tables. The reason for the drop
> is due to table corruption and
Hi !
Are sub-selects supported by MySQL 3.23.58, because below query does not
work (syntax error in console):
select iphdr.ip_src, timestamp \
from iphdr , acid_event \
where iphdr.sid = acid_event.sid \
and iphdr.cid = acid_event.cid \
and acid_event.sig_name = "STATEMENT" \
and acid_event.tim
Hi toby
If I log in to mysql via the command line on the hosting machine it says
[EMAIL PROTECTED] ... therefore, stating the obvious :) it doens't think you're
connecting from localhost - this may be because of the two NICs but I don't
know enough to be sure .when you connect to the mysql se
thnx rory
the thing is kwexchange is localhost you know .
so it should work
alwayz has before this dammed day .
anywayz .
i did install mysql on another machine and installed all the rest , php,
apache, phpmyadmin on another
when it gave me these access denied errors
the ve
Hi Toby
I am not an expert on permissions within mysql - boy, do I wish I was - but
could the problem be that you have only granted permissions to
[EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ?
Here endeth my knowledge of MySQL permissions
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL P
Hi Taylor
While I have only used mysqldump to backup MyIsam files, I have found the
process to be fairly painless. Mysqldump creates "batch" f iles which
effectively rebuild your database structure + database data. To restore the
data all you need to do is run the backup files as a batch file i.e.
Hi group,
I recently asked about Compression and security and got nice answers.
Now I have got a different question:
What are the disadvantage of using that client/server Compression protocol?
Does it increase speed? Does it decrease speed? Does it overload the server? The
client?
Any ideas
"Jose Rojas" <[EMAIL PROTECTED]> wrote:
>
> I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the
> next messages in the ../var/*.err file:
>
> mysqld started
> /home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13)
> 031008 15:18:16 Could not use
I still have this problem with replication, and i dont know how to fix it.
I have a slave that has been running for a long time without any problems,
but now its not replicating any more. So I tried to do a "LOAD DATA MASTER;"
which always gives me this error now:
Version: '4.0.15-standard-log'
these are linux machines on internet, one is web server and another db
server, with real IPs. but I may optionally want to export data to my PC,
also on internet connected through LAN to my web server and db server.
thanx for ur time
Nitin
- Original Message -
From: "Christensen, Dave" <
100 matches
Mail list logo