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
Post a Comment