Tag Archives: MySQL

How to dump MySQL stored procedures

When dumping a MySQL database, by default, stored procedures and functions will not be backed up. If you want to backup stored procedures as well as the structure and data you can specify the –routines option on mysqldump. mysqldump -u …

Posted in Linux

How to solve the MySQL replication Access denied for user ‘debian-sys-maint’@’localhost’ issue

While testing a MySQL master -> slave replication I was unable to connect to the slave remotely, despite this working on the master. Originally I thought the issue was simple, I forgot to comment out the binding of MySQL to …

Posted in Linux

Simple MySQL replication with Ubuntu – Master to slave

A simple, easy to follow and extremely detailed how to on setting up basic MySQL master to slave replication on Ubuntu.

Posted in Linux

Fly by nights

I fancy a bit of an intriguing rant. Firstly a couple of dictionary results for the main keywords: Proficient Well-advanced or competent in any art, science, or subject; skilled: a proficient swimmer Knowledge Acquaintance with facts, truths, or principles, as …

Posted in Entrepreneurism