Shell script fails to create a mysql backupHow 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?
Using too much dialogue?
Why was this character made Grand Maester?
Is there an idiom that means that you are in a very strong negotiation position in a negotiation?
Can a UK national work as a paid shop assistant in the USA?
Time complexity of an algorithm: Is it important to state the base of the logarithm?
Why does Bran want to find Drogon?
Why A=2 and B=1 in the call signs for Spirit and Opportunity?
Rewriting trigger for an old API version
Why'd a rational buyer offer to buy with no conditions precedent?
Is "vegetable base" a common term in English?
Why is 'additive' EQ more difficult to use than 'subtractive'?
Testing using real data of the customer
Count all vowels in string
Are there historical examples of audiences drawn to a work that was "so bad it's good"?
Are there any German nonsense poems (Jabberwocky)?
Can a multiclassed Kensei monk/Swashbuckler rogue use an offhand finesse weapon to trigger Sneak Attack, without using a bonus action?
Storing voxels for a voxel Engine in C++
How can I minimize the damage of an unstable nuclear reactor to the surrounding area?
Why do Russians almost not use verbs of possession akin to "have"?
Why does the hash of infinity have the digits of π?
I want to ask company flying me out for office tour if I can bring my fiance
What would prevent living skin from being a good conductor for magic?
Flatten not working
Gravitational Force Between Numbers
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
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 4 hours ago
Hooman BahreiniHooman Bahreini
1495
asked 4 hours ago
Hooman BahreiniHooman Bahreini
1495
1495
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 4 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 4 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 4 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 4 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 4 hours ago
steeldriversteeldriver
72.8k11118192
answered 4 hours ago
steeldriversteeldriver
72.8k11118192
answered 4 hours ago
steeldriversteeldriver
72.8k11118192
answered 4 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
