---
# System prepended metadata

title: CREAinstancias
tags: [DataBase]

---

# 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
```