Backing Up the Database Configuration File

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US

Not every customization made to MySQL 5.6 or 5.7 will be compatible with MySQL 8.0, so it is not recommended to copy the database configuration file from your currently installed version of MySQL for use as the database configuration file for MySQL 8.0. However, it is best practice to back up your current database configuration file to keep for reference for when you are making customizations to MySQL 8.0.

  1. Log in to the server hosting the MySQL database.
  2. Locate the my.ini file in a filepath similar to the following, depending on your currently installed version of MySQL: C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
    Note:

    This directory is hidden by default. To navigate to this directory, paste the filepath into the Windows Explorer address bar and press Enter.

  3. Copy the my.ini file to a location for future reference (e.g., ~/Desktop).