OGP-Website

Open Game Panel

*** Backup Database ***

Backup of the existing database can be done with following command:

$ mysqldump --user [username] -p [database] > backup.sql

Replace the [username] with username located in includes/config.inc.php and [database] with database located in same file. After executing the command the password is asked (same as in config.inc.php).

*** Restore Database Backup ***

Backup can be restored with following command:

$ mysql --user [username] -p [database] < backup.sql

*** Lost admin password ***

In case you lose the admin password you can reset the password with for eample the following command:

$ mysql --user [username] -p [database]

Then type in following command but change the OGP_USERNAME and NEW_PASSWORD to the proper ones:

UPDATE ogp_users SET users_passwd=MD5('NEW_PASSWORD') WHERE ogp_users.users_login='OGP_USERNAME';

After this type quit to exit the mysql prompt.