PostSparrow

Import sql database file by command Line

In Ubuntu open terminal :-

/opt/lampp/bin/mysql -u root

use database_name;

source /var/www/backup.sql;

in Windows open cmd :-

cd xampp\mysql\bin

mysql -u root

use database_name;

source C:/Users/Avinash/Downloads/bckup.sql;

command for direct import sql file from server

mysql -u root -p cdl_jobcast < /var/www/html/DB/cdl_jobcast.sql