restoring the backup

the files

the databases are usually compatible to a very specific mediawiki version, so restore the correct files or find the correct version.

the db part

this username/passwords are used

lastlogwiki     3kv5j3k4j5v3k4j53vk
museseqorg      asdfasdfasdf
uniprotokolle   ababababababab
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('newpassword') WHERE user='root';
mysql> FLUSH PRIVILEGES;
CREATE DATABASE lastlogwiki;
CREATE USER 'lastlogwiki'@'localhost' IDENTIFIED BY '3kv5j3k4j5v3k4j53vk';
GRANT ALL ON lastlogwiki.* TO 'lastlogwiki'@'localhost';

CREATE DATABASE museseqorg;
CREATE USER 'museseqorg'@'localhost' IDENTIFIED BY 'asdfasdfasdf';
GRANT ALL ON museseqorg.* TO 'museseqorg'@'localhost';

CREATE DATABASE uniprotokolle;
CREATE USER 'uniprotokolle'@'localhost' IDENTIFIED BY 'ababababababab';
GRANT ALL ON uniprotokolle.* TO 'uniprotokolle'@'localhost';

now i restore my backup

mysql -u lastlogwiki -p lastlogwiki < 20120430_lastlogwiki
mysql -u museseqorg -p museseqorg < 20120430_museseqorg
mysql -u uniprotokolle -p uniprotokolle < 20120430_uniprotokolle
Powered by MediaWiki