Skip to main content

Import_Export_SQLFile

How to Import MySQL Database or SQL File​

  • Access MySQL with Root User
mysql -u root -p
  • Create New Database
Syntax:- CREATE DATABASE Database_name;
Example:- CREATE DATABASE osmsdb;
  • Access Newly Created Database
Syntax:- USE Database_name;
Example:- USE osmsdb;
  • Import Database or SQL File
Syntax:- source sql_file_path
Example:- source /var/myimporteddb/osmsdb.sql

How to Export MySQL Database as SQL File​

  • Export MySQL Database as SQL File
Syntax:- mysqldump -u db_user_name -p Database_Name > File_Path/File_Name.sql
Example:- mysqldump -u root -p dps > /var/myexporteddb/dps.sql