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
how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz
Moderators: Developer, Contributor
Re: how to restore data backup in mantis 1.2.11 from dump file i.e. mantisbk_2019-12-01.trz
How did you create the dump, using mysqldump?
Then follow:
https://alvinalexander.com/blog/post/my ... ackup-file
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
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
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
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.
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
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
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
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
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
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
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
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
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
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