How to install PHP-fpm and MariaDB in CentOS 7

In the last article we installed Nginx in CentOS 7. In this article we will extend our previous how-to and add how to install PHP-fpm and…

Read more...

Backup and Restore MySQL databases [Part 4]

In this part we will backup MySQL databases via mysqldump command. I assume you are logged in to your Amazon instance.

Read more...

Backup MySQL data into CSV [Part-2]

Now let’s say we have multiple tables and they are connected with each other through keys. For example user table with votes table.

Read more...

How to insert csv file data into MySQL database

MySQL have this load data function, where we can insert data to a table from external files like csv, txt etc.

Read more...

MySQL: create user and database, assign privileges and user to database

Do you want to create a separate user for a database which only some users/user can access. Want to create user who can only have access…

Read more...