Is it possible to get the DB user name, DB name, and password into one line. Its funny because all of the documentation that I see the -p is for password but everyone uses it for the DB name. Im confused? I can do manuall DBdumps via SSH but Im trying to set up a CRON job and it keeps getting hung up on the password part of the line Im giving it to run. Heres a example of what Im trying.
mysqldump --opt -Q -u myusername -p myforumdatabase mypassword> /my/file.sql
Can anyone give me the correct type to insert for a no password asking mysqldump? If I can get that working via SSH then I think I can make it work in my CRON tab manager.
Regards,
mysqldump --opt -Q -u myusername -p myforumdatabase mypassword> /my/file.sql
Can anyone give me the correct type to insert for a no password asking mysqldump? If I can get that working via SSH then I think I can make it work in my CRON tab manager.
Regards,
Comment