I am trying to use Moodle Adminer to do a dump of the mysql database. However I am not sure what options need to be checked off for this to work correctly. Also, when I restore the database what would be the correct settings for this as well?
I have selected the correct database and clicked in Dump and all the tables are selected.
The questions are for output, I assume I would select save or gzip?
For Format I assume I would select sql - as the format of the file has to have ****.sql
For Database - i am not sure what to select. The drop down has USE, DROP+CREATE and CREATE and 2 check boxes: one called routines and the other Events. Right now there is nothing selected under the drop down and there are checkmarks next to both routines and events.
For tables the drop down shows DROP+CREATE and Triggers is checked off.
For DATA it shows as INSERT.
Are these all the correct settings when I select Dump or are there changes that need to be made?
I have searched through Moodle and Google but unable to find any details on these settings. I have attached a screen shot of the above information.
I hesitate to mention which version we are using right now as I am not sure if anyone will assist. And I am not sure if the version of Moodle is pertinent to my question, I am running version 2.6. We are in the process of upgrading to the newest version later this fall. We are running moodle on Server 2008 R2 and PHP v5.6, and MySQL 5.x?? and IIS 7.
Thank you