Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell> mysql -p -u root
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
Hi Elim,
I didn't test it out but it sounds like you want to do this "
SELECT * FROM group_members GROUP BY head_id, member_id ORDER BY name
ASC ".
On Thu, Jul 16, 2009 at 1:20 AM, Elim PDT wrote:
> My table group_member looks like this:
> +---+---+-+
> | member_id | name
My table group_member looks like this:
+---+---+-+
| member_id | name | head_id |
+---+---+-+
| 1 | Elim |NULL |
| 2 | Ann | 1 |
| 3 | David |NULL |
| 4 | John | 3 |
| 5 | Jane | 3 |
+---
Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
On Wed, Jul 15, 2009 at 6:44 PM, Tachu® wrote:
> I'm having random query slowness that i can only reproduce once. My main
> question is that the query runs faster the second time around but i dont
> have query cache enabled he
Hello,
I've written a fulltext plugin for Mysql 5.1. The plugin works great
and I'm happy with it, but I would like to log an error when I
encounter some unexpected data. Do plugins have access to the Mysql
error log? If so, how do I write to it?
Thanks!
--
MySQL General Mailing List
For lis
A Google video search for "mysql for beginners" found this guy's beginner
tutorials. I only glanced at them but they look pretty helpful.
http://www.youtube.com/user/leanjhuls
I hope this helps.
~~Fish~~
On Wed, Jul 15, 2009 at 9:20 AM, Marcus Bointon
wrote:
> On 15 Jul 2009, at 13:56, sh
I'm having random query slowness that i can only reproduce once. My main
question is that the query runs faster the second time around but i dont
have query cache enabled here is some info from mysql profiler;
The time is spent mostly on the sending data step
first time around
63 rows in set (0.5
Or you could just do an export with
mysqldump --single-transaction > backup.sql
Then replace all the ENGINE=InnoDB with ENGINE=MyIsam in the .sql file.
-Original Message-
From: mos [mailto:mo...@fastmail.fm]
Sent: Wednesday, July 15, 2009 11:58 AM
To: mysql@lists.mysql.com
Subject: Re: An
At 07:53 AM 7/15/2009, you wrote:
hi all,
I have backup all the database files(innodb engine).
Now I want to recover it as myisam engine offline.
Any suggestions?
Why can't you copy the InnoDb files to another machine and open the
database with another MySQL server? (You could do it on your
If a mailbox is protected by one of these types of services:
1) It should be smart enough to see mailing lists and use that as a
qualifying address to be allowed through.
2) It should be smart enough to not reply to bulk precedence mail
3) Or the mailbox should never be subscribed to a mailing list
On Tue, Jul 14, 2009 at 2:14 AM, Marcus
Bointon wrote:
> You should take a look at Percona's xtrabackup utility to do this. It takes
> a clean snapshot of an innodb database that can be restored on a target
> machine in a few minutes, though it does crash recovery at backup time which
> can take a
On 15 Jul 2009, at 13:56, shridhar kyrlageri wrote:
i am very new to mysql . i want to learn this but i don know where
to start what to do. so please enlighten me .
http://dev.mysql.com/doc/
Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK reseller
hi guys
i am very new to mysql . i want to learn this but i don know where to start
what to do. so please enlighten me .
Looking for local information? Find it on Yahoo! Local
http://in.local.yahoo.com/
hi all,
I have backup all the database files(innodb engine).
Now I want to recover it as myisam engine offline.
Any suggestions?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
14 matches
Mail list logo
