UK Sales: 0800 035 6364 | sales@2020media.com | We'll Call You

Question:
How do I create and manage database on 2020Media's Plesk servers.

Solution:
To create a new database on your hosting account:

1. Go to Domains > domain name > Databases and click Add New Database.
2. Enter a name for the database.

We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).
3. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
4. To set up database administrator's credentials, click Add New Database User.
5. Type a user name and a password that will be used for accessing the contents of the database.
6. Click OK.

To import an existing database:

1. Go to Domains > domain name > Databases and click Add New Database.
2. Enter a name for the database. We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).
3. Select the database type that you are going to use: MySQL or Microsoft SQL Server. Click OK.
4. To set up database administrator's credentials, click Add New Database User.
5. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
6. Click WebAdmin in the Tools group. An interface to phpMyAdmin (or ASPEnterpriseManager) database management tool will open in a separate browser window.

If you have a MySQL database:

1. Click Query window in the left frame, click the Import files tab,
2. Select the text file that contains the data and click Go.
3. Click the Insert data from a text file link.

If you have a MS SQL database:

1. Click the name of your database in the left frame
2. Click Query (the magnifying glass button)
3. Copy the text of your script into the text area and click Run Query.
4. Or, if you have a complex database, we can restore from your backup. See "Import MSSQL database to a plesk server" in the Support section

To manage your databases and their contents, use the web based database management tool accessible from Plesk control panel (Domains > domain name > Databases > Database name > WebAdmin).

2020Media is a leading provider of small business Wi-Fi hotspots. If you want to offer free Wi-Fi to your customers or users, our service could be exactly what you are looking for. Our Hotspots are managed in the cloud, ultra-reliable and give you loads of information about behaviour patterns of your users. Read More   Read more...
2020Media introduces Moodle Hosting - UK servers and UK Moodle experts setup your site ready to use. Read more...
Special Offer for Longer Registration Periods Register or renew a .com, .net or .org domain name for 5 years we'll include 1 year free*. Read more...
2020Media is now offering zero-click installation of the popular TYPO3 content management system. Read more...

Our blog is regularly updated with news, tips and industry opinion.

Clients

  • AggieWestons
  • baker-and-mckenzie
  • arts-council-england
  • Big Finish
  • barratt-developments-logo
  • City-of-Lincoln-council-logo
  • brora-logo
  • DenisMacShane
  • Construction-Industry-Council
  • colchester