MySQL backup

[riffola]

Hi,

I tried out the technique shown on this forum to backup a MySQL db via Crontab, and it didn't work.

I dont remember the exact lines I put into crontab as it was sometime back, and the relevent post on this forum is no longer available.

Any help would be appreciated.

[DCE]

It' in the FAQ
http://faq.codingclick.com/



DCE

[riffola]

Thanks

[riffola]

Well I tried it out just like it says in the FAQ, and it didn't work.

Any help would be appreciated.

[Adam]

Did you try specify the complete path to mysqldump?
/Adam

[riffola]

Yeah I used to full path, relative path, normal path, but nothing worked so I tried
mysqldump --opt --u username --pPassword table > public_html/backup.sql

the file did save, but it wasn't the SQL db, it was the mysqldump script...

Any idea what went wrong?

[Adam]

For me, this worked:
mysqldump --opt -u myuser --password=mypassword mydatabase mytable > backup.sql
The first ~25 rows of backup.sql is related to table structure, the rest is data.
What do you mean by "the mysqldump script"?
/Adam

[Son Nguyen]

Originally posted by riffola
Yeah I used to full path, relative path, normal path, but nothing worked so I tried
mysqldump --opt --u username --pPassword table > public_html/backup.sql

the file did save, but it wasn't the SQL db, it was the mysqldump script...

Any idea what went wrong?

You used the wrong syntax:
--user (NOT --u)
-pPASSWORD (not --pPASSWORD)

[riffola]

thanks for the replies, it works now. :)