Home about IT Motivation Course Sales Project About Me

Thursday, July 18, 2019

EXPORT & IMPORT SQL FILE TO MYSQL TABLE

#IMPORT SQL FILE TO TABLE
Login to mysql database first then run below script:
source namefile.sql

or from logout of mysql
mysql -u root -p DBName < NameofImportTable.sql

#EXPORT TABLE TO SQL FORMAT
exit from mysql sql first then run below script:
mysqldump -u root -p DBname TableName > NameofExportTableFile.sql

No comments: