MySQLsoftware-recommendation
Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu?
So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat which is a windows port and runs under wine, but none of these is perfect. In an ideal world, I'm looking for something like a native version of navicat.
I used this for a while, it doesnt have to many feature but it does it job for managing modules and virtualhosts.
Rapache is a simple tool for remotely managing and configuring an apache2 instance without having to hassle around through configuration files.
MySQL Admin (discontinued - was available in natty) has a backup tool with a (basic) scheduler to make backups on a daily, weekly, or monthly basis. It is even included in Ubuntu: mysql-admin.
Random image from the web: 
My favourite way ofcourse is command line and I found a backup script on UF.
#!/bin/bash #Script to make a regular copy of a mysql database and gzip it into the SAVEDIR. USER="authorized_user" PASSWORD="the_password" DATABASE="database_name" SAVEDIR="/backup" /usr/bin/nice -n 19 /usr/bin/mysqldump -u $USER --password=$PASSWORD --default-character-set=utf8 $DATABASE -c | /usr/bin/nice -n 19 /bin/gzip -9 > $SAVEDIR/$DATABASE-$(date '+%Y%m%d-%H').sql.gz
Edit the varibles, save it as .bkup.sh and run it in a crontab, then you have an automatic mysql backup. All the code for this script explained here. Kudos to kat_ams.
Best Answer
Sadly, you can't find these in the Ubuntu Software Centre in later versions of Ubuntu any more. This is because these two pieces of software have reached their end-of-life, and are no longer supported.
MySQL Workbench
is probably the most complete tool, but a bit sluggish according to me.
I prefer "MySQL Query browser" and "MySQL Administrator". These two can do all basic stuff, and are very user friendly.