403Webshell
Server IP : 209.209.40.120  /  Your IP : 216.73.217.112
Web Server : Microsoft-IIS/10.0
System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586
User : NEWWWW$ ( 0)
PHP Version : 8.3.30
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/migration_bulk_copy_data.pyc
�
�"�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cCs�x�|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

Youez - 2016 - github.com/yon3zu
LinuXploit