1. Over PHPMyAdmin
You can create a dump of your database over the PHPMyAdmin-Interface. Please click on the point “export” and select “structure and data” there, so that the structure and also the content of the database will be exported.
2. Over SSH
After you configured the SSH access, you can execute a dump of your database over the SSH shell console with the following command:
mysqldump -h HOSTNAME -u db12345 -pPASSWORT db12345 > dump.sql
Please enter the correct database password, instead of “PASSWORD”. Please make sure that there is no space between the preceding “p” and the database password. Please substitute “HOSTNAME” with the currently valid host name. The host name varies depending on the MySQL version used:
- Für MySQL3: mysql.your-company.ch
- Für MySQL4: mysql4.your-company.ch
- Für MySQL5: mysql5.your-company.ch