Page 1 of 1

how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 13 Jan 2020, 08:47
by pr_redkar
Hi Team,

Request you to guide me how to restore mantis data backup from dump files i.e. in mantisbk_2019-12-01.trz format

Regards,

Chandrakant Redkar

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 13 Jan 2020, 15:20
by cas
How did you create the dump, using mysqldump?
Then follow:
https://alvinalexander.com/blog/post/my ... ackup-file

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 14 Jan 2020, 06:45
by pr_redkar
Hi cas,

Thanks for your reply but in my case mysql database backup is in below given format
mantisbk_2019-12-01.trz


not .sql file
for your information i am not expert in mysql administration

Regards,
Chandrakant Redkar

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 14 Jan 2020, 09:53
by cas
the TRZ extension is most likely generated by a compression program ( treezip?).
So decompress the file and you probably get the sql file.
If not sure, check with whom ever created the backup for you.

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 14 Jan 2020, 10:18
by pr_redkar
hi cas,
Thanks for your reply i had already tried that un compress , file is created by schedule backup which was created long back and that user was not available . that mantis install on fedora 16 and i just wanted to restore it from old backup

FYI self is not have expertise in this mantis

Regards,

Chandrakant Redkar

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 14 Jan 2020, 11:15
by cas
You better contact that user that created the backup. Not that old, seems to be from last December 1st :mrgreen:

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 15 Jan 2020, 08:15
by pr_redkar
Hi file has been created on 1st Dec but its from auto backup schedule and i tried below given command to restore after uncompress 'mantisbk_2019-12-01.trz' this file

mysql -u root -p testdb; < /MantisNew/db1.dump

result showing given below

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< db1.dump


Regards,
Chandrakant Redkar

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 15 Jan 2020, 08:28
by cas
can you read the dumpfille using notepad?
If so, then it is ok.
Syntax for import must be:
mysql -u root -p testdb < /MantisNew/db1.dump

So the semi-colon needs to be removed

Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz

Posted: 15 Jan 2020, 10:57
by pr_redkar
Hi Cas,

Thanks for your support self is able to restore database with new empty database with below given command

mysql -u root testdb < /MantisNew/db1.dump

Regards,

Chandrakant Redkar