Restoring a mysqldump
Posted: Thu Mar 31, 2005 8:05 am
I'm using the following code to backup my db: (works fine)
I'm not trying to restore the db using: (not working properly)
Code: Select all
$_dir = dirname($_SERVER['DOCUMENT_ROOT']).'/dbbkup/';
exec('mysqldump --add-drop-table --all --complete-insert -h localhost -u USER_NAME -pPASSWORD DATABASE_NAME > ' . $_dir . date('Y_m_d_His').'.sql');I'm not trying to restore the db using: (not working properly)
Code: Select all
$fileName = '2005_03_30_135901.sql';
$fileName = dirname($_SERVER['DOCUMENT_ROOT']) . '/dbbkup/'.$fileName;
if(is_file($fileName))/* validate correct file */
echo 'is a file<BR>'.$fileName;
else
echo 'is not a file<BR>'.$fileName;
exec('mysql -h localhost -u USER_NAME -pPASSWORD -D DATABASE_NAME < ' . $fileName);