search

tony2001 / pinba_engine

Pinba - MySQL plugin and storage engine
http://pinba.org
GNU General Public License v2.0
475 stars 41 forks source link

Cannot load pinba sql dump after dumping #31

Open azilber opened 10 years ago

azilber commented 10 years ago

Get this error:

ERROR 1031 (HY000) at line 44: Storage engine PINBA of the table pinba.info doesn't have this option

This is with MariaDB 10.0.12 built from source. Seems to work ok otherwise.

tony2001 commented 10 years ago

What exactly are you loading?

azilber commented 10 years ago

mysqldump pinba > pinba.sql mysql pinba < pinba.sql

The doesn't work.

tony2001 commented 10 years ago

Inserting values into the tables shouldn't work by design - Pinba tables are just virtual 'views', allowing read-only access to the data stored inside (nothing is written on the disk, everything is stored in memory). Just create the tables, the data will be populated as soon as data packets arrive.

azilber commented 10 years ago

That makes sense, but creates a few problems:

  1. Intaro Dashboard generates it's tables within the pinba database. This makes sql dump of Intaro impossible unless you dump by table.
  2. I need to setup a separate server for an external developer on EC2. I wanted to dump my pinba db, obfuscate the data, and have the developer work on this bug: https://github.com/intaro/pinboard/issues/86

I'm not sure how this can be accomplished if the db is unloable via sql files.

tony2001 commented 10 years ago

Well, you can re-create the same tables with the same data, but using simple MyISAM or InnoDB tables instead of Pinba, if you need this exact data to stay for some time - just change the table type in the dump. Don't know if it's possible, but doesn't Intaro allow to create its own tables in a separate DB? So that you could dump it along with the data.

azilber commented 10 years ago

That's a good idea for smaller datasets. Seems to be working. For Pinboard, I only see one database config section, so I assume there's no easy way to configure a second db just for Pinboard.

On Thu, Aug 14, 2014 at 8:43 PM, Antony Dovgal notifications@github.com wrote:

Well, you can re-create the same tables with the same data, but using simple MyISAM or InnoDB tables instead of Pinba, if you need this exact data to stay for some time - just change the table type in the dump. Don't know if it's possible, but doesn't Intaro allow to create its own tables in a separate DB? So that you could dump it along with the data.

— Reply to this email directly or view it on GitHub https://github.com/tony2001/pinba_engine/issues/31#issuecomment-52178129 .