Replace a Broken MySQL Database

Issue

You need to replace a broken or corrupt MySQL database.

You may need to complete these steps because:

• Your MySQL database may no longer be accessible. MySQL service may be running on your server, but your office workstations either fail to connect or present database errors, and connection information has been verified as accurate.
• Your office had a power outage, or the server was not properly shut down, and the MySQL service was still running.

For further information, see the following articles:

• MySQL Stops or Will Not Start
• MySQL Errors and Troubleshooting

Solution

1. Make sure you have a backup of all Land F/X projects, preferences and templates. If you do not have a recent backup in your Land FX/data/backup folder, you'll need to locate projects individually in the same folder directory where your DWGs are stored. Follow our steps to Import Project Data from .lfx or auto_projdata.lfx or a backup file.

2. Open the MySQL command line. Open the Start menu and either:

• Search for MySQL in the list of programs, then launch the MySQL Command Line Client, or
• Type MySQL into the search bar and select MySQL Command Line Client from the search results

3. With the command line open, you'll be prompted for a password. Type landfx, then press Enter.

4. You'll now see a command prompt displaying MySQL>. Copy and paste the following text at the command prompt:

 

DROP DATABASE landfx;

 

Then press Enter.

5. Once the database has been removed, copy and paste the following text at the command prompt:

 

CREATE DATABASE landfx;

 

Then press Enter.

 

6. Grant access to the database:

 

• If installing to a workstation (not a laptop): Copy and paste the following text at the command prompt:

 

GRANT ALL ON landfx.* TO 'ODBC';

 

Then press Enter.

 

 

• If installing to a laptop: Copy and paste the following text at the command prompt:

 

GRANT ALL ON landfx.* to ''@'localhost';

 

NOTE: '' is not a double quote – it's two single quotes.

 

Then press Enter.