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...
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...
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...
You must have faced the foreign key constrains issues many times while working with MySQL database. Generally this issue occurred during delete, insert records, backup and restore database and drop database and drop tables. In this situation its hard to complete task. MySQL provides an option to disable foreign key checks during any operation...
Logs are very useful part of any service to check status. We can easily trouble shoot issues using logs data. In this article you will know how to enable different types of logs in MySQL server or change log file location in MySQL server. Error Log – this contains all the information about errors...
MySQL is an Relational Database Management System, widely used as database system for Linux systems. This article will help you to calculate size of tables and database in MySQL or MariaDB servers though sql queries. MySQL stored all the information related to tables in database in information_schema database. We will use information_schema table to...
Binary log files contains data about modification’s make by MySQL server. You can see there are multiple binary files will be available on your MySQL server and there will be one .index file which contains names of all binary files to keep track of them. Step 1. List Binary Files First list binary log...
Syntax mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL ON [dbname].[table] TO 'username'@'localhost'; Implementation First login to mysql with root account and use following command to create new user ‘rahul in mysql with Full privileges. But this user can access database server from localhost only. mysql> CREATE USER 'rahul'@'localhost' IDENTIFIED BY 'password';...
MariaDB ia an enhanced, drop-in replacement for MySQL. MariaDB can be a better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and MySQL This article will help you to...
