Deploying Databases
If your hosting package includes local database, you can manage your database through the panel. You can either create a new database for your site or import the data from your previously backed up MySQL, or Microsoft SQL database. Creating or Importing a DatabaseTo create a new database on your hosting account: 1 On your Home page, click Databases. 2 Click Add New Database. 3 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). 4 Select the database type that you are going to use: MySQL or Microsoft SQL Server (depends on the server that your site is hosted on). 5 Select the database server of the selected type from the list. Click OK. 6 To set up database administrator‘s credentials, click Add New Database User. 7 Type a user name and a password that will be used for accessing the contents of the database. 8 Click OK. To import an existing database: 1 On your Home page, click Databases. 2 Click Add New Database. 3 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). 4 Select the database type that you are going to use: MySQL, or Microsoft SQL Server. Click OK. 5 To set up database administrator‘s credentials, click Add New Database User. 6 T ype a user name and a password that will be used for accessing the contents of the database. Click OK. 7 Click the DB WebAdmin icon in the Tools group. An interface to phpMyAdmin, phpPgAdmin, 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. To manage your databases and their contents, use your favorite MySQL, or Microsoft SQL Server client or the Web based database management tool accessible from Parallels Plesk Panel (Home > Databases > database name > DB WebAdmin). |