We're talking about a Windows machine, right? I don't have any of
those these days but it sounds to me like it didn't thoroughly
uninstall.
If that much is correct, I'd first be suspicious of junk left in the
registry or data directories. Even if it meant I had to install it
again, I'd use a sep
Aha! You are precisely correct. Thank you!
On 3 October 2010 21:16, Dan Nelson wrote:
> In the last episode (Oct 03), George Larson said:
>> I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free'
>> of '3896508416'. If I'm
Hello all.
I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free'
of '3896508416'. If I'm correctly understanding what I've been
reading, those are good conditions to optimize the table. I
understand the part where it maps to 'ALTER' for InnoDB. However,
nothing I do seems to aff
Willy Mularto wrote:
> Hi,
> I got this result on InnoDB Buffer Pool Status:
> Free pages1
> Dirty pages 2,040
> Pages containing data 31,359
> Pages to be flushed 457,083,205
> Busy pages1,408
>
> Read requests 31,348,288,497
> Write requests7,913,407,934
> Read
Uwe Brauer wrote:
>
> What I had to do in addition was to copy the ibdata1
> *then* I recovered the content of the db.
>
> Thanks a lot
>
>
> Uwe Brauer
>
Uwe,
Congratulations! That's great news! Sorry I didn't know to mention
that step. Where is your 'ibdata1'? Mine is in '/var/lib/mysql' so
Johan De Meersman wrote:
> On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent wrote:
>
>> You do know you can use ssh tunnels and such to connect to your server from
>> your desktop right? I do it all day long. It's pretty easy to do and built
>> in to these programs.
>>
>
> You can't multi-jump, t
Carlos Mennens wrote:
> On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent wrote:
>> Get this tool: http://sqlyog.com/ it rocks.
>>
>> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
>
> I can't use any graphical or 3rd party add-on's. I was hoping MySQL
> had this native /
Daevid Vincent wrote:
> Get this tool: http://sqlyog.com/ it rocks.
>
> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
>
>
Alternatively, there is MySQL WorkBench. Some of the guys around here
use SQLYog but, since it is a LAMP environment, I like that WorkBench is
Shawn Green (MySQL) wrote:
> On 9/10/2010 10:01 AM, george larson wrote:
>>
>> Uwe Brauer wrote:
>> ...
>> The only one I know of, for my environment, is /etc/my.cnf. I believe
>> that it can be located elsewhere but you could just use 'find' to find
&
file, when it
> does not exist, since you just deleted everything?
>
> anyway, I hope I missed the joke here, or missed something...
>
> Steve.
>
>
> On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
>> We do nightly backups at work just by taring the mysql
Uwe Brauer wrote:
>>>>>> On Thu, 09 Sep 2010 18:02:09 -0400, George Larson
>>>>>> wrote:
>
>> We do nightly backups at work just by taring the mysql directory. In
>> my environment, that is /var/lib/mysql.
>
>> Lik
Hi all. I've got a greenhorn question but I didn't find the right
keywords to get Google to answer it for me.
Is it more efficient to put conditions in a JOIN instead of sticking
them all at the end in the WHERE clause, or is that just a matter of
preference? Putting conditions in the JOIN It se
We do nightly backups at work just by taring the mysql directory. In
my environment, that is /var/lib/mysql.
Like this:
service mysql stop
cd /var/lib/mysql
rm -rf *
tar zxvf file.tar
rm -rf ib_logfile*
chown -R mysql.mysql
service mysql start
Something similar might work for you. Somebody wit
UUdate IS NULL
GROUP BY UUid;
) as sub;
In this case, the field 'previous' is the UUid that I want to copy the
UUdate from and sub.UUid is where I want to copy to.
Does that even make sense?
Thanks,
George
Hello,
I have a quite loaded server with bin-log enabled. I'd like to disable
binary logging globally not for a single session without restarting
mysql. Is it possible? Any input is appreciated.
Best Regards,
George
--
MySQL General Mailing List
For list archives: http://lists.mysq
http://www.mydebugger.com/whatsnew.php
Thank you for your interest.
--
Best regards,
George Schmidt,
http://www.mydebugger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
You can also use HeidiSQL, another free tool to visually manage and export
structure/data etc (and a whole host of other stuff) I use it to manage
windows and linux hosted databases.
George
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: 08 April
gards,
George Schmidt,
http://www.mydebugger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
...@logicworks.net]
Sent: Wednesday, May 20, 2009 4:13 PM
To: TETTERTON George; mysql@lists.mysql.com
Subject: RE: Starting MySQL in Maintenance mode
Do 'service mysql restart --skip-networking'
This prevents all TCP/IP connections
You can login as r...@localhost and the client program will use the
s
equivalent for MySQL?
George Tetterton
Alcatel-Lucent
3400 W. Plano Pkwy
Plano, TX 75075
Office: 972-477-1571
Cell: 972-400-0887
Email: george.tetter...@alcatel-lucent.com
mailto:george.tetter...@alcatel-lucent.com>
Yahoo Messenger ID: george_tetterton
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
>> Now I did create that new database called 'forums' and would like to
>> create a new user who has access only to that specific database from
>> localhost. I can't seem to find the
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
>> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>>> All user information is stored in the mysql database. If you want to
>>> see a list of users that have been created, que
I'm quite a distance from the best person to answer this question but MySQL
has weekly webinars and there are a ton of good tutorials on the web.
I started with WAMP (LAMP, MAMP and XAMP are suitable alternatives) and just
started reading tutorials. Then I went to the local discount store and got
Yeah! No kidding. If IBM doesn't pick it up then maybe I will. ;-p
On Wed, Mar 18, 2009 at 12:30 PM, Lin Chun wrote:
> Sun only worth 6.5 billions?
>
> --
> -
> Lin Chun
>
I am new to MySQL administration, and must devise a backup plan, I have read
the manual but still want to know if I am understanding and applying the
principals correctly, please let me know if you have a better way, or if I
am wrong somewhere, my main question is regardng the locking of the databa
This was a faulty disk after all. I just did not see any errors, when
running smartd. However, they showed up when looking on the system
log.
I am currently replacing the disk.
Thank you,
George Crewe
On 8/3/07, George F. Crewe <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> I
//dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
I check my disk with smartd utility and it passes the test.
I do not know where to look. Any help will be greatly appreciated.
George Crewe
I'm seeing:
innodb.comHere are some
related websites for:
innodb.com
Sponsored Links
MySQL database designData
t; the first script commit to the database or rollback ?
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-isolation.html
--
George-Cristian Bîrzan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
information_schema table,
> however, I don't get a consistent reading.
> executing it multiple times, I get multiple numbers. (and no, the table
> is static already, no updates/deletes etc)
That's a guesstimate if using InnoDB. Works for MyISAM...
--
George-Cristian Bîrzan
--
MySQL G
> created) and I then restored the data from a dump.
Well, the thing is... There is no dump. Or rather, what we have is
rather old... :-P
--
George-Cristian Bîrzan
Network Engineer
___
RCS & RDS Constanta
Tel.: +40341.400.401 / +40341.400.402
Fax: +40
ere is no way to do this in MySQL, does anyone have any
> innovative suggestions as to how I could work around the problem? The
> table is very large, so solutions involving multiple copies are tricky
> to implement.
Convert the table to InnoDB, which uses row level locking, as opposed t
I can
get the disk space down to a more manageable capacity.
The previous DBA had told me that the last time he purged the logs, it
took it several minutes - but I can only assume he tried to purge too
much at once.
Thanks again!
--
George
>-Original Message-
>From: Dan Buett
On Wednesday 18 October 2006 23:36, Dan Buettner wrote:
> George-Cristian - is it possible that the *.frm files also got moved
> about??
Nope. What I'm thinking is the logs got moved, server restarted, it created
new ones and...
--
George-Cristian Bîrzan
Netwo
f I were to add 'expire_logs_days 45' to my.cnf and restart mysql, is
mysql going to attempt to purge the logs
> 45 days old and if so... how long does it typically take. We cannot
afford to restart if its going to take
any significant amount of time for it to purge the logs and restart
TECTED]
> > Sent: Wednesday, October 18, 2006 2:16 PM
> > To: George-Cristian B�rzan
> > Cc: mysql@lists.mysql.com
> > Subject: Re: InnoDB messup
> >
> > Can you just put the files back where they were originally?
> > Ordinarily that would be in the path s
s, is there a way to fix this?
(Well, I have the .MYD and .MYI from back when the table was MyISAM, but I
lack the .frm, and using an older one makes MySQL segfault...)
--
George-Cristian Bîrzan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
m what the previous admin who I inherited this from says, this
locks up the whole database while its purging the logs.
Are there any low-impact solutions?
This is a fairly high traffic DB, so locking up the database really is
not an option.
Thanks!
George Law
glaw at ionosphere.net
--
MySQL Gener
Thought this might be of interest to some on the list:
http://www.oreilly.com/catalog/hpmysql/chapter/ch07.pdf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
show processlist gives you an abbreviated list of queries.
show full processlist gives you the full queries.
>-Original Message-
>From: Feliks Shvartsburd [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 03, 2006 1:57 PM
>To: mysql@lists.mysql.com; [EMAIL PROTECTED]
>Subject: Questio
",?" : "?") for (@results);
my $sth2 = $dbh2->prepare("INSERT INTO table2 values
($placeholders);");
$sth2->execute(@results);
$sth2->finish;
}
$sth1->finish;
$dbh1->disconnect();
$dbh2->disconnect();
George Law
[EMAIL PROTECTED]
MSN: [EMAI
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL
damn outlook!
fire up perl's CPAN interface:
perl -MCPAN -eshell
cpan> i /mysql/
...
Bundle Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz)
...
cpan> install Bundle::DBD::mysql
>>>-Original Message-
>>>From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
>>>Sent: M
someone correct me if I am wrong.
DBI is the generic database interface module for perl
DBD::mysql is the mysql specific module DBI relies upon to talk to mysql.
cpan> i /mysql/
>>>-Original Message-
>>>From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
>>>Sent: Monday, September 25,
Hello,
My name is George and I'm from http://www.hikingforums.net/.
While visiting your site I have noticed that you are collaborated with other
sites, and I wish to invite you to work with my website as well.
If you can support Hiking Forums by adding a link to your site, I'll be
crname` char(50) default NULL,
`call_dest_custid` char(20) default NULL,
`call_zone_data` char(20) default NULL,
`calling_party_on_dest_num_type` int(1) default '0',
`calling_party_from_src_num_type` int(1) default '0',
`original_isdn_cause_code` int(1) default '0&#
l Message-
>>>From: Jay Pipes [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, August 30, 2006 1:44 PM
>>>To: George Law
>>>Cc: mysql@lists.mysql.com
>>>Subject: RE: Degrading write performance using MySQL 5.0.24
>>>
>>>What type of data are
er get a solid
answer.
If I disable the keys, do the import, then re-enable the keys, it takes
just as long,
if not longer.
I have just about given up on finding a solution for this and just
rotate my tables out
regularly once the imports take over 5 minutes to process roughly 10,000
records
--
Love it when that happens :)
Fastest way I can think of is dumping out the structure of the database
with mysqldump -d > database.sql
and then searching the output to see where those columns appear
>>>-Original Message-
>>>From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesd
idth char fields.
So, I am eager to see if this sorting idea helps any.
--
George
>>>-Original Message-
>>>From: Dan Buettner [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, August 18, 2006 3:53 PM
>>>To: George Law
>>>Cc: MYSQL General List
&
r [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, August 18, 2006 1:40 PM
>>>To: George Law
>>>Cc: MYSQL General List
>>>Subject: Re: sorting datafile for "load data infile"
>>>
>>>George, I've not heard of that technique - "sorting
89628873 |
| 008bbf9dc9691110800100201c00edff | 89627287 |
Any suggestions on exactly how to sort those fields before
Thanks!!!
--
George Law
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mark,
Perfect! Thanks!!
I altered my table to specify ZEROFILL and that did the the trick.
--
George
>>>-Original Message-
>>>From: Mark Leith [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, August 09, 2006 3:56 PM
>>>To: Jonathan Mangin
&
ery does not work, butselect * from table where
concat(npa,nxx,station)=800123123
does.
TIA!
--
George
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sure how this would work with an array (mod_type[]).
PHP might treat
the hidden field as index 0, and if the checkbox is checked, it would be
index 1
-
George
>>>-Original Message-
>>>From: Nicholas Vettese [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, July
I think if you do it as a enum field, it shows as a checkbox in phpmysql
define it as enum 'Yes','No'
>>>-Original Message-
>>>From: Brian E Boothe [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, July 25, 2006 11:07 AM
>>>To: mysql@lists.mysql.com
>>>Subject: yes or no checkbox
>>>
>>>kn
Just a shot in the dark...
how about : \T /home/karl/sql_log_$$
I believe, in bash, $$ will give you the pid of the process, so you
should
get a unique (somewhat) file name every time
>>>-Original Message-
>>>From: Karl Larsen [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, July 11, 2006
SELECT max(id) FROM menu_links
:)
> -Original Message-
> From: Mike Wexler [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 29, 2006 1:22 PM
> To: Mike
> Cc: mysql@lists.mysql.com
> Subject: Re: MS SQL TOP Replacement
>
> Mike wrote:
> > I have a SELECT statement for MS SQL that is
> >
I had to do some disk space recovery mysql last month...
I have backed up some of the raw .MYI, .MYD files and deleted them from
the data directory. Running 5.0.18, I had to shut down mysql and
restart before it freed up the space.
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+---+
| 1/666 |
+---+
| 0.00 |
+---+
mysql 5.0.18:
select 1/666;
++
| 1/666 |
++
| 0.0015 |
+----+
George Law
> -Original Message-
> From: Chris W [mailto:[EMAIL PROTEC
(unix_timestamp(NOW()) - 1148492137)/60;
+-+
| (unix_timestamp(NOW()) - 1148492137)/60 |
+-+
|2.32 |
George Law
> -Original Message-
> From: Brian Menke [mailto:[EMAIL PRO
more than likely someone is harvesting emails off groups.google.com
http://groups.google.com/group/mailing.database.myodbc
Your posting shows top of the list :)
George Law
> -Original Message-
> From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 24, 200
there is also a nice tool for Mac OSX called CocoaMySQL.
http://cocoamysql.sourceforge.net/
George Law
> -Original Message-
> From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 23, 2006 3:58 PM
> To: Rithish Saralaya; mysql@lists.mysql.com
> Subject:
I ran into this same type of question the other evening at a local
linux group.
I think that once you reach the end of the results set the only way to
start back at the beginning of that results set is to do the query
again.
Once option - do your query and grab all the rows
load them into a dat
Nicholas,
just found something on google:
"In general, this cannot be done. Default values cannot be the return of
a
MySQL function (as much as I'd love to use NOW() for default values!).
However, there's one loophole. When inserting, not specifying a value
for
the first timestamp field in a ta
try a search for "old_password"
-Original Message-
From: Amer Neely [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 1:39 PM
To: MySQL List
Subject: MySQL 5 / phpMyAdmin
I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin
2.8.0.3 is now giving me grief. It giv
$query = "INSERT INTO staffs (firstname, lastname, signin) VALUES
('$firstname', '$lastname', NOW())";
I think if you alter the table and set a default value on signin to
NOW()
ALTER TABLE staffs CHANGE signin signin DATETIME DEFAULT 'now()' not
null';
then you could just to :
$query = "INSE
Johan,
have you thought about doing this incrementally?
ie - 25% at a time x 4
to show something for NULL, you can use the
COALESCE function.
ie - COALESCE(column,'nothing')
--
George Law
VoIP Network Developer
864-678-3161
[EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
-Origin
I think what he is saying is that be began the "transaction" in a
command line client
session from one location but was not able to give the
> mysql> SET FOREIGN_KEY_CHECKS = 1;
> mysql> COMMIT;
commands in the same session. (ie - I owe, I owe, its off to work I go
:) )
This is a good questi
DOH!
Sorry - I totally misread the question!
A quick google for "rename database" shows Adrian is correct!
-Original Message-
From: Adrian Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 9:51 AM
To: George Law
Cc: Hardi OK; mysql@lists.mysql.com
Subject:
Hardi
I rotate tables out on a monthly basis. The way I do it is:
rename table1 to table2
If you need a new copy of table1, you can do :
create table table1 like table2
--
George
-Original Message-
From: Hardi OK [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 11:19 PM
try :
select . into outfile '/tmp/t3.csv' FIELDS TERMINATED BY ',' LINES
TERMINATED BY '\n' from table where .
This will create a file in the /tmp directory on the DB server itself
this doesn't do the column headings and your output file cannot already
exist.
-Original Mess
try:
group by substring(timeofclick,1,10)
-Original Message-
From: Randy Paries [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 11:25 AM
To: mysql@lists.mysql.com
Subject: Help with this query. How to do a group by on a datetime just
the month/day/year
Hello,
Not sure if i ca
Shawn,
Perhaps :
UPDATE TABLE_NAME SET FIELD4 = concat(FIELD1,FIELD2);
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 9:33 AM
To: Mysql General (E-mail)
Subject: UPDATE question
If I have 4 Fields (FIELD1, FIELD2, FIELD3 &
perl ?
just quickly throwing something together - this is untested.
$done = 0;
$count = 0;
while ($done) {
$dbh->do("analyze table t1");
my $info = $dbh->{mysql_info};
if ($info =~ /some kind of error message/) {
$dbh->do("repair table t1");
my $info2 = $dbh->
- chances are its just a flat file - try
opening it in
A text editor.
If the file command reports "data" - then it is probably some type of
database file.
Just a thought :)
--
George
-Original Message-
From: Pedro mpa [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2
'\n' works for me in the command line client
select concat('Co: ABC','\n','Acct: 123','\n','Drive: Summer Special');
+-+
| concat('Co: ABC','\n','Acct: 123','\n','Drive: Summer Special') |
+---
After you give the query, try :
echo mysql_error()."".mysql_info();
This way, you should be able to see exactly what error is coming back
from PHP/MySQL
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:55 PM
To: Jay Blanchard; mysql@lists
This brings up a question I was asked...
Which is more efficient?
Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd
hh:mm:ss'
Or
Select . where unix_timestamp(date) between
unix_timestamp('-mm-dd hh:mm:ss') and unix_timestamp('-mm-dd
hh:mm:ss')
PHP is picky on what can and cannot be in quotes... I get this all the
time.
Try :
$sql = "INSERT INTO addvalue (`value1`, `value2`,
`sumfeild`) VALUES ('".$value1."', '".$value2."', '".$sumfield."')";
$result=MYSQL_QUERY($sql);
I think part of the error had to do with you missing a ) at the e
Mike,
Maybe :
LAST_DAY(date)
Takes a date or datetime value and returns the corresponding value for
the last day of the month. Returns NULL if the argument is invalid.
mysql> SELECT LAST_DAY('2003-02-05');
-> '2003-02-28'
mysql> SELECT LAST_DAY('2004-02-05');
-> '2004-02-29'
m
You should be able to pull each table (create + inserts) out into a stand
alone file
table1.sql
table2.sql
etc...
and then you can restore table by table.
This might be harder depending on the size of your database tables. If you
have a million rows, chances
are your .sql file is huge and it
Movable Type + OSXServer + MySQL issues.Miles,
David is correct - DBI isn't installed in OSX by default.
check out http://www.brandonhutchinson.com/installing_perl_modules.html for a
brief into
on installing from CPAN.
Make sure you do this as root or through sudo
--
G
mysqldump has a -w option:
-w, --where= dump only selected records; QUOTES mandatory!
--
George
> -Original Message-
> From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 02, 2006 12:30 PM
> To: 'MySQL general mailing list'
> Subject: du
ill change a single
quote ' to a double '' so its mysql safe. Then when it reads it
back in from the database
and renders the HTML, it also displays the doubles.
If you look in the database iteself from the mysql command line client
do the double quotes show?
--
George Law
Is your mysql server listening just on localhost (127.0.0.1)?
That is differnet than 192.xxx.xxx.xxx
> -Original Message-
> From: Xiaobo Chen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 28, 2006 11:27 AM
> To: Amaia Anabitarte
> Cc: mysql@lists.mysql.com
> Subject: Re: jdbc:
s running the
query. This has helped me determine
some additional indexes that greatly speed up my queries.
--
George
- Original Message -
From: "Schalk" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 23, 2006 6:59 AM
Subject: Query returns to many results
Greet
Daniel,
What about just running your import file through dos2unix before piping
it to mysql?
That way, it would leave \n alone (since that is unix format) and
replace any occurrances of
\r\n with plan old \n.
--
George
> -Original Message-
> From: Daniel Kasak [mailto:
Michael,
can you connect using the command line client? sounds to me like it may be
the "old_password" problem.
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
--
George
- Original Message -
From: "Michael Satterwhite" <[EMAIL PROTECTED]>
To:
Henry,
Maybe the shell is doing something funky with the parens?
maybe try escaping them with the \ ??
Just a wild guess :)
> -Original Message-
> From: Henry Dall [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 15, 2006 12:06 PM
> To: mysql@lists.mysql.com
> Subject: Problem
Andre,
I tried this a couple weeks ago... I think you want the "on duplicate"
option for the INSERT query.
depends what version you have... I think this was introduced in mysql 4.1
insert into values () on duplicate key update set x=2,y=5;
unfortunately, the server I was testing thi
looks like there is only a partial query
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM
1',0,46,0,'osmbanner1.png
','http://www.opensourcematters.org','2004-07-07$
there is no ending ', so when it hits the 'jos_banner
/*!4 ALTER TABLE `jos_banner`
it sees it as the end of the field
I have also seen the table locking on deletes and even on large selects
with INNODB. I had converted to INNODB strictly for the "row level
locking" that is the biggest selling point of using INNODB.
So all the avantages of INNODB that are advertised (ie - row level
locking) are mis-represented?
t tool
md5sum export.sql.gz
Then after you upload, run the same command to make sure you didn't
loose any bits in the transfer.
--
George
> -Original Message-
> From: JamesDR [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 06, 2006 11:54 AM
> To: mysql@lists
site
belongs to a previous employer). At the time, I think I had to drop the
unpacked jar file for the mysql
driver into the Tomcat source directory. That is about all I remember
about Tomcat.
--
George Law
> -Original Message-
> From: Chuck Craig [mailto:[EMAIL PROTECTED]
>
Phillip,
You probably didn't need to upgrade - just set the mysql password to use
"old_password":
FTFM:
"As indicated earlier, a danger in this scenario is that it is possible
for accounts that have a short password hash to become inaccessible to
pre-4.1 clients. A change to such an account'
... Before continuing.
--
George
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 4:09 PM
To: mysql@lists.mysql.com
Subject: Lost connection to MySQL server during query
I am getting this error when connecting to mysql with PHP:
Lost con
to find
the longest sub string match right in SQL.
Thanks!!
George Law
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the numeric part), and sort based on these 2 column.
--
George
-Original Message-
From: Nicolas Verhaeghe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 11:09 AM
To: mysql@lists.mysql.com
Subject: RE: How can I isolate the integer part of a varchar field and
use it in an
--+
| uid | name |
+-+---+
| 1 | george099 |
| 2 | george100 |
| 3 | george101 |
| 4 | george001 |
| 5 | 123bill |
| 6 | 100bill |
| 13 | george|
| 14 | darren|
| 15 | joe |
| 16 | bill |
+-+---+
10 rows in set (0.00 sec)
mysql> select uid,name fro
1 - 100 of 302 matches
Mail list logo
