Linux command mysql export and import data.

Basic command for import and export database

Telnet to database server.
-> telnet 192.168.0.2

Use MySQL
->mysql -uadmin -p1234
mysql>create database dbMember;

Export data
->mysqldump -uadmin -p1234 dbMember > dbMember.sql

If export data select table
->mysqldump -uadmin -p1234 dbMember tblMember > tblMember.sql

Import data
->mysql -uadmin -p1234 dbMember < dbMember.sql

If import data select table
->mysql -uadmin -p1234 dbMember tblMember < tblMember.sql