Database Server |

How to check Database size in Linux

We can check all the sizes of databases through execute a simple query in mysql server Step 1: Login with[…]

Step 1: Install MySQL Server Install MySQL Server on both machines. # apt-get update # apt-get install mysql-server mysql-client Step[…]

Step 1: Login MySQL Server Use the mysql credentials to login in mysql server: # mysql -u root -p Step[…]

There are 2 methods in order to delete the database in mysql through Linux Shell. Method 1: Delete through mysqladmin[…]

Step 1: Modify /etc/mysql/my.cnf File To enable mysql slow query logs add the lines in my.cnf file. #vi /etc/mysql/my.cnf log_slow_queries[…]

Step 1: Login MySQL Database Login to MySQL database using following command: # mysql -u root -p Enter password: Server[…]

Step 1: Remove mysql Server We can use apt-get command in order to remove both MySQL server and client in[…]

Export MySQL database To export mysql database, use the mysqldump command. # mysqldump -u root -p database-name > backup.sql e.g[…]