Updating twitter from python

Just looking into posting twitter updates from python. I’ve found three methods so far: -

• Python Twitter Tools
• python-twitter
• Command-line via Curl (can possible do with urllib)

Hmmm, more investigation required…

Backup of all MySQL databases

To backup all MySQL databases on a machine, use the following command: -

mysqldump -u root -psecret –all-databases > backup.sql

To restore all databases, use the following command: -

mysql -u root -psecret < backup.sql

To restore a single database (from a cpanel backup etc), use the following command: -

mysql -u user -psecret dbname < dbbackup.sql

AJAX Libraries API

The “AJAX Libraries API” is a google-sponsored initiative that hosts key javascript libraries: -

• jQuery
• jQuery UI
• prototype
• script.aculo.us
• MooTools
• dojo

It handles the cache headers etc, and more importantly saves your bandwidth!

To use them, simply refer to them in your HTML. For example, to load Prototype version 1.6.0.2, place the following in your HTML:

<script src=”http://ajax.googleapis.com/ajax/libs/prototype/1.6.0.2/prototype.js”></script>

Graphs and Charts

Open Flash Chart is a great way to include fancy graphs and charts on your web site. There are plenty of examples and tutorials on the site – it’s really easy to use.