laravel 实现数据备份

laravel有时候需要快速备份表，可参考代码如下：

需要新建一个备份库

    public function backupTable($table, $backupTable = false, $connectionName = 'mysql', $backupConnection = 'mysql_backup')
    {
        $sourceConnect = DB::connection($connectionName);
        $sourceDatabaseName = $sourceConnect->getDatabaseName();
        $connection = DB::connection($backupConnection);
        $backupDatabaseName = $connection->getDatabaseName();
        try {
            $baseTable = $backupTable ? $backupTable : "backup_tb_$table" . "_" . date('YmdHis');
            $backupTable = $baseTable;
            $count = 1;
            while (Schema::connection($backupConnection)->hasTable($backupTable)) {
                $backupTable = $baseTable . '_' . ($count > 9 ? $count : '0' . $count);
                ++$count;
            }
            $sql = "CREATE TABLE `$backupDatabaseName`.`$backupTable` LIKE `$sourceDatabaseName`.`$table`";
            $connection->statement($sql);
            $sql = "INSERT INTO `$backupDatabaseName`.`$backupTable` SELECT * FROM `$sourceDatabaseName`.`$table`";
            $connection->statement($sql);
        } catch (\Exception $e) {
            throw new \Exception("全表备份数据异常：$table" . ", " . $e->getMessage() . $e->getTraceAsString(), ExceptionCode::ERROR_INTERNAL);
        }
    }

快速备份数据，代码参考如下：

    public function backupData($table, $data, $backupTable = false, $connectionName = 'mysql', $backupConnection = 'mysql_backup')
    {
        $sourceConnect = DB::connection($connectionName);
        $sourceDatabaseName = $sourceConnect->getDatabaseName();
        $connection = DB::connection($backupConnection);
        $backupDatabaseName = $connection->getDatabaseName();
        try {
            $baseTable = $backupTable ? $backupTable : "backup_dt_$table" . "_" . date('YmdHis');
            $backupTable = $baseTable;
            $count = 1;
            while (Schema::connection($backupConnection)->hasTable($backupTable)) {
                $backupTable = $baseTable . '_' . ($count > 9 ? $count : '0' . $count);
                ++$count;
            }
            $sql = "CREATE TABLE `$backupDatabaseName`.`$backupTable` LIKE `$sourceDatabaseName`.`$table`";
            $connection->statement($sql);
            if (!is_array($data)) {
                $data = $data->toArray();
            }
            $connection->table($backupTable)->insert($data);
        } catch (\Exception $e) {
            throw new \Exception("备份数据异常：$table" . ", " . $e->getMessage() . $e->getTraceAsString(), ExceptionCode::ERROR_INTERNAL);
        }
    }