MySQL Import/Export Commands

Importing and Exporting through commands for mysql:

Import File into Mysql:

• mysql -ppassword -hlocalhost schemaname < /filePath/file.sql

Export Mysql Schema in File:

• mysqldump -uusername -ppassword database_name > dump.sql
• mysqldump -uusername -ppassword -no-data database_name > dump.sql

rizzz86