Backup Website on Shared Server

Databases
1

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?

2

phpmyadmin uses mysqldump (which you should look up in da manual), and yes, the backup does generate CREATE TABLE and INSERT statements

3

Well Mr. Database Guru that was helpful!
You provided NO useful information and responded to NONE of my questions.
What was it you wanted me to look up, that the manual knew what I already told you?

Anyway, if anyone else knows the best backup strategy for a database hosted on a shared server where I am under some restrictions, I would be very interested - even if they’re not in the “Official” Mysql manual.

4

wow, who pissed in your cornflakes this morning?

here ya go…

One concern here is that I have some auto-increment columns
the generated INSERT statements preserve those values

Is there any true backup and restore in this situation?
yes, using mysqldump

What’s the best I can do?
use phpmyadmin

Or, will Mysql require a private server?
no, it won’t

5

wow… what a jerk…

the first thing you do jerk is log in to phpmyadmin, click on the ‘Export’ tab, check the ‘Save File As’ box at the bottom and hit Alt+F4.