What is the best (or any) strategy for backing up a database on my website, which is hosted at an ISP on a shared server. I don't have full access to the MySql server because that is also shared. ISP provides C-Panel and phpMyAdmin, although these are not the latest versions.
I used one backup feature I could find but I think it generated SQL code to rebuild the tables and do Inserts. One concern here is that I have some auto-increment columns, so a new insert would probably mean new (different) values. I imagine that would take a very long time to execute as well.
Is there any true backup and restore in this situation? What's the best I can do?
Or, will Mysql require a private server?