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 tutorial will help you to recover or reset Amazon RDS master user password via Amazon Web Services Console interface. 1. Login to Amazon Web Services Console. 2. Go to RDS services. 3. Select RDS instance >> Click on Instance Actions >> Click Modify. 4. Enter your new master password in New Master Password...
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 <...
Some times your server may experience issue of too many connections in MySQL server. To fix this you can increase the max_connections value in your mysql configuration. Check max_connections Value Max connections value are stored with variable named max_connections. Login to you mysql terminal with privileged user and execute following query. mysql> SHOW VARIABLES...
Few days back PHP version 7.0 has been released. Which has number of changes and improvements over PHP version 5.X. This article will help you to install PHP 7, NGINX and MySQL 5.6 on CentOS / RHEL 7.1 & 6.7 operating systems. This tutorial has been tested with CentOS 7.1, so all the services...
The latest major release of PHP version 7.0 has been released with lots of speed optimizations and security. So you should try this version for your development. This tutorial will help you to install PHP 7.0, Nginx, & MySQL 5.6 on Ubuntu 15.10, 14.04 and 12.04 LTS release. Step 1 – Install PHP 7...
LEMP Stack (Linux, Nginx, MySQL and PHP ) is a popular web hosting environment for websites developed in php programming language. Linux is the operating system, Nginx is the popular web server and MySQL is relational database management system used for storing data. This tutorial will help you to setup LEMP Stack on Ubuntu...
Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most popular database used for storing values. MySQL database driver for Node.js is available under NPM repository. In this tutorial you will learn to how to connect MySQL database using node.js and do INSERT, UDATE, SELECT and DELETE...
