Export and Import Database
Export and Import Database :
In mysql we can export(dump) and import database .The dump typically contains SQL statements to
create the table, populate it . However, mysqldump can also be used to generate files in CSV, other delimited text, or XML format.
For export:
mysqldump - u [username] -p[password] -h [host] >[filename]
For Import:
mysql -u [username] -p[password] -h [host] <[filename]
