Sometimes you may need to keep track of largest table in MySQL database to optimize it. Here’s an SQL query to find the largest table in MySQL database
Here’s how to get MySQL database size for all or a specific database. You can use the following SQL query to get it.
Get MySQL table size for a table in your database with the following SQL query. MySQL table size is the sum of data length and index length.
Here’s how you can connect to MySQL on Amazon EC2 from Linux / Mac without opening any port by forwarding your local port over SSH
Convert .pem to .ppk using PuTTY to connect to Amazon EC2 instance from Windows. Amazon provides a .pem private key which cannot be directly used in PuTTY.
Here’s how you can connect to MySQL on Amazon EC2 from Windows without opening any port.
Here’s how you can connect to Amazon EC2 Linux instance from Windows laptop using PuTTy
Here’s how you can connect to Amazon EC2 Linux instance from your Linux/Mac laptop, using SSH.
When working with MySQL, you may need to backup and restore MySQL database regularly to recover in case of accidents. Here’s how you can do it.
Usually remote access to MySQL database is disabled for security reasons. However, if you need to provide remote access to MySQL, just follow these steps.