LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 04-27-2012, 08:30 AM   #1
varunb
Member
 
Registered: Mar 2011
Location: Bangalore, INDIA
Distribution: opensuse, fedora
Posts: 135
Blog Entries: 1

Rep: Reputation: 1
Question 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>
 
Old 04-27-2012, 11:49 AM   #2
Nermal
Member
 
Registered: Jan 2009
Distribution: Debian
Posts: 59
Blog Entries: 2

Rep: Reputation: 6
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.
 
Old 05-01-2012, 11:58 PM   #3
varunb
Member
 
Registered: Mar 2011
Location: Bangalore, INDIA
Distribution: opensuse, fedora
Posts: 135
Blog Entries: 1

Original Poster
Rep: Reputation: 1
Quote:
Originally Posted by Nermal View Post
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.
 
  


Reply

Tags
archive, engine, storage


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Sphinx As MySQL Storage Engine (SphinxSE) LXer Syndicated Linux News 0 05-21-2010 07:30 PM
MySql Compilation Error with Archive storage option ashish_neekhra Linux - Server 0 11-04-2009 10:25 PM
LXer: Mysql Falcon Storage Engine Open Sourced LXer Syndicated Linux News 0 01-04-2007 09:03 AM
LXer: A Look at the MySQL CSV Storage Engine LXer Syndicated Linux News 0 05-06-2006 04:54 PM
LXer: Soliddb™ Storage Engine for MySQL LXer Syndicated Linux News 0 04-17-2006 10:54 PM


All times are GMT -5. The time now is 04:54 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration