pw protect Backups MOD ?

[euroman]

Is there a MOD so you can password protect database backup so only one administrator can take backups ?

[dcz]

Well, it could be done by just hard coding (with a constant) the admin user ID (the one authorized) and check if the current admin id is the one defined as the main one.

But, actually, you should not use phpBB db utilities. It's ok for small DBs, but phpmyAdmin is the way as soon as it get a little bit bigger. And since phpmyadmin should be password protected independently from phpBB, using it would solve your issue (just keep the password for yourself) and will make db backups more reliable.

++

[euroman]

I have taken a backup using phpmyadmin. Are the below options correct ?



In the import window it says a max file sice of 20 mb but the backup is 35 mb - how do I workaround that when/if the time comes to restore the backup?

***

[dcz]

All right, good, phpMyadmin is a lot better than the phpBB db utilities.

But as you can see, there are still limits, you cannot import too much data at once. The only way to deal with large db at once is to do it with the sql server it self, using sql_dumps, but you won't be able to do so unless you have SSH access to your server (mostly on dedicated).

You can still use phpMyadmin to import db as long as you import it by part, each one being smaller than the upload limit (20 mo in your case it seems).

Doing this is enough until one single table goes over the upload limit. At this time you can still increase the upload limit in you php.ini file, but this mean you should worry about sql server and sql_dumps a bit more

Don't worry, you have time before that.

So, in phpMyadmin, you don't need the extended inserts, but the option are correct. Don't hesitate to spend some time on a good how too, as there is plenty.

To cut your db into several pieces, you can choose to only export a selection of tables in the db. It's not too long to find out the proper selections to stay bellow your max upload size. Cut it by three and it will be ok.
To import it if needed, you'll just need to import all the parts, one after the other, and it will work the same

++

[euroman]

Ok - I see thanks. About the other issue - do you think theres an easy way to disable backup from the admin panel ?

[dcz]

Yes, and it's very easy, just delete admin/admin_db_utilities.php