Thursday, 15 November 2018

How to create Database Dump using MySQLDump

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:

[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