Category: DataBase
Recovering MySQL DataBases on AWS instance after an unexpected server crash and without backups
Its possible that an AWS instance can run into various issues of unexpected crashes or can even be a case where you lost connectivity to your instance possibly due to network/firewall issue at AWS level or within your instance. In either of these cases, you’d have no choice than to re-configure your solution on a new instances. However, you will not have even an option to backup your MySQL DB that is running on the instance that is inaccessible. If you have planned good and configured your WAMP solution in a way that MySQL DB Data files are relocated to […]
Read moreRelocate or Move “MySQL on Windows” Data Files to another Drive using MySQL Workbench
When you install “MySQL on Windows”, the database Data Files are by default placed/located in “C:/ProgramData/MySQL/MySQL Server 5.1/Data/” folder as shown below: As a best practice, a DBA would always like to have the DB data files to be placed on a separate drive/volume. To change the folder location, you need to modify it in “MySQL Workbench” > Under Instance, Options File > General Tab > Directories > datadir and set the path to the folder on a another drive/volume (as shown below). Then click Apply. Click Apply on the “Apply Changes to MYSQL Configuration File” (“C:\Program Files\MySQL\MySQL Server 5.1\my.ini”) […]
Read more