MySQL Tips

From KaminskiWiki
Jump to: navigation, search

Commands

  • specify username: mysql -u username
  • prompt for password: mysql -p
  • dump schema only: mysqldump -d tablename
  • dump data only, for reimport: mysqldump -c -e -t tablename

mysqldump Switch Shortcuts

  • --complete-insert, -c
  • --extended-insert, -e
  • --no-create-info, -t
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox