spranir/handy repository overview

Install Docker from this link - [ https://www.digitalocean.com/community/tutorials/how-to-install-and-use-docker-on-ubuntu-18-04⁠ ]

Pull the Docker latest updated handy docker image from here - [ https://hub.docker.com/r/spranir/handy/tags⁠ ]

Create a sub network for the containers to talk to other containers using the following command

      docker network create --subnet=172.18.0.0/16 handy

Create a container using the following command

      docker run -it -h handy --ip 172.18.0.5 -p 0.0.0.0:3306:3306 -p 0.0.0.0:2909:2909 --net handy -d --name handy handy:tag number

Start the container if it is not already started using the following command

      docker start handy

Login into the container using the following command

      docker exec -it handy bash -c "stty cols $COLUMNS rows $LINES && bash"

Start the MySQL server using the following command

      /etc/init.d/mysql restart (or) service mysql restart

Login to MySQL server using the credentials

      Username : root

      Password  : password

Check for spw_config and spw_audit databases inside the MySQL server using the following command

      show databases;

If the above mentioned databases are available then you are good to go and you can stop here

If you don't see the above mentioned databases then do the following

1. Create the above mentioned databases using the following command

      create database spw_config;
      
      create database spw_audit;
   

   Copy

2. Change directory using the following command

      cd /home/handy/database
   

   Copy

3. Load the MySQL backup file into the database using the following command

      mysql -u root -ppassword spw_config < spw_config.sql
   
      mysql -u root -ppassword spw_audit < spw_audit.sql
   

   Copy

That's it you are done with handy