databaseTag Archive

ERROR 1153 (08S01) at line 8606: Got a packet bigger than ‘max_allowed_packet’ bytes. Date: 22-05-2021 Introduction: When doing a very large MySQL import from a dump file you may get this error. You can follow the below steps to solve this error. Step 1: You can see the current configured… Continue Reading ERROR 1153 (08S01) at line 8606: Got a packet bigger than ‘max_allowed_packet’ bytes.

How to secure MongoDB databases Date: 22-12-2020 You must edit mongod.conf, MongoDB’s configuration file to enable authentication. Once you enabled it and restart the Mongo service, users will still be able to connect to the database without authenticating. However, they won’t be able to read or modify any data until… Continue Reading How to secure MongoDB databases

We got this Error when we upgraded Bugzilla. This is a normal database error as well. When we ran ./checksetup.pl, we got this error. After following the below steps we upgraded Bugzilla successfully. 1) First we need to check the database version.mysql –version2) If it is below 5.5 then we… Continue Reading The used table type doesn’t support FULLTEXT indexes

How to delete databases in Amazon RDS Date: 13-05-2020 Introduction: Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Amazon RDS Free Tier. It helps new AWS customers get started with a managed database service in the cloud for free. Step 1: Open Amazon RDS… Continue Reading How to delete databases in Amazon RDS

MONGODB BASIC OPERATIONS Date posted :11/05/2019 INTRODUCTION: In this tutorial we are going to see about mongodb basic operations. 1)Start mongodb in port The following command used to start the mongodb with the port(27017). 2)Stop mongodb To stop the mongo services the following command used to stop the mongo services.… Continue Reading MONGODB BASIC OPERATIONS

How to create a database and the user for that database in cPanelThese are the steps to create a database and the user for that database in cPanel 1) Login to the cPanel 2) Go to “Databases” 3) Click on “MySQL Darabases” 4) Under “Create Database” 5) Enter the database name.… Continue Reading Create a database and the user for that database in cPanel

Here, is the script that we used to take backup of all the MSSQL database present in the windows server. You would need to get the “Sa” password from any website web.config file.=============================== @ECHO OFF SETLOCAL REM Created By Dhanasekaran for /F “tokens=2-4 delims=/ ” %%A in (‘Date /T’) DO… Continue Reading Bacth script to take backup of all the database MSSQL