MySQL

MySQL

# Fix mysqld start fail: (when backup server)
vim /etc/mysql/my.cnf --> 
[mysqld]
innodb_force_recovery = 3
# Backup: 
mysqldump -u root -p[password] [database_name] > dumpfilename.sql
# Restore: 
mysql -u root -p[password] [database_name] < dumpfilename.sql
# Create user
CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';
# Grant Privileges on Database
grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd';
# Disable foreign key checks
SET foreign_key_checks = 0;
# Enable foreign key checks
SET foreign_key_checks = 1;