/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 vote178 views1 answer
Redis::CommandError: MISCONF Redis is configured to save RDB snapshot
Shell/Bash
0 vote163 views1 answer
Run shell script remotely using ssh
Shell/Bash
0 vote163 views1 answer
Langkah-langkah menginstal git di terminal
Shell/Bash
1 vote188 views2 answers
Install htop
Shell/Bash
17 votes195 views6 answers
Pip upgrade all packages
Shell/Bash
0 vote165 views1 answer
Npm start prevent browser
Shell/Bash
0 vote165 views1 answer
Open first image in directory linux
Shell/Bash
20 votes175 views4 answers
Uninstall dependencies yarn
Shell/Bash
-2 votes194 views1 answer
Add username password git
Shell/Bash
4 votes178 views3 answers
Git how to remove git
Shell/Bash