Shell script to create a new SQL dump

Question

I am currently using MAMP pro and i want to create a simple terminal script (or a .bat file like on the PC) which allows me to create a sql dump (where i go in and preconfigure the database name) and it automatically creates me the .sql file.

This is what i know so far:

1: The script should first visit cd /applications/MAMP/library/bin

2: When it in that directory, it should run the following

./mysqldump -u root -p databaseName > /Applications/MAMP/htdocs/website/db.sql

Finally, in that directory, when i click the script, it should not replace the older file, but create a new one, maybe just add the date or a integer after it.

Is that possible?

Apologies, i have no idea the best way of doing this.

Thanks in advance.

konsolebox · Accepted Answer · 2014-07-15 16:17:12Z

2

You can have this:

#!/bin/sh
TS=$(exec date '+%s')
cd /applications/MAMP/library/bin && \
    ./mysqldump -u root -p databaseName > "/Applications/MAMP/htdocs/website/db.$TS.sql"

It would create files in the form of db.(timestamp).sql.

If you want to have other forms, just changhe the date command. '+%s' specifies the format to produce which is the timestamp. You can see other formats with date --help or man date.

answered Jul 15, 2014 at 16:17

konsolebox

76.3k13 gold badges110 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sylvain Leroux Over a year ago

What's the advantage of $(exec date...) instead of $(date ...) ?

konsolebox Over a year ago

Just optional to prevent extra forking. Without exec the shell makes a process tree of shell->subshell->date while with exec it just becomes shell->date.

Sylvain Leroux Over a year ago

Thank you for your explanations! Isn't it a bash construct -- or is it available on plain old sh?

Sylvain Leroux · Accepted Answer · 2014-07-15 16:21:30Z

1

Just a variation on the other answer (vote for it!). You don't have to change directory to execute mysqldump :

#!/bin/bash
TS=$(exec date '+%s')
/applications/MAMP/library/bin/mysqldump -u root -p databaseName \
                  > "/Applications/MAMP/htdocs/website/db.$TS.sql"

Please beware that you have both /Application and /application directories. Depending your FS case sensitivity this might be an error.

answered Jul 15, 2014 at 16:21

Sylvain Leroux

52.3k8 gold badges114 silver badges136 bronze badges

Comments

Adriano Tadao · Accepted Answer · 2014-07-15 16:28:26Z

1

Are you using the OSx?

#!/bin/bash
cd /applications/MAMP/library/bin && mysqldump -u root -p databaseName >   /Applications/MAMP/htdocs/website/db.sql

After this, you'll need set the permission to your script:

chmod +x your_script_file

Now, you can call...

./your_script_file

or

sh yout_script_file

If you want to replace the old file, this command will do this, because the new file name is the same the older file name

answered Jul 15, 2014 at 16:28

Adriano Tadao

9861 gold badge11 silver badges12 bronze badges

Collectives™ on Stack Overflow

Shell script to create a new SQL dump

3 Answers 3

3 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Related