Answers for "import database mysql"

10

how to export db from mysql

mysqldump -u username -p dbname > dbexport.sql
Posted by: Guest on May-19-2020
8

linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql
Posted by: Guest on June-25-2020
5

mysql import sql file

mysql -u username -p database_name < file.sql
Posted by: Guest on February-10-2020
2

import database mysql command line

mysql -u username -p new_database < data-dump.sql
Posted by: Guest on September-13-2020
1

Import database from a file using mysql commandline

mysql -u username -p database_name < file.sql
Posted by: Guest on January-20-2021
0

import database mysql

#!/bin/sh
mysql -u root --password="${MYSQL_ROOT_PASSWORD}" --database=projectdb </tmp/projectdb.sql &&
  rm /tmp/projectdb.sql
Posted by: Guest on September-18-2021

Code answers related to "Shell/Bash"

Browse Popular Code Answers by Language