Mdthbs

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;
}

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

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

share|improve this question

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.

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

share|improve this question

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

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

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

share|improve this answer

answered 5 hours ago

steeldriversteeldriver

72.8k11118192

share|improve this answer

answered 5 hours ago

steeldriversteeldriver

72.8k11118192

answered 5 hours ago

steeldriversteeldriver

72.8k11118192

answered 5 hours ago

steeldriversteeldriver

72.8k11118192