Backup with Where condition in Mysql



Syntax:




mysqldump -u user_name -p"<password>" <db_name> <table_name> --no-create-info --where=col_name='col_value' > "<Path\file_name.sql>"


Example:


mysqldump -u root -p"Root@123" sample1 table_one --no-create-info --where=id=3 > "E:\backup\table_one_id.sql"





Comments

Popular Posts