,
--Kevin
. If you've got a MyISAM
table, I recommend a FULLTEXT index.
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
--
Kevin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
and data integration and it is
very manageable.
You can trap errors using cursors if the data has anomalies.
Kevin O'Neill
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
To: Shawn Green (MySQL) shawn.l.gr...@oracle.com
Cc: Sydney Puente sydneypue...@yahoo.com; mysql
update mydata set column1 = column2, column2 = column1
(works in sqlserver, can't try mysql at the moment)
You can select which rows by adding a where clause obviously.
I suppose that the field values are copied to a buffer which is the written
to the table at the end of the update (or row by
Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards
--Kevin Labecot,Innovanticwww.innovantic.frTél. : 05.56.45.60.54
The separate table for the IDs is probably best solution, maybe counting on
caching of the table with an index on the id value to speed up the 'where'
clause; this checks what numbers are left instead of what numbers have been
used; the disadvantage is that you have to manage a second table
' does not
match, it returns NULL as expected. Has anyone seen this before?
Thanks,
Kevin
--
Full explanation below:
--
Table 'file_detail' with 1 row:
id_file_detail, id_file, id_machine, id_user, path
1 , 1 , 1 , 1 , C:\Program Files\BlueZone
--
Stored Procedure
The problem occurs because the parameter names are the same as the column
names. I'm not sure why, since the columns are specified in quotes, but it does.
Thanks,
Kevin
-Original Message-
From: Kevin Baynes [mailto:kbay...@bluezonesoftware.com]
Sent: Wednesday, May 26, 2010 10:07 AM
any ideas, please let me know! Below is the output
from my program, and the code I am using to connect- am I doing something wrong
there? If there is any more information I can provide, please let me know.
Thank you,
-Kevin
Program output
==
Starting Engine...
Reading Control Data
to solve and folks may be better able to
provide useful advices.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to demands. Have you looked at temporary tables
or materialized views? These might help you in this endeavor.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This one time, at band camp, Perrin Harkins [EMAIL PROTECTED] wrote:
In your case, you might be able to just cheat it with some
MySQL-specific LIMIT stuff:
Thanks very much Perrin, this is most useful and I can take it from
here.
Kind regards
Kevin
--
MySQL General Mailing List
For list
,
test_answer_correnct tinyint(4) NOT NULL,
PRIMARY KEY (test_answer_id),
FOREIGN KEY (test_question_id) REFERENCES test_questions (test_question_id)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Any help in this matter hugely appreciated,
Kind regards
Kevin
--
MySQL General Mailing
This one time, at band camp, Peter Brawley [EMAIL PROTECTED] wrote:
See Within-group quotas (Top N per group) at
http://www.artfulsoftware.com/infotree/queries.php.
Yes, I have seen that, very clever. How does it relate to my situation?
Simply point to vague references is not helpful.
Kevin
the
schema I presented does.
If you dont know the answer, just leave it out, but thanks for your efforts.
If anybody can steer me in the right direction here, that would be great.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
results.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
The reproducible part is very important, because without it, it's
suspect to be just your individual case, as with a bug in *your*
application code, your hardware, or generally something in your setup.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
a programming
language of your choice. Did you have any luck writing a program to
do just that?
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
option; try adding the option --protocol=TCP.
You may well find a similar issue with phpmyadmin - there's a
configuration option:
$cfgServers[...]['connect_type'] = 'tcp';
which might solve this.
hth,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, however.
Kevin
[1] http://www.sqlite.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of skewed
data even faster. Postgres, for example, has partial-indexes.
As I said at the beginning of this email, I suggest the OP do some
personal investigation and tests, because understanding indexes /and
your own data/ is not as simple as a checklist.
Kevin
P.S. I highly suggest you Google some
-done,
which I gather we both understand. I suggest again to the OP to do some
tests on /personal data sets/ and see what answers needs.
Besides, who likes puce anyway? ;-)
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father [EMAIL PROTECTED] wrote:
Schema is a collection of databases.
A schema is a definition of tables fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
that be enough?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to relocate MySQL and a database to another hard drive on the
same system. According to this page,
http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the
impression that I should be able to do this by copying the data files to the
new MySQL installation. However,
generally tend towards
normalization, not denormalization.
The question is: what do you want to do with the schema?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Wikipedia is a good starting pace.
Kevin
At 12:30p -0500 on 18 Jan 2008, Alex K wrote:
Well the basic information, company description and personalized
options will be selected many times (whenever a user submits a query).
It will basically be show on the result page of the search engine.
The user's
-for-mysql/
HTH,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. You may be surprised.
Kevin
At 10:56p -0500 on 15 Jan 2008, Moon's Father wrote:
To know the exact speed improvement ,you have to have a test yourself append
on your hardware mathine.
On Jan 15, 2008 11:39 PM, mos [EMAIL PROTECTED] wrote:
At 11:25 AM 1/14/2008, Jay Pipes wrote:
Are you using
that article came out, and
haven't yet had a chance to try it out.)
Good luck with your problem!
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-clone-for-mysql/
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-profiler.html
A quick google with these keywords mysql index hints query profiler
seemed to provide a good jumping off point.
HTH,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
be able to better help.
That said, I'm guessing you're looking for GROUP BY and ORDER BY. Take
a gander at the MySQL docs for the version that you are using. A
starting point:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions-and-modifiers.html
Kevin
--
MySQL General Mailing List
For list
.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This one time, at band camp, Baron Schwartz [EMAIL PROTECTED] wrote:
INSERT INTO item (`key`)
SELECT CONCAT('my-item',
(SELECT IF(COUNT(*) = 0, '', CONCAT('-', COUNT(*)))
FROM item WHERE `key` LIKE 'my-item%'));
Kevin, this design is not first normal form and will cause you
regards
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This one time, at band camp, Martin Gainty [EMAIL PROTECTED] wrote:
Kevin-
Declare the column AUTO_INCREMENT
http://lists.mysql.com/mysql/161930
You can auto increment a non INT field?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
version of the query that is trying
to match them, and it doesn't work. Any suggestions?
SELECT * FROM schedule
LEFT JOIN directory ON
( REPLACE('@wncc.edu','@wnc.edu',schedule.email) = directory.email
)
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada
kind
of thing every day), you could setup a cron job to run in the middle
of the night to execute those queries. That would seed the query
cache and when users begin to use your system in the morning, they
wouldn't experience a cache miss slowdown.
--
Kevin.
--
MySQL General Mailing List
For list
|
+-++---+
Where it should return also the results with the bookmark_id of 1 as the
bookmark_url
http://www.redhat.com has two keywords, php and linux so this should match
both.
What should I be looking at here?
Kind regards
kevin
--
Democracy
the keyword of php then the
results
would be 1,3,5, and 8
Kind regards
Kevin
--
Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
to SELECT all related articles, that is, all records in the articles
table, with the keyword 'tiddles'.
MySQL 5 and the db layout looks like this so far.
thanks for looking
Kevin
CREATE table articles (
article_id int(9) NOT NULL auto_increment,
user_id int(9) default NULL
behind that.
The array pointer is now at the end of the result set.
Kevin
--
Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
This one time, at band camp, Warren Young [EMAIL PROTECTED] wrote:
Storing arbitrary data in a BLOB column is
tantamount to trying to turn the database into a file system. If you
want a file system, use a file system.
What is a file system, if not a database?
Kevin
--
MySQL General
this on 5.1.19 and 4.1.21 with the same symptoms.
Anyone have any advice here? Did you guys make any changes with the zlib
implementation you're using?
I'm willing to file this as a bug if necessary.
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype
Why doesn't mysql support gzip for COMPRESS/UNCOMPRESS and only zlib
For network applications zlib is a lot less compatible than gzip.
For example I could send gzip'd content directly from the database within a
larger gzip'd stream.
Kevin
--
Founder/CEO Tailrank.com
Location: San
point to the PHP site:
http://us.php.net/manual/en/function.mysqli-prepare.php
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the results if you were able to implement both.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 5:45a -0400 on 28 May 2007, Yves Goergen wrote:
On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote:
In particular, I imagine a lot of the HTTP requests would be the
same, so you could create a table to store the requested URLs, and
then have a second table with the timestamp and foreign key
= ' '; -- a space character
If this is the case, you might consider using a different table type,
such as InnoDB.
HTH,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
( val1, val2, NULL ) INTO myTable;
and was only able to get the tuples back when I did
SELECT * FROM myTable WHERE col3 = ' '; -- a space character
If this is the case, you might consider using a different table
type, such as InnoDB.
HTH,
Kevin
MyISAM has no problem representing NULL.
My
This one time, at band camp, Peter M. Groen [EMAIL PROTECTED] wrote:
Any thoughts? Any desires to contribute?
Hi Keith,
Great Idea!
I volunteer for the developer side (Mysql and C++)
I have written for php|mag previously, I'll put my hand up for PHP/MySQL
Kevin
--
Democracy is two
On 4/26/07, Mike OK [EMAIL PROTECTED] wrote:
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system.
Still, that leaves many other applications. Groups, gmail, reader,
news et al...
--
Kevin
for a single file I dunno, I would like to see
some benchmarks on this.
Kevin
--
Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
on the
right path.
http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html
Kevin
--
Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
table also will need to have some sort of mechanism so when a
deposit is taken from the customer, the referer is paid thier commission.
Am I going in the right direction here?
Kind regards
Kevin
--
Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb
using mysqlhotcopy and snapshotting the
tables to disk either on the master or the slave.
Has anyone done this and have they had any problems?
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
I have a puzzling situation where a query works, but only outside of a
function. If I try to abstract away some of the complexity by placing the
subquery inside a function, the db seems to get stuck in an infinite query
and the entire system becomes unresponsive (from the MySQL console I can
translate to MINUS. However, last I
checked, MySQL does not support (or has not yet implemented) the
MINUS operator. This Google finding might prove useful to you in
this endeavor (scroll to the last entry on the page):
http://www.terminally-incoherent.com/blog/category/mysql/
Kevin
--
MySQL
João Cândido de Souza Neto [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Could you try to put the start transaction into your .sql file.
Ok, I tried that -- same result. I even tried including the rollback in the
.sql file as well, but the changes are still committed afterwards. The
Greetings all, I am trying to track down the cause of some issues I'm
having. I am doing this from the mysql prompt:
start transaction;
source c:/queries.sql;
rollback;
When I examine the db though, it appears that the changes from the sourced
queries have been committed.
--
MySQL General
Just use XFS. it's a solve problem..
Kevin
On 3/8/07, Christopher A. Kantarjiev [EMAIL PROTECTED] wrote:
I'm setting up mysql on linux for the first time (have been using OpenBSD
and
NetBSD with UFS until now). The default file system is ext3fs, and I don't
mind
that, but it seems
keep all your
data encrypted and in the DB. And as I wrote this, colbey explains this
well in his email of 4:06p.
It seems to me that the point is to use the correct tool for the job at
hand. Computers have many tools, so no sense in turning everything into
a proverbial nail head.
Kevin
that I'd like to have to avoid.
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
On 2/24/07, Jean-Sebastien Pilon [EMAIL PROTECTED] wrote:
Hello,
I would like to get some of your input on file systems to use with
mysql. Should I use a journaling filesystem ? Should I choose a
different one based on what I store (log files, myisam dbs, innodb
datafiles, etc ) ? Is there any
A little birdie:
http://forge.mysql.com/wiki/Top10SQLPerformanceTips
notes..
In 5.1 BOOL/BIT NOT NULL type is 1 bit, in previous versions it's 1 byte.
Is this true?
I didn't see a note in the manual..
I assume it would be here
the bottleneck.
Thoughts?
I don't want to have to write anything because I'm amazingly lazy ;)
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
--
MySQL General Mailing List
For list archives: http
where all INSERTs go a *new* row
will be created.
Is there any way around this problem?
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
--
MySQL General Mailing List
For list archives: http
I thought about it I was actually going to use merge tables AND
partitions to split the underlying MyISAM tables across two disks and
then partition on top.
It's POSSIBLE to use partitioning the way I want it but I'm going to
have to grok it for a bit more.
Thanks though.
Kevin
On 2
Hm. Running on 4.1.21 seems to have a 'feature' where SHOW SLAVE
STATUS blocks when the disk is full. Thoughts?
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
--
MySQL General Mailing List
Hey.
I should have posted this hear earlier but it just dawned on me that
you guys could have some good feedback:
We've been working on the design of a protocol which would enable
promotion of a slave to a master in a MySQL replication cluster.
Right now, if a MySQL master fails, most people
We're trying to write a monitoring process for our master so that if a
table is corrupt it will raise flags which can then trigger
operations.
We can do the basic stuff such as asserting that the port is open and
that we can ping the machine but I want to test if any
INSERT/UPDATE/DELETEs are
Administrator does not in any way allow you to
login to a host with a shell account, root or otherwise.
--
Kevin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
favorite tool?
I've always found the MySQL Query Browser to be rather handy for
creating querying tables.
http://dev.mysql.com/downloads/gui-tools/5.0.html
--
Kevin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
size?
My Created_tmp_disk_tables is considerably lower than my Created_tmp_files
value. So it seems the Created_tmp_files cannott include the values from the
Created_tmp_disk_tables.
Kevin
- Original Message
From: Visolve DB Team [EMAIL PROTECTED]
To: Kevin Fries [EMAIL PROTECTED]; mysql
replication) we see counts for this variable in the tens
of thousands.
Thanks in advance,
Kevin
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
On 12/7/06, David Sparks [EMAIL PROTECTED] wrote:
Kevin Old wrote:
Hello everyone,
We have a 4 CPU master server running the 5.0.27 RPM x86_64 version of
MySQL with a mix of InnoDB and MyISAM tables.
We normally run at 1500 queries/per second and lately, the server will
all of a sudden
We have 16GB total, but are only using 8GB (according to mysql and our dbadmin).
Kevin
On 12/8/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
How much memory do you have on your system ? (the current setting in your
my.cnf could eat *a lot* of memory)
Thanks,
Jocelyn Fournier
these problems.
Thanks for your help,
Kevin
--
Kevin Old
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
provide my configuration if it is necessary, but was just
wondering if someone else might have experienced this and could
possibly point me in the right direction as to what might be causing
this.
Thanks,
Kevin
--
Kevin Old
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
back to MyISAM tonight and see if
that fixes it.
Thanks for your help,
Kevin
On 12/7/06, Michael Bacarella [EMAIL PROTECTED] wrote:
RAM too, how are you on RAM?
Obviously 100GB+ probably isn't going to fit in cache, but the usage pattern
during slower periods might be causing killer thrashing
What's the ETA for 5.1.13? There are a few critical bugs with NDB that are
fixed in this rev that I'd like to play with.
I'm hoping it's right around the corner :)
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415
they've dealt with this
task, and the pros and cons of their approach compared to mine?
Thank you in advance for your advice and suggestions.
-Kevin
Kevin Zembower
Internet Services Group manager
Center for Communication Programs
Bloomberg School of Public Health
Johns Hopkins University
111
repeated 8 times below.
Thanks, again.
-Kevin
=\
I originally wrote:
I have a database of publications in different languages. main
categories are organized into sub categories with baseitems of
publications. Each baseitem can be printed in one or more
possible and CONCAT the Y or N together.
Can anyone suggest where I'm going wrong in my attempts? Is there a
better way overall to produce this information?
Thanks in advance for your help and suggestions.
-Kevin
Kevin Zembower
Internet Services Group manager
Center for Communication Programs
FROM langversion AS lv
JO' at line 11
[EMAIL PROTECTED]:~$
-Kevin
-Original Message-
From: Chris Sansom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 12:45 PM
To: Zembower, Kevin; mysql@lists.mysql.com
Subject: Re: Requesting help
There was a thread before about this... this is much better than connector
J's load balancing.
You can take machines out of production, add thhem back in, it's MySQL slave
aware, etc
On 7/19/06, Christopher G. Stach II [EMAIL PROTECTED] wrote:
Kevin Burton wrote:
Hey Gang.
I wanted to get
Hey Gang.
I wanted to get this out on the list and facilitate some feedback.
http://www.feedblog.org/2006/07/announce_lbpool.html
I CC'd both lists because this might be of interest to the larger MySQL
community as the techniques I used here could be implemented in other
languages.
==
in order to run benchmarks, it is useful to be able to
clear the buffer cache. i'm using innodb. is there a
way to clear the buffer cache, i.e., something equivalent
to oracle's alter system flush buffer pool?
thanks,
kevin
--
MySQL General Mailing List
For list archives: http
would like to improve this.
I tried fulltext index on this field hoping that locate() will be faster,
but it dint make any difference. It would be great help if you could help
solve this problem.
thanks
On 6/24/06, John Hicks [EMAIL PROTECTED] wrote:
kevin vicky wrote:
Hi,
I am trying
is there a
special character set to use rather than the default? Also since the search
string will be between 30-50 characters is there any parameters to make the
index effective?
If my questions are not clear please let me know I will try to explain
better,
thanks,
Kevin
(like the
dash). Fat chance there is, but I thought I'd ask.
Hope this helps someone,
Kevin
--
Kevin Old
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 6/21/06, Barry [EMAIL PROTECTED] wrote:
Kevin Old schrieb:
Hello everyone,
I had a horrible thing happen to me this morning and wanted to make it
known to the community.
I needed to delete a record from a very large table (yes, it was
backed up) and like the cli interface of mysql. I
anyone have a solution?
Thank you for your time
Kevin Felix
[EMAIL PROTECTED] (e-mail)
[EMAIL PROTECTED] (MSN-Messenger)
ekefster (AIM)
use the same database though. Does it matter what
version phpinfo() is giving me?
Kevin Felix
Op 14-jun-06, om 05:18 heeft Dan Buettner het volgende geschreven:
Kevin -
You can start up the MySQL server without password protection using
the --skip-grant-tables option. Note
,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
If it hangs:
Sounds like there's nothing to read from the pipe.
What does 'cat mysql.pipe' print?
HTH,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this operation?
Kevin
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://www.feedblog.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
. The box would fail. Of course at this point its a bit
like pulling a SCSI cable out.
If this turns out to be a good way to scale MySQL someone could just
pay to have NBD enhanced to support fault tolerance with mirror nodes.
Thoughts?
Kevin
Kevin A. Burton, Location - San Francisco, CA
--no-data your_output_file.sql
And then import it:
mysql databasename your_output_file.sql
--
Kevin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 650 matches
Mail list logo