Code Affairs Web Technologies!

widgets Import Sql file to Mysql Database

For import sql file to database:

mysql -uUsername -p database_name_backup.sql < database_name.sql

Then write password and start import process.

For compressed files like sql.bz2 :

bunzip2 < database_filename.sql.bz2 | mysql -uUsername -p target_database_name

bubble_chart Short Description

history_toggle_off Created: March 30, 2019, 9 a.m.

category Related Categories

visibility Total Read: 6