/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

5 votes185 views4 answers
Unzip mac terminal
Shell/Bash
1 vote191 views1 answer
Ubuntu boot slow
Shell/Bash
45 votes235 views2 answers
Plasma
Shell/Bash
8 votes193 views1 answer
React icons delete
Shell/Bash
5 votes178 views2 answers
Unable to resolve reference git
Shell/Bash
1 vote178 views1 answer
Kali linux wsl
Shell/Bash
3 votes174 views1 answer
Ports are not available: listen tcp 0.0.0.0/50070: bind: An attempt was made to access a socket in a way forbidden by its access permissions
Shell/Bash
63 votes171 views3 answers
How to remove a remote origin in git and add new
Shell/Bash
0 vote191 views1 answer
Open a file in crrent vcscode using cmd
Shell/Bash
0 vote205 views1 answer
Centos install copmposer
Shell/Bash