MySQL crash course in 10 easy steps. 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
my favourite "mysqldump" options. 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