search

engineyard / ey-docs

Engine Yard Docs
http://docs.engineyard.com
28 stars 11 forks source link

Restore Mysql dump - Scenario 2 #279

Closed jnak closed 12 years ago

jnak commented 12 years ago

Hi,

A quick heads up to let you know there is little bug in the doc regarding Mysql dump loading at http://docs.engineyard.com/database-restore.html

It should be gunzip < [filename] | mysql -u [username] --password=[password] -h [database host] [app_name]

instead of gunzip < [filename] | mysql -u [username] -p [password] -h [database host] [app_name]

Hope this helps! J.

janeday commented 12 years ago

Hi J,

Thanks very much for your message. Sorry that you had problems, but thank you for letting me know.

Did you try without a space between the -p and the password? For example: -pmypassword ?

In your message, it looks like there is a space after the -p .

I'll work with one of the Engine Yard database experts to figure out the best way to fix that step.

best regards, J

jnak commented 12 years ago

If I remember well, I tried both with and without a space. Regards, J.

On Wed, Jan 25, 2012 at 1:27 PM, Jane reply@reply.github.com wrote:

Hi J,

Thanks very much for your message. Sorry that you had problems, but thank you for letting me know.

Did you try without a space between the -p and the password?   For example:  -pmypassword   ?

In your message, it looks like there is a space after the -p  .

I'll work with one of the Engine Yard database experts to figure out the best way to fix that step.

best regards, J

Reply to this email directly or view it on GitHub: https://github.com/engineyard/ey-docs/issues/279#issuecomment-3656017

janeday commented 12 years ago

Our security guy suggests that best practice is to use -p without the password and then get prompted for the password -- that way the database password doesn't get saved in the shell's history. So, I've changed the Engine Yard database docs to use that syntax and added a word of explanation on this page http://docs.engineyard.com/database-password.html My database experts swear that the -pPassword should work, so I've included both syntaxes in that explanatory paragraph. Thanks again for raising this issue and helping to make Engine Yard docs better for all. Sincerely, Jane