mysqldump

Simple backup script for remotely backing up databases

Tags: backupbackupscPanelcpanel mysql backupdatabaseMySQLmysqldumpremoteremote mysql backupscript

Published on : May 25, 2011 by

Simple backup script for remotely backing up databases

This database backup script is actually a small modification of another backup script available in Google. I am not able to get that URL to mark/link reference. The only modification I added is a four liner to remove a week old backup automatically. You may also see https://www.supportsages.com/2011/05/applying-wildcards-in-grant-option-of-mysql/ as well. Indenting in python is lost, […]

Continue Reading...


Applying wildcards in GRANT option of MySQL

Tags: backupscPanelcPanel server backupdatabaseMySQLmysqldump

Published on : by

Applying wildcards in GRANT option of MySQL

In MySQL server support, We had this particular requirement of creating a database user to be used to backup only the cPanel databases. Only recently the database mapping has been introduced by cPanel which allows the clients to create databases without the _ . However on all our client servers, we insist to have the […]

Continue Reading...


MySQL for Beginners

Tags: cPaneldatabaseMySQLmysqldumpphpmyadminrepairWHM

Published on : February 4, 2011 by

MySQL for Beginners

In this post, I’ll explain some MySQL basics that would be very useful for beginners Reset MySQL root password Log in as Root and Stop the MySQL daemon. Then Start the MySQL daemon and skip the grant tables which store the passwords. Now you should be able to connect to mysql without a password. If […]

Continue Reading...


Let's Connect

Get new updates

Categories

$0.000 items