After writing a simple shell script for MySQL database backup. This is our new advance bash script for MySQL database dump. This script will provide you to backup MySQL database and upload backups various remote locations like FTP, SFTP and Amazon s3 bucket. This script is available on our Github account with all supporting...
Q. How do I use MySQL command without prompting password? How do I use mysqldump command without using the password in the script? How do I use MySQL commands without passing the password in crontab? In this tutorial, you will find a way to use MySQL commands without passing passwords as command line parameter...
Q. How do I run a SQL text file on MySQL prompt? How to source .sql file on MySQL command prompt? How do execute the .sql file in MySQL command prompt? How to Run SQL Text File on MySQL Command Prompt? If you are on MySQL command prompt and need to execute all SQL...
This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU. To run this query, start SQL Server Management Studio, Open New Query window and...
PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. This tutorial will help you to install PostgreSQL database server on Debian 8 and Debian 7 systems. How to Install PostgreSQL on Ubuntu Step 1. Configure Apt Repository First, you need to import PostgreSQL packages...
Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup. USE MASTER GO RESTORE DATABASE MyDB FROM DISK = 'C:\Backups\MyDB_15082016.bak' WITH REPLACE GO
MySQL database restoration process failed with a error message while restoring a large backup file. I got the below message. After reading about this problem i found that this is not with size of backup, this problem occurred when a single package size is greater than allowed packet size. [email protected]:~$ mysql -p mydb <...
MySQL configuration file (my.cnf) file location depends on operating system or installation method. There are no command available to trace this file location on your system. In this tutorial you will get some default location’s of my.cnf file can be found. /etc/my.cnf /etc/mysql/my.cnf $MYSQL_HOME/my.cnf [DATADIR]/my.cnf ~/.my.cnf In case my.cnf file is available on more...
MongoDB is a nosql database server. The default installation provides you the access of database using mongo command through command line without authentication. In this tutorial you will learn how to create users in Mongodb server with proper authentications. Create Admin User You can use below commands to create user with admin privileges in...
Indexes are very useful to improve search queries on database tables. For example you are searching for particular record in a database table having millions of records. You will find that search queries taking very less time on tables having indexes enables. CREATE INDEX:- This will creates index on mysql table. This will allow...
