Etydhv

Quantum corrections to geometry

Flatten not working

Can a multiclassed Kensei monk/Swashbuckler rogue use an offhand finesse weapon to trigger Sneak Attack, without using a bonus action?

Is there an idiom that means that you are in a very strong negotiation position in a negotiation?

Why'd a rational buyer offer to buy with no conditions precedent?

Why does the hash of infinity have the digits of π?

Can flying creatures choose to hover, even if they don't have hover in their flying speed?

Python program for fibonacci sequence using a recursive function

Writing "hahaha" versus describing the laugh

Dad jokes are fun

Did Game of Thrones end the way that George RR Martin intended?

Why is 'additive' EQ more difficult to use than 'subtractive'?

relative price of a transistor and a capacitor

Are there historical examples of audiences drawn to a work that was "so bad it's good"?

Visual Block Mode edit with sequential number

How can I minimize the damage of an unstable nuclear reactor to the surrounding area?

Ribbon Cable Cross Talk - Is there a fix after the fact?

Is superuser the same as root?

Why did it take so long for Germany to allow electric scooters / e-rollers on the roads?

Is "vegetable base" a common term in English?

How does the Earth's center produce heat?

3 prong range outlet

What is to the west of Westeros?

Are cells guaranteed to get at least one mitochondrion when they divide?

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;

2

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

share|improve this question

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 | 

2

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

share|improve this question

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

share|improve this question

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.

#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

sudo bash -x ./mysqlbackup.sh

share|improve this question

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.

share|improve this question

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

1 Answer
1

active

oldest

votes

5

<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.

share|improve this answer

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.

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

Name

Email

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

Name

Email

Required, but never shown

5

<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.

share|improve this answer

answered 4 hours ago

steeldriversteeldriver

72.8k11118192

add a comment | 

5

<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.

share|improve this answer

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.

share|improve this answer

answered 4 hours ago

steeldriversteeldriver

72.8k11118192

share|improve this answer

answered 4 hours ago

steeldriversteeldriver

72.8k11118192

answered 4 hours ago

steeldriversteeldriver

72.8k11118192

answered 4 hours ago

steeldriversteeldriver

72.8k11118192