As for "saving" the HEAP tables, you would just TRUNCATE the stored tables and do a SELECT INTO from the HEAP tables into the stored tables. Although I would keep two or more copies of the database and alternate between the databases when storing.
On Jul 30, 2004, at 1:10 PM, Stephen Rasku wrote:
I just looked into this. It looks like HEAP tables don't support the BLOB field type and we are using it.
...Stephen
-----Original Message----- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Jul 30, 2004 6:19 AM To: Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: Installing MySQL Databases on RAM Drive
Why use a RAM disk? Why not just load the tables into HEAP tables?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]