If you ever had to deal with MySQL in the past, I'm sure you had to spend lots of time searching on Google (as I did..). To save you some searching, I'll post some commands I "learned while doing". I'll assume all you know about MySQL is "mysql -u root -p" The above… Read More

MySQL Tools & Co. are very nice and smart toys, 'though sometimes DB Admins like to overcomplicate things that should be easy and simple. Over time and experience, I developed a specific taste for the following mysqldump options: mysqldump -u root -p - -add-drop-databases - -add-drop-table - -databases DB_NAME > filename.sql Beware of the dreaded… Read More