« So much to do... | Main | Another Day... »

October 27, 2017

Nightly Backups

So, the nightly backup process that runs on Peenie Wallie is "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\backup.bat" and there's a shortcut to it on my desktop.

It looks like I can delete my old files of the form:

s:\pw\MySQL\backups\pw_backup_%DATEN%.sql

So i deleted them up through 10/14/2017.

Now, I see these backup files also.

s:\pw\MySQL\data\ib_logfile0_10272017
s:\pw\MySQL\data\ib_logfile1_10272017
s:\pw\MySQL\data\ib_data1_10272017

These (above) are backups of the following 3 files, which we want to keep:

s:\pw\MySQL\data\ib_logfile0
s:\pw\MySQL\data\ib_logfile1
s:\pw\MySQL\data\ib_data1

So, I think that we want to keep these 3 files(above). But there are countless backups of these files of the form::

ib_logfile0_10272017
ib_logfile1_10272017
ib_data1_10272017

So, I'm reasonably sure it's safe to get rid of these backups. So, I deleted these backups up through 10/1/2017.

Now, looking back at an earlier post:http://www.peeniewallie.com/2013/08/web-server-main.html

And, I seem to recall that I can delete the access.log and the error.log.

1. Monitor Apache Server. Start - All Programs - Apache HTTP Server 2.0 - Control Apache Server - Monitor Apache Servers. Says Apache is already running.
2. Stop Apache. Start - All Programs - Apache HTTP Server 2.0 - Control Apache Server - Stop. The apache server is stopping.
3. Rename the error.log and the access.log.
Renamed c:\Program Files (x86)\Apache Group\Apache2\logs\access.log to
access_102717.log.
Renamed c:\Program Files (x86)\Apache Group\Apache2\logs\error.log to error_102717.log.
4. Restart Apache


Posted by Rob Kiser on October 27, 2017 at 3:27 AM

Comments

Post a comment




Remember Me?

(you may use HTML tags for style)


NOTICE: IT WILL TAKE APPROX 1-2 MINS FOR YOUR COMMENT TO POST SUCCESSFULLY. YOU WILL HAVE TO REFRESH YOUR BROWSER. PLEASE DO NOT DOUBLE POST COMMENTS OR I WILL KILL YOU.