/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 vote119 views1 answer
Ubuntu gpg 2
Shell/Bash
0 vote122 views1 answer
Git autocorrect
Shell/Bash
77 votes197 views6 answers
Zip files linux
Shell/Bash
8 votes131 views2 answers
Anaconda install package
Shell/Bash
0 vote114 views1 answer
Head equivalent cmd windows of pipeline output
Shell/Bash
0 vote140 views1 answer
How to remove MINGW64 from git bash
Shell/Bash
1 vote116 views2 answers
Copy ssh key from windows to linux
Shell/Bash
23 votes137 views6 answers
Git remove Untracked files
Shell/Bash
0 vote182 views1 answer
How to get the digit count of number swift
Shell/Bash
5 votes121 views1 answer
Git how to reset only one file
Shell/Bash