cat /root/.my.cnf
[mysqldump]
user = root
password = Zinn-a-Zu
[client]
user = root
password = Zinn-a-Zu


harvey: /var/backups/mysql/daily
akolmogo.sql.gz
akustas1.sql.gz
gwint1.sql.gz
hzils.sql.gz
mneuhard.sql.gz
wcp38.sql.gz
world.sql.gz
 
SAVE mysql files
cd /var/lib
systemctl stop mysqld
systemctl status mysqld
tar -cvf mysql.tar mysql
systemctl start  mysqld

Look for /root/Desktop/centosone-mysql.sql


https://centostwo.binghamton.edu/legacychouck/public_html/projects/mysql.html

To load database
================
Go into mysql
  Create the database for each dump. PHPmyAdmin
  Create the database user
         To get user PMA - [Databases] Check privleges
         check box the user and  Export

mysql -u root -p <datebase name> < sqldump-file-name.sql


To get user priviledges
=========================
from https://harvey.binghamton.edu/myDBadmin/

[User Accounts]

find user

Edit privileges
    ( Databases )
      Export 
GRANT USAGE ON *.* TO 'hzils'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `hzils`.* TO 'hzils'@'localhost';


Here are a couple of links explaining how to import and export a MySQL database using the command line:

    How To Import and Export Databases in MySQL or MariaDB
    https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

    Import and Export Databases in MySQL using Command Line
    https://www.interserver.net/tips/kb/import-export-databases-mysql-command-line/

    Youtube video on how to import and export a database using phpMyAdmin.
    https://www.youtube.com/watch?v=_GgeT_DBawM