/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 vote159 views1 answer
How to clear gradle cache gitignore
Shell/Bash
8 votes114 views3 answers
Powershell make directory
Shell/Bash
0 vote139 views1 answer
ERROR: Failed building wheel for kiwisolver
Shell/Bash
0 vote140 views1 answer
Install laravel mix
Shell/Bash
3 votes146 views3 answers
Bash split string into array
Shell/Bash
0 vote163 views1 answer
Proxy v git
Shell/Bash
1 vote115 views2 answers
Reinstall xcode cli tools
Shell/Bash
1 vote119 views1 answer
Nohup & 2 &1
Shell/Bash
75 votes117 views4 answers
Upload new repo to git
Shell/Bash
2 votes148 views1 answer
Kumaran km github
Shell/Bash