Mediawiki backup - Revision history

Pio2pio: /* Recreate wiki database */

2014-06-18T19:59:27Z

Recreate wiki database

← Older revision		Revision as of 21:59, 18 June 2014
Line 5:		Line 5:
	= Recreate wiki database =		= Recreate wiki database =
	Create a new MySQL database and grant your user account permissions on the database. SELECT, INSERT, UPDATE and DELETE permissions should suffice.		Create a new MySQL database and grant your user account permissions on the database. SELECT, INSERT, UPDATE and DELETE permissions should suffice.
			mysql -u root -p<span style="color: blue">password</span>
	CREATE DATABASE wikidb ;		CREATE DATABASE wikidb ;
	CREATE USER wikiuser;		CREATE USER wikiuser;

Pio2pio at 19:57, 18 June 2014

2014-06-18T19:57:05Z

← Older revision		Revision as of 21:57, 18 June 2014
Line 2:		Line 2:

	More to come....		More to come....

			= Recreate wiki database =
			Create a new MySQL database and grant your user account permissions on the database. SELECT, INSERT, UPDATE and DELETE permissions should suffice.

			CREATE DATABASE wikidb ;
			CREATE USER wikiuser;
			USE wikidb;
			GRANT SELECT ON wikidb.* TO wikiuser;
			GRANT UPDATE ON wikidb.* TO wikiuser;
			GRANT INSERT ON wikidb.* TO wikiuser;
			GRANT DELETE ON wikidb.* TO wikiuser;

			If a database exists and you want to entirely replace it from the backup. To destroy the database, the -p parameter will prompt you for the password:
			mysqladmin -u [userid] -p drop [wikidbname]
			Then to create a new database:
			mysqladmin -u [userid] -p create [wikidbname]

			To import dbdump.sql from the command line do:
			sudo mysql -u [userid] -p<span style="color: blue">password</span> [databasename] < dbdump.sql

	= References =		= References =

Pio2pio: /* References */

2014-06-18T19:31:47Z

References

← Older revision		Revision as of 21:31, 18 June 2014
Line 4:		Line 4:

	= References =		= References =
	*[http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki ~~Backing up a~~ wiki]		*[http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki Manual:Backing_up_a_wiki]
			*[http://www.mediawiki.org/wiki/Manual:Moving_a_wiki Manual:Moving_a_wiki]
			*[http://www.mediawiki.org/wiki/Manual:Restoring_a_wiki_from_backup Manual:Restoring_a_wiki_from_backup] From_the_command_line_using_mysql

Pio2pio: Created page with "Finally after multiple times I have backed up this and other mediawikis I am going to stream line this process. Any deviration I will record here to work out the best way of d..."

2014-06-08T21:43:11Z

Created page with "Finally after multiple times I have backed up this and other mediawikis I am going to stream line this process. Any deviration I will record here to work out the best way of d..."

New page

Finally after multiple times I have backed up this and other mediawikis I am going to stream line this process. Any deviration I will record here to work out the best way of doing so. Maybe even the outcome will be a simple script.

More to come....

= References =
*[http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki Backing up a wiki]