Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days

Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days
In this post we will see how to make a batch file to take backup of MySQL database (single database) to a particular folder on the same computer. As you may already know, there are various variants of mysqldump command. But for this exercise we will use this command:

mysqldump --routines -u<username> -p<password> <database name> > <output sql file name>

Simple Batch File to backup MySQL Database:
Read more »

Comments

Post a Comment

Popular posts from this blog

Mi PC Suite and USB connection problems: not detected and need to update your device to use Mi PC Suite

Image
F or those using Mi phones, you might as well be using Mi PC Suite to manage your phone from a computer using a USB cable. But lately, Mi PC Suite doesn't seems to be working for most people. There are a lot of threads in the Mi Forums as well complaining about issues with Mi PC Suite. While the Mi Phone is connected to computer using USB, when Mi PC Suite is opened, we get messages like: 1) Device not detected 2) You need to update your device to use Mi PC Suite 3) Can't connect to your device. In this post, let's see the problems with Mi PC Suite and the status of this issue. If Mi PC Suite still does not work after the following troubleshooting steps, some compatible PC Suite softwares are listed at the end of this post that you can use to manage your Android Phone on computer. For this particular post, the system details of the Mi Phone, computer and Mi PC Suite are as follows. System details: Read more »
Read more

How to create the simplest guestbook on WordPress [no plugin]?

Image
Guestbooks are features that allows visitors on a website to leave messages, feedback and comments. They are not the same as comments on blog posts, which are specific to that post. Guestbook messages are generally not related to a particular content but are directed to the owner.  In this post, we will see how to create the simplest WordPress Guestbook without any plugin– the simplest, and the easiest – make it under 10 minutes! Actually, under 20 seconds!! We'll apply the same WordPress comments feature to use as a Guestbook. Any one will be able to see the messages left on the guestbook. Before we begin, I must tell you that this is not the best way to create guestbooks on websites but nonetheless, it is a working solution if you want a simple yet working solutions without having to install plugins etc. Read more »
Read more

Updating Android Froyo to Gingerbread on ZTE Blade/Dell XCD 35

Updating Android Froyo to Gingerbread on ZTE Blade/Dell XCD 35 [old post] All this time I have been contented with my Android phone running on Froyo. But suddenly decided to update my android phone OS from Froyo (Android 2.2) to GingerBread (Android 2.3). Who don’t like to upgrade right? So I was looking up on the internet for resources on how to do it. I found so many helpful resources and videos (which I will also be sharing here), but I had trouble updating; it was not a simple click-install task, and it took some time as I had to search solutions for the problems I faced. Anyways, the good things is that I learned a lot about the Android World! Here is my experience on how I finally upgraded to Gingerbread (Android 2.3).  And I’m loving it!! The process is practically the same for almost all Android Phones, I learned, just some software version differences here and there based on hardware / phone models. So read but check out for appropriate software packages for your p...
Read more