If you're on a Linux/Unix machine, you can use the Command Line tools via SSH to create a database dump (backup of the mysql database) by inserting the command:
Quote:
mysqldump -uusername -ppassword databasename > databasename.sql


If you wish to compress the above output so that it's easier to transfer around, then you can do:
Quote:
tar -cvpzf databasename.tgz databasename.sql


If you've compressed the output and would like to decompress it, then you can run:
Quote:
tar -xzvf databasename.tgz

(the output will extract as databasename/databasename.sql)

And to restore said backup, after you purge data out of the MySQL database:
Quote:
mysql -h localhost -uusername -ppassword databasename < databasename.sql


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!