Comments - pre-seeding databases from remote servers for multi-source replication
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
i'm guessing you mean the entire database directory, as copying everything from multiple source servers will only work for one server. after copying the source database's files in place (.idb/.frm/etc), it does show up in "show databases". i can even query the tables with "use <dbname>; show tables;". however, i get errors if i try and run commands that would actually read from the table. this appears to be an issue with mismatching table/space id's.
one option might be to:
- export schema only (no content) from the desired database on the source server - run the import scripts on the target replication server - shutdown mysql on the replication server - inspect each of the table files for table/space id. - remove all files for the selected database and replace them with the files from the source server - modify each of the .idb files to have the corresponding table id. - start mysql
while this might get past the problem of the mismatching table id, i don't know what other problems i might run into with files originating on a different server which aren't associated with the current master schema information (stored in "mysql" db).