he method we are using to bulk
insert into our tables. Works like a champ.
Don
-Original Message-
From: axis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 9:10 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: What's the best way to INSERT a long list of ema
es it work with '../../Customer_Data.csv'?
Axis
On 9/12/2006 10:22:01 PM, Don ([EMAIL PROTECTED]) wrote:
> Presuming your csv is set up in the structure of your table - this may
> help
>
>
>
> BULK INSERT tablename
>
> FROM 'C:\filelocation\my_d
fine if I have an exact entry but fails for a partial entry. For
example. If I have an entry where "Booking" is 'TSIN15' and I search on
the string 'TSIN15', it is found.
How can I get it to find a partial match if the string I enter is only
'15000
d, it will find all
instances of BOOKING with a '12345' in it.
Hence, partial matches
Thanks,
Don
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:31 PM
To: Don; mysql@lists.mysql.com
Subject: RE: Are partial searches possible?
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
-Original Message-----
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:40 PM
To: mysql@lists
t; mysqladmin -u root flush-privileges password "newpwd"
I get the error:
mysqladmin: unable to change password; error: 'Can't find any matching row
in the user table'
I think my user table is screwed up but how can I get in to fix it???
Worst case, do I just uninst
ms SET ItemHSCode = concat(substr( ItemHSCode, 1, 4 ),
substr( ItemHSCode, 6, 2 ), substr( ItemHSCode, 9, 2 ))
Thanks,
Don
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/1
UPDATE DocComms SET ItemHSCode = concat(substr( ItemHSCode, 1, 4 ),
substr( ItemHSCode, 6, 2 ), substr( ItemHSCode, 9, 2 ))
Thanks,
Don
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/1
This is my configure line;
setenv CFLAGS "-O3"
setenv CXX gcc
setenv CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/lycra/homes/fike/bugz/mysql --enable-assembler --with-
mysqld-ldflags=-all-static
Then I run gmake and the following error is reported. It se
ude/sys/types.h:349: previous declaration of `pthread_t'
Any help greatly apprectiated,
Don [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
?
Thank you,
Don
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
Hello,
Due to some recent headaches I have decided to come out of the dark ages and
upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was wondering if anyone had
any upgrade tips and/or precautions to recommend before I start.
Thanks,
Don
[EMAIL PROTECTED
13, 2002 4:04 PM
+To: Don
+Cc: [EMAIL PROTECTED]
+Subject: Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
+
+
+In the last episode (Aug 13), Don said:
+> Due to some recent headaches I have decided to come out of the dark
+> ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51.
se
in an inconsistent state (partial transaction).
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
read the manual"
However, if the user is in isolation , the user will be more apt to read the
manual more carefully as they are not guaranteed of getting voice/List
support.
Don
-
Before posting, please check:
http:/
Good idea
Quentin Bennett wrote:
> Perhaps, along with the 'Please check the manual' message at the end of all
> messages, there should be a reference to a reliable archive, allowing list
> users who are referred to the archive an easy way of finding it!
>
> Quentin
>
> > -Original Message--
The link contained in the coumentation, http://dbimysql.photoflux.com/,
leads to page that points to a non existant link.
So.I HAVE checked the docs before asking. I require more
information on using the Perl API with my mysql than perldoc DBD:mysql
provides. Any links would be appreciated.
You have to remove yourself
Jenny Lie wrote:
> Hi, Please remove my name from the list. Thanks!
>
> Jenny Lie
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mys
I'm stilllooking for documentation to see what this code does and if it
does what I want.
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
should probably also have a look at the REPLACE INTO command
> to see if this does what you need.
Yes, I believe it will but as I am used to programming with Non-SQL
databases, I am also used to replacing only those fields that I specify
within a record meaning everything but t
> Don wrote:
> >
> > > > Prior to updating, I want to search the table to see if my Key exists.
> > > > That way, I can add it or just update the associated fields. How do I
> > > > tell my script which Index file to use? I can't seem to find th
ot;);
$sqlCmd->execute();
Where '$port' is a scaler variable.
If the record exists, I suppose I can do an INSERT. If not, I'll do an
UPDATE. I can't seem to find the code/function to check for this simple
test.
Thanks,
Don
---
7; at myprog.pl
line 164.
Ports is my table. "GERMANY" is actually the contents of the scaler
array $country, so why is it giving me an unknown column error?
Thanks,
Don
-
Before posting, please check:
http://www
names are not
null. MySQL is reporting a syntax error. What is the error please?
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi all,
The compiler is reporting a syntax error in mySQL statement near the
WHERE clause. Help. Perl code is as such:
$sqlCmd = $dbh->prepare (q{
UPDATE Sailings
SET SailPort = ?,
SailDate = ?,
Deleted = ?,
WHERE Vessel = ? AN
nce. Will MySQL scan through
the entire table or will it utilize the index and quickly delete all
record with the above statement?
If the former, what would be an efficient and quick way to delete
records of a partial key?
Thanks,
Don
--
rying with "mysqladmin | more" but no success and I
don't see any examples in the manual. Example of what I tried was:
mysqladmin my_db my_table | more
but all I get is:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'webmail@
Hi,
Is there a quick and simple way to change the name of a Table that is
contained within my database?
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
nning
with "A" all the way through "Z") but rather in the order they were
entered.
So, it seems to me that indexes are only used for querying. If I run
through the data or issue the above SELECT statement, how do I display
my rows in Primar
kup < pswd
(pswd contains the password)
In each case, I still get prompted for the password. How can I automate
this so that is accepts the password that I include. I guess what I am
looking for is the proper syntax or a neat trick.
Thanks,
Don
properly
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-passw
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST ("9640")
When there are entries in the Filename list that have 9640 in them?
I'm using MySQL 5.1.11.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
I just deleted and re-created my indexes and the query works now... I guess
the index got corrupted somehow. Strange that I never saw any indications of
this in messages, just that 0 rows were returned.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday
.
A link to a previous thread or documentation on this would be fine. I don't
mind doing the reading - but my Google search seems to turn up more info
about multi-table deletes than inserts. I realize that MySQL doesn't
support a single multi-table insert function, but are the two appr
I'm installing MySQL 4.1.14 on a new Gentoo box. When I try to connect
to the mysqld daemon, it crashes and restarts itself, which just doesn't
seem right. I enter these commands:
cd /usr; /usr/bin/mysqld_safe &
mysqladmin -u root password 'foobar'
and get this response:
mysqladmin: connect
don't seem to be any symbols in
the executable:
# nm -n /usr/sbin/mysqld
nm: /usr/sbin/mysqld: no symbols
Nor is there a file anywhere on the system named mysqld.sym.gz.
--
Don Doumakes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only
4.0.7 or some such older version.
Thanks!
-Original Message-
From: Julian C. Dunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 9:39 AM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject:
Hi all...
I have some OLD programs I don't have the source for that were built with
the MySQL 3.23.55 client libraries. They still work great, even when using
those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in
the new lib dir)
However, is there some way I can build a 3.
7;$baz%'";
// then test, case by case, to see if you need more selection clauses:
if (! empty($area))
$qry = andclause($qry, 'area', $area);
if (! empty($interest))
$qry = andclause($qry, 'interest', $interest);
echo '', $qry, '&#
> the NULL handling syntax.
>
> If you are wondering who Codd is I can anticipate you that he invented the
> things we are talking about
> (http://en.wikipedia.org/wiki/Edgar_F._Codd)
>
>
> Cheers
>
> Claudio Nanni
And Claudio for the WIN!
--
Don Read
ion is that the query runs faster the second time around but i dont
> > have ...
> >
>
> --
> A: It reverses the normal flow of conversation.
> Q: What's wrong with top-posting?
> A: Top-posting.
> Q: What's the biggest scourge on plain text ema
CT ... FROM MSSQL_table WHERE seen='GET';
INSERT INTO MySQL_table ...
UPDATE MSSQL_table SET seen='GOT' WHERE seen='GET';
lather, rinse, repeat.
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So
.
When the user logs in, it scans all the 'en' (english) tokens and stores
it in a PHP array('Day' => 'Day', 'Total' => 'Total' ...
Once you figure out the user's locale (either from a user table or
parsing the http headers) you re-sc
sing old IPs.
>
> So how to resolve this problem?
> Thanks for my newbie questions.
> Merry Holidays!
>
> Eva.
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
"UPDATE noticed='sca
On Sat, 26 Dec 2009 10:43:55 +0800 Eva said:
> 2009-12-26 2:36, Don Read :
>
> >
> > Change noticed to enum('new', 'scan', 'done') not null default 'new';
> >
> > When proc two runs, it should
> > "UPDATE noticed=&#
uot;, "Extra-small", "'aqua:7FFFD4', 'blue:99'");
>
INSERT INTO products ...
..., ('aqua:7FFFD4', 'blue:99'));
http://dev.mysql.com/doc/refman/5.0/en/set.html
Regards,
--
Don Read
ELECT name FROM students [ORDERED BY ...]';
$res = mysql_query($qry);
for ($cnt=0; $cnt < 5000; $cnt++) {
$row = mysql_fetch_array($res);
$div1str .= '' .$row['name'];
}
while ($row = mysql_fetch_array($res))
$div2str .= '' .$row['name&#x
ction side, and then:
>
> mysql -h test_db_server -h user -pPASSWORD database < /tmp/db.sql
...
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that
This seems like a topic that must have been studied, but I'm having
trouble figuring out what to search for in Google, since the usual
discussion of sql injection is not what I'm looking for here.
If anyone knows of references that discuss the issue, I'd like to
see them. I'm also interested in a
Adam Alkins writes:
> Sounds like you just want to GRANT access to specific tables (and with
> limited commands), which is exactly what MySQL's privilege system does.
How about this part?
> > Finally, suppose I want to limit access to the table to the rows
> > where col1=value1. If I just add
Daevid Vincent writes:
> For the love of God and all that is holy,
> do NOT put the user/pass on the URL like that!!
What's so unholy (or even unwise) about it?
> Or use "mod_auth_mysql" to maintain your 'authorized' users to your page.
Why is this so much better?
In my case it's worse ca
Daevid Vincent writes:
> > > For the love of God and all that is holy,
> > > do NOT put the user/pass on the URL like that!!
> > What's so unholy (or even unwise) about it?
> Oh my goodness, where to begin...
> Well barring the fact that it'll be in the user's cache and browser
It won't b
Raj Shekhar writes:
> One option here might be to use "mysql proxy" as a man-in-the-middle and
> filter out unwanted queries...
This seems more or less the same as what I'm doing now with php.
The same question applies there - what would you look for in your
filter?
--
MySQL General Mailing Li
d,
regardless of the combination I use, invalid relationships come back
as NULL - need to return 0 so I can use it in a math formula.
Probably simple - maybe ;-)
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
nsactions WHERE
transaction_id IN ((select group_concat(payment_id) from
tl_trans_pmt_items where inv_id = 1033911)) AND client_id != 251719
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
Don
--
MySQL General Mailing List
For list archiv
be exported or printed? Graphs would be nice, too.
I know I can build this from scratch, but would rather get a hold of
something already pre-built (open source or shareware) to save me a
bunch of coding time.
I appreciate any feedback you can offer!
Don
e where the COUNT of appointments (in
the entire tl_appt table) LESS THAN the stime > 0
I am sure I need a multiple select query, but I am having a hard time
wrapping my head around it.
Thanks for any feedback.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ient_id = 161
AND user_id != 503 AND appt_status_id = '3' AND
FROM_UNIXTIME(time_start,'%Y-%m-%d') between '2012-01-01' and
'2012-05-20';
dr_not_ther_qty = 2
SELECT count(*) as dr_all_ther_qty FROM tl_appt WHERE client_id = 161
AND appt_st
4 ---
SELECT count(*) AS dr_all_ther_qty FROM tl_appt LEFT JOIN tl_rooms r
on r.room_id = tl_appt.room_id WHERE client_id = '254023' AND
r.location_id = '1' AND user_id = '506' AND appt_status_id = '3' AND
time_start > '1321903800'
--- end query 4 ---
Don Wieland
D W D a t a C o n c e p t s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
arlier with ANY user, those appts can be earlier
than the start of the date range.
If they have a count of ZERO appts prior to the earliest appt within
the date range, the are a NEW CLIENT else a FORMER CLIENT.
Any assistance would be appreciated. Thanks!
Don Wieland
--
MySQL Gene
how many emails my server can send per hour.
They recommended I find a 3rd party service provider with support PHP
API connections.
My budget is limited. Does anyone have any suggestions of companies
that might work for my scenario?
Any feedback is appreciated ;-)
Don
--
MySQL General
for the work they do on the site ;-)
If you are interested, please contact me PRIVATELY and include a few
examples of your work (websites,etc...). Thanks.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
contact me, privately, if you can assist. I am located in California,
USA (PST). Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
:= a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
EIF NEW.content_asset_type_code = 'VIDEO' THEN
INSERT INTO videos (content_asset_id) VALUES (NEW.id);
END IF;
INSERT INTO content_asset_statistics (content_asset_id,
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from
content_asset_statistic_t
rst_name
INTO OUTFILE '/tmp/1_2031305738.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"']
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
o resolve this issue asap.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
@'localhost' to database
'teal1dwd_teal'
Do I need to perform this query in a different place? Sigh…
Don
On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote:
> "into outfile" is *not* a db-specific permission
>
> http://lmgtfy.com/?q=mysql+permissions+into
eath ;oP
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
Hey gang,
I need a few hours of support from a LAMP developer to resolve a few issues via
TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can
offer this to me, please contact me PRIVATELY. Please include your support
hourly rate.
Thanks!
Don Wieland
d
This is using version: 5.0.18-log on linux.
I have a stored procedure that takes .2 sec the first time,
12 the second, 12 the third. The data is unchanged.
The relevant part of the procedure looks like this.
...
drop temporary table if exists temptab;
create temporary table temptab (index (
I have a customer that loaded up a HUGE table and was doing all sorts of
fancy stuff in it, and not waiting for the process to finish before sending
the same query, and eventually loading up the server to the point where the
only thing I could do was unplug it.
Is there a way to prioritize or set
er [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
> Is there a way to prioritize or set the amount of resources t
Nevermind on the "badly formatted number"... I specified the full path
/usr/bin/nice and it worked ok this time :-)
However, I still want to know if there is a way to specify a nice level for
an entire users processes.
Thanks!
-Original Message-----
From: Don O'Neil
x27;top' still shows his processes (old and new) with a nice of 0.
Is there something else I'm missing?
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mys
g one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
D W D a t a
id = 730 AND ht.tr_date BETWEEN "2015-01-01 00:00:00" AND
"2015-12-31 23:59:59"
GROUP BY ht.`transaction_id`
ORDER BY ht.tr_date DESC, ht.rec_code ASC;
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
the SUM I need is on the JOIN relationship -
results should be:
1,Banana,3
2,Orange,5
3,Melon,6
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
(a.time_start) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don Wieland
D W D a t a C o n c e p t s
= a.client_id
GROUP BY a.client_id
HAVING max(a.time_start) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don
te, "%M %Y") AS mo_label FROM
tl_items_classes ic
LEFT JOIN tl_items i ON ic.item_id = i.item_id
WHERE i.active = 1 AND ic.cl_cancelled IS NULL ORDER BY ic.cl_date ASC;
Any help would be appreciated.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
ot;Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
ot;Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
99'
We are trying to find Former Clients who have not been seen after the date
range - Lapsed Client Report
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
y may show up
somewhere I don't want them?
Is there a way to do this, does it work and I am missing something?
Thanks,
Don.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
by creating a new select
statement and running it.
It seems this is not possible if the framework tries to use a single
global connection to the daemon, yes? no?
Can another connection be made?
thanks,
Don.
---
[EMAIL PROTECTED] wrote:
The parent-child type of query you want to make is
34
050423 12:07:20 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050423 12:07:20 mysqld ended
--
Don
Vaillancourt
Director of Software Development
WEB
IMPACT INC.
phone: 416-815-20
umented? Am I missing something obvious? I have a lot of tables I
expected to behave the same way as they did in prior releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
x27;t been
documented? Am I missing something obvious? I have a lot of tables I
expected to behave the same way as they did in prior releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
7;tab' ?
>
Does it have to be a SELECT? Or just a NO-OP?
SET @nothing=0;
-or-
DO 0;
- or -
SHOW TABLES LIKE 'asdfzxcv1234';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
ste
ow: 0
Any ideas?
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Heikki,
Heikki Tuuri wrote:
Don,
it is the assertion below which fails.
Do you use FOREIGN KEY ON UPDATE CASCADE?
Nope.
Do you have any idea which query causes the crash?
I didn't, but after Googling for similar problems, I found a thread
where you had talked about a bug
Hi Heikki,
Thanks so much for taking the time to look into this. No wonder you
have such a great product.
When 4.0.17 comes out, I'll certainly test it.
Thanks again,
Don
Heikki Tuuri wrote:
Don,
I believe I found the bug.
"
MySQL/InnoDB-4.0.17, December xx, 2003
* Fixed a b
reciated...ohh in a forum it was
suggested to use the --skip-grant-tables option...but I am not sure what
the command variables would be...
Thank you,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7;@'localhost' = PASSWORD 'xx'
This is exactly how I typed it in...(just copied and pasted)
When I hit enter with that password...I just get a prompt...no
confirmation the password was accepted or anything.
Did I type in the command for the pass wrong?
Don
-Original Mes
Thanks all for the help...thats what it was...the ;
Now I need to tighten up the security on it...I am going to install
phpmyadmin...
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rough socket
'/var/lib/mysql/mysql.sock' (2)
[EMAIL PROTECTED] root]#
(p.s. x's are me hiding my ip address)
Any thoughts?
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 456 matches
Mail list logo
