Automated SQL Backups using only FTP and HTTP
0
There are several hosting services hosting several websites with several frameworks (Wordpress, Joomla, ...).
Since I have neither SSH nor any backend access, I have a weekly schedule of
- uploading PhpMyAdmin using FTP
- Surfing to PhpMyAdmin
- Login (using the same credentials as the installed Framework)
- Download/Export Database
- remove PhpMyAdmin using FTP
I would like to partly automate this, I've already automated the FTP Upload/Download, but maybe there is a simpler "SQL Dumper" script thats more straight forward and easier to automate?
backup ftp mysql automation
asked Feb 10 at 17:06
xavorxavor
1
add a comment |
0
There are several hosting services hosting several websites with several frameworks (Wordpress, Joomla, ...).
Since I have neither SSH nor any backend access, I have a weekly schedule of
- uploading PhpMyAdmin using FTP
- Surfing to PhpMyAdmin
- Login (using the same credentials as the installed Framework)
- Download/Export Database
- remove PhpMyAdmin using FTP
I would like to partly automate this, I've already automated the FTP Upload/Download, but maybe there is a simpler "SQL Dumper" script thats more straight forward and easier to automate?
backup ftp mysql automation
asked Feb 10 at 17:06
xavorxavor
1
1
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);
– Dave
Feb 11 at 12:56
The$bu_Filevariable has the full path to where the backup file is stored and it is of course within the protected directory.$bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).
– Dave
Feb 11 at 12:57
add a comment |
0
0
0
There are several hosting services hosting several websites with several frameworks (Wordpress, Joomla, ...).
Since I have neither SSH nor any backend access, I have a weekly schedule of
- uploading PhpMyAdmin using FTP
- Surfing to PhpMyAdmin
- Login (using the same credentials as the installed Framework)
- Download/Export Database
- remove PhpMyAdmin using FTP
I would like to partly automate this, I've already automated the FTP Upload/Download, but maybe there is a simpler "SQL Dumper" script thats more straight forward and easier to automate?
backup ftp mysql automation
asked Feb 10 at 17:06
xavorxavor
1
There are several hosting services hosting several websites with several frameworks (Wordpress, Joomla, ...).
Since I have neither SSH nor any backend access, I have a weekly schedule of
- uploading PhpMyAdmin using FTP
- Surfing to PhpMyAdmin
- Login (using the same credentials as the installed Framework)
- Download/Export Database
- remove PhpMyAdmin using FTP
I would like to partly automate this, I've already automated the FTP Upload/Download, but maybe there is a simpler "SQL Dumper" script thats more straight forward and easier to automate?
backup ftp mysql automation
backup ftp mysql automation
asked Feb 10 at 17:06
xavorxavor
1
asked Feb 10 at 17:06
xavorxavor
1
asked Feb 10 at 17:06
xavorxavor
1
asked Feb 10 at 17:06
xavorxavor
1
asked Feb 10 at 17:06
xavorxavor
1
1
1
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);
– Dave
Feb 11 at 12:56
The$bu_Filevariable has the full path to where the backup file is stored and it is of course within the protected directory.$bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).
– Dave
Feb 11 at 12:57
add a comment |
1
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);
– Dave
Feb 11 at 12:56
The$bu_Filevariable has the full path to where the backup file is stored and it is of course within the protected directory.$bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).
– Dave
Feb 11 at 12:57
1
1
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:
$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);– Dave
Feb 11 at 12:56
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:
$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);– Dave
Feb 11 at 12:56
The
$bu_File variable has the full path to where the backup file is stored and it is of course within the protected directory. $bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).– Dave
Feb 11 at 12:57
The
$bu_File variable has the full path to where the backup file is stored and it is of course within the protected directory. $bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).– Dave
Feb 11 at 12:57
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1404187%2fautomated-sql-backups-using-only-ftp-and-http%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1404187%2fautomated-sql-backups-using-only-ftp-and-http%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Write a script to query the data you need. Make it password protected so you don't have to delete it. Call it whenever you want to create a backup, save the result. Done.
– RalfFriedl
Feb 10 at 17:30
If you are able to set up a cron job and call mysqldump from PHP it's pretty easy to set up a scheduled dump of a database and, optionally, mail it to yourself or simply leave it available on your site should you need it. As RalfFriedl said, you'll want to put the code and dump files in a password protected directory so they aren't visible to anyone but you. FWIW the 2 working lines I use in PHP to do dumps are:
$cmdline = "/usr/bin/mysqldump --host=$hn --user $un -p$pw --databases $db --skip-extended-insert --quick --result-file=$bu_File"; exec($cmdline);– Dave
Feb 11 at 12:56
The
$bu_Filevariable has the full path to where the backup file is stored and it is of course within the protected directory.$bu_File = '/home/virtualh/public_html/Private/DB-Backups/' . date("Ymd") . "-" . $db . ".sql";. That way I can tell exactly what date the backup was made (I have other code that removes older backups keeping only 2 weeks worth on file).– Dave
Feb 11 at 12:57