Move MySQL Installation ***For IT Administrators Only***

Step 1: Prerequisites

Before completing these steps, make sure that:

You are your office's IT administrator.

Your office has Local Data – not Cloud Data.

You have admin permissions on both your old server and your new server.

You have a USB drive handy.

Nobody in your office is currently using our software. We recommend completing these steps during non-working hours.

Step 2: Dump the MySQL database & copy the dump file to a USB drive

Complete this step on your old server.

2A. Dump the MySQL database.

Your MySQL dump instructions will depend on your server type:

• Dump the MySQL database on a MySQL server.
• Dump the MySQL database on a Microsoft SQL (MS SQL) server (DBA on staff required).

Dump the MySQL database on a MySQL server

32-bit computer:

• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysqldump -uroot -plandfx landfx > c:/landfxdump.sql
• Go to the root of the C: drive, and verify that you see a file named landfxdump.sql there.

64-bit computer:

• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysqldump -uroot -plandfx landfx > c:/landfxdump.sql
• Go to the root of the C: drive, and verify that you see a file named C:/landfxdump.sql there.

Dump the MySQL database on a Microsoft SQL (MS SQL) Server (DBA on staff required)

32-bit computer:

• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysqldump –compatible=mssql -uroot -plandfx landfx > c:/landfxdump.sql
• Go to the root of the C: drive, and verify that you see a file named landfxdump.sql there.

64-bit computer:

• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysqldump –compatible=mssql -uroot -plandfx landfx > c:/landfxdump.sql
• Go to the root of the C: drive, and verify that you see a file named landfxdump.sql there.

2B. Insert a USB drive into your old server.

2C. Go to the root of the C: drive, and locate the file landfxdump.sql.

2D. Copy the file landfxdump.sql onto your USB drive.

Step 3: Install Land F/X and MySQL on your new server

Complete this step on your new server. Do not skip this step. The Land F/X installer will place several important files onto your new server. You'll also need to install MySQL manually.

3A. Log in to your new server, and follow our steps to install Land F/X.

3D. Follow our manual MySQL installation steps.

Step 4: Copy the landfxdump.sql file onto your new server & restore MySQL database (recommended)

Complete this step on your new server.

4A. Insert your USB drive into your new server.

4B. Copy the file landfxdump.sql from your USB drive to the root of the C: drive on your new server.

It's important that you copy this file to the root of the C: drive. You'll be restoring it from that location using the following steps.

4C. Restore the MySQL database.

Your instructions for restoring the MySQL database will depend on your server type:

• Restore the MySQL database on a MySQL server.
• Restore the MySQL database on a Microsoft SQL (MS SQL) server (DBA on staff required).

Restore the MySQL database on a MySQL server

32-bit computer:

• Verify that the file landfxdump.sql is located at the root of the C:\ drive.
• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysql -uroot -plandfx landfx < c:/landfxdump.sql

64-bit computer:

• Verify that the file landfxdump.sql is located in C:\
• Open the Command Prompt. Copy and paste the following text into the Command prompt: cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin (Note: If you have a server that is more than a few years old, you may need to replace 5.5 with 5.1.)
• Copy and paste the following text into that directory: mysql -uroot -plandfx landfx < c:/landfxdump.sql

Restore the MySQL database on a Microsoft SQL (MS SQL) server (DBA on staff required)

Your database administrator (DBA) needs to enter the following in Microsoft (MS) SQL:

• CREATE DATABASE landfx;
• CREATE USER 'ODBC';
• GRANT ALL ON landfx.* TO 'ODBC';

If installing to a laptop, also include the following:

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

Finally, import the file landfxdump.sql into Microsoft (MS) SQL.

Step 5: Configure your office workstations

Complete the following steps on every CAD workstation in your office that will be using our software.

5A. Prerequisites:

Before configuring the CAD workstations in your office, make absolute sure that:

Land F/X is installed on your new server.

You have a LandFX folder on your new server.

You have a mapped letter drive pointing to that LandFX folder.

5B. Follow our steps to uninstall F/X Workstation from any Land F/X Workstations that currently have this component installed.

5C. Download the Land F/X Workstation Installer – linked below.

{jumi [*52]}

5D. Run the setup_FXWorkstation.exe file you just downloaded.

5E. Verify that the workstation is configured correctly with your new server.

 

Open the General Preferences screen from the F/X Admin ribbon.

 

Click Install Info.

 

You should see the name of your new server listed next to Project Data Server.

5F. Verify that your Land F/X data has been transferred successfully to your new server.

 

Open the Projects dialog box from the F/X Admin ribbon.

 

You should see all your existing Land F/X projects and templates in the Projects list.

5G. Migrate the licenses. Note: You only need to complete this step once, on the first workstation you configure.

Open CAD. When the License Management screen opens, assign all licenses to the new server.

5H. Repeat steps 5A–5F on each additional workstation in your office network.

5i. Remove any unused CAD workstations from the License Manager on your old server.

Complete this step after all workstations have been configured. Note: This step is only necessary if your office plans to take one or more computers out of commission as CAD workstations.

 

 

Open our License Manager screen, then follow our steps to remove each of your office's unused workstations from the License Manager.

Congratulations!

Once you've configured all CAD workstations in your office, you've completed your Land F/X server migration.

Each workstation user will check out a license from our License Management screen when he or she opens CAD and needs to use our software.