DonatShell
Server IP : 180.180.241.3  /  Your IP : 216.73.216.252
Web Server : Microsoft-IIS/7.5
System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
User : IUSR ( 0)
PHP Version : 5.3.28
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /Program Files/MySQL/MySQL Workbench 6.3 CE/modules/migration_bulk_copy_data.pyc
ó
2z”Xc@s8ddlZddd„ƒYZdefd„ƒYZdefd„ƒYZdefd	„ƒYZd
dd„ƒYZdefd
„ƒYZdefd„ƒYZdefd„ƒYZdefd„ƒYZ	dd d„ƒYZ
de
fd„ƒYZde
fd„ƒYZde
fd„ƒYZ
dd!d„ƒYZdS("iÿÿÿÿNtImportScriptcBs;eZd„Zed„ƒZd„Zd„Zd„ZRS(cCs
d|_dS(Nsimport_errors.log(terror_log_name(tself((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyt__init__scCsA|dkrtƒS|dkr&tƒS|dkr9tƒSdSdS(Ntwindowstlinuxtdarwin(tImportScriptWindowstImportScriptLinuxtImportScriptDarwintNone(t	target_os((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytcreatescCsdS(N((Rtconnection_argstpath_to_filetschema_name((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytgenerate_import_script$scCsdS(N((R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytget_script_ext&scCsdS(N((RttableR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytget_import_cmd(s(t__name__t
__module__RtstaticmethodRRRR(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRs
			RcBs#eZd„Zd„Zd„ZRS(cCsd|d||dfS(Ns\LOAD DATA INFILE '%s_#####_import/%s' INTO TABLE %s FIELDS TERMINATED BY ',' ENCLOSED BY '';t
target_schemattarget_table((RRR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR-scCsdS(Ntcmd((R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR0scCsdg}|jdƒ|jdƒ|jd|j|jfƒ|jd|d|d|jfƒ|jdƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jd
ƒ|jd
ƒ|jdƒ|jd|ƒ|jd||jfƒ|jdƒ|jdƒ|jd
ƒ|jd
ƒ|jd||jfƒ|jdƒ|jdƒ|jd
ƒ|jd
ƒ|jd|d|d|||jfƒ|jdƒ|jdƒ|jd
ƒ|jd
ƒ|jd|ƒ|jdƒ|jdƒ|jdƒ|S(Ns	@ECHO OFFs$echo Started load data. Please wait.sSET MYPATH=%%~dp0s1IF EXIST %%%%MYPATH%%%%%s del /F %%%%MYPATH%%%%%ss¯SET command=mysql.exe -h127.0.0.1 -P%s -u%s -p -s -N information_schema -e "SELECT Variable_Value FROM GLOBAL_VARIABLES WHERE Variable_Name = 'datadir'" 2^>^> %%%%MYPATH%%%%%sttarget_portttarget_users=FOR /F "tokens=* USEBACKQ" %%%%F IN ^(^`%%command%%^`^) DO ^(s    SET DADADIR=%%%%Fs^)sif %%ERRORLEVEL%% GEQ 1 ^(s9    echo Script has failed. See the log file for details.s
    exit /b 1spushd %%DADADIR%%smkdir %s_#####_importsBxcopy %%%%MYPATH%%%%*.csv %s_#####_import\* 2^>^> %%%%MYPATH%%%%%ssBxcopy %%%%MYPATH%%%%*.sql %s_#####_import\* 2^>^> %%%%MYPATH%%%%%ssOmysql.exe -h127.0.0.1 -P%s -u%s -p ^< %s_#####_import\%s 2^>^> %%%%MYPATH%%%%%ssrmdir %s_#####_import /s /qsecho Finished load datatpopdtpause(tappendR(RR
RRtoutput((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR3sD	

%















+






(RRRRR(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR,s		RcBs#eZd„Zd„Zd„ZRS(cCsd|d||dfS(Ns\LOAD DATA INFILE '%s_#####_import/%s' INTO TABLE %s FIELDS TERMINATED BY ',' ENCLOSED BY '';RR((RRR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRfscCsdS(Ntsh((R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRiscCsùdg}|jdƒ|jd|jƒ|jd|jƒ|jdƒ|jd|d|d|jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd
|ƒ|jd||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jd||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd|d|d|||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd|ƒ|jdƒ|S(Ns#!/bin/bashsMYPATH=\`pwd\`sif [ -f \$MYPATH/%s ] ; thens    rm \$MYPATH/%stfisÅTARGET_DIR=\`MYSQL_PWD=$arg_target_password mysql -h127.0.0.1 -P%s -u%s -s -N information_schema -e 'SELECT Variable_Value FROM GLOBAL_VARIABLES WHERE Variable_Name = \"datadir\"'\` 2>> \$MYPATH/%sRRsif [ \$? -ne 0 ];thens8   echo Script has failed. See the log file for details.s	   exit 1spushd \$TARGET_DIRsmkdir %s_#####_imports2cp \$MYPATH/*.csv %s_#####_import/ 2>> \$MYPATH/%ss2cp \$MYPATH/*.sql %s_#####_import/ 2>> \$MYPATH/%ss$echo Started load data. Please wait.s_MYSQL_PWD=$arg_target_password mysql -h127.0.0.1 -P%s -u%s < %s_#####_import/%s 2>> \$MYPATH/%ssecho Finished load datasrm -rf %s_#####_importR(RR(RR
RRR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRls@	

%













+





(RRRRR(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRes		R	cBs#eZd„Zd„Zd„ZRS(cCsd|d||dfS(Ns\LOAD DATA INFILE '%s_#####_import/%s' INTO TABLE %s FIELDS TERMINATED BY ',' ENCLOSED BY '';RR((RRR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRœscCsdS(NR ((R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRŸscCsùdg}|jdƒ|jd|jƒ|jd|jƒ|jdƒ|jd|d|d|jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd
|ƒ|jd||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jd||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd|d|d|||jfƒ|jd	ƒ|jd
ƒ|jdƒ|jdƒ|jdƒ|jd|ƒ|jdƒ|S(Ns#!/bin/bashsMYPATH=\`pwd\`sif [ -f \$MYPATH/%s ] ; thens    rm \$MYPATH/%sR!sÅTARGET_DIR=\`MYSQL_PWD=$arg_target_password mysql -h127.0.0.1 -P%s -u%s -s -N information_schema -e 'SELECT Variable_Value FROM GLOBAL_VARIABLES WHERE Variable_Name = \"datadir\"'\` 2>> \$MYPATH/%sRRsif [ \$? -ne 0 ];thens8   echo Script has failed. See the log file for details.s	   exit 1spushd \$TARGET_DIRsmkdir %s_#####_imports2cp \$MYPATH/*.csv %s_#####_import/ 2>> \$MYPATH/%ss2cp \$MYPATH/*.sql %s_#####_import/ 2>> \$MYPATH/%ss$echo Started load data. Please wait.s_MYSQL_PWD=$arg_target_password mysql -h127.0.0.1 -P%s -u%s < %s_#####_import/%s 2>> \$MYPATH/%ssecho Finished load datasrm -rf %s_#####_importR(RR(RR
RRR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR¢s@	

%













+





(RRRRR(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR	›s		tSourceRDBMScBs)eZd„Zed„ƒZd„ZRS(cCs
||_dS(N(t	source_os(RR#((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRÒscCs`|dkrt|ƒS|dkr,t|ƒS|dkrBt|ƒS|dkrXt|ƒSdSdS(Ntmssqltmysqlt
postgresqltsqlanywhere(tSourceRDBMSMssqltSourceRDBMSMysqltSourceRDBMSPostgresqltSourceRDBMSSqlAnywhereR
(tsource_rdbmsR#((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRÕs



cCsdS(N((RR((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytget_copy_table_cmdâs(RRRRRR-(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR"Ñs	
R(cBseZd„ZRS(cCsdt|jƒ|jƒƒS(NsÊbcp "SELECT %(select_expression)s FROM %(unquoted_source_schema)s.%(unquoted_source_table)s" queryout %(source_table)s.csv -c -t, -T -S .\%(source_instance)s -U %(source_user)s -P %%arg_source_passwords(tdicttitems(RRR
((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR-çs(RRR-(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR(æsR)cBseZd„Zd„ZRS(cCsO|jdkr-dt|jƒ|jƒƒSdt|jƒ|jƒƒSdS(NRsumysqldump.exe --login-path=wb_migration_source -t --tab=. %(source_schema)s %(source_table)s --fields-terminated-by=,s¥MYSQL_PWD=$arg_source_password mysqldump -h127.0.0.1 -P%(source_port)s -u%(source_user)s -t  --tab=/tmp %(source_schema)s %(source_table)s --fields-terminated-by=','(R#R.R/(RRR
((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR-íscCs|jdkrd|SdS(NRsomysql_config_editor.exe set --login-path=wb_migration_source -h127.0.0.1 -P%(source_port)s -u%(source_user)s -p(R#(RR
((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytget_cfg_editor_cmdós(RRR-R0(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR)ìs	R*cBseZd„ZRS(cCsdt|jƒ|jƒƒS(Nswpsql -U %(source_user)s -d %(source_schema)s -c "COPY %(source_table)s TO stdout DELIMITER ',';" > %(source_table)s.csv(R.R/(RRR
((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR-ùs(RRR-(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR*øsR+cBseZd„ZRS(cCsO|jdkr-dt|jƒ|jƒƒSdt|jƒ|jƒƒSdS(NRs¼dbisql.exe -c "DBN=%(source_schema)s;UID=%(source_user)s;PWD=%arg_source_password%" "SELECT * FROM %(source_table)s; OUTPUT TO '%(source_table)s.csv' FORMAT TEXT DELIMITED BY ',' QUOTE '';s·dbisql -c "DBN=%(source_schema)s;UID=%(source_user)s;PWD=$arg_source_password" "SELECT * FROM %(source_table)s; OUTPUT TO '%(source_table)s.csv' FORMAT TEXT DELIMITED BY ',' QUOTE '';(R#R.R/(RRR
((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR-þs(RRR-(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR+ýstDataCopyScriptcBs)eZd„Zed„ƒZd„ZRS(cCs
d|_dS(Nsbulk_copy_errors.log(R(R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRscCsA|dkrtƒS|dkr&tƒS|dkr9tƒSdSdS(NRRR(tDataCopyScriptWindowstDataCopyScriptLinuxtDataCopyScriptDarwinR
(R#((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR
scCsdS(N((Rttablestscript_pathR,((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytgenerates(RRRRRR7(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR1s	R2cBseZd„ZRS(cCs6d}dt|ƒ}|dd}|dd}	d|}
d|
}d||jƒf}d|}
t|d	ƒ»}|jd
ƒ|jdƒ|jd|j|jfƒt|tƒrà|jd
|jƒ|jdƒ|jdƒ|jdƒ|jdƒ|jd|j|ƒ|jfƒ|jdƒ|jdƒ|jdƒ|jdƒ|jd|d|d|jfƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒ|jdƒn|jdƒ|jdƒt|tƒs|jdƒn|jdƒ|jd||
fƒ|jd|
ƒ|jd|
ƒ|d}|jd |
ƒ|jd!d"|
fƒ|jd!d#|
fƒ|jd!d$|	|
fƒ|jd%|d&|ƒx|D]þ}|jd|j	||ƒ|jfƒ|jdƒ|jdƒ|jdƒ|jdƒt|tƒr‰|jd'|d(|d(fƒ|jd)|d(ƒn|jd!|j
|d*|d(ƒ|
fƒ|d}|jd+|d&||d(fƒqãW|jd |ƒ|j||
|	ƒ}x%|D]}|jd,||fƒqW|d}|jd-|d&||fƒ|jd.ƒ|jd/|
ƒ|jd0ƒ|jd1ƒ|jd2ƒ|jd3ƒ|jd4ƒ|jd5ƒ|jd6ƒ|jd7ƒ|jd8ƒ|jd9ƒ|jd:|
|jfƒ|jdƒ|jdƒ|jdƒ|jdƒ|d}|jd;|d&||
fƒ|jd<|
|jfƒ|jdƒ|jdƒ|jdƒ|jdƒ|jd=|
ƒ|jd>ƒ|jd?|
ƒ|jd@|
ƒ|jd.ƒ|jdA|
ƒ|jdBƒWdQXdS(CNiit
source_schemaRsdump_%ss%s.logsimport_%s.%ss
import_%s.sqlswb+s@ECHO OFF
sSET MYPATH=%~dp0
s+IF EXIST %%MYPATH%%%s del /F %%MYPATH%%%s
sTmysql_config_editor.exe remove --login-path=wb_migration_source 2>> "%%MYPATH%%%s"
sif %ERRORLEVEL% GEQ 1 (
s;    echo Script has failed. See the log file for details.
s    exit /b 1
s)
s%s 2>> "%%MYPATH%%%s"
s­SET command=mysql.exe -h127.0.0.1 -P%s -u%s -p -s -N information_schema -e "SELECT Variable_Value FROM GLOBAL_VARIABLES WHERE Variable_Name = 'datadir'" 2>> "%%MYPATH%%%s"
tsource_porttsource_users6FOR /F "tokens=* USEBACKQ" %%F IN (`%command%`) DO (
s    SET DADADIR=%%F
s6set arg_source_password="<put source password here>"
sSET DADADIR=%TEMP%\
s6set arg_target_password="<put target password here>"
spushd %DADADIR%
s&echo [%d %%%%] Creating directory %s
s
mkdir %s
s
pushd %s
is
copy NUL %s
secho %s >> %s
sSET SESSION UNIQUE_CHECKS=0;s!SET SESSION FOREIGN_KEY_CHECKS=0;suse %s;s%echo [%d %%%%] Start dumping tables
idsrename %s.txt %s.csv
tsource_tablesdel %s.sql
s%s.csvs echo [%d %%%%] Dumped table %s
s(echo %s) >> %s
s+echo [%d %%%%] Generated import script %s
spopd
sset TEMPDIR=%%DADADIR%%%s
sHecho Set fso = CreateObject("Scripting.FileSystemObject") > _zipIt.vbs
sUecho InputFolder = fso.GetAbsolutePathName(WScript.Arguments.Item(0)) >> _zipIt.vbs
sQecho ZipFile = fso.GetAbsolutePathName(WScript.Arguments.Item(1)) >> _zipIt.vbs
s–echo CreateObject("Scripting.FileSystemObject").CreateTextFile(ZipFile, True).Write "PK" ^& Chr(5) ^& Chr(6) ^& String(18, vbNullChar) >> _zipIt.vbs
sEecho Set objShell = CreateObject("Shell.Application") >> _zipIt.vbs
sGecho Set source = objShell.NameSpace(InputFolder).Items >> _zipIt.vbs
sAecho objShell.NameSpace(ZipFile).CopyHere(source) >> _zipIt.vbs
sxecho Do Until objShell.NameSpace( ZipFile ).Items.Count ^= objShell.NameSpace( InputFolder ).Items.Count >> _zipIt.vbs
s&echo wScript.Sleep 200 >> _zipIt.vbs
secho Loop >> _zipIt.vbs
sLCScript  _zipIt.vbs  "%%TEMPDIR%%"  "%%DADADIR%%%s.zip" 2>> "%%MYPATH%%%s"
s0echo [%d %%%%] Zipped all files to %s.zip file
s,xcopy %s.zip %%MYPATH%% 2>> "%%MYPATH%%%s"
sdel %s.zip
sdel _zipIt.vbs
sdel /F /Q %s\*.*
s
rmdir %s
s]echo Now you can copy %%MYPATH%%%s.zip file to the target server and run the import script.
spause
(tlenRtopentwriteRt
isinstanceR)R0RR-RR(RR5R
R6R,t
import_scripttprogressttotal_progressR8Rtdir_nametlog_filetimport_file_nametimport_sql_file_nametfRtimport_file_linestline((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR7s¼








#



%










&



+
'























(RRR7(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR2sR3cBseZd„ZRS(cCs=d}dt|ƒ}|dd}|dd}	d|}
d|
}d||jƒf}d|}
t|d	ƒÂ}tj|d
ƒ|jdƒ|jdƒ|jd
ƒ|jdƒ|jdƒ|jd|jƒ|jd|jƒ|jdƒxŽ|D]†}|jd|dƒ|jdƒ|jd|dƒ|jdƒ|jd|dƒ|jdƒ|jdƒ|jdƒqW|jdƒ|jd||
fƒ|jd|
ƒ|jd|
ƒ|d}|jd d!|
fƒ|jd"d#|
fƒ|jd"d$|	|
fƒ|jd%|d&|ƒx5|D]-}|jd'|j||ƒ|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒt|t	ƒr|jd+|d|dfƒ|jd,|dƒ|jdƒ|jd-|dƒ|jdƒn|jd"|j
|d.|dƒ|
fƒ|d}|jd/|d&||dfƒqHW|jd0|ƒt|tƒs¨t|tƒr¼|jd1|ƒn|j
||
|	ƒ}x%|D]}|jd"||fƒqØW|d}|jd2|d&||fƒ|jd3ƒ|jd4|
|
|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒ|d}|jd5|d&||
fƒ|jd6|
ƒ|jd7|
|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒ|jd3ƒ|jd8|
ƒ|jd9ƒWdQXdS(:NiiR8Rsdump_%ss%s.logsimport_%s.%ss
import_%s.sqlsw+iÀs
#!/bin/bash

s
MYPATH=`pwd`
s1arg_source_password="<put source password here>"
s1arg_target_password="<put target password here>"
sÙ
    if [ -z "$arg_source_password" ] && [ -z "$arg_target_password" ] ; then
        echo WARNING: Both source and target RDBMSes passwords are empty. You should edit this file to set them.
        exit 1
    fi
    sif [ -f $MYPATH/%s ] ; then
s    rm $MYPATH/%s
sfi
sif [ -f /tmp/%s.txt ];
R;sthen
s   rm /tmp/%s.txt 2> /dev/null
s   if [ $? -ne 0 ];then
sb       echo "File /tmp/%s.txt already exists. You should remove file before running this script."
s       exit 1
s   fi
spushd /tmp
s#echo [%d %%] Creating directory %s
s	mkdir %s
s	pushd %s
isecho "%s" > %s
sSET SESSION UNIQUE_CHECKS=0;secho "%s" >> %s
s!SET SESSION FOREIGN_KEY_CHECKS=0;suse %s;s"echo [%d %%] Start dumping tables
ids%s 2>> $MYPATH/%s
sif [ $? -ne 0 ];then
s9   echo Script has failed. See the log file for details.
s
   exit 1
scp /tmp/%s.txt %s.csv
sif [ -f /tmp/%s.sql ];
s   rm /tmp/%s.sql
s%s.csvsecho [%d %%] Dumped table %s
s	touch %s
schmod +x %s
s(echo [%d %%] Generated import script %s
spopd
s zip -r %s.zip %s 2>> $MYPATH/%s
s-echo [%d %%] Zipped all files to %s.zip file
s
rm -rf %s
s!cp %s.zip $MYPATH 2>> $MYPATH/%s
sdecho Now you can copy $MYPATH/%s.zip file to the target server, unzip it and run the import script.
s*read -p "Press [Enter] key to continue..."(R<RR=tostchmodR>RR-R?R)RR	RR(RR5R
R6R,R@RARBR8RRCRDRERFRGRRHRI((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR7”sš















&




+
'












(RRR7(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR3“sR4cBseZd„ZRS(cCs=d}dt|ƒ}|dd}|dd}	d|}
d|
}d||jƒf}d|}
t|d	ƒÂ}tj|d
ƒ|jdƒ|jdƒ|jd
ƒ|jdƒ|jdƒ|jd|jƒ|jd|jƒ|jdƒxŽ|D]†}|jd|dƒ|jdƒ|jd|dƒ|jdƒ|jd|dƒ|jdƒ|jdƒ|jdƒqW|jdƒ|jd||
fƒ|jd|
ƒ|jd|
ƒ|d}|jd d!|
fƒ|jd"d#|
fƒ|jd"d$|	|
fƒ|jd%|d&|ƒx5|D]-}|jd'|j||ƒ|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒt|t	ƒr|jd+|d|dfƒ|jd,|dƒ|jdƒ|jd-|dƒ|jdƒn|jd"|j
|d.|dƒ|
fƒ|d}|jd/|d&||dfƒqHW|jd0|ƒt|tƒs¨t|tƒr¼|jd1|ƒn|j
||
|	ƒ}x%|D]}|jd"||fƒqØW|d}|jd2|d&||fƒ|jd3ƒ|jd4|
|
|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒ|d}|jd5|d&||
fƒ|jd6|
ƒ|jd7|
|jfƒ|jd(ƒ|jd)ƒ|jd*ƒ|jdƒ|jd3ƒ|jd8|
ƒ|jd9ƒWdQXdS(:NiiR8Rsdump_%ss%s.logsimport_%s.%ss
import_%s.sqlsw+iÀs
#!/bin/bash

s
MYPATH=`pwd`
s1arg_source_password="<put source password here>"
s1arg_target_password="<put target password here>"
sÙ
    if [ -z "$arg_source_password" ] && [ -z "$arg_target_password" ] ; then
        echo WARNING: Both source and target RDBMSes passwords are empty. You should edit this file to set them.
        exit 1
    fi
    sif [ -f $MYPATH/%s ] ; then
s    rm $MYPATH/%s
sfi
sif [ -f /tmp/%s.txt ];
R;sthen
s   rm /tmp/%s.txt 2> /dev/null
s   if [ $? -ne 0 ];then
sb       echo "File /tmp/%s.txt already exists. You should remove file before running this script."
s       exit 1
s   fi
spushd /tmp
s#echo [%d %%] Creating directory %s
s	mkdir %s
s	pushd %s
isecho "%s" > %s
sSET SESSION UNIQUE_CHECKS=0;secho "%s" >> %s
s!SET SESSION FOREIGN_KEY_CHECKS=0;suse %s;s"echo [%d %%] Start dumping tables
ids%s 2>> $MYPATH/%s
sif [ $? -ne 0 ];then
s9   echo Script has failed. See the log file for details.
s
   exit 1
scp /tmp/%s.txt %s.csv
sif [ -f /tmp/%s.sql ];
s   rm /tmp/%s.sql
s%s.csvsecho [%d %%] Dumped table %s
s	touch %s
schmod +x %s
s(echo [%d %%] Generated import script %s
spopd
s zip -r %s.zip %s 2>> $MYPATH/%s
s-echo [%d %%] Zipped all files to %s.zip file
s
rm -rf %s
s!cp %s.zip $MYPATH 2>> $MYPATH/%s
sdecho Now you can copy $MYPATH/%s.zip file to the target server, unzip it and run the import script.
s*read -p "Press [Enter] key to continue..."(R<RR=RJRKR>RR-R?R)RR	RR(RR5R
R6R,R@RARBR8RRCRDRERFRGRRHRI((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR7üsš















&




+
'












(RRR7(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR4ûstDataCopyFactorycBs,eZd„Zd„Zd„Zd„ZRS(cCs=tj||ƒ|_tj|ƒ|_tj|ƒ|_dS(N(R"RR,R1tdatacopy_scriptRR@(RR#RR,((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRdscCs3d|kr|dd!S||jdƒdd!SdS(Nt.iiÿÿÿÿi(tindex(Rt
identifier((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyt_unquoteIdentifieriscCsx†|D]~}|d|d<|d|d<|j|dƒ|d<|j|dƒ|d<|j|dƒ|d<|j|dƒ|d<qWdS(NR8tunquoted_source_schemaR;tunquoted_source_tableRR(RQ(RR5R((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pytunquoteIdentifiersos
cCs3|j|ƒ|jj||||j|jƒdS(N(RTRMR7R,R@(RR5R
R6((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyR7xs
(RRRRQRTR7(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyRLcs				(((((RJRRRR	R"R(R)R*R+R1R2R3R4RL(((sQC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_bulk_copy_data.pyt<module>s966	zhh

Anon7 - 2022
AnonSec Team