/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

2 votes146 views3 answers
Error Failed to install the app. Make sure you have the Android development environment set up
Shell/Bash
0 vote150 views1 answer
Removing portion of history from terminal mac
Shell/Bash
20 votes155 views2 answers
Homebrew install git
Shell/Bash
2 votes144 views2 answers
Install firewall-cmd centos 7
Shell/Bash
2 votes152 views3 answers
Conda install ffmpeg
Shell/Bash
8 votes156 views2 answers
How to restart psql in linux
Shell/Bash
0 vote116 views3 answers
Error: there are no scenarios; must have at least one.
Shell/Bash
0 vote142 views1 answer
Execution failed for task ':react-native-firebase_auth:generateDebugRFile'
Shell/Bash
6 votes136 views4 answers
Install nodejs 14 for ubuntu 20.04
Shell/Bash
16 votes144 views2 answers
Git remove commit before push
Shell/Bash