/opt/dedrads/__pycache__
NameSizeModeActions
alp.cpython-313.pyc188170644editdlrm
check_prov.cpython-313.pyc63940644editdlrm
clean_exim.cpython-313.pyc89020644editdlrm
cmspass.cpython-313.pyc63780644editdlrm
cms_check.cpython-313.pyc140790644editdlrm
cms_counter.cpython-313.pyc329480644editdlrm
cpanel_postgres_manager.cpython-313.pyc407620644editdlrm
docroot.cpython-313.pyc54920644editdlrm
envinfo.cpython-313.pyc81840644editdlrm
exclude_rbl.cpython-313.pyc66820644editdlrm
first_setup.cpython-313.pyc204930644editdlrm
fixwpcron.cpython-313.pyc72230644editdlrm
innodb_converter.cpython-313.pyc143470644editdlrm
mail_sources.cpython-313.pyc99690644editdlrm
modsec_disable.cpython-313.pyc158380644editdlrm
mysql_selector.cpython-313.pyc867480644editdlrm
show-conns-adv.cpython-313.pyc684140644editdlrm
sparta.cpython-313.pyc4909030644editdlrm
vhost_data.cpython-313.pyc69830644editdlrm
Edit: /opt/dedrads/__pycache__/innodb_converter.cpython-313.pyc (14347B)
}j$ SrSSKJr SSKrSSKrSSKJr SSKrSSKr\R"5S:wa\R"S5 \R"S5r \ R\R5 \R"\R 5r\R\R$5 \ R'\5 \R("S5r\R\R5 \ R'\5 SS\4S jjrS \4S jr\"5rS \4S jrS \S \\S-\\S-44SjrS \S\S \\S-\S-44Sjr S \S\S \S-4Sjr!S \\\44Sjr"S\S \4Sjr#S\S \4Sjr$Sr%\&S:Xa\%"5 gg)z$Converts all MyISAM tables to InnoDB)PathN)ArgumentParserzThis script must be run as rootzinnodb_convert.pyz/var/log/innodb_convert.logcheckc4U(agSUS3n[U5R5=(d UnUR5S:waTSUS3n[U5R5=(d UnUR5S:wa[R"S5 ggg)zIConfirms that backups have been taken, with configurable default (Y or N)NzHave you taken backups? (y/z) yz#Do you wish to continue anyway? (y/z Exiting...)inputstriplowersysexit)rdefaultpromptanswerprompt2answer2s /opt/dedrads/innodb_converter.pyconfirm_backupsrs *7)2 6F 6] " -gF ||~7yC.&&(3G ==?c ! HH\ " "returnc@[S5nUR5(d+[RS5 [R "S5 0n[ USS9nUHznURS5(aURS5n0X'M0UR5RS5upVURS S 5RS S 5nXaWU'M| S S S 5 S USSUSSS[RRS.nU$!,(df  N<=f)z/Returns a dictionary of the MySQL configurationz /root/.my.cnfz#Error: /root/.my.cnf does not existutf-8encoding[z[] ='"N localhostclientuserpasswordutf8mb4)hostr"r#charset cursorclass)rexistsloggererrorr r open startswithr splitreplacepymysqlcursors DictCursor) mysql_cnf my_cnf_datafilelinesectionkeyvaluedb_config_dicts r get_db_configr:(s_%I      :;  K i' *dDs##**V,') $!ZZ\//4  c2.66sB?,1G$S) +H%f-)*511 N # + *s BD Dc/n[R"S0[D6nUR5nUR S5 UR 5nUVs/sHo3SPM nnUsSSS5 sSSS5 $s snf!,(df  O=fSSS5 g!,(df  g=f![R Ra%nSU3n[R"U5 SnAgSnAff=f)zReturns a list of all databaseszSHOW DATABASESDatabaseNError: ) r/connect db_configcursorexecutefetchallerr MySQLErrorr r ) databases connectionrAxer*s rlist_databasesrJHsI  __ )y )Z""$/0"OO- 4=>Iqz]I > %$* )?%$$* ) ) ;; ! !!  scB*B&A>A9#A>& B/ B*9A>> B BB* B'#B*'B**C-C((C-databasec/n[R"SSU0[D6nUR5nUR S5 UR 5nUVs/sH oDSU-PM nnSU4sSSS5 sSSS5 $s snf!,(df  O=fSSS5 g!,(df  g=f![R Ra+nSUSU3n[RU5 US4sSnA$SnAff=f)z*Returns a list of all tables in a databaserKz SHOW TABLES Tables_in_N Error on : r>) r/r?r@rArBrCrDrEr)r*)rKtablesrGrArHrIr*s r list_tablesrQWs F  __ DEfL834fEV| %$= <F%$$= < < ;; ! !H:Rs+ Ud{siB1B &BB(B- B 6 B1B B B B1 B.*B1.B11C: C5/C:5C:tablec[R"SSU0[D6nUR5nSnUR SU45 UR 5nXES4sSSS5 sSSS5 $!,(df  O=fSSS5 g!,(df  g=f![R Ra.nSUSUSU3n[RU5 US4sSnA$SnAff=f) zReturns the engine of a tablerKNzSHOW TABLE STATUS LIKE %sEnginerN.rOr>) r/r?r@rArBfetchonerDrEr)r*)rKrRrGrAr* table_statusrIs r check_enginerXgs  __ ) r/r?r@rArBr.rDrEr)r*)rKrRtargetrGrArIr*s r convert_tabler\vs __ E 69E >E E E E  E0 rFcP/SQnUHnX ;dM URU5 M U$)z&Removes system databases from the list)information_schemaperformance_schemamysqlr test)remove)rFskipsrKs r clean_db_listrws- PE    X & rc/nUR(aSnSnOSnSnUGHOn[U5upgUR(aXURU;aUR/nO:SURSU3n[R U5 UR U5 MzU(aUR U5 MUHn[ XX5upiU(aUR U5 M*UR(a[RSXXU 5 MTU R5UR5:XdMx[RSXXU5 [XXU5nU(dMUR U5 M GMR U$)zProcesses all databasesInnoDBMyISAMr=z does not exist in z %s.%s is %szConverting %s.%s to %s) myisamrQrRr)r*rbrXrinfor r\) rFargserrorscurrentr[rKr*rPrRengines rprocess_databasesrs( F {{#H-  ::zzV#**!$**-@ K U# e$  MM% E(9ME e$zz M8FC||~0 4hvN%hv>5MM%(6 Mrc [SS9nURSSSSS9 URSS S S 9 URS S SS 9 URSSSS9 URSSSS9 UR5nUR(aMUR(a<[ R S5 UR5 [R"S5 OUR(dbUR(dQ[ R S5 [ R S5 UR5 [R"S5 O3UR(a"UR(dUR S5 /n[UR5 [5n[U5nUR(aEURnXC;a1SUS3n[ R U5 [R"U5 U/n[X15n[!5upg[#U5S:d[#U5S:aS[ R S5 UHn[ R SU5 M UHn[ R SU5 M [ R%S5 UR'5Hhup[ R%SU 5 U R'5H9upU S:Xa[ R%SU 5 M#[ R%S X5 M; Mj g!)"z Main functionz Converts MyISAM tables to InnoDB) descriptionz-az--allzSelect all databases store_true)helpactionz-dz --databasezDatabase to convert)rz-tz--tablez+Specify a table to convert. combine with -dz--checkzCheck selected databasesz--myisamz#Convert to MyISAM instead of InnoDBz2Error: --all and --database are mutually exclusiverzError: No database specifiedz3must use either --all (-a) or --database (-d) flagsz--table requires --databaser=z' does not exist or is a system databaserzErrors occurred:z %szInnoDB settings:z%srz %s = %sN)r add_argument parse_argsallrKr)r* print_helpr r rRrrrJrwrrolenr|rf) parserr}r~rFrKr*rkrj key_errorfilenamernr7r8s rmainrsJ (J KF g,B<X l1FG i.[\  (B<X  )NWcd    D xxDMM IJ  XXdmm 34 JK  DMM 23 FDJJ Ii(I }}==  $hZ'NOE LL  HHUOJ y /F";"=J 6{Q#j/A- '(E LL '#I LL +$ KK"#-335 D(#"..*JC{ FC( K4 +6r__main__)N)'__doc__pathlibrosr argparserloggingr/getuidr getLoggerr)setLevelDEBUG StreamHandlerstderrconsole_handlerINFO addHandler FileHandler file_handlerboolrdictr:r@r`rJrctuplerQrXr\rorwrr__name__r>rrrs* #99;!HH ./   . / '' 3&/"""#@A gmm$, #4 #t: O    # %d DI4D(D"E  3 s uS4Zt5K/L  C  d '5t#4'<Td$$$N/5d zFr