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

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
pr_redkar
Posts: 13
Joined: Dec 31, 2019 1:26 am

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

Post 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

cas
Posts: 863
Joined: Mar 11, 2006 11:08 am
Contact:

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

Post by cas »

How did you create the dump, using mysqldump?
Then follow:
https://alvinalexander.com/blog/post/my ... ackup-file

pr_redkar
Posts: 13
Joined: Dec 31, 2019 1:26 am

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

Post 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

cas
Posts: 863
Joined: Mar 11, 2006 11:08 am
Contact:

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

Post 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.

pr_redkar
Posts: 13
Joined: Dec 31, 2019 1:26 am

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

Post 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

cas
Posts: 863
Joined: Mar 11, 2006 11:08 am
Contact:

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

Post by cas »

You better contact that user that created the backup. Not that old, seems to be from last December 1st :mrgreen:

pr_redkar
Posts: 13
Joined: Dec 31, 2019 1:26 am

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

Post 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

cas
Posts: 863
Joined: Mar 11, 2006 11:08 am
Contact:

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

Post 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

pr_redkar
Posts: 13
Joined: Dec 31, 2019 1:26 am

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

Post 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

Post Reply