mysql - mysqldump --single-transaction -

-

i'm testing --single-transaction (st) on test server backups of mariadb server. started dump cmd st option , on parallel terminals ran 2 create table, 2 delete table ,1 insert statements test result. result :

  1. insert statement successful in original db , dump.
  2. 2 create table statements not successful.available in database not in dump file.
  3. 1 delete successful in database , dump 1 delete not successful in database records in dump.

as per manual consistent backup i'm not suppose use create,alter,delete,rename,truncate statements. wanted decide go st or no? goal consistent backup doing exercise. in advance...!


Comments

Post a Comment

Popular posts from this blog

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

c++ - What's the differece between of link to a dynamic file and as a input object? -

-
i use g++ link project (an executable mono_kitti) , project dependent on thirdparty library pangolin. when link action -lpangolin option: g++ -l../../lib -lorb_slam2 -lpangolin mono_kitti.o -o mono_kitti it returns: mono_kitti.o:(.data+0x0): undefined reference `vtable pangolin::handler' mono_kitti.o:(.data+0x8): undefined reference `vtable pangolin::handlerscroll' mono_kitti.o: in function `pangolin::handler::~handler()': mono_kitti.cc:(.text._zn8pangolin7handlerd2ev[_zn8pangolin7handlerd5ev]+0x13): undefined reference `vtable pangolin::handler' mono_kitti.o: in function `pangolin::handlerscroll::~handlerscroll()': mono_kitti.cc:(.text._zn8pangolin13handlerscrolld2ev[_zn8pangolin13handlerscrolld5ev]+0x13): undefined reference `vtable pangolin::handlerscroll' collect2: error: ld returned 1 exit status but when use command: g++ -l../../lib -lorb_slam2 mono_kitti.o /usr/local/lib/libpangolin.so -o mono_kitti it succeeded. but failed again when tr...
Read more

How to pass json object using PHP in Wepay API -

-
i have integrated wepay payment gateway . have facing problem pass json object wepay . shows incorrect json format. please @ below code. $forca_a = array( 'debit_opt_in'=>true ); $forca = json_encode($forca_a,json_force_object); $wepay_create_array = array( 'name' =>"xxxx", 'description' => "xxxxxxxxx xxxx", 'callback_uri' => "xxxxxxx", 'country' => "ca", 'currencies' => array('cad'), 'country_options' => $forca, 'rbits'=> array( array( 'receive_time'=>strtotime("now"), 'type' =>'website_uri', 'source' => 'partner_database', 'properties'=> array('uri'=>xxxxx) ) ) ); if won't pass country_options , seems working if pass parameter, giv...
Read more