# CREAinstancias ----- ###### tags: `DataBase` ### Plan de cambio ||Analisis|Instancia Productiva|Instancia Google| |:----|:----:|:----:|:----:| |<span class="text-nowrap"> **Copia de seguridad**</span> |✔|✔|✖| |<span class="text-nowrap"> **Restaurar**</span> |✖|✔|✔| |<span class="text-nowrap"> **Cambio de plataforma**</span> |✖|✖|✔| <br> ## Respaldos Mysql Thermofluidos Script backups console SCP9000 Thermofluidos Intance ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=Thermodb.FXLMFacturacion Thermodb > /opt/backups/previos/force_bakup.sql mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 -e "CREATE DATABASE Thermodb" mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 Thermodb < /opt/backups/previos/force_bakup.sql ``` ---- mysqldump -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=Thermodb.FXLMFacturacion Thermodb > backup_thermo_16.sql mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 Thermodb < /opt/backups/previos/force_bakup.sql mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 Thermodb_test < backup_thermo_16.sql ---- ## Respaldos Mysql Polydb Script backups console SCP9000 Polydb Intance ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=poly.FXLMFacturacion poly > /opt/backups/previos/force_bakuppoly.sql mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 -e "CREATE DATABASE poly" mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 poly -v < /opt/backups/previos/force_bakuppoly.sql ``` ## Respaldos Mysql polycopia polycopia Intance ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=polycopia.FXLMFacturacion polycopia > /opt/backups/previos/polycopia_bakup.sql mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 -e "CREATE DATABASE polycopia" mysql -u root -p"6dO7PwA2lMx1HwvG" -h 35.224.46.21 polycopia < /opt/backups/previos/polycopia_bakup.sql ``` ______ ## Respaldos Mysql RALY BD : raly_test USER: scpraly pass raly_test Intance Local ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=ralydb.FXLMFacturacion ralydb > /opt/backups/previos/ralydb_bakup.sql mysql -u root -p"Jn3:16&Ap3:20" -e "CREATE DATABASE ralydb_test" mysql -u root -p"Jn3:16&Ap3:20" ralydb_test -v < /opt/backups/previos/ralydb_bakup.sql ``` ----- raly_test Intance GOOGLE ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE --ignore-table=ralydb.FXLMFacturacion ralydb > /opt/backups/previos/ralydb_bakup.sql mysql -u root -p"2pzr9uwnejIHaji1" -h 35.194.53.128 -e "CREATE DATABASE ralydb_test" -v mysql -u root -p"2pzr9uwnejIHaji1" -h 35.194.53.128 ralydb_test -v < /opt/backups/previos/ralydb_bakup.sql ``` _______ ## Respaldos Mysql cfdsprovee BD : cfdsprovee cfdsprovee_test Intance Local ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE cfdsprovee -v > /opt/backups/previos/cfdsprovee_res.sql mysql -u root -p"Jn3:16&Ap3:20" -e "CREATE DATABASE cfdsprovee_test" -v mysql -u root -p"Jn3:16&Ap3:20" cfdsprovee_test -v < /opt/backups/previos/cfdsprovee_res.sql CREATE USER 'usuario'@'localhost' IDENTIFIED BY 'password'; ``` :::success Instance Google ::: raly_test Intance GOOGLE ```bash= mysql -u root -p"yCpvrL1xx3VE" -h 35.192.128.108 -e "CREATE DATABASE cfdsprovee_test" -v mysql -u root -p"yCpvrL1xx3VE" -h 35.192.128.108 cfdsprovee_test -v < /opt/backups/previos/cfdsprovee_res.sql ``` ---- ## Respaldos Mysql THERMO BD : Thermo_oldv Thermo_oldv Intance Local ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE Thermodb -v > /opt/backups/previos/Thermo_oldv.sql mysql -u root -p"Jn3:16&Ap3:20" -e "CREATE DATABASE thermo_old" -v mysql -u root -p"Jn3:16&Ap3:20" thermo_old -v < /opt/backups/previos/Thermo_oldv.sql ``` ----- # Tabla FMXLFacturacion Sinergy ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE sinergydb -v FXLMFacturacion > /opt/backups/previos/FXLMFac.sql mysql -u root -p"5F84CBq46HmGf9pF" -h 104.198.228.191 sinergydb -v < /opt/backups/previos/FXLMFac.sql mysqldump -u root -p"5F84CBq46HmGf9pF" -h 104.198.228.191 ``` # Laboratotio pruebas ```bash= mysql -u root -p"yCpvrL1xx3VE" -h 35.192.128.108 -e "CREATE DATABASE cfdsprovee_test" -v mysql -u root -p"5F84CBq46HmGf9pF" -h 104.198.228.191 sinergydb -v < /opt/backups/previos/FXLMFac.sql ``` #Dump20200318 # Costeo ```sql= mysql -u develov -p"0siete61" -h 35.188.120.132 -e "CREATE DATABASE cost" -v mysql -u postgres -p"l;n2@pdTonrU" -h 35.188.120.132 costos_develop -v < /home/pdual/costeo_dump.sql ``` # Tabla FListaEnsamble ```bash= mysqldump -h 34.68.173.102 -u root -p"c7iuho4vgLyPBDw8" scp9000 FListaEnsamble > /home/pdual/dumps/FListaEnsamble_backup.sql mysql -h 10.150.4.103 -u admin -p"Gc2b0ae0xqvi" scp900 FListaEnsamble < /home/pdual/dumps/FListaEnsamble_backup.sql -v ``` # CFDSPROVEE DEVELOP ```bash= mysqldump -u root -p"Jn3:16&Ap3:20" --default-character-set=latin1 --dump-date --quick --single-transaction=TRUE cfdsprovee -v > /opt/backups/previos/cfdsprovee_dev.sql mysql -u root -p"Jn3:16&Ap3:20" -e "CREATE DATABASE cfdsprovee_develop" -v mysql -u root -p"Jn3:16&Ap3:20" cfdsprovee_develop -v < /opt/backups/previos/cfdsprovee_dev.sql ```