Databases
Creating, importing and managing MySQL and MSSQL databases.
Databases articles
Backing Up and Restoring Databases in Plesk 12.5
Backing Up and Restoring Databases You can back up a database in the following ways: Export a database dump in the SQL format. This enables you to create and download the database in a single file. An individual file can be restored into the same or another database. See the Exporting and Importing Database Dumps […]
Exporting and Importing Database Dumps in Plesk 12.5
Exporting and Importing Database Dumps A database dump is a file containing a database structure and content. You can use it for backup purposes. In earlier Plesk versions, dumps could be created only using database management tools. Now Plesk offers a quicker way to create database dumps, store them, and deploy previously created dumps on […]
How many simultaneous connections can one MySQL database have?
We allow up to 200 simultaneous connections per MySQL user.
Creating Databases
Creating Databases To create a new database on a hosting account: If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace. Click the Websites & Domains tab. Click Databases (in the Advanced Operations […]
Creating Database User Accounts
Creating Database User Accounts If you collaborate with other people on managing a website and wish to give them access to the database, you should create separate user accounts for them. To create a database user account: If you are subscribed to several hosting packages and have access to several webspaces associated with your account, […]
How to Create database in Plesk 12.5
Creating Databases https://youtube.com/watch?v=euPzAJqCdqg You can create and remove databases in Websites & Domains > Databases. You can create a database by specifying its name. If your subscription grants you the corresponding permission, you can choose a database type and the database server on which the database should be created. You can select a website on […]
How to Change a Database Quota for a Particular Domain
Please follow the below procdure for database quota change for particular domain 1.Login to your plesk control panel 2.Click on subscriptions 3.Click on customize option 4.Check the quota for your database and change it. 5.Click on ok.
How to move a database to the different database server within Plesk?
How to move a database to the different database server within Plesk on Motherhost Server? Log into Plesk Navigate to the **Domains > example.com > Databases: ** Click on the Copy button under the database that should be moved to another database server Select the desired target database server in the Destination database server field: […]
Importing Databases
Importing Databases To import an existing database: If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace. Go to the Websites & Domains tab > Databases (in the Advanced Operations group) > Add […]
What are the limitations for MSSQL?
We allow up to 100 simultaneous connections per MS SQL user. MS SQL Server limits you to 1024 columns per table. The number of tables and of rows per table is only limited to 200 MB. Additionally, each MS SQL database transaction log is limited to 100MB in size.