Basics

What is MySQL?

MySQL is a database manager. The use of SQL language and is free to use. More information about mySQL can be found e.g. here: https://en.wikipedia.org/wiki/MySQL

Where can I find my database information?

- log in to your Servage account - Go to "Databases" and then choose "MySQL": - A new window opens, push the button "EDIT" for the database which you want to work on - A new interface opens and you find several information about the database and you can check or change settings like e.g. the permissions". If you push the orange button "EDIT" another time, you can change the password of the database

Good use of database

Our system is designed to give you fast and reliable access to your data. But, please note that it is necessary to carry out maintenance on your databases to keep the good performance up. Also, some small things need to be considered in order to run your databases smoothly. Please keep a close watch on the following points: - Save only a limited amount of log files (e.g. 10.000 entries or 10 mb) in your database. We recommend to put such files directly into your webspace. - Don't save eit...

Can I manage databases via SSH? (Mysql)

SSH is very good at both import and export MySQL databases with MySQL command, so you can do both: Export a MySQL db to file: mysqldump -h [SERVER] -u [username] -p [DATABASE]> dump.sql This above command exports your database and save it as "dump.sql". Importing a MySQL db from file: mysql -h [SERVER] -u [username] -p [dATABASE] <dump.sql This above command will import your dump file to the database, the will overwrite existing tables with the same name.

How to add MySql database

- log in to your Servage account - go to Control Panel >> DATABASES >> Mysql section in your control panel : - click the green 'ADD NEW DATABASE' button. - Enter and database username, password , repeat password. (Please use a strong password) - once done, click the green 'ADD' button at bottom. - You have successfully added a new Mysql database.

How to delete a MySQL database

- log in to your Servage control panel - go to Control Panel >> DATABASES >> Mysql section of your control panel - Locate the database you want to delete and click the red 'Delete' button in front of the database. - Confirm the database deletion in next step Your database is now deleted. (Deleted database cannot be recovered. Please be careful during database deletion)

MySQL: triggers and stored procedures

We don't allow triggers We allow Stored procedures

Remote database

Remote databases are not supported by Servage. To have external MySQL access in the new system you will need to tunnel your connection through an SSH-acccount. You can find the instructions on how to tunnel your MySQL connection through SSH in the SSH section of this Helpdesk.

Where are my database log in details?

For security purposes, we don't display the log in details for the databases in the control panel. But, you can check the database details via the webfiles which are associated to the database. Most applications have a config file which holds the database information (server, databasename, username, password). You can check your files for this information either via the Servage filemanager or via FTP. If you need help finding these information, please get in touch with our support. For example ...

Where to find the application information

If you installed an application via our application installer, you can find the relevant information (including the mySQL database info) for that app via the following procedure: - go to "Domains and Websites" - navigate to "Websites" - push the button "Apps" - click on the grey button "Manage": - choose "Show Info" from the drop down menu - a new window opens with plenty of information related to the application: