Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
Please share what tools you use for managing your online databases of websites.
I have been fan of phpmyadmin and putty combination for compelte management of databases
here is quick tip for backing up using putty
Connect to your host via SSH
Run: mysqldump --opt -u user -p dbname > [PATH]/backup.sql
Just enter the details and hooooo database backed up in just some minutes .
Its great time saver
Please do share names of tools and softwares which you use for managing your databases
Have a nice day
$db_host = mysql.yoursite.com or "localhost"
$sql_admin_login = mysql user login name, for public-access applications this user should be a read-only user, but in the context of doing a backup, this should only be done from an admin script anyway. In this case this will be a write user for admin functions only.
$sql_pass = password for this user
$db_name = your database name
$rt = /full/path/to/domain/root
$bu = directory to store backup file, it must have write permissions by the script
$file = yourbackup.sql, I like to create a file name with the date on the fly: domainname + 2008-01-19 + .sql
mysqldump -h $db_host --user=$sql_admin_login --password=$sql_pass $db_name > $rt/$bu/$file
Mysql is so easy to script I build it into my own applications. I've used phpMyAdmin and a couple others, but am not comfortable not knowing **exactly** what the scripts are doing. :-)
Additional help, restoring from a backup: from the mysql prompt, type source /path/to/backup_file.sql
Vital tools for your dev and test boxes I normaly write my sql queries in query browser first only then do a write the php code.
plus just about any other system, server, file or data administration or management function you might have...