GitHub - OpenGamePanel/OGP-Website
source link: https://github.com/OpenGamePanel/OGP-Website
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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 the 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 example, the following command:
$ mysql --user [username] -p [database]
Then type in the 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.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK