sudo yum install epel-release
sudo yum install phpmyadmin
- allow access from home IP address
sudo vim /etc/httpd/conf.d/phpMyAdmin.conf
# - allow/require [home workstation IP addr]
- from browser go into phpMyAdmin (<serverIP>/phpMyAdmin)
- log into root account, using mySQL root password
use phpMyAdmin to create database
- click New
- Under Create database
- set database name for <project-database> and <project-database-sandbox>
- pull down utf8_general_ci
- click Create
Use phpMyAdmin to create user after creating database
- click Users
- click Add user
- User name: <database-username>
- Host: 127.0.0.1
- Password: <unique password>
- click Go
Use phpMyAdmin to give database user access to database
- click Users
- next to <database-username>, click Edit Privileges
- Click Database
- Add privileges on the following databases
- select <project-database> and <project-database-sandbox>
- click Go
- check Check All
- click go
See https://webcheatsheet.com/SQL/mysql_backup_restore.php
Dump
mysqldump -h 127.0.0.1 [-P 8889] -u [user] -p [database] > file.sql
# enter [user] password
# note [-P 8889] is if different port, e.g., using mamp
Restore
mysql -h 127.0.0.1 [-P 8889] -u [user] -p [database] < file.sql
# enter [user] password
# note [-P 8889] is if different port, e.g., using mamp
or
gunzip < file.sql.gz | mysql -h 127.0.0.1 [-P 8889] -u [user] -p [database]
[or] zcat file.sql.gz | mysql -h 127.0.0.1 [-P 8889] -u [user] -p [database]
# enter [user] password
Use phpmyadmin to restore database. note the file size accepted is limited
- select database to be restored
- click Import
- choose file (.sql or can be gzipped)
- go