teful for any advice that you could give.
Thanks,
--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
or ETL 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"
To: "Shawn Green (MySQL)"
Cc: "Sydney Puente" ;
Sent: Wednesday, Novemb
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 row
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 with
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:
the 'path' 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\Bl
f you have 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 Co
and then pull only the appropriate data from the database at query time
> using JOINs.
This is closer to a better approach. That said, be more specific about
the problem you're trying 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]
gy "catches up" 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 Ge
where 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
erences is not helpful.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) NOT NULL,
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 Gener
data is absolutely a
bug, and a critical one.
A quick (< 3min) perusal of the bugs currently open did return any
meaningful results.
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ther to fixing the problem.
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:
should be done via 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]
unix socket, and ignoring your "-P"
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
--
nt to talk to someone about getting the right schema in
place, 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]
d data it takes to satisfy a query, it's actually better to
ignore the indexes and do a range scan of the table.
The point is that it isn't as simple as snap-your-fingers,-you're-done,
which I gather we both understand. I suggest again to the OP to do some
tests on /personal data set
n. Depending on the
DB (read: implementation) one could make this particular style 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 da
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.
o
single quotes ... ? Shouldn't 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, th
on normalization and
schema design. 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 pag
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]
ut it when 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]
-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'll know what *your* speed
gain/loss will be, is to do it and find out. 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 P
query-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]
/26/mytop-a-top-clone-for-mysql/
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem
rather than exactly what you're trying to do, we may 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-
nation of privileges you like.
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%'));
&g
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: htt
regards
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
iated 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 Mar
ers typically request the same 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.
--
x27;re
> selecting the child columns.
Im not sure I follow, the results should be those with id's of 1, 3, 4, 5, 6,
7, 8
and If I chose http://www.php.net that has only the keyword of "php" then the
results
would be 1,3,5, and 8
Kind regards
Kevin
--
"Democracy is t
p://www.redhat.com |
+-++---+
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 b
ecuted, but not the second time. What is the reason 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
ed with it. I would then like
to be able 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
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
--
M
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.co
(0.00 sec)
..
I've tested 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:
our time
doing something mundane.
In lieu of an example, I'll just 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]
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 tabl
ne you could get quite a savings. Anything
else that's repeated as well? IP's? Return codes?
Would be curious about 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]
NSERT ( 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 represen
hen 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
--
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, "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&#
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...
--
over 11,000 rows 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
ages and BLOBs. It should get you 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 M
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
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
ctrl-c
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 afterwa
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 Ma
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
the top priority, you'd better 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 in
bloat 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 an
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
http://dev.mysql.com/doc/refman/5.1/en/storage-req
ypto was really
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 Lis
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 Mailin
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.
K
table 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:
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 j
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 fai
MySQL 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]
s your 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.m
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
ent (which has 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
witch to the x86_64 version are we seeing 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]
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 Fo
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, th
them 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
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
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: fe
re are any other ways to store and access
multilingual data. Can anyone suggest other ways 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
C
ix
lines I 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
y AS m
JOIN subcategory AS s ON m.maincatid=s.maincatid
JOIN baseitem AS b ON s.subcatid=b.subcatid
WHERE
b.available = "Y"
ORDER BY m.title, s.title;
[EMAIL PROTECTED]:~$ mysql orderDB mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 12:45 PM
To: Zembower, Kevin; mysql@lists
m.title, s.title;
I think this demonstrates that the two subqueries are working.
What I'd ultimately like to do is produce a string like "YNNYYN" where Y
is printed if the language version of the baseitem exists (is not
null?). I was going to do this by creating a SELECT subquery for each
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 Ga
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
cution takes more than 30 seconds and I 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]> wro
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
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) an
if it contains a certain character (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]
r MySQL do all 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
ning without me getting access to the
server once again.
Does anyone have a solution?
Thank you for your time
Kevin Felix
[EMAIL PROTECTED] (e-mail)
[EMAIL PROTECTED] (MSN-Messenger)
ekefster (AIM)
s is actually a FAQ, with solutions in
> the manual
> <http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html>.
good luck,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al command but reading from
the new sql.fifo .
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:
rt
was pulled. 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 - Sa
e --add-drop-table --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 675 matches
Mail list logo
