something wrong in my dumps

Gabriele Venturini

unread,

May 24, 2018, 11:37:39 PM5/24/18

to TwinDB

I start using your tool undrop-innodb.

but in my dumps I've

in the sql I've an error:

head -5 dumps/default/SYS_INDEXES.sql

SET FOREIGN_KEY_CHECKS=0;

LOAD DATA LOCAL INFILE '/root/undrop-for-innodb/dumps/default/SYS_INDEXES' REPLACE INTO TABLE `SYS_INDEXES` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES STARTING BY 'SYS_INDEXES\t' (`TABLE_ID`, `ID`, `NAME`, `N_FIELDS`, `TYPE`, `SPACE`, `PAGE_NO`);

-- STATUS {"records_expected": 13103, "records_dumped": 12637, "records_lost": true} STATUS END

same thing for tables.

Any help?

Aleksandr Kuzminsky

unread,

May 24, 2018, 11:48:34 PM5/24/18

to Gabriele Venturini, TwinDB

It may be looking scary but there is no error here.

SYS_INDEXES is a tab separated values dump.

SYS_INDEXES.sql is an SQL command to load the dump.

Aleksandr Kuzminsky,

TwinDB

Skype: aleksandr.kuzminsky

Phone: +1 (844) 533-0409 ext 101

--
You received this message because you are subscribed to the Google Groups "TwinDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to twindb+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/twindb/377ff6ed-5de2-4fb3-b259-d61242985558%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Gabriele Venturini

unread,

May 25, 2018, 12:00:19 AM5/25/18

to Aleksandr Kuzminsky, TwinDB

ahhh ok, I misunderstand .sql files... I think that here I can find my tables+data.

In my scenario I've all data of my db in ibdata1, I use the parser that create tons of page files, then the dumps that you can see in the screenshot.

But now? I don't understand the next step to recreate tables schema and data.

can you point me to the right direction?

2018-05-25 5:48 GMT+02:00 Aleksandr Kuzminsky <al...@twindb.com>:

It may be looking scary but there is no error here.
SYS_INDEXES is a tab separated values dump.

SYS_INDEXES.sql is an SQL command to load the dump.

Aleksandr Kuzminsky,
TwinDB
Skype: aleksandr.kuzminsky
Phone: +1 (844) 533-0409 ext 101

On May 24, 2018, at 20:37, Gabriele Venturini <ioti...@gmail.com> wrote:

I start using your tool undrop-innodb.

but in my dumps I've
in the sql I've an error:
head -5 dumps/default/SYS_INDEXES.sql
SET FOREIGN_KEY_CHECKS=0;
LOAD DATA LOCAL INFILE '/root/undrop-for-innodb/dumps/default/SYS_INDEXES' REPLACE INTO TABLE `SYS_INDEXES` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES STARTING BY 'SYS_INDEXES\t' (`TABLE_ID`, `ID`, `NAME`, `N_FIELDS`, `TYPE`, `SPACE`, `PAGE_NO`);
-- STATUS {"records_expected": 13103, "records_dumped": 12637, "records_lost": true} STATUS END

same thing for tables.
Any help?

--
You received this message because you are subscribed to the Google Groups "TwinDB" group.

To unsubscribe from this group and stop receiving emails from it, send an email to twindb+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/twindb/377ff6ed-5de2-4fb3-b259-d61242985558%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--