AtulHost

MySQL

  • How to export and import an SQL file using the command line in MySQL?

    How to export and import an SQL file using the command line in MySQL?

    People who use phpMyAdmin may find using command line difficult as using wrong syntax can lead to anything, while using command line is the most secure and reliable way where phpMyAdmin fails due to scripts limits. First, login to server using SSH like: ssh username@hostname (and use -p flag if using any port). Before we […]

  • Installing MariaDB and secure it on Debian

    Installing MariaDB and secure it on Debian

    MariaDB is one of the best relational databases and we can use it on Debian Linux to host databases for apps, blogs, and websites. In this article we’ll learn installing MariaDB and securing it on Debian. 1. Refresh the system once. sudo apt update 2. Install MariaDB server. sudo apt install mariadb-server 3. Secure it. […]

  • Optimize MySQL Databases to Improve the Query Performance

    Optimize MySQL Databases to Improve the Query Performance

    Many times you must have been facing the issues that are caused due to a slow running database. In such cases when the database is running slow, several queries will line up, the backlogs will grow at pace and users would be refusing connections. What do most management boards do in such a condition? The […]