Hi,
Can anyone tell where to find documentation on myisam_ftdump? I would like to know
what myisam_ftdump is and how it differs from mysqldump.
John
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 4:42 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Ask the person who gave you the file to do the work. Give them a list of formats you
can read (i.e. SQL, csv, etc.) and let them decide which of those formats they want to
export into.
John
-Original Message-
From: Mark Graves [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003
Can we
do anything about these? I am getting several ofthem a
day.
-Original Message-From: Microsoft Corporation
Technical Services [mailto:[EMAIL PROTECTED]Sent:
Thursday, December 04, 2003 11:07 AMTo: ConsumerSubject:
New Microsoft Critical Patch
PROTECTED]
Sent: Thursday, December 04, 2003 11:17 AM
To: John Griffin
Subject: RE: New Microsoft Critical Patch
Yes. Stop using email :-) or use procmail to send them to a safe place..
I don't really understand why you send this to a MySQL list..
B.
At 11:11 04-12-2003 -0500, John Griffin
Hi Andrew,
I am not a Guru. I would suggest that you look at MySQL's excellent replication
facility rather than NFS mount a drive. Having your data on an NFS mounted drive will
significantly degrade the performance of your database. Replication will not.
John Griffin
-Original Message
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you
need.
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 9:57 AM
To: Todd Cary; Jay Blanchard
Cc: [EMAIL PROTECTED]
Subject: RE: Export in XML
I think that to
I have been developing with Windows2000, Apache, MySQL and PHP (WAMP ?) platform for
about two years now and have had no problems. However, I have been deploying onto a
Linux server so my observations may not be valid for your purposes.
John Griffin
-Original Message-
From: Paul Fine
I had a similar problem with an Oracle database once. It turned out to be some memory
in the process of going bad.
John
-Original Message-
From: Jon Wagoner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 2:24 PM
To: [EMAIL PROTECTED]
Subject: RE: periodic corruption problem
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
will find that MySQL fits this definition nicely.
John Griffin
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 11:11 AM
To: [EMAIL PROTECTED]
Subject: Re: Foreigner keys in MySQL?
Nevertheless, I received the information that MySQL don't
Can you post your DDL to go along with your DML?
-Original Message-
From: Allen Weeks [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:51 PM
To: Jesse Sheidlower; Cybot
Cc: [EMAIL PROTECTED]
Subject: RE: Slow results with simple, well-indexed query
The only thing I can add is
On my 1.8GHz p4 with 512Gig of RAM I get:
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
on relational databases and the relational model
first suggested by Dr. Codd and then come back and ask questions. Anyone on this list
would be happy to answer them.
Anybody got any good titles or URLs for Ioana?
John Griffin
-Original Message-
From: Ioana [mailto:[EMAIL PROTECTED]
Sent
Hello Steve,
Do a select on the record before you insert it. If the record does not exist in the
database (i.e. mysql_num_rows () == 0) than it is safe to do the insert.
John
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:41 PM
To: MySQL
Hi Darryl,
Why not use mysqldump --no-data [database] [table1] [table2] ...
John Griffin
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 10:49 AM
To: [EMAIL PROTECTED]
Subject: copying
Greetings,
in my last email nobody tackled the schema
Hi David,
check out http://gtk.php.net/ It is a GUI toolkit with a PHP interface to allow you to
build client applications.
John Griffin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject
way of finding logic
errors in code.
Please don't take these suggestions as sarcasm. Relying on your tools to catch
anything other than syntax errors is a bad idea. It builds in a false sense of
security.
John Griffin
-Original Message-
From: Dave Dyer [mailto:[EMAIL PROTECTED]
Sent
Hi,
PL/SQL is an Oracle proprietary language and can not be used. I know that the good
people at MySQL are planning to add a language to MySQL but I do not think that there
is a target release for this. Views, Functions and Procedures are also on the list of
things to add to MySQL but I do not
interface. Keep in mind that the good people at MySQL suffer from the same time and
financial constraints as you do so don't ask for the moon unless you are willing to
help go and get it.
All appropriately tagged rants accepted.
John Griffin
-Original Message-
From: Seth Brundle [mailto
what you can
uninstall as MySQL on W2K is not the issue.
BTW, I eventually solved my problem at work by moving MySQL over to a Linux box. That
actually gave me better performance than my W2K box at home.
John Griffin
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello David,
Since you were kind enough to clarify some matters on licensing I was hoping you would
also be open to suggestions. Instead of charging a flat fee for each copy of MySQL
that is resold why not charge a percentage up to a certain point. It might make it a
bit easier for developers
sale. The current pricing scheme does not support this
market and I am hoping that MySQL is open to suggestions to allow it to support that
market.
John
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 3:13 PM
To: John Griffin
Cc: David Axmark
-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 2:49 PM
To: John Griffin
Cc: David Axmark; Damir Dezeljin; MySQL List
Subject: Re: InterBase vs. Mysql
Well, then I would buy a $50.00 product using MySQL, and then
your $5000.00 product. Oh, and subtract the $500.00
Hello,
First install.
Acquired the mysql-max-3.23.55-pc-linux-i686.tar.gz file.
Uncompressed and installed into /usr/local
Would like to have Innodb tables activated and set the datadir to
'/usr/local/mysql_db_files'
In viewing the /usr/local/mysql/scripts/mysql_install_db file the option
results.
John Griffin
-Original Message-
From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 6:39 AM
To: [EMAIL PROTECTED]
Subject: Looping through parent and childs
I'm new to mySQL and would like to know how do a SELECT where I get all child records
. Unless you have a monster database containing
gigabytes of data the cost of a nightly archival should be far less than the cost of
your time doing a four month restore of the data. Do the math and show your boss if he
needs any convincing. The numbers should speak for themselves.
John Griffin
MySQL supports _rowid. _rowid is defined as a synonym for the primary key if the
primary key consists of one column and is an integer.
Hope this helps,
John Griffin
-Original Message-
From: geeta varu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:54 PM
To: [EMAIL
and the administrator, to start or stop the MySQL server
process. If it is possible, remove all user access to the box your database is running
on.
John Griffin
-Original Message-
From: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 12:13 PM
To: [EMAIL PROTECTED
it. PHP has the Zend
compiler. This will keep your competitors from easily stealing your code. It will also
allow you to add code to protect your application from easily being pirated.
John Griffin
-Original Message-
From: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]
Sent: Wednesday
on Linux, at least for the Web applications we
are running on the hardware we are running. If at all possible, I would suggest you do
some timing tests with both Linux and Windows and see which works better for you.
John Griffin
-Original Message-
From: Theisen, Gary [mailto:[EMAIL PROTECTED
for something use:
SELECT _rowid, ...
FROM my_table
WHERE ...
This will return a unique identifier for each row in _rowid. It is not a raw pointer
like Oracle's ROWID but it will give you what you want (I think).
John Griffin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
the software to save you from all situations is just a
bad idea.
John Griffin
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 3:36 PM
To: Michael T. Babcock
Cc: [EMAIL PROTECTED]; Muruganandam
Subject: Re: Can MySQL handle 120 million records
Hi All,
I ran the following commands:
DROP TABLE IF EXISTS test_date;
CREATE TABLE test_date (test_date datetime);
INSERT INTO test_date (test_date) VALUES ('2002-02-31');
SELECT * FROM test_date;
I got the following results:
mysql DROP TABLE IF EXISTS test_date;
Query OK, 0 rows affected
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002
UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer
of the world's most popular open source database, and NuSphere Corporation, an
independent operating company of Progress Software Corporation,
people a bit of an edge when designing databases ;)
John
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 5:49 PM
To: John Griffin
Cc: Yuri; [EMAIL PROTECTED]
Subject: Re: Marketing materials ??
On Wed, Sep 18, 2002 at 10:15:05AM
Hi Yuri,
Money talks. Point out that MySQL is an open source initiative and can save them
money. As for knowing another product, such as MS-SQL, being a deciding factor; it
really isn't an issue. All databases, at their core functionality, are the same. The
same rules of database design apply
Okay,
This is getting very nasty. There is no need for harsh words. Let's take a step back
and look at the problem a bit differently. The story, as I understand it, is this;
Will made a decision some time ago to develop applications on MySQL. Will based his
decision at least partially on the
coolness or
altruistic support of the open source movement doesn't cut it with most managers.
Productivity, cost, and support usually does.
John Griffin
-Original Message-
From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:25 PM
To: [EMAIL PROTECTED
Hi Mary,
It's not a question of approval. If you are having problems with MySQL there is an
entire list of people who are willing to offer support for free. Post your query and
some table information and let's see if we can clear up your performance issues.
John Griffin
-Original Message
to the database. Here is the code PHP I am using as a
test:
?
$host = 142.226.186.222;
$user = root;
$pass = ;
mysql_connect($host,$user,$pass);
?
Has anyone else encountered this problem before? I am using MySQL 3.23.41, PHP 4.0.6,
and Apache 1.3.20.
John Griffin
dns. It is on a non-routable network
address behind a firewall, and just static files are used
for internal hosts.
Does mysqlgui _have_ to verify the host via dns? If so can
that be turned off somehow?
Thanks
--
John Griffin-Wiesner
[EMAIL PROTECTED]
It said, Windows 95 or better, so I
42 matches
Mail list logo