To Export your SQL DB type the commands bellow. no need shotdown the server.
Our default SQL DB on Skyzone for Ragnarok Games is ragnarok.
Do the following Steps.
Step 1: 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="YOUR_DB_PASS"
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME | gzip > "$DB_NAME"_`date '+%Y-%m-%d_%H%M%S'`.sql.gz
Step 2: the backup sql will be uploaded on root folder in your winscp.
NOTES: copy all commands and paste it in Putty SSH at a time.
- 0 Utenti hanno trovato utile questa risposta
