We are happy to help you!
Our technical support is available to you from Monday to Saturday from 9 a.m. to 12 midday and 1.30 p.m. to 5 p.m. You can of course send us your questions by email. Emailed support questions are also viewed at the weekend and answered promptly according to the degree of urgency.
Managing a database & creating backups
If you have already created one or more databases and are looking for a way of managing them (creating new tables, inserting own data, etc.) proceed as follows:
1. Login to your Hosting Control Panel.
The link can be found in the email with the login details: http://login-X.hoststar.ch (the X should be replaced by your server number).
|Login:||Enter your web number "webX" (replace X with your personal web number) or your domain "YourDomain.ch".|
|Password:||Enter your FTP password.
3. Next, a window appears requesting your username and password.
Enter here the user details that were given to you when you created your first MySQL database. If you have forgotten the password, please use our Password change guide.
4. Now you will see a window with the following contents:
This is the start screen of phpMyAdmin. Please note that many of the functions cannot be explained in more detail here, owing to the complexity of MySQL and phpMyAdmin. The guide is limited to the important phpMyAdmin functions that are necessary for working on a database.
5. In the navigation panel on the left, a click on the database to be worked on will take you to the management of that database.
Afterwards, the most important functions that you can see on this page will be briefly explained. At the upper edge of the screen you will see the following buttons:
Structure: This function is marked in dark grey and thus currently selected. All the database tables are listed for you, but only the structure of the tables, not their actual content. You can also see the names of all the tables, the number of entries contained in them and the storage space they take up on the hard disk of the Hoststar server. If you scroll down to the very bottom, you can also create new tables here.
SQL: You can directly run SQL code here. If, for instance, you need to run several lines of SQL code for the installation of a certain application, you are in the right place. After the code has been run, it will be displayed again (if you have made the appropriate setting for this) and you will also see whether or not the code execution functioned correctly.
Search: With this search function you can search all your tables for specific contents. If, for instance, you are looking for an entry and do not know which table it is in or on which line, you can use this search function to find it.
Query editor: This function offers the possibility of creating your own queries. If, for instance, you have an address database and are looking for a way to generate a list with all addresses in a certain locality, you can create a query here that enables precisely that. Certain basic knowledge of MySQL is absolutely essential for the creation of such queries.
Export: This is one of the most used functions. It offers the possibility of creating a backup of your database. The exact procedure for creating a backup is described further below.
Import: The import function is the complement of the export function. Here you can import previously created backups of your database. If your database should get lost for some reason, you can use this function to import the database exactly as it was when you made the backup.
Operations: Here you can find all possible operations that you can execute with your database or table. As a normal user you do not have many possibilities for customizing the database, but you have with the tables. If you click the Structure button of one of the tables you can, amongst other operations, analyse, repair or optimize the table. So if one of the tables has some problem, you can see if repair solves the problem, or if the analysis possibly shows exactly where the problem lies.
Next, a more detailed explanation of the buttons that are to be found in every table in the "Action" column:
: You can display the contents of the respective table via this symbol. So in an address database you would see the individual names and addresses of the people entered in it. Here you can make your own entries or delete existing entries.
: With this you can display the structure of the table. Unlike with the structure of the database, you see here only the table on which you have clicked, although all individual fields in the table are additionally listed. If, for instance, there is no field for a mobile telephone number in an address database, it is possible to create one subsequently here.
: This search function works exactly the same as the search function already explained above, except that the one explained above only searches the selected tables. Correspondingly, with this search you cannot select the individual tables to be searched but you can select the individual fields of the respective table.
: With this function you can directly make further entries in your tables.
: The "empty" function does just what it promises: it empties the table. However, the actual structure of the table is left intact. So after a table has been successfully emptied, you can immediately start filling it out again without the necessity of creating the whole table again from the beginning.
: The "delete" function deletes the whole table including contents. After deletion, the table structure is also lost and has to be recreated, if this is necessary.
Because the creation of a database backup is such an important topic, the exact procedure will be described again briefly below.
1. Follow the above guide until you find yourself at the structure display of your database (point 5).
2. Select the "Export" button at the upper edge of the screen.
3. Make the following settings on the Export screen:
Click on "Select all" to specify that all the tables should be included in the backup. If you only require to backup certain tables, you can of course select these individually.
If "Send" has a check mark, it means that when you click "OK" you will be offered the backup as a download. If there is no check mark, the contents of the backup will be directly presented in the Internet browser. With very large databases this can have the result, amongst other things, that the browser crashes.
After you have made the two settings, you can download the backup with a click on "OK". Afterwards, keep this safe in a secure location, as the file can be opened with a simple text editor and all entries in the various tables are directly visible.
We will be happy to answer further questions:Administrative Questions: