… we want to copy order_line table to different server. Note I am going to do it online, no needs to lock or shutdown server. To export table… regular InnoDB ® file, and exp is file with special export information. Both files should be copied to remote server. Now on remote server you have to run MySQL server…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… file: Change to the flexviews/consumer directory and copy the consumer.ini.example file to consumer….from localhost. It is possible to read from and/or write to remote servers, but this example uses…c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec…
Post: Living with backups
November 6, 2008 By 28 Comments
…bar. With a busy database server it may turn out that running a simple copy operation from MySQL data … out to the standard output, which is then is redirected through the pipe over SSH to a remote host … to be divisible by 4096 in order to read it right. Even though it’s always the case for InnoDB…
