Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 14:33 schrieb Sergei Golubchik: > On Aug 13, Reindl Harald wrote: >> >> >> Am 13.08.2018 um 12:22 schrieb Ling, Andy: "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table is read locked until UNLOCK TABLES is executed" is not really true because

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Sergei Golubchik
Hi, Reindl! On Aug 13, Reindl Harald wrote: > > > Am 13.08.2018 um 12:22 schrieb Ling, Andy: > >> "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table > >> is read locked until UNLOCK TABLES is executed" is not really true > >> because that's only valid for the running

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 12:27 schrieb Sergei Golubchik: > On Aug 13, Ling, Andy wrote: >> >> The code doing this stops everything talking to the database (Yes, I >> know there could be someone fiddling remotely in a shell, but this is >> very unlikely). Even tables which are never written to cause this

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 12:22 schrieb Ling, Andy: >> "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table >> is read locked until UNLOCK TABLES is executed" is not really true >> because that's only valid for the running connection > > Surely not. If you've locked a table for read

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Sergei Golubchik
Hi, Andy! On Aug 13, Ling, Andy wrote: > > The code doing this stops everything talking to the database (Yes, I > know there could be someone fiddling remotely in a shell, but this is > very unlikely). Even tables which are never written to cause this > error > > So if I'm careful, is there a

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread 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

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 11:57 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