Work with php however without much knowledge of the serverside perfect world, look for a script that exports to the mysql character information such as name, id, farming and others that you can seder me ...
Thank you in already.
Printable View
Work with php however without much knowledge of the serverside perfect world, look for a script that exports to the mysql character information such as name, id, farming and others that you can seder me ...
Thank you in already.
Search for backing up Mysql database you would like to dump it
Have fun :)Code:<?php
/*
* It keeps only 31 backups of past 31 days, and backups of each 1st day of past months.
*/
define('DB_HOST', 'localhost');
define('DB_NAME', 'your_database_name');
define('DB_USER', 'your_database_username');
define('DB_PASSWORD', 'your_username_password');
define('BACKUP_SAVE_TO', 'backup_storage_path'); // without trailing slash
$time = time();
$day = date('j', $time);
if ($day == 1) {
$date = date('Y-m-d', $time);
} else {
$date = $day;
}
$backupFile = BACKUP_SAVE_TO . '/' . DB_NAME . '_' . $date . '.gz';
if (file_exists($backupFile)) {
unlink($backupFile);
}
$command = 'mysqldump --opt -h ' . DB_HOST . ' -u ' . DB_USER . ' -p\'' . DB_PASSWORD . '\' ' . DB_NAME . ' | gzip > ' . $backupFile;
system($command);
?>
Create HTACCESS file
Code:Order deny,allow
Deny from all
you dont need htaccess, if you let the values be loaded from somewhere else that is outside the apache context, or use the active session that might be around anyways.