Search options

Hi TM,

I agree with you too.  Database backup file should not be tempered and to prevent that, prevent download and view is one of the ways I could do for now.

Hi APMuthu,

The codes work fine.   Thank you so much.

Dear APMuthu,

Thanks very much for the codes and Wiki'ed it.

I have added the codes provided and test run it, the few excluded tables still exist in the backup .sql file (please see the appended codes).  I inspected the few variables and arrays and I couldn't spot the issue.  I need your advise on this....

Another potential issue which is related to the restoration of this modified backup file.  As stated in the Wiki, the restore functions will first drop all the tables before being recreated and populated.

Wiki: "On restoration, these tables will first be dropped before being recreated and populated."

If the tables are excluded, unless the backup .sql totally ignore these excluded tables and they are not dropped during restoration.  (I hope this is the case).  Otherwise the Restoration of these excluded tables will be "emptied" and it will make the FA not functioning as the data are missing (for example, the users will not be able to login since the user table is empty).   

I'm sorry I could not contribute to the coding but I could only share my thoughts with regards to this issue.  Your help is very much appreciated.

Thank you!

KH

=====================
   $res = db_query("show table status");
    $all_tables = array();
    while($row = db_fetch($res))
    {
        if (($conn["tbpref"] == "" && !preg_match('/[0-9]+_/', $row['Name'])) ||
            ($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) === 0))
            $all_tables[] = $row;
    }
   
//Skip tables during backup:  The codes below skipped the few tables that may cause security issues such as '0_users', 'seicurity_roles' etc.

$skip_tables_list = Array('users', 'security_roles', 'sql_trail');

    foreach ($skip_tables_list as $skip_table_name) {
        if (($key = array_search($conn["tbpref"].$skip_table_name, $all_tables)) !== false) {
            unset($all_tables[$key]);
        }
    }
// End Skip Files during backup   
   
        // get table structures
    foreach ($all_tables as $table)
    {
        $res1 = db_query("SHOW CREATE TABLE `" . $table['Name'] . "`");
        $tmp = db_fetch($res1);
        $table_sql[$table['Name']] = $tmp["Create Table"];
    }
===========================

Thanks apmuthu.  I actually have the role permission of Admin and has checked all the items and I login to admin.  The issue is I did not see an item of OScommerce  for me to check.

Any further advise you could provide?  Thanks again.

Best regards
KH