Skip to main content

Mysql

MYSQL

PHPmyAdmin

https://mysql.webhosting.rug.nl

manual backups / restore

CLI dump database

$ ssh account@ssh.webhosting.rug.nl
$ mysqldump --host mysql01.service.rug.nl -u account -p -D database \ 
| gzip -c | > ~/backup/database.sql.gz

CLI restore database

$ ssh account@ssh.webhosting.rug.nl
$ gunzip < ~/backup/database.sql.gz | mysql --host mysql01.service.rug.nl \ 
-u account -p database > ~/backup/database.sql

CLI optimize database

$ ssh account@ssh.webhosting.rug.nl
$ mysqloptimze --host mysql01.service.rug.nl -u account -p -D database

CLI enter database

$ ssh account@ssh.webhosting.rug.nl
$ mysql --host mysql01.service.rug.nl -u account -p

CLI remote access database

$ ssh -L 3306:mysql01.service.rug.nl:3306 account@ssh.webhosting.rug.nl -N 1
$ mysql --host localhost -u account -p
Back to top