Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@diversen
Last active April 4, 2022 12:42
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save diversen/507c89cc19601aa5df996d32122c3685 to your computer and use it in GitHub Desktop.
Save diversen/507c89cc19601aa5df996d32122c3685 to your computer and use it in GitHub Desktop.
Wordpress backup if you don't have SSH access but you can use mysqldump and tar
<?php
// Read database configuration
include_once "wp-config.php";
// Default database
// $database = $databases['default']['default'];
$database['host'] = DB_HOST;
$database['user'] = DB_USER;
$database['pass'] = DB_PASSWORD;
$database['name'] = DB_NAME;
$backup_name = uniqid();
// SQL dump
$mysql_dump_command = "mysqldump -p$database[pass] --user=$database[user] --host=$database[host] --add-drop-table $database[name] > ./$backup_name-backup.sql";
exec($mysql_dump_command, $output, $ret_var);
if ($ret_var == 0) {
echo "Database dump created successfully as $backup_name-backup.sql<br />";
}
// Source copy
$path = getcwd();
$tar_create = "tar --exclude=$backup_name-backup.tar.gz --exclude=wp-content/uploads/* -czvf ./$backup_name-backup.tar.gz . ";
exec($tar_create, $output, $ret_var);
if($ret_var == 0 || $ret_var == 1) {
echo "File backup created successfully as $backup_name-backup.tar.gz <br />";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment