Shell script fails to create a mysql backupHow do you change the default shell for ALL USERS to bash?How to...
Why do the i8080 I/O instructions take a byte-sized operand to determine the port?
Was this scene in S8E06 added because of fan reactions to S8E04?
How to teach an undergraduate course without having taken that course formally before?
One word for 'the thing that attracts me'?
Why do testers need root cause analysis?
Are cells guaranteed to get at least one mitochondrion when they divide?
Cisco 3750X Power Cable
How did the Allies achieve air superiority on Sicily?
Visual Block Mode edit with sequential number
How to deceive the MC
Are there guidelines for finding good names for LaTeX 2e packages and control sequences defined in these packages?
Reduce size of sum sub/superscript?
Moons and messages
Count all vowels in string
Why is std::ssize() introduced in C++20?
Is this homebrew "Cactus Grenade" cantrip balanced?
Is there an idiom that means that you are in a very strong negotiation position in a negotiation?
Possibility of faking someone's public key
Why is unzipped directory exactly 4.0K (much smaller than zipped file)?
Why does FOO=bar; export the variable into my environment
"Official wife" or "Formal wife"?
Testing using real data of the customer
Local variables in DynamicModule affected by outside evaluation
Is superuser the same as root?
Shell script fails to create a mysql backup
How do you change the default shell for ALL USERS to bash?How to take daily backup of database?What is the best way to use the mysql charm in Juju with dynamic database credientials?grant command syntax error near password in shell scriptHow can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?Terminal crashes when running lsblk -hDelete oldest file in a directory, when there are more than 7 files?Php script does not connect to MySQL (Vagrant VM)Unable to insert in table in database in mysql using phpHow do I start and stop a systemctl service inside a bash script?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I want to create a shell script to automatically backup MySQL DB. I will later copy it to an s3 bucket.
I have created the following shell script:
#vim /home/ubuntu/backup/mysqlbackup.sh
#!/bin/bash
## Specify the name of the database that you want to backupbackup
# Database credentials
USER="user1"
PASSWORD="password"
HOST="hostname.compute.amazonaws.com"
DB_NAME="db1"
#Backup_Directory_Locations
BACKUPROOT="/home/ubuntu/backup"
TSTAMP=$(date +"%d-%b-%Y-%H-%M-%S")
S3BUCKET="s3://s3bucket"
#LOG_FILE="/home/ubuntu/backup/log/dump.log"
mysqldump -h <HOST> -u <USER> --database <DB_NAME> -p"$PASSWORD" > $BACKUPROOT/$DB_NAME-$TSTAMP.sql
Then from the command line, I run the script:
sudo bash -x ./mysqlbackup.sh
And it fails, telling me:
HOST: No such file or directory
command-line bash mysql
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I want to create a shell script to automatically backup MySQL DB. I will later copy it to an s3 bucket.
I have created the following shell script:
#vim /home/ubuntu/backup/mysqlbackup.sh
#!/bin/bash
## Specify the name of the database that you want to backupbackup
# Database credentials
USER="user1"
PASSWORD="password"
HOST="hostname.compute.amazonaws.com"
DB_NAME="db1"
#Backup_Directory_Locations
BACKUPROOT="/home/ubuntu/backup"
TSTAMP=$(date +"%d-%b-%Y-%H-%M-%S")
S3BUCKET="s3://s3bucket"
#LOG_FILE="/home/ubuntu/backup/log/dump.log"
mysqldump -h <HOST> -u <USER> --database <DB_NAME> -p"$PASSWORD" > $BACKUPROOT/$DB_NAME-$TSTAMP.sql
Then from the command line, I run the script:
sudo bash -x ./mysqlbackup.sh
And it fails, telling me:
HOST: No such file or directory
command-line bash mysql
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I want to create a shell script to automatically backup MySQL DB. I will later copy it to an s3 bucket.
I have created the following shell script:
#vim /home/ubuntu/backup/mysqlbackup.sh
#!/bin/bash
## Specify the name of the database that you want to backupbackup
# Database credentials
USER="user1"
PASSWORD="password"
HOST="hostname.compute.amazonaws.com"
DB_NAME="db1"
#Backup_Directory_Locations
BACKUPROOT="/home/ubuntu/backup"
TSTAMP=$(date +"%d-%b-%Y-%H-%M-%S")
S3BUCKET="s3://s3bucket"
#LOG_FILE="/home/ubuntu/backup/log/dump.log"
mysqldump -h <HOST> -u <USER> --database <DB_NAME> -p"$PASSWORD" > $BACKUPROOT/$DB_NAME-$TSTAMP.sql
Then from the command line, I run the script:
sudo bash -x ./mysqlbackup.sh
And it fails, telling me:
HOST: No such file or directory
command-line bash mysql
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want to create a shell script to automatically backup MySQL DB. I will later copy it to an s3 bucket.
I have created the following shell script:
#vim /home/ubuntu/backup/mysqlbackup.sh
#!/bin/bash
## Specify the name of the database that you want to backupbackup
# Database credentials
USER="user1"
PASSWORD="password"
HOST="hostname.compute.amazonaws.com"
DB_NAME="db1"
#Backup_Directory_Locations
BACKUPROOT="/home/ubuntu/backup"
TSTAMP=$(date +"%d-%b-%Y-%H-%M-%S")
S3BUCKET="s3://s3bucket"
#LOG_FILE="/home/ubuntu/backup/log/dump.log"
mysqldump -h <HOST> -u <USER> --database <DB_NAME> -p"$PASSWORD" > $BACKUPROOT/$DB_NAME-$TSTAMP.sql
Then from the command line, I run the script:
sudo bash -x ./mysqlbackup.sh
And it fails, telling me:
HOST: No such file or directory
command-line bash mysql
command-line bash mysql
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
asked 5 hours ago
Hooman BahreiniHooman Bahreini
1496
1496
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Hooman Bahreini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
<HOST>. <DB_NAME> etc, are just placeholders.
They should be replaced by actual strings or shell variable expansions "$HOST", "$DB_NAME" and so on - just as you have done with -p"$PASSWORD"
The error message is because < and > are redirection operators.
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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
});
}
});
Hooman Bahreini is a new contributor. Be nice, and check out our Code of Conduct.
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%2faskubuntu.com%2fquestions%2f1144917%2fshell-script-fails-to-create-a-mysql-backup%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
<HOST>. <DB_NAME> etc, are just placeholders.
They should be replaced by actual strings or shell variable expansions "$HOST", "$DB_NAME" and so on - just as you have done with -p"$PASSWORD"
The error message is because < and > are redirection operators.
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
add a comment |
<HOST>. <DB_NAME> etc, are just placeholders.
They should be replaced by actual strings or shell variable expansions "$HOST", "$DB_NAME" and so on - just as you have done with -p"$PASSWORD"
The error message is because < and > are redirection operators.
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
add a comment |
<HOST>. <DB_NAME> etc, are just placeholders.
They should be replaced by actual strings or shell variable expansions "$HOST", "$DB_NAME" and so on - just as you have done with -p"$PASSWORD"
The error message is because < and > are redirection operators.
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
<HOST>. <DB_NAME> etc, are just placeholders.
They should be replaced by actual strings or shell variable expansions "$HOST", "$DB_NAME" and so on - just as you have done with -p"$PASSWORD"
The error message is because < and > are redirection operators.
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
answered 5 hours ago
steeldriversteeldriver
72.8k11118192
72.8k11118192
add a comment |
add a comment |
Hooman Bahreini is a new contributor. Be nice, and check out our Code of Conduct.
Hooman Bahreini is a new contributor. Be nice, and check out our Code of Conduct.
Hooman Bahreini is a new contributor. Be nice, and check out our Code of Conduct.
Hooman Bahreini is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Ask Ubuntu!
- 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.
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%2faskubuntu.com%2fquestions%2f1144917%2fshell-script-fails-to-create-a-mysql-backup%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
