General help

 
 
Picture of David Cooke
Re: Moodle 2.2.1 Adminer guidance needed
 

Hi

I am needing some guidance on using Adminer.  Using Moodle 2.2.1 this is a screenshot of what I see in Adminer.  I need to backup up key files as the automated Moodle backup has never worked for me.

Can you confirm the files that need backing up and the exact process to follow.  I don't want to drop any tables again!

Many thanks

David


 
Average of ratings: -
Randy Thornton
Re: Moodle 2.2.1 Adminer guidance needed
Group Documentation writersGroup Particularly helpful Moodlers

Select whichever is your actual Moodle db - I'm guessing that's moodledb. Then use the Dump command to dump (export) it out to a file for safekeeping.

However, doing this does not guarantee a clean database: if users are using it there may very well be transactions going on that will be out of sync (especially interactive things like quizzes, forums, grades, etc.) as the dump takes place.

That's one reason why it is better to schedule database dumps for off hours in the middle of the night instead of doing them interactively with a tool like Adminer.

For a complete backup you will also need to backup your /moodledata folder structure too.

Also, you say Moodle backups don't work for you. If you mean the Automated backups, then it's important to know they do not backup the Moodle database. They automate backing up of -courses- using the standard Moodle course backup process so they can be easily restored. They don't and aren't designed to back up the whole Moodle system.

 
Average of ratings: -
Picture of David Cooke
Re: Moodle 2.2.1 Adminer guidance needed
 

Hi Randy

 

Many thanks for the advice.

Just for accuracy and also because I managed to dump not drop once, I choose moodledb from the Adminer dropdown menu then 'use' then dump? I then save this file somewhere 'safe' off server.

Am I wrong to assume that the automated Moodle backup that is not working for us will be completed when running /cron.php as that backs up courses etc?

Thanks

David

 
Average of ratings: -
Randy Thornton
Re: Moodle 2.2.1 Adminer guidance needed
Group Documentation writersGroup Particularly helpful Moodlers

Yes, save the file somewhere so you can get to it if you need it. "Dump" is just database jargon for what the rest of the world calls "backup" or "export." The file will have an extension of .sql.

Take a look at this for info on automating dumps: http://www.mysqltutorial.org/how-to-backup-database-using-mysqldump.aspx

Yes, Automated backups will start working once cron is working. Automated backups in Moodle are run by cron, but on the schedule you set for it, not every cron run like most things.

See: http://docs.moodle.org/25/en/Automated_course_backup for the settings.

If you automate both a database dump and auto backups, do the dump first as it is quick and you don't want to dump during the auto backup process. Auto backups are much slower and can vary a lot in the time they take to run depending on course usage.

 

 

 

 

 
Average of ratings: -
Picture of David Cooke
Re: Moodle 2.2.1 Adminer guidance needed
 

Hi Randy

Your help is much appreciated.

I note with the Adminer options (see image) that I need to choose from some drop down options.  

Can you suggest the 'correct' options or do I leave it as the default one as seen?

I am also looking at the page you suggested on backing up MYSQL databases.  

Thanks again

David


 
Average of ratings: -
Randy Thornton
Re: Moodle 2.2.1 Adminer guidance needed
Group Documentation writersGroup Particularly helpful Moodlers

Which of those databases is the actual live one? It is the one set in the config.php file. You should back up that one.

When I do this manually, my habit it to first go into the database itself. Then I dump it from there. There's no drop button inside (just in case ;)

 

 

 
Average of ratings: -
Picture of David Cooke
Re: Moodle 2.2.1 Adminer guidance needed
 

Hi Randy

I have attached 3 images below of the three drop down options available to me when using Adminer.  I hope you appreciate my confusion over  the options particularly when one of them mentions the dreaded 'drop' word.  My last backup produced a .sql.txt file, is this correct?

The default drop down setting is:

Database Create

Tables Drop+Create

Data Insert

Is this the optimal setting?

Many thanks once again

David




 
Average of ratings: -