mySQL backup by the client

Associate
Joined
16 May 2005
Posts
680
Unfortunately a client’s site is hosted with some awful hosting, last month the MySQL had to be backed up from some really old records, and this month they managed to bin the whole db, tables, everything without any backups.

I'd got some backups but I’ve had to waste an afternoon using Google to repopulate the site the best way I can.

I'm thinking of writing some PHP to effect fake a MySQL dump that the client can store, but is there a better way of doing it? Is there an operation that would do it with one command?

They’re going to move hosts, and I’ve had MySQL issues with other hosts before and have been impressed by their redundancy, but I think I ought to add a procedure to all my CMSs from here on in to create local backups.

Cheers
 
Back
Top Bottom