When you do a mysqld -? it will say:
Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf
So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.)
Hope this helps.
Peter Sap.
- Original Message
You could install version 3.23 under a different username (like mysql323)
than the 4.0 version (like username mysql40).
Then put each .my.cnf in the ~ directory.
Regards,
Peter Sap
- Original Message -
From: Arnoldus Th.J. Koeleman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday
Hi Chris,
Please tell me why a group by with a having shouldn't work in this case.
I tested it with a small table and it works fine, at least in this case.
Peter Sap.
- Oorspronkelijk bericht -
Van: Chris [EMAIL PROTECTED]
Aan: List: MySQL [EMAIL PROTECTED]
Verzonden: vrijdag 21
Hi Yves,
You can use a having clause to work with groups:
select grp, max(id) as maxid
from tbl
group by grp
having maxid = max(id)
Regards,
Peter Sap
- Original Message -
From: Yves Goergen [EMAIL PROTECTED]
To: List: MySQL [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 11:28 PM
switching to InnoDB (row locks in stead
of page locks) and take another look at the tranactions themselve like the
sequence of insert/delete/update/select.
Hope this helps.
Peter Sap.
- Original Message -
From: Mike Gollub [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 21, 2003
to the where clause.
Please check the use of and , I didn't pay much attention to that.
Hope this helps
--
Peter Sap
- Original Message -
From: Olaf van Zandwijk [EMAIL PROTECTED]
To: Peter Sap [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 8:17 AM
Subject: Re
Hi Olaf,
try something like this:
AND gebdatum between now() and date_add(now(),interval 7 day)
However, I have no idea if this can be done with 3.23.49a.
--
Peter Sap.
- Original Message -
From: Olaf van Zandwijk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 17, 2003
is not
capable of handling this.
--
Peter Sap
- Original Message -
From: Nathan Jones [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:16 AM
Subject: Merging duplicate rows
How do you merge duplicate rows? All rows involved contain identical data
in each
at Sybase sites and everybody says that the query
performance is very good. You can run into problems when loading data: only
one session at a time can update a single table (many readers but only one
writer)
Peter Sap
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
To: [EMAIL
Try something like this:
select Screen_Name,count(*)
from MBoard
where Message_Date='2003-11-00'
group by Screen_Name
order by 2 desc
limit 5;
Peter Sap
- Original Message -
From: Daniel Harik [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 12:28 PM
Subject
As far as I know no locking will be done, unless you use the --lock-tables
flag: the tables in a database are locked before the dump starts.
When using InnoDb, use the flag --single-transaction to get a consistent
snapshot of your database.
Peter Sap
- Original Message -
From: Paul Fine
You could try to use MERGE tables to get around this problem.
Put all your data in several MyISAM tables and create a merge table on top
of them.
Peter Sap.
- Original Message -
From: Niran Angkawattanawit [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday
You start a transaction but you insert into a non-transactional table
(probably MyISAM).
Change your table type into InnoDB or DBD and it will work.
Peter Sap
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 14, 2003 4:54 PM
13 matches
Mail list logo