WordPress.org

Ready to get started?Download WordPress

Plugin Directory

WP Maintenance Mode

Adds a splash page to your site that lets visitors know your site is down for maintenance. Full access to the back- & front-end is optional.

Other Notes

Work with MySQLDumper

This option is designed for users, who backups their database with "MySQLDumper". With this option you can switch your WordPress into maintenance mode, when you create a database-backup with MySQLDumper. This is very usefull especially for larger blogs, because their backup takes a longer time. With this option enabled, you have the guarantee of a clean and full backup of your database. All other requests to your database from other resources were blocked in the time of the backup and all the performance of the MySQL-Server will be taken for the backup.

How to use

  • MySQLDumper must be installed and has to run full funtionally. This includes the crontab, MySQLDumper uses.

How to install MySQLDumper: Please visit the official website for several tutorials and videotutorials where you can see, how to install MySQLDumper.

To configure the automatic backup with MySQLDumper: Please visit the official website for informations about the full automatic backup of your database with perl and crontab.

  • Maintenance Mode must be installed and all needed options must be set.
  • After that, go to your Dumper-settings -> Configuration -> Databases. There you have two options ->Command before Dump ->Command after Dump
  • On the right you find a link named "SQL Commands", after you click this link, you can set the two queries for the automatic backup.
  • Click the link "new command", give it a name like "activate maintenance mode" and paste the code below in the required field and finally save this command:

    UPDATE wp-database.wp-prefix_options SET option_value = '1' WHERE wp-prefix_options.option_name = 'wp-maintenance-mode-msqld';

  • Now you can set the second command to deactivate the maintenance mode like the first one with this code:

    UPDATE wp-database.wp-prefix_options SET option_value = '0' WHERE wp-prefix_options.option_name = 'wp-maintenance-mode-msqld';

Note!

You must edit three places of the code to your options:

  • wp-database -> put here the name of your database.
  • wp-prefix_options -> put here the name of your options-table with the prefix you use (normally wp_options). This you must edit twice in the code!

When you have edited the code, save the two commands and go back to the MySQLDumper Configuration. Now you can choose the commands in the required field. For "Command before Dump" use the Command you named like "activate maintenance mode" and for "Command after Dump" use the other, named like "deactivate maintenance mode".

Don't forget to save these settings! After that, your WordPress will be switch in maintenance mode, when Dumper is backup your database!

Frequently Asked Questions for MySQLDumper

Please visit the official website for general informations about MySQLDumper.

How to: Backup with maintenance mode and MySQLDumper (illustrated Tutorial in german language)

Please visit Automatisches Backup der WordPress-Datenbank

Acknowledgements

Requires: 3.0 or higher
Compatible up to: 3.9.1
Last Updated: 2014-7-7
Downloads: 1,180,385

Ratings

4 stars
4.4 out of 5 stars

Support

2 of 17 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Works!

7 people say it works.
3 people say it's broken.

100,1,1 100,1,1
100,1,1 100,1,1
100,8,8 0,1,0 100,10,10 100,1,1 100,4,4 100,1,1
100,1,1 86,7,6 83,6,5 67,3,2 100,1,1 100,1,1
57,7,4 100,1,1 75,4,3 78,9,7
0,1,0 100,1,1
0,2,0
100,1,1 100,1,1
100,2,2
0,1,0 60,10,6
80,5,4 0,1,0
40,5,2 0,1,0
100,1,1 100,4,4 100,3,3
100,1,1 50,2,1 0,1,0 100,1,1
50,10,5
94,16,15 50,8,4 67,3,2 100,2,2
100,11,11
85,27,23
78,18,14
67,3,2
76,17,13 100,1,1
67,3,2 100,3,3 89,9,8 100,1,1 80,5,4 100,3,3 100,1,1
100,1,1 100,11,11 100,1,1
50,2,1 100,8,8 77,13,10 67,9,6 75,4,3 80,5,4
100,2,2 100,3,3 0,11,0
50,14,7
100,4,4
100,1,1
100,6,6
80,10,8
86,7,6
100,1,1
100,4,4
70,10,7