database

You can follow below steps to update Remote Query Timeout in MSSQL: Login to MSSQL server with SQL Server Management Studio On the left side in Object Explorer right click on particular server name and choose “Properties” option. A new window will open where you have to click on “connections”...

We always recommend “db” folder which is created with ‘www’ or ‘wwwroot’ folder for .mdb file (MS-Access database). Here are the reasons why ‘db’ folder is used for .mdb file. 1. Read/Write Access: We place database file in ‘db’ folder because system user have read-write access of this folder...

Are you struggling with the error Eximstats database is too large? One most common error will have occurred during the performance of the lower disk. /usr/local/cpanel/scripts/eximstats_spam_check The above script tends to load when you have lower performance on disk. There is a default...

You have to use following command to take backup : You can use below command to take backup of postgresql database. pg_dump mydb > db.out You can use this command to restore database psql -d database -f db.out

You can follow below steps: Go to Enterprise Manager and expand all SQL server databases. Now click on particular database and right click on it. Now you want to select “All Tasks” and click on “Backup Database”. You have to select “Database-complete” to take complete backup. Now click on “Add”...

Normally MySQL data will store in /var/lib/mysql, but still you want to check the the location of your database then you can follow below steps: You can use below command to find the location of data directory: mysql -e "show variables like 'datadir'" You can get the directory for MySQL with...

The open_files_limit setting can be set via system on CentOS 7 server, for that you have to edit my.cnf file. First you have to create file and you can check command for that: /etc/systemd/system/mariadb.service.d/limits.conf After that you have to add below lines of code in your my.cnf file...

Normally MySQL data will store in /var/lib/mysql, but still you want to check the the location of your database then you can follow below steps: You can use below command to find the location of data directory: mysql -e "show variables like 'datadir'" You can get the directory for MySQL with...

Mysqluserstore script helps to update users.db and users.db.cache file. You can check location of these files : /var/cpanel/databases/users.db /var/cpanel/databases/users.db.cache After that you will get below error: [mysqluserstore] Restarting MySQL due to my.cnf modifications. You have to...

MySQL triggers is an object which is attached with particular table and execute when that event occur. These triggers only work when any of these Mysql statements run like INSERT, UPDATE, DELETE etc. NOTE: You can only use triggers if you have MySQL SUPERUSER privileges. So you have your own...

If you want to optimize your created table in your database then you can simply follow this article. Login to cpanel. Here click on “PHPMyAdmin” under “Database” section. Select the “Database” which you want to optimize. Now select the particular table or you can select all links which is...

Follow below steps to check and repair databases: Login to Plesk. Navigate to Websites & Domains >> Databases >> Check and Repair. If there is any problem then you can click on the provided link and resolve it. You will find the details of tables and its problems, here in MySQL database you can...

While restoring database sometimes it’s possible that few database users will get orphaned and if you want to use them again then you need to repair those databases, to achieve this you have to follow below steps: You can check your database is orphaned or not with below steps: Login to Plesk...

First you can install MariaDB with below command on server: #yum install mariadb-server OR #yum install -y mariadb mariadb-server Now restart MariaDB while booting with commands: #systemctl start mariadb.service - Restart MariaDB #systemctl enable mariadb.service - Auto run when boot With...

You can follow below steps to rename mysql database: Login to cpanel. Search for “Mysql Databases” under Databases. Now select particular database which you want to rename from “Current Databases” list and click on “Rename” option. Enter your desired password and click on “Proceed” button. Now...

You can follow below steps to create Mysql database. Login to DirectAdmin. Now click on “Mysql Management” link. Here you will find “Create New Database”, you have to click on it. Enter below details : Database Name Database Username Password of that user Re-type Password At last click on...

MySQL: MySQL is the popular open source database with relational database management system. It is used by web-based application and its performance is high, reliable and it is very easy to use. Table contains set of elements with rows and columns. Creating the table is same as creating a...