The syntax is as Follows

mysqldump –add-drop-table -u sadmin -p pass21 Customers customer_master customer_details> custback.sql

So the syntax for the command to issue is:

mysqldump -u [username] -p [password] [databasename] [table1 table2 ....]

    • [tables] – This is a list of tables to backup. Each table is separated by a space.

Post By Editor (2,827 Posts)

Website: →

Connect