I'm trying to set up an auto back-up thing on a database table.
I'd like the back-up name to be the table's name, then a space, and the date and timestamp.
The following syntax isn't working though. Can anyone advise how it should be done instead?
/* Re-name the Current Table as a Back Up */
// Connect to Database
@ include($_SERVER['DOCUMENT_ROOT'] . '/protected/table-info.php');
@ mysql_select_db($db_Database) or die("Server too busy. Please try again later.");
// Re-name Table
$backup_name = 'yellow_categories ' . date('Y-m-d') . '_' . time();
$query = "RENAME TABLE yellow_categories TO $backup_name";
// Dis-connect from Database