Re: [firebase-br] FB 5.0 - Restaurar backup
Marcelo Alaggio via lista <[email protected]> Tue, 6 Aug 2024 09:28:27 -0300
| Newsgroups | gmane.comp.db.firebase.portuguese |
|---|---|
| Message-ID | <[email protected]> |
Bom dia a todos! @Rogério, muito obrigado pela dica, vou tentar. Abs Marcelo Alaggio Delphus Software Em 05/08/2024 21:38, Rogerio django via lista escreveu: > Boa noite! > Marcelo tente usando a api do firebird assim: > gbak.exe -c -r -o -user SYSDBA -pas masterkey -p 16384 -SE 127.0.0.1:service_mgr c:\backup\dados.fbk c:\backup\dados.fdb -v > ________________________________ > De: lista<[email protected]> em nome de Marcelo Alaggio via lista<[email protected]> > Enviado: quinta-feira, 1 de agosto de 2024 21:27 > Para: Rogerio django via lista<[email protected]> > Cc: Marcelo Alaggio<[email protected]> > Assunto: Re: [firebase-br] FB 5.0 - Restaurar backup > > Boa noite Rogerio! > > O IP 192.168.2.214 é o IP local da máquina onde está o FB5, é o mesmo > que C: . > > De qq forma, fiz o que tu sugeriu e apareceu o mesmo resultado: > > C:\Program Files\Firebird\Firebird_5_0>gbak -user SYSDBA -pas masterkey > -r -p 16384 -v -o c:\backup\dados.fbk c:\backup\dados.fdb > gbak:opened file c:\delphus\dados.fbk > gbak:transportable backup -- data in XDR format > gbak: backup file is compressed > gbak:backup version is 11 > gbak: ERROR:Error occurred during login, please check server > firebird.log for details > gbak: ERROR:failed to create database c:\backup\dados.fdb > gbak:Exiting before completion due to errors > > No firebird.log segue aparecendo: > > DESKTOP-0VFUGNP Thu Aug 1 21:02:38 2024 > Authentication error > unavailable database > > Alguma sugestão? > > Obrigado. > > Marcelo Alaggio > Delphus Software > > > > Em 01/08/2024 19:56, Rogerio django via lista escreveu: >> Boa noite! >> >> >> voce esta fazendo um restore local para outra maquina? "c:\backup\dados.fbk 192.168.2.214:c:\backup\dados.fdb " >> >> gbak -c -r -o -user SYSDBA -pas masterkey -p 16384 >> c:\backup\dados.fbk c:\backup\dados.fdb -v >> >> >> deveria ficar assim. >> >> ________________________________ >> De: lista<[email protected]> em nome de Marcelo Alaggio via lista<[email protected]> >> Enviado: quinta-feira, 1 de agosto de 2024 17:26 >> Para: FireBase<[email protected]> >> Cc: Marcelo Alaggio<[email protected]> >> Assunto: [firebase-br] FB 5.0 - Restaurar backup >> >> Boa tarde a todos! >> >> Peço a ajuda de vocês para resolver a seguinte questão: >> >> Eu tenho um arquivo FBK gerado a partir do banco de produção que está >> rodando em um servidor Linux. >> >> Tenho um computador de desenvolvimento onde também está rodando o FB5, >> computador com Windows11, configuração padrão do FB. >> >> Eu quero gerar restaurar esse FBK gerando um FDB nesta máquina Windows. >> >> Uso o seguinte comando a partir da pasta C:\Program >> Files\Firebird\Firebird_5_0: >> >> gbak -user SYSDBA -pas masterkey -r -p 16384 -v -o >> c:\backup\dados.fbk 192.168.2.214:c:\backup\dados.fdb >> >> Resposta do comando: >> >> gbak:opened file c:\delphus\datateck.fbk >> gbak:transportable backup -- data in XDR format >> gbak: backup file is compressed >> gbak:backup version is 11 >> gbak: ERROR:Error occurred during login, please check server >> firebird.log for details >> gbak: ERROR:failed to create database 192.168.2.214:c:\backup\dados.fdb >> gbak:Exiting before completion due to errors >> >> No firebird.log aparece: >> >> DESKTOP-0VFUGNP Thu Aug 1 17:15:57 2024 >> Authentication error >> unavailable database >> >> O banco está rodando, verifiquei em serviços. >> >> O firebird.conf estava com todas as linhas comentadas. Tirei o >> comentário da linha que indica a porta, ficando em 3050. Reiniciei o >> serviço, tentei novamente e mesmo erro. >> >> Realmente não sei o que pode ser. >> >> Alguém conseguiria me ajudar? >> >> Desde já obrigado! >> >> Marcelo Alaggio. >> Delphus Software >> >> >> >> >> -- >> ______________________________________________ >> FireBase-BR (https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166378953%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=rgneZ2h0%2BOemltRSqf7DtrFPwZYDcjqkNJXwVgXB0m8%3D&reserved=0<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166392003%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=Lm%2FF3b7gg9%2FUHwRfEHj%2BbERYQUjdBUIQxH3nfYW2CLc%3D&reserved=0<http://www.firebase.com.br/>>) - Hospedado emhttps://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.locador.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166399946%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=YQxPL3%2FlU4WA%2BCI1YistLzNtc6OoPj3WwuACUb4YNwc%3D&reserved=0<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.locador.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166404797%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=%2BDkPaqAs%2BgtmLUG8%2BelgDFum%2Fym6I%2B5wJJrDiIiAOvs%3D&reserved=0> >> Para saber como gerenciar/excluir seu cadastro na lista, use:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Ffb%2Fartigo.php%3Fid%3D1107&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166409224%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=MoEZiJenA4sfj8C9b7dD59DTYapCu%2F6VUd3cHU2xgws%3D&reserved=0<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Ffb%2Fartigo.php%3Fid%3D1107&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166413413%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=uFdYml3IOJ%2FOuEttqxTr4izTDjNyAQg2zq8GeNeR3h0%3D&reserved=0> >> Para consultar mensagens antigas:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Fpesquisa_lista.html&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166417459%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=sGPI%2BuJjmYIddCbaXrKXYdXby3cygpqOutSjedBOe5k%3D&reserved=0<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Fpesquisa_lista.html&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166421541%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=UWIKKLjQv5hM1uP4LFV524HGcuQ%2BmY5iHZQC4s4sNqQ%3D&reserved=0> >> ______________________________________________ >> FireBase-BR (https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166425570%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=7BlQdSuRp574BYWnAryfFlG8AJvHvnxavrYZrLH6fMI%3D&reserved=0<http://www.firebase.com.br/>) - Hospedado emhttps://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.locador.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166429505%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=jQNWhBOxRynZhiir%2FXSUHE%2FkcUB1tu3M1acVZcZcb%2F4%3D&reserved=0 >> Para saber como gerenciar/excluir seu cadastro na lista, use:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Ffb%2Fartigo.php%3Fid%3D1107&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166433439%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=Kg8uY1xPAE4GopzBIZOd3c7aDta%2BwtX9EMrMGZqE8Vk%3D&reserved=0 >> Para consultar mensagens antigas:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Fpesquisa_lista.html&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166438292%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=zSEdnSgQWCPOuLZA7cjgc%2BfA6z2x80%2FJ1tFn1vNwLgo%3D&reserved=0 > ______________________________________________ > FireBase-BR (https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166442456%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=irLYbI3Fx4rv7X2RhjVlwNuowTW3MBqH0y1XmVQDKRY%3D&reserved=0<http://www.firebase.com.br/>) - Hospedado emhttps://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.locador.com.br%2F&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166446461%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=hLcdVQ%2FEYwYQ96g%2BswVxuiDTlHDmRhBFDfUQL0OnU%2Bw%3D&reserved=0<http://www.locador.com.br/> > Para saber como gerenciar/excluir seu cadastro na lista, use:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Ffb%2Fartigo.php%3Fid%3D1107&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166451127%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=Z7HK6Q6U3sc2fGOrpjsYb%2BV%2Ba5iK1ByreJgRR6Rx6rQ%3D&reserved=0<http://www.firebase.com.br/fb/artigo.php?id=1107> > Para consultar mensagens antigas:https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.firebase.com.br%2Fpesquisa_lista.html&data=05%7C02%7C%7C098f72f669f34ec38e9408dcb28a0872%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638581553166455308%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=x9j8oaEUJHuz9tcaGfV%2FX79gLm1o0AfhrWb0nlzoF38%3D&reserved=0<http://www.firebase.com.br/pesquisa_lista.html> > ______________________________________________ > FireBase-BR (www.firebase.com.br) - Hospedado emwww.locador.com.br > Para saber como gerenciar/excluir seu cadastro na lista, use:http://www.firebase.com.br/fb/artigo.php?id=1107 > Para consultar mensagens antigas:http://www.firebase.com.br/pesquisa_lista.html ______________________________________________ FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br Para saber como gerenciar/excluir seu cadastro na lista, use: http://www.firebase.com.br/fb/artigo.php?id=1107 Para consultar mensagens antigas: http://www.firebase.com.br/pesquisa_lista.html