Manual talk:Restoring a wiki from backup

Section: Import the database backup
please check the import of DB (restore of DB)
 * mysqldump --default-character-set=binary --user=foobar --password=barbaz wikidb > dbdump.txt
 * mysql --silent --local --password=barbaz newdb < dbdump.txt

should be with user? so: TiloWiki (talk) 01:17, 19 February 2013 (UTC)
 * mysql --user=foobar --silent --local --password=barbaz newdb < dbdump.txt
 * Your absolutely correct TiloWiki. Had already been FIXED by someone. Laudaka (talk) 10:01, 9 September 2014 (UTC)

Section: Re-create the database, user and permissions
Laudaka (talk) 16:30, 17 August 2014 (UTC) ERROR 1142 (42000) at line 22: DROP command denied to user &#39;wikidb_user&#39;@'localhost' for table 'mw_archive' USE wikidb; GRANT SELECT ON wikidb.* TO wikidb_user; GRANT UPDATE ON wikidb.* TO wikidb_user; GRANT INSERT ON wikidb.* TO wikidb_user; GRANT DELETE ON wikidb.* TO wikidb_user; GRANT DROP ON wikidb.* TO wikidb_user;      <===== ADDED Laudaka (talk) 10:01, 9 September 2014 (UTC) GRANT DROP ON wikiclubnix.* TO mediawiksoft@localhost;
 * I tidied up the commands someone has to give on the SQL prompt. The formatting is now very close to the MySQL documentation like here http://dev.mysql.com/doc/refman/5.5/en/create-user.html
 * IDENTIFIED BY was missing, so you would end up with a MySQL user with no password.
 * When trying to restore the wikidb with the mysql command I get this error:
 * So to the list of permissions of our MySQL wikidb_user we need to add the DROP permission:
 * Hmmmmm. I'm not so sure about the need for the DROP permission. Can someone with MySQL expertise have a look at it? The first time I got an ERROR 1142 the GRANT DROP command above solved it. For another wiki I restored I had to use the command line below. I don't know what to think of it. Please FIXME. Thanks in advance.

All sections
Laudaka (talk) 18:12, 17 August 2014 (UTC)
 * For the things the user has to fill in I consistently changed everything in . Both in what has to be typed on the MySQL prompt (mysql) and what has to be typed on the ordinary command line (bash or cmd.exe)
 * I chose for  instead of   because   has been written as one word as well.
 * I would appreciate if someone could have a look if everything is OK. I'm an advanced user but by no means a professional :-) BTW Thanks for this versatile piece of open source software MediaWiki :-D
 * Not yet finished. Laudaka (talk) 19:04, 17 August 2014 (UTC)

List of placeholders proposed by Laudaka
wikifolder wikifolder_backup wikidb wikidb_user wikidb_userpassword
 * Directories AKA folder with files (in the filesystem):
 * And this is in the MySQL/PostgresQL/SQLite database: