/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

1 vote122 views1 answer
Npm windows set env variable
Shell/Bash
2 votes125 views2 answers
Restart elasticsearch
Shell/Bash
6 votes123 views4 answers
Git clean branches
Shell/Bash
0 vote119 views1 answer
Installing mailcatcher ubuntu
Shell/Bash
1 vote125 views1 answer
Rename heroku app local
Shell/Bash
6 votes133 views1 answer
Git error needs merge
Shell/Bash
0 vote130 views1 answer
Github fork subdirectory
Shell/Bash
0 vote192 views1 answer
Curl get-pip
Shell/Bash
4 votes150 views4 answers
Reinstall mysql
Shell/Bash
0 vote129 views1 answer
Check if a command exists
Shell/Bash