I have an admin area on my site, and I want to include a backup function (IE, not through raw access or phpmyadmin). Is there a special query to select everything from every table, or even create all the tables, like the backups generated from phpmyadmin? Maybe there's an SQL query someone else has already written?
Hi, I have something similiar to what you need that I wrote in VB for a client of mine. It can be run by clicking the button, or it can be scheduled, daily, weekly, monthly. It basically does a complete backup of the entire database, structure and data, very similar to phpmyadmin. If the client ever needs to, they could restore the entire database from the previous days backup. If you want it, I am happy to send it to you, no charge. PS, if anyone else wants it and is able to program in VB, I will give you the code. This is not used alot by me, so it may have bugs, but if there are more than one of me working on it, it could become a nice little utility. Having said that, it does work well for me and my client, so its not too bad... Regards, John