Page 1 of 1

SQL-Backup by administrator

Posted: 2013-12-15 14:32
by RonP
Hi,
Wouldn’t it be nice to have a backup function (Structure and or data ). This when you are a member in the Administatorgroup.

Now you have to go to PhPAdmin and make a backup from there. So if it is possible within your application it should be nice.

Ron

Re: SQL-Backup by administrator

Posted: 2013-12-21 20:59
by KSan
Here's an idea. You can create a table only Admin can see. In this table you can keep a date / time etc record of when a backup is requested. Then you can attach a PHP script initiating a backup to the after_insert hook. This way you go in and create a new record and trigger a backup request. See the following for how you can use PHP code to trigger backups. Hope this helps.

http://www.php-mysql-tutorial.com/wikis ... bases.aspx