There are two ways of sending a backup of your database through Specify. One way allows you to create the backup while you are logged into your database. The other way allows you to create the backup without having to be logged in. Both methods create the same files; they are just different means of doing it.
Log into Specify. You must be logged in as an Admin user.
Once in Specify, go to Edit in the Menu Bar and select Preferences from the list.
- In Preferences, click MySQL to open the MySQL screen.
- Continue to Step 5 below.
- In the Start menu, click All Programs to reveal the programs listed. Find the Specify folder and click on it to reveal the Specify applications. Select SpBackupRestore from the list of applications.
- In the Backup and Restore window, enter your IT username and password. The IT username and password are the logins for the MySQL server on which your database is located. The username is likely root.
- Click More Information to reveal the Database and Server fields. Make sure the correct database and server are identified. (This step is not necessary if you only use one MySQL server and it is located on your machine and you only have one database in the MySQL server.)
The first time you use Backup and Restore, you will have to identify the MySQL Dump and MySQL files Specify will use when creating a backup or restoring a database.
- To identify the MySQL Dump file, click Browse. Navigate to the MySQL folder on your computer. (MySQL must be installed on your computer to perform this function!) It is likely on your Local Disk C:\Program Files\MySQL\MySQL Server 5.7\bin. Click the mysqldump file (the exe extension may or may not be added to the file name depending on your computer configuration) and click Open to select.
- To identify the MySQL file, click Browse. Navigate to the MySQL folder on your computer. It is likely on your Local Disk C:\Program Files\MySQL\MySQL Server 5.7\bin. Click the mysql file (the exe extension may or may not be added to the file name depending on your computer configuration) and click Open to select.
- For the Backup Location field, click Browse. Navigate to the folder in which the database to be restored is saved. Select the folder and click Open to select. Note: The field only identifies the folder in which the backup will be created.
The Backup and Restore window will show you a progress bar.
- When the backup is completed, the progress bar will disappear and the window will say the size of the backed up database.
- Once the backup is created, navigate to the file. If you can, zip the file to compress the size.
- Navigate to https://spaces.hightail.com/uplink/specify.
- In the screen that appears, enter your email address and any other data you would like to add. In the Select a file field, navigate to the zipped backup and click Open. The file will briefly upload.
- Once the file has been selected, click Send It.
- The file will be sent and Specify will be notified.