Skip to content

Instantly share code, notes, and snippets.

@faizanayubi

faizanayubi/mysql.txt

Last active September 8, 2015 10:21
Show Gist options
  • Save faizanayubi/1cdfbb32da7eca5d83e1 to your computer and use it in GitHub Desktop.
Save faizanayubi/1cdfbb32da7eca5d83e1 to your computer and use it in GitHub Desktop.
Download ZIP
Important MySQL Terminal Commands
Raw
mysql.txt
Backup database
mysqldump -uroot -p database_name > dumpfilename.sql
Restore database
mysql -uroot -p database_name < dumpfilename.sql
Checks database for error
mysqlcheck chris_wordpress
Auto repair databases
mysqlcheck chris_wordpress --auto-repair
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment