MySQL

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...


MySQL Storage Engines – an overview, their limitations and an attempt for comparison

Tags: comparison of storage enginesinnodbinnodb or myisammyisamMySQLstorage engines

Published on : August 31, 2010 by

MySQL Storage Engines – an overview, their limitations and an attempt for comparison

MySQL is a database management system. Most of us are using MySQL database and majority don’t know how to choose the data base engines, what are the different types of storage engines available in mysql and how they differ from each other. In this article let me give you a brief idea about the Storage […]

Continue Reading...


Let's Connect

Categories

Your Cart

Cart is empty.

Subtotal
₹0.00
APPLY
0
Send this to a friend