NEBridge - Database Documentation: Backup and Restore

1. Four programs create many records on at least one file. Before running any of those programs, it is important to create a copy of all files affected.

1.1 The program to backup and restore files is the first one in the rightmost column on both the Database Menu and the Winners Board Menu of both the local and remote systems.

The routines in this option are commonly used to copy and restore four sets of tables.

1.1.1 The advancement table, which is in green, is used by the program on the Database Menu to record advancements in rank.

1.1.2 The attendance, D25_points, and other_attendance tables, which are in red, are used by the program on the Database Menu that record attendance at tournaments.

1.1.3 The players and players_date_points tables, which are in blue, are used by the programs on the Database Menu that process ACBL roster files.

1.1.4 The winners_link and winners_link_players tables, which are in purple, are used by the programs on the Winners Board Menu that create winners links.

1.2 The first step is usually to delete copies of files that are no longer needed. Click on the boxes next to the files to be deleted. Make very sure that you are only deleting obsolete files. Then click on the “Delete” button at the bottom. The screen will reappear with a message at the bottom detailing whether the files were deleted.

1.3 To make new backup copies of the files, select the files to be copied. Check the value of the “Suffix” field against the list of backup files beneath each file to be copied. Clicking on the “Copy” button will create new files and populate them with the values in the existing files, but it cannot do that if the files with those names already exist.

1.3.1 If the suffix has already been used, alter the value of the “Suffix” field by placing a letter after the displayed date or by entering a different date.

1.3.2 After you click on “Copy” the screen will reappear with the new files listed.

1.3.3 Messages will appear at the bottom detailing which files were created and populated. Do not leave the screen until all files have been successfully copied with the same suffix.

1.4 If you need to restore from the backup copies:

1.4.1 Change the value of the “Suffix” field to match the suffix on the backup copies.

1.4.2 Select the files (without the suffixes) to be restored.

1.4.3 Click on the “Restore” button at the bottom. The screen will display again with messages at the bottom detailing the success of the actions.

2 The entire database can be backed up using the export function of phpMyAdmin.

2.1 On the local system the URL for phpMyAdmin is http://localhost/phpmyadmin/ You will need to select the database, which is called mikestuff, from a pull-down menu.

2.2 On the remote system the option for phpMyAdmin is located on the control panel. You should then click on Databases

2.3 Select the “Export” button at the top of the screen.

2.3.1 Select the “Quick” option on the first screen and click on the “Go” button.

2.3.2 Select “Save File” from the second screen and click on the “OK” button.

2.3.3 In the Downloads section of the browser it will display a message when the process has been completed. Right-click on the message and select “Open Containing Folder”.

2.3.4 In the list of downloaded files select mikestuff.sql, copy it and paste it to the folder used for backups. Then change the name to one that includes the date, e.g., msbu_180601.sql.