Are there any scripts out there that will back-up a whole database and download it to my hd as a file, and also restore them?
phpmyadmin 🙂
but dont know how to back it up...
depends on version but on 2.3 it has an export tab which allows to select table/structure+data and export it as a SQL file in a gzip archive 🙂
perhaps its because im on 2.2.5 😛
Ill try and get my host to update it 🙂
Are there any scripts that will be able to do this for me incase my host wont change it?
exists in main database page in other phpmyadmin versions
built into the system, everywhere mysql is sold...
mysqldump -u {username} -p {database name} > {local filename}
using a -d flag will dump just the structure, adding a -e will make that prettier depending on the mysql version.
You don't need to rely on your host to update phpmyadmin. Just download the newest version, change the config.inc.php file and upload it all.
