mysqldump on console, how to escape password?

Posted by psynnott on Super User See other posts from Super User or by psynnott
Published on 2010-03-25T09:49:57Z Indexed on 2010/03/25 9:53 UTC
Read the original article Hit count: 588

Filed under:

mysqldump

|

password

|

escape-characters

Hello,

I am running a mysqldump via a bash script and have encountered a problem with a password that contains special characters. How do I escape the password?

mysqldump -hlocalhost -uUSERNAME -pPA$$W0RD DATABASE | gzip > /home/USERNAME/backups-mysql/BACKUP.gz

© Super User or respective owner

Related posts about mysqldump

Get to know error and error codes of Mysqldump

as seen on Server Fault - Search for 'Server Fault'
Hi I would like to back up our mysql database. We have huge records in the database. What are the errors can occur and possible while running mysqldump.? Mysql official site did not mention the specific error and error codes for mysqldump, They just commonly put the error and error codes. I am expecting… >>> More
mysqldump on console, how to escape password?

as seen on Super User - Search for 'Super User'
Hello, I am running a mysqldump via a bash script and have encountered a problem with a password that contains special characters. How do I escape the password? mysqldump -hlocalhost -uUSERNAME -pPA$$W0RD DATABASE | gzip /home/USERNAME/backups-mysql/BACKUP.gz >>> More
mysqldump table names prefix

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql databases that have almost the same structure and representing the data of the same web app but one of them represents the current version and second one was made long time ago. How can I create the database with both dumps inside but with old_ prefix for tables from the first and… >>> More
Dumping views with mysqldump in the right order.

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a script that backs up our database, which contains multiple tables and views constructed from tables. The command used is: mysqldump -u UserName -ppassword -h hostname DatabaseName dump.sql; I have noticed however that some view definitions are backed up before the definitions of the… >>> More
mysqldump from a query

as seen on Stack Overflow - Search for 'Stack Overflow'
How do we take a mysql dump from the results of a query I need something like this.. `mysqldump -uroot -pxxxx mydb "select * from table where name='1';" /tmp/a Thanks >>> More

Related posts about password

remember password is not filling the password field automatically

as seen on Stack Overflow - Search for 'Stack Overflow'
IE is not filling the password field automatically when i click on the bookmarked url. But it's working on firefix,chrome etc. I tried with autocomplete="on" but no use. IE will fill the password only When i select a usename from the possible user names which the browser had kept for each login.… >>> More
Lost shell password: change user password from root

as seen on Super User - Search for 'Super User'
Hi. I recently accidentally forgot my user password to my shell. I know the root password. How do I change the user password? I figure it's something like $su root $passwd -[something] username but I can't get it to work. Halp pls? >>> More
[GEEK SCHOOL] Network Security 1: Securing User Accounts and Passwords in Windows

as seen on How to geek - Search for 'How to geek'
This How-To Geek School class is intended for people who want to learn more about security when using Windows operating systems. You will learn many principles that will help you have a more secure computing experience and will get the chance to use all the important security tools and features that… >>> More
Membership Generate Password alphanumeric only password?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use Membership.GeneratePassword to return a password that ONLY contains alpha or numeric characters? The default method will only guarantee a minimum and not a maximum number of non alphanumeric passwords. I have the solution already but thought I'd share for future visitors. .. Answer… >>> More
Password Recovery without sending password via email

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I've been playing with asp:PasswordRecovery and discovered I really don't like it, for several reasons: 1) Alice's password can be reset even without having access to Alice's email. A security question for password resets mitigates this, but does not really satisfy me. 2) Alice's new password… >>> More