« 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