story of my life

<?php
class SqlBackup
{
    private $user = 'user';
    private $pass = 'pass';
    private $host = 'mysqlXXX.user.sakura.ne.jp';
    private $root = '/home/user/MySqlFullBackup/';//バックアップの置き場所：絶対パス
    private $dblist = [
        "wp_db",
    ];
      
    public function fullBackup(string|null $dir=null)
    {
        $dir = $dir??$this->root;

        if (!is_dir($dir)) {
            return $this;
        }

        try {
            foreach ($this->dblist as $dbname) {
                exec('mysqldump -u ' . $this->user . ' -p' . $this->pass . ' -h ' . $this->host . ' --single-transaction --no-tablespaces ' . $dbname . ' > ' . $dir . date('Y-m-d-H-i_') . $dbname . '.sql 2>/dev/null');
            }
        } catch (\Throwable $th) {
            file_put_contents('bug.txt', $th->getMessage());
        }
        return $this;
    }

    function deleteOldFiles(string|null $dir=null, int $days = 7)
    {
        $dir = $dir??$this->root;

        if (!is_dir($dir)) {
            return $this;
        }

        $deletedCount = 0;
        $limitTime = time() - ($days * 24 * 60 * 60);

        $iterator = new RecursiveIteratorIterator(
            new RecursiveDirectoryIterator(
                $dir,
                FilesystemIterator::SKIP_DOTS
            )
        );

        foreach ($iterator as $file) {
            /** @var SplFileInfo $file */
            if ($file->isFile()) {
                // ファイルの更新日時を取得
                if ($file->getMTime() < $limitTime) {
                    if (@unlink($file->getPathname())) {
                        $deletedCount++;
                    }
                }
            }
        }

        //echo $deletedCount;
        return $this;
    }
}
if ($argv[0]) {
    (new SqlBackup)->fullBackup()->deleteOldFiles();
}