BBdd

[joseamtalavera]

Local Machine

DB_HOST=database-2.c50syq0iyqal.eu-north-1.rds.amazonaws.com DB_DATABASE=database-2 DB_USER=postgres DB_PASSWORD=Rakna6164 DB_PORT=5432

CREATE DATABASE lha_inmo_app; access: psql -h database-2.c50syq0iyqal.eu-north-1.rds.amazonaws.com -U postgres -d lha_inmo_app -p 5432 password: Rakna6164

CREATE TABLE admins ( id SERIAL PRIMARY KEY, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

email: admin@example.com password: lha1234 email: jose@be-working.com password: be1234

Dockers / local

create postgres using docker-compose

db: image: postgres:13-alpine environment:

• POSTGRES_USER=postgres
• POSTGRES_PASSWORD=postgres
• POSTGRES_DB=mydatabase ports:
• '5432:5432' # Optional, for direct access from host volumes:
• db-data:/var/lib/postgresql/data

volumes: db-data:

• First get the id for the postgres

docker ps

• Second, access to the postgres

docker exec -it lhm_inmo_app-db-1 psql -U postgres -d mydatabase

email: jose@test.com password: 1234

EC2

h=database-2.c50syq0iyqal.eu-north-1.rds.amazonaws.com d=lha_inmo_app u=postgres p=5432 password=Rakna6164

psql -h database-2.c50syq0iyqal.eu-north-1.rds.amazonaws.com -d lha_inmo_app -U postgres -p 5432

DATABASE_URL=postgres://postgres:Rakna6164@database-2.c50syq0iyqal.eu-north-1.rds.amazonaws.com:5432/lha_inmo_app

Import Database from the Local to Docker

1. Prepare the MySQL Dump File. Ensure that your MySQL dump file
2. Install pgloader. Install pgloader on your local machine. This tool will be used to convert the MySQL dump to a PostgreSQL-compatible format.

brew install pgloader

4. Start a temp mysql database in a new container. This will create a mysql image

docker run --name temp_mysql -e MYSQL_ROOT_PASSWORD=root -d -p 3306:3306 mysql:5.7

5. Copy the MySQL Dump File to the MySQL Docker Container

Copy the MySQL Dump File to the MySQL Docker Container

6. Import the the mysql dump file in the temp mysql database.

• Exec into the MySQL container: docker exec -it temp_mysql bash
• Log into MySQL: mysql -u root -p
• enter root
• create a new database and import the dump:

CREATE DATABASE lhainmobiliaria; USE lhainmobiliaria; SOURCE /dump-lhainmobiliaria-202410151837.sql;