MySQL Tips

From KaminskiWiki

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