MySQL Database Backup and Reload

You will need to remote access to the FactoryWiz server to perform these procedures.

NOTE: the password portion askusforthispassword in these commands is not the actual password.
You will need the actual password for the root user.
Please send an email to support at factorywiz.com and we can supply this password to you.

To backup the FactoryWiz database to C:\Bin from command line:

1. Open a Windows command prompt in (Start>Run type cmd and then press the [enter] key)
   
2. Change directory to the MariaDB by typing the following: 
   CD "C:\Program Files\MariaDB 10.11\bin"
3. then type the following command: 
   mysqldump -u root --password=askusforthispassword Factorywiz > C:\bin\full_db.sql
   

To restore a database from a backup file in C:\BIN directory:

1. Open a Windows command prompt in (Start>Run type cmd and then press the [enter] key)
   
2. Change directory to the MariaDB by typing the following: 
   CD "C:\Program Files\MariaDB 10.11\bin"
3. then type the following command: 
   mysql -u root --password=askusforthispassword Factorywiz < C:\bin\full_db.sql
   replace c:\bin\fulldb.sql with the actual path and name of your database backup file

If you want to backup an individual table, such as the fwconfig table,
put that table name after the FactoryWiz database name:

mysqldump -u root --password=askusforthispassword Factorywiz fwconfig > C:\bin\fwconfig_db.sql

• Related Articles

• 8.3.1 Database Backup

  The Database Configuration window, shown in Figure 9‑72, allows you to select how long FactoryWiz™ Monitoring stores the data it collects from your machines. Database Backup The Backup Configuration window lets you specify where and when you want ...

• 8.3.5 MySQL Console

  MySQL Console FactoryWiz™ Monitoring provides a MySQL command console to access the database directly using T-SQL database commands. FactoryWiz™ recommends that only users with MySQL experience and training be authorized to open this console. To ...

• 8.3.6 Full Database Wipe

  Full Database Wipe If you need to purge all the data collected and retained in the FactoryWiz™ Monitoring database, you may do so with a full database wipe. This is an irrevocable action – you will not be able to recover the data afterwards. NOTE: ...

• MySQL Too Many Connections

  Too Many Connections We recommend taking a back up of your server beforehand. Set the following: You need to create 2 new DWORDS in the Registry. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters Value Name: MaxUserPort Data Type: ...

• 11 External Documentation

  FactoryWiz uses multiple external libraries and software packages. Here are links to vendor resources and manuals. · MySQL Database · Adam APAX Utility · Adam APAX Utility Manual · Moxa Device Manager Software · Moxa Nport Manual · Comtrol Manual · ...