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.
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:
- Open a Windows command prompt in (Start>Run type cmd and then press the [enter] key)
- Change directory to the MariaDB by typing the following:
CD "C:\Program Files\MariaDB 10.11\bin" - then type the following command:
mysqldump -u root -p Factorywiz > C:\bin\full_db.sql
once you press the enter key, you will be prompted for the root password, please contact FactoryWiz support for that password
To restore a database from a backup file in C:\BIN directory:
- Open a Windows command prompt in (Start>Run type cmd and then press the [enter] key)
- Change directory to the MariaDB by typing the following:
CD "C:\Program Files\MariaDB 10.11\bin" - then type the following command:
mysql -u root -p Factorywiz < C:\bin\full_db.sql
replace c:\bin\fulldb.sql with the actual path and name of your database backup file
once you press the enter key, you will be prompted for the root password, please contact FactoryWiz support for that password
If you want to backup an individual table, such as the fwconfig table,
put that table name after the FactoryWiz database name:
put that table name after the FactoryWiz database name:
mysqldump -u root --p Factorywiz fwconfig > C:\bin\fwconfig_db.sql