Tag Archive: mysqldump
SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP
If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases.
|
1 2 |
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">USER</span> <span class="hljs-string">'backupuser'</span>@<span class="hljs-string">'localhost'</span> <span class="hljs-keyword">IDENTIFIED</span> <span class="hljs-keyword">BY</span> <span class="hljs-string">'xxx'</span>; |
|
1 2 3 |
<span class="hljs-keyword">GRANT</span> <span class="hljs-keyword">SELECT</span>, <span class="hljs-keyword">SHOW</span> <span class="hljs-keyword">VIEW</span>, <span class="hljs-keyword">LOCK</span> <span class="hljs-keyword">TABLES</span>, RELOAD, <span class="hljs-keyword">REPLICATION</span> <span class="hljs-keyword">CLIENT</span> <span class="hljs-keyword">ON</span> *.* <span class="hljs-keyword">TO</span> <span class="hljs-string">'backupuser'</span>@<span class="hljs-string">'localhost'</span>; |
|
1 |
<span class="hljs-keyword">FLUSH</span> <span class="hljs-keyword">PRIVILEGES</span>; |
Then use this bash script. You […]
read more
How to setup GoDaddy Cron Jobs
If you have a shared hosting account and need to create a Cron Job then follow these simple steps. Cron jobs are scheduled tasks that allow you to run a script in the background at a set frequency. HOW TO SETUP GODADDY CRON JOBS INSTRUCTIONS Login to your Godaddy Account Click on Cron Job Manager […]
read more