Maintenance

24-07-2014, 13:04. Author: dlestarter

Home » DLE Administrations » Maintenance

Maintenance Option in Datalife Engine Administration is for Optimize database, Repair database, Database Backup and Database Restore, this option is very useful for backup and restore your website database, backup and restore without having to login to your PHPMyAdmin and Datalife Engine have done a wonderful works in this function and make it easy to use for users, Maintenance Option comes with 3 functions (options)

Database Functions

Database Functions: This function is for optimize and repair database, you will have the list of all DLE database tables in this section, you can optimize or repair specific table or multiple or all tables. The process is quick or slow depending on the size of your database and database server connections.

Optimize database: It is recommended to optimize MySQL database at least once a week. This option will optimize database by check for error and report if there is anything needs to be improve on performance etc..this option is also available with "Cron", we recommend that you use cron to setup optimize database weekly, please visit Cronjob/Crontab in DLE page
Repair database: Use this function only when MySQL database stops responding, sometime if you have any error or any issue on your database of your website, and you still able to access to Admin CP, use this option to repair the database first before you do anything else, the repair process will check for database error base on DLE data structure, it will repair the error table and column, it any table or column can't be repair it will set the table back to standard structure. NOTE: do not use this option if you don't have any error in your database because you might loose some data in case there is fault error.

Database Backup

Database Backup: This option is to backup your database that using for your DLE site, the backup process will only backup the Datalife Engine table that have same prefix that you specified when you install Datalife Engine, it will not back any other database prefix, to be exact word, backup will only backup the database table the listed in "Database Functions" above section. The backup function will allow you to select between "No compression" file as .sql file, and gzip file format, inside the gzip it contains .sql file which all phpmyadmin support to import. NOTE: this backup option is also available in "Cron", you can use cron to setup the weekly or daily or monthly backup automatically, for more information please visit Cronjob/Crontab in DLE page.

The backup file names will be automatically generated by the script function, the file name will start with DB-PREFIX_YEAR_MONTH_DAY_TIME_RANDOM.sql or .gzip, The process is quick or slow depending on the size of your database and database server connections.

Database Restore

Database Restore: If you have created any backup on your server before, you will have the list of backup file in the drop down list, or if you move your website from another host and before you move you have perform the backup then download/upload the files from older server to this new server, then you will see the list of the backup files, you select from the list and restore the full data from the old server using this option is handy and easy. In some cases people move the server and install the new DLE process just to make sure that the new server have the system requirements for DLE, so after finished installation they will use this option to restore that data to database, this is recommend and great idea to start by install the bran new script, because many people don't realize the issue on this, after they moved to the new server then they got problems something works, something doesn't work etc...reinstall script and restore the database is the most recommended way to move the webhost. The process is quick or slow depending on the size of your database and database server connections.

Go back