Categories :

Export Database From MySQL

# Open CMD
# Step1: Change the directory folder current directory to mysql bin directory.
C:UsersPHPKishan> cd D:wamp64binmysqlmysql5.7.19bin ↲

# Step2: write below command line and in this cmd
D:wamp64binmysqlmysql5.7.19bin>mysqldump –databases –user=[Username] –password [DBNAME] > [DIR PATH][DBNAME.sql] ↲

 EX D:wamp64binmysqlmysql5.7.19bin>mysqldump –databases –user=root –password test_table > DBtest_table_bk.sql ↲

# Step3: Enter password
Enter password:***** ↲

# Step4: See exported database in you directory

Leave a Reply

Your email address will not be published. Required fields are marked *