Introduction

The database tools interface allows you to use functions to manage the MySQL database that the LinkX data is being stored in. The functions available in the Database Tools interface are described in this document.

Database Backup and Restore

The database backup and restore functions provide you with an internal method to create a backup of the MySQL database tables that LinkX uses to store it's data. On some servers, depending on the server configuration and size of your database, this internal function may not work and you may need to use an alternate method. The method that you use is really not that important, as long as the data is in a format that MySQL can read.

Database Backup

To use the database backup feature access the Database > Tools function from the control panel menu. This will load a page with a section header bar labeled 'Database Backup and Restore'. There will be an information bar below the header bar to let you know what method the software will use for the database backup function. Each of those is described below. To do the actual database backup simply enter a filename in the text input box and press the Backup button. The file with the backup data will be created with the filename you specified in the data directory of your LinkX installation. After you run the backup function, check the data directory to make sure the backup file has been created. You can also monitor the size of that file to determine when the backup process is complete. When the file size stops increasing, you can download that file to your local computer for safe keeping.

Database Restore

To use the database restore feature access the Database > Tools function from the control panel menu. This will load a page with a section header bar labeled 'Database Backup and Restore'. There will be an information bar below the header bar to let you know what method the software will use for the database restore function. These are basically the same as the backup methods, so you can refer to that information above.

To do the actual database restore, you will first need to make sure the backup file has been uploaded to the data directory of your LinkX installation. Once it is uploaded simply enter it's filename in the text input box and press the Restore button. The data in that file will be read into the MySQL database. You should allow a few minutes for this process to complete (more time will be needed for larger databases) before you begin accessing the other software functions.

Alternate Backup/Restore Methods

Coming soon...

Raw Database Query

This function allows you to run a raw SQL query against the MySQL database that is storing the LinkX data. This feature is intended for advanced users who have experience working with SQL queries and understand the impact they will have on the database. In most cases you will not need to use this feature, unless you have been instructed to by the JMB Software staff.