Emmy

webhosting? I pay for webhosting. I've been trying to set something up to automatically back up my MySQL database regularly. Most of the solutions I've found for doing this involve using the mysqldump command in a script that I would run as a cron job. When I try to use the mysqldump command, I get the error:

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

I've googled for info on this error and found that it's probably a configuration error on the server. I called the webhosting company's tech support number and they told me I'm not allowed to use mysqldump. They guy I talked to didn't seem to know what he was talking about, and didn't seem to understand what I was trying to do. Nevertheless, the answer was that I shouldn't be trying to do this.

I'm thinking I might switch web hosts over this. I'd like to know if it's reasonable to want to use mysqldump to back up databases, or if it's typical for paid webhosting to not allow that.