2008-03-10, 06:11 AM
2008-03-23, 10:32 AM
Sorry I didn't answer sooner, I can't believe I forgot to put that in the tutorial... you have to change the permissions for the folder you are saving the backup and make it writable. CHMOD it to 777.
Also, you do not use quotes in the file. Your first example is correct.
Also, you do not use quotes in the file. Your first example is correct.
2008-03-23, 12:28 PM
Its a good tut but it's not explained very well for those newbies
2008-03-23, 03:18 PM
Hmmm...I could have sworn I tried changing the chmod, but I'll do it again just to make sure.
edit: OK, that worked...but one thing I did a bit different, since not everyone has access to anything below the root directory. I just chmoded the directory to 733, where it could be written and executed but not read by the public...and the backup went through just fine. Thanks for the tutorial and help.
edit: OK, that worked...but one thing I did a bit different, since not everyone has access to anything below the root directory. I just chmoded the directory to 733, where it could be written and executed but not read by the public...and the backup went through just fine. Thanks for the tutorial and help.
2008-03-23, 08:08 PM
Jag100 Wrote:Its a good tut but it's not explained very well for those newbiesI tried my best at this as I went through it myself and documented everything I did, I need to work on adding the "common sense" steps though.
judel Wrote:Hmmm...I could have sworn I tried changing the chmod, but I'll do it again just to make sure.Sorry about that, like I said I haven't used a web host with anything other than cPanel in years so I'm basing it on what I know.
edit: OK, that worked...but one thing I did a bit different, since not everyone has access to anything below the root directory. I just chmoded the directory to 733, where it could be written and executed but not read by the public...and the backup went through just fine. Thanks for the tutorial and help.
2008-03-24, 02:05 AM
Hey! I have common sense, and I know my way around a computer...but if you write step by step instructions, you cannot leave anything out. LOL...I've never dealt with cron jobs before, so I needed to be spoon fed. And if I needed that, you can bet others will too! But like I said, it finally worked and I appreciate the help!
2008-03-24, 03:11 AM
I didn't mean any disrespect, I had the quotes around common sense because it was common sense to me but I should have taken into account that this tutorial wasn't for me. This tutorial was written for newbs, by a newb.
2008-03-24, 03:13 PM
Well, this is one newb that is glad you created this thread. LOL...I can now rest easy in case some stupid hacker finds my forum, since I have a backup running every 12 hours.
2008-03-26, 05:55 PM
Well, darn! I spoke too soon. After upgrading my mysql server from 4.0 to 4.1, I can no longer do the backup through a cron job. I keep getting the following error.
/usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found
(Errcode: 2)
/usr/bin/mysqldump: Character set '#33' is not a compiled character set
and is not specified in the '/usr/share/mysql/charsets/Index' file
/usr/bin/mysqldump: Got error: 1251: Client does not support
authentication protocol requested by server; consider upgrading MySQL client when
trying to connect
I've searched google and found it all over the place but could find no solution, other than a lot of people get this error with 4.1 but not 4.0. Has anyone who is using 4.1 been able to do the mysqldump?
/usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found
(Errcode: 2)
/usr/bin/mysqldump: Character set '#33' is not a compiled character set
and is not specified in the '/usr/share/mysql/charsets/Index' file
/usr/bin/mysqldump: Got error: 1251: Client does not support
authentication protocol requested by server; consider upgrading MySQL client when
trying to connect
I've searched google and found it all over the place but could find no solution, other than a lot of people get this error with 4.1 but not 4.0. Has anyone who is using 4.1 been able to do the mysqldump?