database

  1. K

    Steps to increase MSSQL Remote Query Timeout

    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”...
  2. K

    For MS-Access database location of database folder

    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...
  3. K

    How to fix the problem “Eximstats database is too large”?

    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...
  4. K

    Steps to take postgreSQL database backup

    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
  5. K

    Steps to create backup file of SQL server database

    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”...
  6. K

    Steps to find MySQL data location

    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...
  7. K

    Steps to increase open files limits for MariaDB

    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...
  8. K

    Steps to find MySQL data location

    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...
  9. K

    Resolve Error “Restarting MySQL due to my.cnf modifications."

    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...
  10. K

    What are MySQL triggers? And steps to use them

    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...
  11. K

    Steps to optimize table in PHPMyAdmin

    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...
  12. K

    How to check and repair databases in Plesk?

    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...
  13. K

    Steps to post restoration database repair

    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...
  14. K

    How to install MariaDB on our server?

    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...
  15. K

    How can we rename mysql database in cpanel?

    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...
  16. K

    How can we create Mysql database in DirectAdmin?

    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...
  17. bhawanisingh

    Steps to Drop all tables in MySQL database

    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...
Top