Monday, 16 September 2019

MySQL Dump to be taken before i Upgrade mySQL and / or CreateDb's/ tables for a New Django project

#Own mySQL Version
$ mysql –version         mysql  Ver 14.14 Distrib 5.7.27

$ sudo mkdir -p /var/run/mysqld
$ sudo chown mysql:mysql /var/run/mysqld
$ cd /var/run/mysqld
 :/var/run/mysqld$ ls -ltr
# Seen below result of $ ls -ltr

# We can notice the last line of the command $ ls -ltr , or we can make life easier and do a grep 

:/var/run$ ls -ltr | grep mysqld

drwxr-xr-x  2 mysql         mysql           40 Sep 16 18:50 mysqld

# Thus , it shows that within the directory -  /var/run/ , there has been created a directory named - mysqld - which is owned by - mysql 

# Also the    /var/run$ ls -ltr --human-readable | grep mysqld
drwxr-xr-x  2 mysql         mysql           40 Sep 16 18:50 mysqld
# Output will be same ...



No comments:

Post a Comment