mysql backup, restore, and users

backup:
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

compress:
mysqldump --all-databases | gzip >databasebackup.sql.gz

restore:
mysql -u [username] -p [password] [database_to_restore] < [backupfile]

restore from archive:
gunzip < custback.sql.sql.gz | mysql -u [username] -p [password] [database_to_restore]

grant user permissions
GRANT ALL PRIVILEGES ON mydatabase.* TO bob@localhost IDENTIFIED BY 'fruitfly';



INSERT IGNORE INTO new_tbl SELECT * FROM orig_tbl;

CREATE TABLE new_tbl SELECT * FROM orig_tbl;