Pricing for online recovery

[decoste...@gmail.com]

Hi

Please clarify - I have about 20 InnoDB tables that I need to recover - together they are approximately 4GB.  Is the pricing USD99 x 20 or USD99 x 4?

Thanks

Helen

[Aleksandr Kuzminsky]

Hi Helen,

Are each of those 20 tables in its own .ibd file or all tables in ibdata1?

[Helen de Coster]

Hi Aleksandr

Separate ibd files.

Thanks

Helen

--
You received this message because you are subscribed to a topic in the Google Groups "TwinDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/twindb/oB_wHb4b1AA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to twindb+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/twindb/0994e68a-cff8-4179-b3e0-676bbcbc3f2d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Aleksandr Kuzminsky]

Depends on how you recover the tables.

If you recover tables one by one, providing an .ibd file and CREATE TABLE statement, then each table will be at least $99 ("Recover Table" -> "corrupted .ibd file").

Which makes little sense because you can archive a directory with .ibd + .frm files and recover them altogether ("Recover Database -> "corrupted database"").

Then cost will be ~$400.

In either case you can review recovered tables before making the payment.

Good luck,

Aleks

-- 
Aleksandr Kuzminsky
Phone: +1 (844) 533-0409 ext 101
Skype: aleksandr.kuzminsky
Web: https://twindb.com
Calendar: http://meetme.so/akuzminsky
GPG: https://keybase.io/akuzminsky

[Aleksandr Kuzminsky]

On Tue, Feb 20, 2018 at 11:09 AM, Helen de Coster <decoste...@gmail.com> wrote:

Do I have to put all the ibd & frm files or just those that I KNOW are corrupt?  For example, the email table is 10GB on its own but I know it is not corrupt. 

Can I just archive those I know are a problem and then recover them?

Assuming the email table is good and is readable in a healthy MySQL instance you need to repair tables t1, t1, t3.

You create a directory db with files t1.ibd, t1.frm, t2.ibd, t2.frm, t3.ibd, and t3.frm.

$ ls db
t1.frm    t1.ibd    t2.frm    t2.ibd    t3.frm    t3.ibd

Then you compress&archive the db directory.

$ tar zcf db.tar.gz db/

Then you upload db.tar.gz on recovery.twindb.com on "Recover Database" -> "corrupted database".

Then if it recovers the tables you can import the dump.sql into the health instance.

[Helen de Coster]

Thanks so much. I will prepare the directories now.

Warm regards

Helen

[Helen de Coster]

Honestly this is the LAST question (I hope :-)) - can I put the tables for 2 different databases into one directory? Or will that screw up the dump file?

Thanks,

Helen

[Aleksandr Kuzminsky]

Yes, you can as long as table names are unique.

Aleksandr Kuzminsky

TwinDB LLC

https://twindb.com/

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

Skype: aleksandr.kuzminsky

Calendar: https://secure.scheduleonce.com/akuzminsky

[Helen de Coster]

Thank you!