← Back to team overview

maria-discuss team mailing list archive

Re: Copying database files


Am 13.08.2018 um 11:30 schrieb Ling, Andy:
> I’m using MariaDB 10.2.13 on Windows 7.  All tables are using the Aria
> engine.
> I am trying to initialise a slave database by copying the files between
> PCs, but when I try and use the copied files I get the error
> Table is from another system and must be zerofilled or repaired to be
> usable on this system
> Repairing the tables fixes this, but I’d rather not have to so that.
> I have tried various things suggested to stop this, but nothing seems to
> help. On the source server I have run aria_chk –zerofill on all the
> tables. Before copying the tables I run FLUSH TABLES <table list> FOR
> EXPORT, but I still get the error.
jesus don't copy tbale files around while the server is running

* rsync hot
* shutdown master server
* rsync cold
* start master server