Patrick,
- Original Message -
From: Patrick Hsieh [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 10:43 AM
Subject: Re: InnoDB is better than MyISAM ?
Hello Heikki Tuuri [EMAIL PROTECTED],
Where can I find InnoDB Hot Backup
Dear All
Could any one tell me what all the chages I have to make in order
to make my existing (english version) of MySQL database compatable
to the Japanese language.
Thanks and Regards
Aravind
-
Before posting, please check:
Hi,
I would like to try to implement a MySQL server that is spanned over several
machines (a sort of database cluster) - as this is only a test, I am not too
woried about the end OS, but I will probably use a Mandrake 8.1 or 8.2 Linux
distribution.
I have found in the manual information about
Hi Gurhan,
The tee command printed out the table perfectly to a
file,
Cheers,
Colin
tee /dir/table.txt;
select * from table;
--- Gurhan Ozen [EMAIL PROTECTED] wrote:
Hi,
Try to use tee command to log all the output into a
file. It will have the
column names and everything you see in the
Description:
While I tried to open MySQL, it showed an error message, is 'can't connect
MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one
(User: root, Group: mysql, Permission: 777), the error code changed into 111.
How-To-Repeat:
Open MySQL.
Fix:
mkw,
Saturday, April 06, 2002, 12:59:15 PM, you wrote:
mDescription:
m While I tried to open MySQL, it showed an error message, is 'can't connect
MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one
(User: root, Group: mysql,
m Permission: 777), the error
hedrickj,
Friday, April 05, 2002, 9:21:14 PM, you wrote:
h I am using MySQL Manager to manage a database created with the tool a week or so
ago. Worked on the database last night and all was fine. Opened up mySQL Manager today
and any change to the tables
h (add or edit of columns) gives the
I have a standard installation of Mysql on a red hat 7.1 box. I am confused
as to where I can disable the SKIP_LOCKING feature.
There is no skip_locking-option in /etc/my.cnf. I removed the string
--skip_locking from /usr/bin/safe_mysqld. I can't find it anywhere, still
when I do mysqladmin
Hello,
I've been looking for a way to select and access all result rows
starting at a specific offset. The according select clause with LIMIT
n,m comes to mind, but unfortunately the current documentation is not
very explicit concerning the appropriate value for m under these
circumstances.
Responsible Person,
We have been asked by a client, to use your products in our intergration
efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86,
version, 5.8, is offered without the installation file
./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes
with
At 1:24 -0600 4/6/02, BD wrote:
Paul,
Do you know if there is any performance differences between
a unique index and primary key (if there are no nulls)?
Is the index file format the same as the primary key?
I cannot answer that with absolute certainty, but as far as I know
Hello Mr CEO,
Hmmm... go away?
Ric
- Original Message -
From: Hugh O'Loughlin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 1:31 PM
Subject: Do any of your applications work?
Responsible Person,
We have been asked by a client, to use your products in
Ditto here. If you have a support contract, then this is not the channel
for seeking support, since it's a free mailing list. And anybody would
need more information than you provided to solve the problem. Did you
try to install a binary version? Did you try to build from source? MySQL
is
Hi...Sir,
The answer on your question is Y E S.But further, perhaps,a little more
experiences for your technical team is needful.
- Original Message -
From: Hugh O'Loughlin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 3:31 PM
Subject: Do any of your applications
I agree with everyone that has responded. A vague answer that does
nothing but moan about something that is more or less incompentence from
your developmental team. Not only that, but you have a support
contract, so why you asking a question here? Shouldn't you be calling
your support for this
* Paul DuBois
At 18:03 +0200 4/6/02, David yahoo wrote:
Is there any way to put a sort order different than the
alpahbetical order in string.
A thing like that order french,german
ORDER BY ELT(language,'english','german','french'),Linkname ASC
Maybe you meant FIELD(language...?
I sense this could be a troll, but...
/* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */
We have been asked by a client, to use your products in our intergration
efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86,
Excellent choice.
./scripts/mysql_install_db. The
I think of a little hack
I can add in where clause something like :
ELT(language,'english','german','french') != 0
to avoid language not in list even if there no normally :)
I try this as soon as i can.
thanks.
* Paul DuBois
At 18:03 +0200 4/6/02, David yahoo wrote:
Is there any way to
/* Kevin Smith [[EMAIL PROTECTED]] writes: */
That has got to be the best reply I have ever seen ;)
I wanted to reply with...
H. O'Loughlin, CEO -- you are the weakest link. Good Bye.
- Original Message -
From: Richard Clarke [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002
Hello [EMAIL PROTECTED],
It's pretty interesting!
Is tere MP3 file available for this song?
On Sat, 6 Apr 2002 09:35:12 -0800 (PST)
[EMAIL PROTECTED] wrote:
Ok... it's Saturday and I've been meaning to share this with a wider
audience for years Antti, you'll probably remember this from
Yesterday we discovered a strange problem with our database running on
MySQL version 3.23.45 on a Linux OS version 2.2.16
The MySQL database had been running perfectly with a PHP interface on
the web since january 30th and records were added normaly. Now suddenly
the MySQL server is brought back
Hi. I have a question about rollbacks and innodb.
Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it going to wait for
Hi,
Generally, an apache setup will kill a PHP enabled page when it has run for
30 seconds. Also, when a php script exits, all connections to the database
are closed, so somwhere you need to keep the results of your script somwhere
(hidden HTML variables, URI string), otherwise, when you change
Hi,
On Sat, Apr 06, 2002 at 03:57:39PM -0500, Victor wrote:
Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it
At 14:31 2002-04-06, Hugh O'Loughlin wrote:
Ommission errors of the magnitude
we have found, are pure 'Microsoftish' in nature, and should have no
place anywhere, integrity not withstanding.
Microsoftish? Gosh, us Microsoft users have been having problems because the
software doesn't follow
Hello,
I am trying to restore some data from the binary log but I get the
following error:
Duplicate entry '1' for key 1
I understand restoring data is a two-stage process:
1. You do a source myfile.sql to restore the data saved with mysqldump
2. You restore the data logged in the binary log
At 18:28 +0200 4/6/02, Roger Baklund wrote:
* Paul DuBois
At 18:03 +0200 4/6/02, David yahoo wrote:
Is there any way to put a sort order different than the
alpahbetical order in string.
A thing like that order french,german
ORDER BY
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
At 18:28 -0500 4/6/02, Carl Schmidt wrote:
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If
My understanding from the mysql docs is that indexing is to be used
primarily for speeding queries on often used tables. This particular
table is to be queried quite a bit , but almost entirely using the priamry
key. So, I assumed that making the primary key an index would speed
table searches.
Subject: any better way?
From: deco [EMAIL PROTECTED]
===
I have a bunch of data stored on a file and organized in messages... I got a
message header and depending on the message type, i'll get a sequence of
values which can be double, float, long, int, char, etc...
Now i want to put this info
At 18:51 -0500 4/6/02, Carl Schmidt wrote:
My understanding from the mysql docs is that indexing is to be used
primarily for speeding queries on often used tables. This particular
table is to be queried quite a bit , but almost entirely using the priamry
key. So, I assumed that making the
I forgot to point out that this is InnoDB
I've searched Google and found the following disquiteing thing:
http://www.innodb.com/oldbugs.html:
Closed or old bug reports: Almost all of these bugs have been fixed. There are some
old bug reports where the cause of the bug was never found, but
I belive I have found a bug here, possibly.
The last known commands to be run on the DB that are suspicious were a join between
2 tables.
This is the info I got from the user who was workign on the DB:
He was joining between keyword and billing
select distinct(a.customerid) from
Hi All,
After working happily for months, my MySQL (v. 3.23.48-1) database has begun displaying
the following problem:
Whenever I log in as mysql root and try to change privileges for my database as
follows:
grant insert, select
on MyDB_Name
to MyExistingUserName;
I get the error that the
Hello again,
I am trying to set up a SQL statement using NOW(), what I am wanting to do
is to use NOW() then do a search on any date less than 7 days. Before I get
several e-mails asking why. I am trying to a news base database for the
company intranet and I am wanting to only show newsitems
Try linux virtual server.
You can Load Balance any port on a multitude of servers.
Your MySQL Servers you would load balance would have to be read-only
slaves though.
We are currently running two linux virtual servers to load-balance
same-port services on multiple servers with multiple Unix
Has anyone though about writing an internal function to have MySQL dump
database statistics into a flat file or database tables?
-RG
On 5 Apr 2002, Jason Yates wrote:
Date: 05 Apr 2002 16:04:01 -0500
From: Jason Yates [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysql monitoring
Is
Very fun !
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 2:35 PM
Subject: My.S.Q.L
Ok... it's Saturday and I've been meaning to share this with a wider
audience for years Antti, you'll probably remember this from when
I sent
On Sunday, 7. April 2002 05:56, Chuck \PUP\ Payne wrote:
Hi,
I am trying to set up a SQL statement using NOW(), what I am wanting to do
is to use NOW() then do a search on any date less than 7 days. Before I get
several e-mails asking why. I am trying to a news base database for the
company
Being the Sys Admin for the Boise Family YMCA in USA Idaho I say thanks for
sharingG MySQL rocks! To bad the H. O'Loughlin CEO dud didnt hear itG
Wish I knew who his client was so they could hear it to and dump him.
-Original Message-
From: João Paulo Vasconcellos [mailto:[EMAIL
Hi!
MySQL AB and Innobase Oy entry-level support contract costs 3770 euros
annually (3250 USD).
For corporations with requirements for high availability we have
more expensive telephone support options. These are extremely low priced
compared
against your costs for proprietary database
On Sat, 6 Apr 2002 [EMAIL PROTECTED] wrote:
I sense this could be a troll, but...
/* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */
.
.
Frankly, the agreement your client should look at cancelling is the one
with your company. Your inability to install MySQL notwithstanding,
jumping
mysql select date_created from forums;
+-+
| date_created|
+-+
| 2002-04-04 19:27:03 |
+-+
1 row in set (0.00 sec)
mysql SELECT CONCAT(HOUR(now()-date_created), 'H',
MINUTE(now()-date_created), 'M', SECOND(now()-date_created),
On Sat, 06 Apr 2002 22:56:11 -0500, Chuck \PUP\ Payne wrote:
Hello again,
I am trying to set up a SQL statement using NOW(), what I am wanting
to do
is to use NOW() then do a search on any date less than 7 days.
Before I get
several e-mails asking why. I am trying to a news base database for
the
45 matches
Mail list logo