To import your backup DB make sure to create DB name in your PhpMyAdmin.
Our default SQL DB on Skyzone for Ragnarok Games is ragnarok.
Do the following Steps.
Step 1: Upload your backup SQL DB on root user in WINSCP and rename it as ragnarok.sql or logs.sql depend on what SQL you need to backup.
Sample: I use to import the ragnarok.sql at this guide.
Step 2: login root user on Putty SSH and type the following commands bellow. make sure input your PhpMyAdmin credentials.
db_user="ragnarok"
db_name="ragnarok"
db_pass="YOURPASSWORD"
mysql -u $db_user -p$db_pass $db_name < $db_name.sql
NOTES: copy all commands and paste it in Putty SSH at a time.
- 0 utilizatori au considerat informaţia utilă
