/Shell/Bash/Import database mysql

Import database mysql

How to export db from mysql

mysqldump -u username -p dbname > dbexport.sql

14

Source: a2hosting.in

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

10

Mysql import sql file

mysql -u username -p database_name < file.sql

10

Import database from a file using mysql commandline

mysql -u username -p database_name < file.sql

1

Source: stackoverflow.com

Mysql export database command line

mysqldump --databases --user=root --password your_db_name > export_into_db.sql

1

Import database mysql

#!/bin/sh
mysql -u root --password="${MYSQL_ROOT_PASSWORD}" --database=projectdb </tmp/projectdb.sql &&
  rm /tmp/projectdb.sql

0

Similar codes

5 votes145 views2 answers
Apt clean cache
Shell/Bash
9 votes155 views4 answers
File list to text
Shell/Bash
0 vote161 views1 answer
Linux How do you find files that have specific permissions?
Shell/Bash
31 votes140 views6 answers
How to remove directory in linux
Shell/Bash
-1 vote138 views2 answers
Error: pathspec 'origin/main-dev' did not match any file(s) known to git
Shell/Bash
0 vote146 views2 answers
Dukto for ubuntu download
Shell/Bash
0 vote136 views1 answer
Set up django-lint
Shell/Bash
0 vote174 views1 answer
Bash run a command every x second
Shell/Bash
0 vote158 views1 answer
Wasm-pack install
Shell/Bash
3 votes145 views1 answer
Remove systemd service
Shell/Bash

Share