how to make the automatic backup?

[supliang]

Each day , I have to backup step by step manually.

I need the automatic backup?

what configures are for that?

[programmerq]

Bluehost's cPanel doesn't have an automatic backup.

What I do instead is run a cron job on my local (home) computer (I run linux) that rsyncs everything in my account.

A simple rsync command that could do the trick:


rsync -a username@example.com:/home/username/ /backups/bluehost/

You'll need SSH at Bluehost, and have passwordless (public/private key) logins set up to be able to do this type of backup.

I've never been able to find a Windows rsync gui that could make backups of remote sites to the local disk.

You can run rsync on mac, windows, and linux. It takes a bit more doing to get working on windows.

There are plenty of detailed tutorials out there that show how to make backups with rsync.

[felgall]

I have a cron job setup on my hosting that creates a backup copy of the databases and then emails that to me - so when I next access my emails the backup gets moved from the server to my computer.

[EricJ]

I have a cron job setup on my hosting that creates a backup copy of the databases and then emails that to me - so when I next access my emails the backup gets moved from the server to my computer.

Same here :)..

Here is the syntax I use:

mysqldump -ce --user=<username>_<mysqluser> --password=<the_mysqluser's_password> <username>_<dbname> | mail <addy_i_only_use_for_backups>@mydomain.org


Without the <>'s of course.

[Rocini]

Hi all....

I´m with a single problem...
One o my databases (MYSQL) have been backed-up with a cron command until last 2 years, I think.
Well, last day I created a view in one of them, and an error on cron was generated via e-mail to me.

This is the command:

mysqldump --user=XXmy-userXX --password=XXmy-passXX --opt XXMY-DBXX > /home/XXdirXX/file.sql

Here is the error:

mysqldump: Couldn't execute 'show create table `w_titulos_valores`': SHOW VIEW command denied to user 'XXmy-userXX'@'localhost' for table 'w_titulos_valores' (1142)

In time: the user have all privileges possible in the CPanel, for database users.


Investigating, I tried to run this command in the ssh, to see more details, and
saw one thing.....

I can´t grant the privilege SHOW VIEW in my databases to any user.

This instigating me.... why have a database if I can´t use views on it?


Can anyone help?


Tks!

[farcaster]

Have you tried using the phpMyAdmin in the cPanel?

[Rocini]

Yes, I did it.... When I try to export the entire database using phpmyadmin, nothing happens.....

When I try to backup the database in the CPanel backup function , evety thing work right, all my tables and the views are in the backup....

Well, as I said.... I think this is a database privilege mismatch....

[Rocini]

Well, guys, I still here looking for some light....:(

After a ticket request, I was informed the permissions are already on the CPanel. Well, the SHOW VIEW doesn´t there.

Tks for attention.... and waiting....