dmancini
09-16-2008, 03:29 PM
I need to back-up a database with about 30 tables and lots of data in it. I tried copying it to another *new* database, but HM's config disallows db creation for phpMyAdmin.
If I export the db, then it roles ALL the tables into one big file that imports wrong anyway. I really don't want to export ALL 30 tables to individual files if I don't have to, and really, given that this is a major host, I don't see a need to be that ridiculous.
Also, there is no 'copy' or 'backup' feature in cPanel's MySQL section, which proves to be the ONLY allowable method of database creation in all of cPanel.
So, is there ANY sane way to BACKUP a database??? I mean, really!
If I export the db, then it roles ALL the tables into one big file that imports wrong anyway. I really don't want to export ALL 30 tables to individual files if I don't have to, and really, given that this is a major host, I don't see a need to be that ridiculous.
Also, there is no 'copy' or 'backup' feature in cPanel's MySQL section, which proves to be the ONLY allowable method of database creation in all of cPanel.
So, is there ANY sane way to BACKUP a database??? I mean, really!