LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Archive storage engine on mysql (http://www.linuxquestions.org/questions/linux-newbie-8/archive-storage-engine-on-mysql-942083/)

varunb 04-27-2012 09:30 AM

Archive storage engine on mysql
 
Hi,

I have mysql configured and installed on my pc.
all i need to do now is to enable archive storage engine on mysql.
please can anyone give some idea regarding this.

Code:

linux-twjc:~ # mysql -p*****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 68
Server version: 5.0.51b-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine    | Support | Comment                                                        |
+------------+---------+----------------------------------------------------------------+
| MyISAM    | DEFAULT | Default engine as of MySQL 3.23 with great performance        |
| MEMORY    | YES    | Hash based, stored in memory, useful for temporary tables      |
| InnoDB    | YES    | Supports transactions, row-level locking, and foreign keys    |
| BerkeleyDB | NO      | Supports transactions and page-level locking                  |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | NO      | Example storage engine                                        |
| ARCHIVE    | NO      | Archive storage engine                                        |
| CSV        | NO      | CSV storage engine                                            |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                |
| FEDERATED  | YES    | Federated MySQL storage engine                                |                                                   
| MRG_MYISAM | YES    | Collection of identical MyISAM tables                          |
| ISAM      | NO      | Obsolete storage engine                                        |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.02 sec)
mysql>


Nermal 04-27-2012 12:49 PM

You need to make msyql with it.

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

PC you say, What OS you running? Distro, version if linux.

varunb 05-02-2012 12:58 AM

Quote:

Originally Posted by Nermal (Post 4664672)
You need to make msyql with it.

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

PC you say, What OS you running? Distro, version if linux.

Hi,

I am using opensuse 11.3.
Do i have to uninstall MySQL and install again enabling archive storage???
also think i need to download the source/tar package.


All times are GMT -5. The time now is 07:10 PM.