pinba_engine icon indicating copy to clipboard operation
pinba_engine copied to clipboard

Published 20 hours ago • verified publisher icon tony2001

Cannot load pinba sql dump after dumping

Open azilber opened this issue 11 years ago • 6 comments

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.

azilber avatar Aug 14 '14 11:08 azilber

What exactly are you loading?

tony2001 avatar Aug 14 '14 11:08 tony2001

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

The doesn't work.

azilber avatar Aug 14 '14 12:08 azilber

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.

tony2001 avatar Aug 14 '14 12:08 tony2001

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.

azilber avatar Aug 14 '14 12:08 azilber

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.

tony2001 avatar Aug 14 '14 12:08 tony2001

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 [email protected] 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 .

azilber avatar Aug 14 '14 15:08 azilber