BACKUP AND RESTORE DATA PORTAL DATABASE MYSQL

-

Backup the SQL file

docker exec -i 41e9179d4edc mysqldump -u mbda_data_user -p mbda_data_portal > mbda_data_portal_backup.sql


Copy the SQL file into the Container (if not already inside)

docker cp /path/to/mbda_data_portal.sql <container_name_or_id>:/tmp/mbda_data_portal.sql

This will copy the SQL file to the /tmp directory inside the container.

Import the SQL File into MariaDB

Once the file is in the container, you can import it by executing a mysql command inside the running container.

Steps:Access the Docker container shell: 

           docker exec -it <container_name_or_id> /bin/bash


Run the MySQL command to import the SQL file: Inside the container, run the following command to import the SQL file into the desired database:


root@fc78ab3e56fc:/# mysql -u mbda_data_user -p mbda_data_portal < /mbda_data_portal_backup.sql



How to get inside the databases

docker exec -it mbda-data-portal-mbda_dataportal_database-1 mysql -u mbda_data_user -p






Comments

Post a Comment

Popular posts from this blog

Moodle Backup and Restore in Docker

-
Backup moodle & mariadb images to a folder First, Run the docker commit container command this is just for copying the container image (where  moodle-moodle-1 &   moodle-mariadb-1   is the name of the constainer try: "docker ps" to look for the name of that container you want to commit ) : # docker commit -p moodle-moodle-1 backup-moodle-moodle-1 # docker commit -p moodle-mariadb-1 backup-moodle-mariadb-1 Alternatively, we can save it as a tar file in any directory and move it freely to any desired docker host system for a deployment: # docker save -o ~/backup-moodle-moodle-1.tar backup-moodle-moodle-1 # docker save -o ~/backup-moodle-mariadb-1.tar backup-moodle-mariadb-1 Backing up Docker volumes to a folder # docker volume ls Secondly , Backup the data in the docker volumes into a compressed file archive and save it to the local directory /tmp or any directory you want (just change only the /tmp to any directory you want) the  mariadb_data, moodle_data, mo...
Read more

Custom Domain to GitHub Pages (Hostinger Edition)

-
Image
Go to your Hostinger domain DNS settings The first step is to go to your Hostinger domain DNS settings. You can do this by visiting  https://hpanel.hostinger.com/domain/yourdomain.com/dns . Create two new CNAME records We need to create two new CNAME records. The first record will point  www.yourdomain.com  to  <your-github-username>.github.io . The second record will point  yourdomain.com  to  <your-github-username>.github.io . Enter Type - CNAME, Name - www, Points to - .github.io, TTL you can leave as default. This is for when someone types  www.yourdomain.com . Then we need the same for APEX domains or when someone just types  yourdomain.com , for this enter another CNAME with Name - @ and Points to .github.io. This will automatically set an ALIAS type and add it to the DNS records.  Add the GitHub Pages IP addresses Finally, we need to add the IP addresses and the txt value(this is obtain in the github/gitlab itself) for...
Read more

Resizing partition in AWS

-
  First lsblk If Using a Standard Partition (No LVM) Resize the partition: sudo growpart /dev/nvme0n1 1 Resize the filesystem: sudo resize2fs /dev/nvme0n1p1 # For ext4 sudo xfs_growfs /dev/nvme0n1p1 # For XFS Step 4: Verify the New Storage df -h You should now see the increased disk space. 🚀
Read more