update table_name set column = 'newvalue' where column = 'some thing'
Comment: The command 'set' fills new value based on condition given in 'where'
How to backup MySQL database?
mysqldump -u user_name –p db_name > backup.sql;
Comment: Executing this command will prompt for your mysql password and upon completion a backup file named 'backup.sql' will be generated. Source - https://support.hostway.com/hc/en-us/articles/360000220190-How-to-backup-and-restore-MySQL-databases-on-Linux