Junaid's Blog

Tag: mysql

  • Replace Collation on a MySQL Dump File

    —

    by

    Junaid
    in

    Sometimes we may find difficulty with importing a database from dump file which is created from a different machine. It may issue an error message like this: Which means the dump file uses a collation which the mysql server on the target machine not understanding. One solution is to replace the collation with one that…

  • Install and Run Multiple PHP Versions in Ubuntu 22.04

    —

    by

    Junaid
    in

    I wanted to run both Drupal 7 and 9, as part of my work, in my machine now running on Ubuntu 22.04. Drupal 7 best run with PHP 5.6 while Drupal 9 requires either PHP 7.4 or 8.1 I could make it work after some research and try. Here is how I made it work.…

  • Install MySQL 5.7 on Ubuntu 20.04

    —

    by

    Junaid
    in

    First follow installation instructions given at https://docs.docker.com/engine/install/ubuntu/ . Then make sure docker is running properly: Ensure it created the image by: Now, install docker MySQL 5.7 image and create a volume for storing data. Make a MySQL installation with command: Replace the password with your one. To show running instances: Login to docker instance terminal:…