← Back to team overview

maria-discuss team mailing list archive

Re: Problems copy database files

 

what about file size on both servers?

Em qua., 6 de mai. de 2020 às 07:35, Ling, Andy <Andy.Ling@xxxxxxxxxxxxxxx>
escreveu:

> Hi,
>
>
>
> I am having problems copying database files.
>
>
>
> I am using MariaDB 10.4.12 on Windows server 2019. And all the tables use
> the Aria engine
>
>
>
> A simple set of operations that reproduces the problem is…
>
>
>
> Add some data to a table
>
> FLUSH TABLE “table” FOR EXPORT
>
> Copy the .FRM, .MAI, .MAD files for the table to a backup folder.
>
> UNLOCK TABLES
>
> switch to the database in the backup folder and check the contents of the
> copied table. I doesn’t contain the data just added. So it looks like the
> data is not being flushed to disk. The documentation suggests this should
> work, so are there some settings I need to change to make sure the data is
> flushed before I do the file copies.
>
>
>
> Thanks for any help
>
>
>
> Andy Ling
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Roberto Spadim
SPAEmpresarial - Software ERP/Scada
Eng. Automação e Controle, Eng. Financeira

References