own3mall
a1bbc7db15
Weird Fix for SQL Issue https://github.com/OpenGamePanel/OGP-Website/issues/348
|
8 年之前 | |
|---|---|---|
| Crypt | 9 年之前 | |
| css | 8 年之前 | |
| images | 8 年之前 | |
| includes | 8 年之前 | |
| js | 8 年之前 | |
| lang | 8 年之前 | |
| modules | 8 年之前 | |
| protocol | 8 年之前 | |
| themes | 8 年之前 | |
| COPYING | 9 年之前 | |
| README.md | 9 年之前 | |
| home.php | 8 年之前 | |
| index.php | 8 年之前 | |
| install.php | 8 年之前 | |
| ogp_api.php | 8 年之前 |
README.md
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.