MySQL Tricks

Dumping data to be compatible with PostgreSQL:

mysqldump -nt --compatible=ansi,postgresql --complete-insert=TRUE --extended-insert=FALSE --compact --default-character-set=UTF8 -u $DB_USER -p$DB_PASS $DB_NAME $TABLE

Reset MySQL Password [DEB]:

# invoke-rc.d mysql stop
# /usr/bin/mysqld_safe --skip-grant-tables &
# mysql --user=root mysql

mysql> update user set Password=PASSWORD('new-password-here') WHERE User='root';
mysql> flush privileges;
mysql> quit;

# fg

Then press Ctrl+C to stop MySQL.

# invoke-rc.d mysql start