How to import mysql database using command in Linx

Restore the backup database to a local server.

mysql -u [username] –p[password] [database_name] < [dump_file.sql]

[username] - A valid MySQL username.

[password] - A valid MySQL password for the user.

[database_name] - A valid Database name you want to take backup.

[dump_file.sql] - The name of the backup dump file you want to restore.

Tags : mysql

Related Post