B) ms sql (Microsoft sql)

• Microsoft Structured Query Language is a relational database management system (RDBMS).

• Connections for administrative purposes can be made via Microsoft’s Enterprise Manager 2000, or Management studio express for MSSQL 2005.

• Each database created on the Hostopia system is assigned a unique

  • Database Name

  • Username

  • Password.

Instructions	Images
Start Enterprise Manager branch out to the Server group level.
At this point you can choose the action menu at the top, and select “New SQL Server Registration” or right click on your server group and choose the same option. The Register server wizard will start as shown below. Click “Next” to continue to the next step.
In the box called “Available servers”, enter mssql.megasqlservers.com. Click “Add." The server name should appear in the “Added Servers” box. Click “Next.”
At this stage, choose the second authentication mode: “The SQL Server Login information that was assigned to be by the system administrator.” Click “Next.”
Choose a connection option. If you want to login automatically, enter your login name and password in the text boxes provided. Your Login name will be dbm.domain.tld (Substitute your domain name for domain.tld). Your password will be the password you chose with your sales representative. Click “Next.”
At this point, the wizard will prompt you to add the newly registered server to your server group. Select the option labeled, “Add the SQL Server(s) to an existing SQL Server group.” Click “Next.”
At this point, the server registration is completed as shown. Click “Finish.” You will now have a new server listed in your Enterprise Manager console. You can branch out this server, branch out the databases, and proceed to your database. There you can perform various administrative tasks such as create tables, stored procedures, and more.

C) MySql

• Developed by Sun Microsystems, MySQL is the most popular open source database server in the world with more than 4 million installations powering websites, data warehouses, business applications, logging systems and more.

• We currently support MySQL version 4.0.27 and 5.0.27

• Customers such as Yahoo! Finance, MP3.com, Motorola, NASA, Silicon Graphics, and Texas Instruments use the MySQL server in mission-critical applications.

• Hostopia supports MySQL on all Silver and higher packages.

• Connect to MySQL using SSH command: mysql -h hostname -u username –pPASSWORD or

mysql -h hostname -u username -D some_database -pPASSWORD

• To test connectivity of the server use the following SSH command: mysql -h hostname -u username -pPASSWORD

MySQL Dump

• http://internalfaq.hostopia.com/index.php?action=artikel&cat=34&id=903&artlang=en

Export a dump.sql file from a database

• mysqldump command is used for creating a backup of the MySQL database.

• Create an dump.sql file in current directory which contains content of the database by using the following SSH command: mysqldump –h hostname –u username –ppassword databasename >dump.sql

• If you encounter an error “Got error: 1044: Access denied for user 'somedomain941953'@'%' to database 'db_somedomain_com' when using LOCK TABLES” try adding -f to the above mysqldump command: mysqldump -f –h hostname –u username -ppassword databasename >dump.sql