Pastikan Anda memiliki akses dan kelengkapan berikut sebelum memulai proses instalasi:
Fase ini bertujuan mendapatkan kredensial otorisasi (credentials.json) agar skrip PHP diizinkan mengunggah file ke Google Drive.
credentials.json, dan simpan di komputer Anda..../folders/1A2b3C4d5E6f7G8h9I0jK-LmNoPqRsTuV).public_html agar tidak dapat diakses langsung oleh publik.
/home/username/).scripts/db_backup/.credentials.json.cd ~/scripts/db_backup
composer require google/apiclient:^2.15
Buat file backup.php di dalam folder scripts/db_backup/ dan tempelkan kode php di bawah ini. Sesuaikan bagian KONFIGURASI.
<?php
if (php_sapi_name() !== 'cli') {
http_response_code(403);
die("Error: Skrip ini hanya dapat dijalankan melalui Terminal.");
}
require __DIR__ . '/vendor/autoload.php';
// 1. KONFIGURASI DATABASE & GOOGLE DRIVE
$dbHost = 'localhost';
$dbUser = 'username_db_anda';
$dbPass = 'password_db_anda';
$dbName = 'nama_db_anda';
// ID Folder dari URL Google Drive Anda
$driveFolderId = 'MASUKKAN_ID_FOLDER_DRIVE_ANDA_DISINI';
// 2. PROSES BACKUP LOKAL (mysqldump)
$date = date('Y-m-d_H-i-s');
$backupFile = __DIR__ . "/backup_{$dbName}_{$date}.sql";
echo "Mengeksekusi mysqldump...\n";
putenv("MYSQL_PWD=" . $dbPass);
$command = sprintf(
'mysqldump --opt -h %s -u %s %s > %s 2>&1',
escapeshellarg($dbHost),
escapeshellarg($dbUser),
escapeshellarg($dbName),
escapeshellarg($backupFile)
);
exec($command, $output, $resultCode);
putenv("MYSQL_PWD=");
if ($resultCode !== 0) {
die("Gagal melakukan backup. Error: " . implode("\n", $output));
}
// 3. AUTENTIKASI GOOGLE DRIVE API
$client = new Google\Client();
$client->setApplicationName('Backup DB cPanel');
$client->setScopes(Google\Service\Drive::DRIVE_FILE);
$client->setAuthConfig(__DIR__ . '/credentials.json');
$client->setAccessType('offline');
$client->setPrompt('select_account consent');
$tokenPath = __DIR__ . '/token.json';
if (file_exists($tokenPath)) {
$accessToken = json_decode(file_get_contents($tokenPath), true);
$client->setAccessToken($accessToken);
}
if ($client->isAccessTokenExpired()) {
if ($client->getRefreshToken()) {
$client->fetchAccessTokenWithRefreshToken($client->getRefreshToken());
} else {
$authUrl = $client->createAuthUrl();
printf("\n!!! BUKA URL BERIKUT DI BROWSER !!!\n%s\n", $authUrl);
print "\nMasukkan Authorization Code: ";
$authCode = trim(fgets(STDIN));
$accessToken = $client->fetchAccessTokenWithAuthCode($authCode);
$client->setAccessToken($accessToken);
}
file_put_contents($tokenPath, json_encode($client->getAccessToken()));
}
// 4. PROSES UNGGAH KE GOOGLE DRIVE
$service = new Google\Service\Drive($client);
$fileMetadata = new Google\Service\Drive\DriveFile([
'name' => basename($backupFile),
'parents' => [$driveFolderId]
]);
$content = file_get_contents($backupFile);
$file = $service->files->create($fileMetadata, [
'data' => $content,
'mimeType' => 'application/sql',
'uploadType' => 'multipart'
]);
echo "File terunggah. ID: " . $file->id . "\n";
// 5. CLEANUP FILE LOKAL
if (file_exists($backupFile)) {
unlink($backupFile);
}
echo "Selesai.\n";
token.json.
php /home/username/scripts/db_backup/backup.phptoken.json.0, Hour: 0, Day: *, Month: *, Weekday: *
/usr/local/bin/php /home/username/scripts/db_backup/backup.php >/dev/null 2>&1
Penambahan >/dev/null 2>&1 digunakan agar cPanel tidak mengirimkan email notifikasi terminal setiap kali cronjob berhasil dijalankan.