Scheduling MySQL Backups on Linux

There are a number of ways to automatically backup MySQL databases, the simplest one is just to use the mysqldump program and schedule a cron job.

The mysqldump program typically produces an SQL file which can used to restore any where between one to all databases on a server.

Running the mysqldump program is done using the following command:

mysqldump [OPTIONS] (Database name or list of databases)
NOTE: You can use --all-databases in the place of a single or list of database
names to backup all the databases in one file!

Whilst there are a large number of options to give the program the most important ones are probably the “username” and “password” ones.

Continue reading

Disabling Bluetooth on Ubuntu/Debian

If you don’t use you Bluetooth on your laptop then you might want to disable it. Firstly it’s another service your computer does not have to start up when it boots and secondly it will use less power.

For all the following commands you will probably need root access, i.e. you may need to prefix “sudo”.

To stop the bluetooth service use the following command.

/etc/init.d/bluetooth stop

Now lets remove the Bluetooth services from starting when you boot up:

update-rc.d bluetooth remove

Unfortunately Bluetooth support is build into the Kernal itself, but the following line should prevent the Kernel from loading up:

echo 'alias net-pf-31 off' >> /etc/modprobe.conf

That’s it, all done. When you reboot Bluetooth should not restart itself any more.