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