Hi all,
I am writing a backup script for my users who have a mysql table on a database on a remote webserver.
Primarily I want the script to download a file full of the sql statements to rebuild that table.
This is not a problem for me as my webhoster has phpmyadmin and backup-facilities available via my control panel, but I dont want my users near this control panel and also this would not be automatic enough (and fool proof) for them.
I have tried my script running on my own server (running mysql) and I use MYSQLDUMP and all works fine.
However, on asking my webhoster, he is not comfortable in setting this up for me (perhaps he doesnt know how to or he may be thinks it is unsafe??).
Does anybody know how to dump a table without using mysqldump hopefully with sql statements, or has anyone had similar problems?
Obviously I could write some complex code to go through all columns and write it all out but I dont want to re-invent the wheel.
Thankyou
Pryce
