Create or Import a mySql database
The Webadmin application can be used to manage your mySql databases within your Plesk Hosting Control Panel.
Use the Webadmin application to create, delete and edit your mySql databases and database users. You can also reset database user passwords from with Webadmin.
Once inside Webadmin, you can do everything that you would expect from phpMyAdmin except create and delete databases, this needs to be performed in the Plesk Hosting Control Panel.
A common problem when attempting to launch Webadmin is your browser Popup Blocker. The Webadmin applications opens using a Popup so you must ensure that Popups are not blocked for your Plesk Hosting Control Panel. If you find that clicking on the "Webadmin" button does nothing, then this is the problem, to resolve the problem Disable the Popup Blocker in your Browser and/or Toolbar..
To create a new database on your hosting account:
- Go to Domains > domain name > Databases and click Add New Database.
- 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).
- Select the database type that you are going to use: eg. MySQL.
- Select the database server of the selected type from the list. Click OK.
- To set up database administrator's credentials, click Add New Database User.
- Type a user name and a password that will be used for accessing the contents of the database.
- Click OK.
To import an existing database:
- Go to Domains > domain name > Databases and click Add New Database.
- 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).
- Select the database type that you are going to use: MySQL, PostgreSQL, or Microsoft SQL Server. Click OK.
- To set up database administrator's credentials, click Add New Database User.
- Type a user name and a password that will be used for accessing the contents of the database. Click OK.
- Click the DB WebAdmin icon in the Tools group. An interface to phpMyAdmin will open in a separate browser window.
If you have a MySQL database:
- Click Query window in the left frame, click the Import files tab,
- Select the text file that contains the data and click Go.
- Click the Insert data from a text file link.
That's all there is to it! If you have any problems simply contact the Helpdesk for further assistance, |