/Shell/Bash/Upload sql database in devilbox

Upload sql database in devilbox

# Navigate to the Devilbox directory
host> cd path/to/devilbox

# Enter the PHP container
host> ./shell.sh

# Create new database if not present
mysql -u root -h 127.0.0.1 -p -e 'CREATE DATABASE my_wp;'
# OR START MYSQL THEN CREATE DATABASE
mysql -u root -h mysql
CREATE DATABASE my_database

# Start the import
mysql -h mysql -u root -p my_db_name < /shared/backups/mysql/my_db_name.sql

Source: devilbox.readthedocs.io

Similar codes

0 vote193 views1 answer
Future<void> _getCurrentUserLocation () async { final locData = await Location().getLocation(); final double newLatitude = locData.latitude; final double newLongitude = locData.longitude;
Shell/Bash
0 vote176 views1 answer
How to install wordcloud in python
Shell/Bash
0 vote201 views1 answer
How to generate a self-signed certificate SSL HTTPS
Shell/Bash
0 vote177 views1 answer
Git log with date
Shell/Bash
1 vote168 views2 answers
Restart ssh service mac
Shell/Bash
0 vote198 views1 answer
Ubuntu upgrade a single package
Shell/Bash
1 vote192 views1 answer
K8 svc url
Shell/Bash
2 votes176 views1 answer
How to remove .env file from git cache
Shell/Bash
0 vote177 views1 answer
Install godaddy ssl certificate on aws ec2 instance
Shell/Bash
1 vote221 views1 answer
Git remanme folder
Shell/Bash