Search.setIndex({docnames:["authors","compiling","examples","files","index","mydumper_usage","myloader_usage"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":3,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":2,"sphinx.domains.rst":2,"sphinx.domains.std":1,"sphinx.ext.todo":2,sphinx:56},filenames:["authors.rst","compiling.rst","examples.rst","files.rst","index.rst","mydumper_usage.rst","myloader_usage.rst"],objects:{mydumper:{"--[skip-]tz-utc":[5,0,1,"cmdoption-mydumper-skip-tz-utc"],"--binlogs":[5,0,1,"cmdoption-mydumper-binlogs"],"--build-empty-files":[5,0,1,"cmdoption-mydumper-build-empty-files"],"--chunk-filesize":[5,0,1,"cmdoption-mydumper-chunk-filesize"],"--complete-insert":[5,0,1,"cmdoption-mydumper-complete-insert"],"--compress":[5,0,1,"cmdoption-mydumper-compress"],"--compress-input":[5,0,1,"cmdoption-mydumper-compress-input"],"--daemon":[5,0,1,"cmdoption-mydumper-daemon"],"--database":[5,0,1,"cmdoption-mydumper-database"],"--defaults-file":[5,0,1,"cmdoption-mydumper-defaults-file"],"--events":[5,0,1,"cmdoption-mydumper-events"],"--help":[5,0,1,"cmdoption-mydumper-help"],"--host":[5,0,1,"cmdoption-mydumper-host"],"--ignore-engines":[5,0,1,"cmdoption-mydumper-ignore-engines"],"--kill-long-queries":[5,0,1,"cmdoption-mydumper-kill-long-queries"],"--less-locking":[5,0,1,"cmdoption-mydumper-less-locking"],"--logfile":[5,0,1,"cmdoption-mydumper-logfile"],"--long-query-guard":[5,0,1,"cmdoption-mydumper-long-query-guard"],"--no-backup-locks":[5,0,1,"cmdoption-mydumper-no-backup-locks"],"--no-data":[5,0,1,"cmdoption-mydumper-no-data"],"--no-locks":[5,0,1,"cmdoption-mydumper-no-locks"],"--no-schemas":[5,0,1,"cmdoption-mydumper-no-schemas"],"--no-views":[5,0,1,"cmdoption-mydumper-no-views"],"--omit-from-file":[5,0,1,"cmdoption-mydumper-omit-from-file"],"--outputdir":[5,0,1,"cmdoption-mydumper-outputdir"],"--password":[5,0,1,"cmdoption-mydumper-password"],"--port":[5,0,1,"cmdoption-mydumper-port"],"--regex":[5,0,1,"cmdoption-mydumper-regex"],"--routines":[5,0,1,"cmdoption-mydumper-routines"],"--rows":[5,0,1,"cmdoption-mydumper-rows"],"--snapshot-interval":[5,0,1,"cmdoption-mydumper-snapshot-interval"],"--socket":[5,0,1,"cmdoption-mydumper-socket"],"--statement-size":[5,0,1,"cmdoption-mydumper-statement-size"],"--success-on-1146":[5,0,1,"cmdoption-mydumper-success-on-1146"],"--tables-list":[5,0,1,"cmdoption-mydumper-tables-list"],"--threads":[5,0,1,"cmdoption-mydumper-threads"],"--triggers":[5,0,1,"cmdoption-mydumper-triggers"],"--use-savepoints":[5,0,1,"cmdoption-mydumper-use-savepoints"],"--user":[5,0,1,"cmdoption-mydumper-user"],"--verbose":[5,0,1,"cmdoption-mydumper-verbose"],"--version":[5,0,1,"cmdoption-mydumper-version"],"-?":[5,0,1,"cmdoption-mydumper-help"],"-B":[5,0,1,"cmdoption-mydumper-database"],"-C":[5,0,1,"cmdoption-mydumper-compress-input"],"-D":[5,0,1,"cmdoption-mydumper-daemon"],"-E":[5,0,1,"cmdoption-mydumper-events"],"-G":[5,0,1,"cmdoption-mydumper-triggers"],"-I":[5,0,1,"cmdoption-mydumper-snapshot-interval"],"-K":[5,0,1,"cmdoption-mydumper-kill-long-queries"],"-L":[5,0,1,"cmdoption-mydumper-logfile"],"-O":[5,0,1,"cmdoption-mydumper-omit-from-file"],"-P":[5,0,1,"cmdoption-mydumper-port"],"-R":[5,0,1,"cmdoption-mydumper-routines"],"-S":[5,0,1,"cmdoption-mydumper-socket"],"-T":[5,0,1,"cmdoption-mydumper-tables-list"],"-V":[5,0,1,"cmdoption-mydumper-version"],"-W":[5,0,1,"cmdoption-mydumper-no-views"],"-b":[5,0,1,"cmdoption-mydumper-binlogs"],"-c":[5,0,1,"cmdoption-mydumper-compress"],"-d":[5,0,1,"cmdoption-mydumper-no-data"],"-e":[5,0,1,"cmdoption-mydumper-build-empty-files"],"-h":[5,0,1,"cmdoption-mydumper-host"],"-i":[5,0,1,"cmdoption-mydumper-ignore-engines"],"-k":[5,0,1,"cmdoption-mydumper-no-locks"],"-l":[5,0,1,"cmdoption-mydumper-long-query-guard"],"-m":[5,0,1,"cmdoption-mydumper-no-schemas"],"-o":[5,0,1,"cmdoption-mydumper-outputdir"],"-p":[5,0,1,"cmdoption-mydumper-password"],"-r":[5,0,1,"cmdoption-mydumper-rows"],"-s":[5,0,1,"cmdoption-mydumper-statement-size"],"-t":[5,0,1,"cmdoption-mydumper-threads"],"-u":[5,0,1,"cmdoption-mydumper-user"],"-v":[5,0,1,"cmdoption-mydumper-verbose"],"-x":[5,0,1,"cmdoption-mydumper-regex"]},myloader:{"--compress-protocol":[6,0,1,"cmdoption-myloader-compress-protocol"],"--database":[6,0,1,"cmdoption-myloader-database"],"--defaults-file":[6,0,1,"cmdoption-myloader-defaults-file"],"--directory":[6,0,1,"cmdoption-myloader-directory"],"--enable-binlog":[6,0,1,"cmdoption-myloader-enable-binlog"],"--help":[6,0,1,"cmdoption-myloader-help"],"--host":[6,0,1,"cmdoption-myloader-host"],"--overwrite-tables":[6,0,1,"cmdoption-myloader-overwrite-tables"],"--password":[6,0,1,"cmdoption-myloader-password"],"--port":[6,0,1,"cmdoption-myloader-port"],"--queries-per-transaction":[6,0,1,"cmdoption-myloader-queries-per-transaction"],"--socket":[6,0,1,"cmdoption-myloader-socket"],"--source-db":[6,0,1,"cmdoption-myloader-source-db"],"--threads":[6,0,1,"cmdoption-myloader-threads"],"--user":[6,0,1,"cmdoption-myloader-user"],"--verbose":[6,0,1,"cmdoption-myloader-verbose"],"--version":[6,0,1,"cmdoption-myloader-version"],"-?":[6,0,1,"cmdoption-myloader-help"],"-B":[6,0,1,"cmdoption-myloader-database"],"-C":[6,0,1,"cmdoption-myloader-compress-protocol"],"-P":[6,0,1,"cmdoption-myloader-port"],"-S":[6,0,1,"cmdoption-myloader-socket"],"-V":[6,0,1,"cmdoption-myloader-version"],"-d":[6,0,1,"cmdoption-myloader-directory"],"-e":[6,0,1,"cmdoption-myloader-enable-binlog"],"-h":[6,0,1,"cmdoption-myloader-host"],"-o":[6,0,1,"cmdoption-myloader-overwrite-tables"],"-p":[6,0,1,"cmdoption-myloader-password"],"-q":[6,0,1,"cmdoption-myloader-queries-per-transaction"],"-s":[6,0,1,"cmdoption-myloader-source-db"],"-t":[6,0,1,"cmdoption-myloader-threads"],"-u":[6,0,1,"cmdoption-myloader-user"],"-v":[6,0,1,"cmdoption-myloader-verbose"]}},objnames:{"0":["std","cmdoption","program option"]},objtypes:{"0":"std:cmdoption"},terms:{"000":5,"000001":3,"094953":2,"1000":6,"106":3,"1146":5,"127":[5,6],"2011":3,"20110614":2,"break":5,"byte":5,"case":5,"default":[2,5,6],"export":[2,5],"function":5,"long":5,"new":5,"super":5,"try":2,For:[5,6],Not:5,Pos:3,The:[0,1,3,5,6],There:3,These:3,Use:[5,6],Useful:5,abort:5,accur:5,across:5,addition:1,advantag:5,against:5,all:[2,5],allow:5,along:2,also:[3,5],altern:[3,6],andrew:0,ani:[2,3,6],applic:3,apt:1,author:4,avail:[5,6],avoid:5,back:5,backup:[2,5,6],been:[0,3],befor:[1,5],being:5,between:5,bin:3,binari:[2,4,5,6],binlog:[3,5,6],binlog_snapshot:3,bubenick:0,build:[1,5],call:3,can:1,capabl:[2,5],caus:[5,6],charact:5,chunk:[3,5],client:[1,5,6],cmake:4,code:[0,5],column:5,com:0,combin:6,comma:5,compil:[4,5],complet:[3,5],compress:[3,5,6],connect:[2,3,5,6],consist:[2,5],consol:5,constantli:3,contain:[3,5],content:[3,4],continu:2,control:5,convers:5,corpor:0,correct:[5,6],correspond:[5,6],count:5,creat:[2,3,5],critic:5,daemon:[4,5],data:[2,5,6],databas:[2,3,5,6],dcmake_install_prefix:1,descript:4,dev:1,devel:1,develop:1,differ:[3,5],directori:[2,3,5,6],disabl:5,distribut:5,dmysql_config:1,doc_html:1,doc_man:1,doe:[3,5,6],doesn:5,doma:0,domain:[5,6],dot:0,drop:6,dump:[3,4,5,6],duplic:6,dure:[3,6],dwith_binlog:5,each:[3,5],easi:5,easier:5,effici:5,empti:5,enabl:[3,5,6],end:3,engin:5,entri:5,error:[3,5,6],etc:5,event:5,everi:[2,3],exampl:[3,4],exclus:5,execut:[1,3,5,6],exist:[2,5,6],exit:[5,6],expens:5,express:5,facebook:0,fail:[2,3],failur:[5,6],faster:5,featur:2,file:[2,4,5,6],filenam:[1,3],files:5,finish:3,follow:[0,1,2,3],format:3,from:[2,3,5],gener:3,get:[1,5],give:[2,6],given:[5,6],glib2:1,good:3,grab:5,guard:5,half:2,has:[0,2,3,5,6],have:[3,5,6],help:[5,6],henc:5,hhmmss:5,host:[5,6],hostnam:[5,6],hour:2,hutch:0,ignor:[2,5],inaccess:[5,6],includ:[2,5],inclus:5,inconsist:5,increment:5,index:4,info:[5,6],innodb:5,input:5,insert:[5,6],insid:3,instal:1,instead:5,interv:[2,5],issu:5,itself:[3,5],just:[1,2],kill:5,laptop:3,last_dump:3,least:3,leith:0,less:5,libglib2:1,libmysqlcli:1,libmysqlclient15:1,libpcre3:1,librari:1,line:5,linuxjedi:3,list:5,littl:3,load:6,localhost:[5,6],lock:5,log:[2,4,5,6],logfil:[2,5],mai:6,maintain:5,make:1,man:1,manag:5,mani:[3,5],mark:0,master:[3,5],match:5,max:0,maximum:5,messag:[5,6],metadata:[4,5],minim:5,minut:5,mituza:0,mode:[4,5],more:6,move:5,much:5,multi:[2,6],mydump:[0,1,2,3,4,6],myload:[2,4],mysql5:1,mysql:[1,2,3,5,6],mysql_config:1,mysqldump:5,name:[3,5,6],need:[2,5],non:5,now:2,number:[3,5,6],occur:[5,6],off:6,often:2,omit:5,one:[3,5,6],option:[1,2,3,4],oracl:0,other:5,otherwis:[5,6],output:[1,2,4,5],outputdir:5,over:5,overal:5,overwrit:[2,6],packag:1,pad:3,page:[1,4],parallel:5,paramet:1,pars:5,partial:3,pass:2,password:[5,6],path:[1,2,6],pattern:5,pcre:[1,5],peopl:0,per:[5,6],percona:[0,5],perform:5,point:[2,3],port:[1,5,6],posit:[3,5],possibl:1,preced:5,privileg:[5,6],procedur:5,program:[5,6],protocol:[5,6],provid:[1,5],python:1,queri:[5,6],rdba:0,read:5,reason:3,reduc:5,regex:[4,5],regular:5,remot:5,renam:3,requir:[4,5],restor:[4,6],result:6,retreiv:[2,3],retriev:[3,5],right:2,root:2,routin:5,row:[3,5],run:[2,5],same:[3,5],savepoint:5,scenario:6,schema:[2,4,5,6],search:4,second:5,separ:[3,5],server:[2,3,5,6],set:[3,5],sever:[3,5,6],share:5,should:1,show:[3,5,6],silent:[5,6],simpl:4,simpli:2,sinc:3,singl:6,size:5,skip:5,skysql:0,slave:[3,5],snapshot:[2,3,5],socket:[2,5,6],sourc:6,specifi:5,speed:5,sphinx:1,split:5,sql:3,start:3,statement:5,statu:3,still:3,storag:5,store:[3,5],sub:3,subdirectori:3,success:5,suppli:3,support:5,symlink:3,synopsi:4,system:1,tabl:[2,5,6],tcp:[5,6],temporari:5,test:2,text:[5,6],than:[5,6],thei:3,them:3,thi:[2,3,5,6],thing:3,thread:[2,5,6],time:[3,5],time_zon:5,timeout:5,timestamp:5,tool:[2,5,6],top:5,transact:6,trigger:5,unix:[5,6],unlimit:5,unpredict:6,updat:3,usag:4,use:[2,5,6],used:[1,3,5,6],useful:6,user:[2,5,6],usernam:[5,6],using:[2,6],utc:5,valu:5,verbos:[5,6],version:[5,6],view:5,warn:[5,6],well:[3,5],when:[3,5,6],where:[1,2,3],which:2,whilst:2,wish:1,without:[2,3],worker:2,write:3,written:[0,3],you:[1,2,5],yum:1,yyyymmdd:5,zero:3,zlib1g:1,zlib:1,zone:5,zypper:1},titles:["Authors","Compiling","Examples","Output Files","Welcome to MySQL Data Dumper\u2019s documentation!","Mydumper Usage","Myloader Usage"],titleterms:{author:0,binari:3,cento:1,cmake:1,compil:1,daemon:[2,3],data:[3,4],debian:1,descript:[5,6],document:[1,4],dump:2,dumper:4,exampl:2,fedora:1,file:3,indic:4,log:3,mac:1,metadata:3,mode:[2,3],mydump:5,myload:6,mysql:4,opensus:1,option:[5,6],osx:1,output:3,redhat:1,regex:2,requir:1,restor:2,schema:3,simpl:2,synopsi:[5,6],tabl:[3,4],ubuntu:1,usag:[2,5,6],welcom:4}})