mysql backup and restore

mysqldump database_name -u root -p > database_name.sql

restore

mysql database_name <> create database racetrack_prod;

mysql> grant all on racetrack_dev.* to
'jason'@'localhost' identified by 'password';

to delete an entry in a table:
delete FROM `rngclient_dev`.`ate_request_reference` where ate_request_id = 150