Mostly, MySQLDump is used for taking backup of MySQL data backups. MySQL provide a mysqldump
scripts with the multiple options to take dump of MySQL Databases.
Syntax to create database dump:
Syntax to create database dump:
[root@linuxcnf
~]# mysqldump -u [username] –p[password] [dbname] > dumpfilename.sql
|
Example to create a database dump in MySQL:
[root@linuxcnf
~]# mysqldump –u root –pmypassword test_db > test_db_dump.sql
[root@linuxcnf
~]#
|
Database test_db backup is done!!!
No comments:
Post a Comment