MySQL Backup Script #mysql #database #backup

I have created an effective MySQL Backup Script . It will load each database into a remote server and save it in a GZ-zipped .sql file.

ICSviewer 4.5

My ical/ics calendar file viewer and exporter ICS Viewer was updated

v4.4
Bug fixes:
- Some dates from 'DTSTART;VALUE=…' were not processed correctly.

v4.5
Bug fixes:
- The app would crash when exporting a CSV into a non-writeable folder. When this happens, you'll now get an error message.

ICSviewer 4.3

My ical/ics calendar file viewer and exporter ICS Viewer was updated

v4.3
Bug fixes:
- Some .ics fies seem to lack the time behind the date. That woud crash the app. When no time is present, 12:00:00 is taken as default.

ICSviewer 4.2


My ical/ics calendar file viewer and exporter ICS Viewer was updated

v4.2
Bug fixes:
- In rare occasions empty lines are created inside a calendar file. These are now skipped.

ICSviewer 4.1


My ical/ics calendar file viewer and exporter ICS Viewer was updated

v4.1
Bug fixes:
- When the connection to MySQL fails, the error message dialog would leave the sheet window hang without any controls.

Oracle Instant Client + oci8 for PHP and Apache on macOS Mojave #oracle #oci8 #php #macos

I was totally new to using Oracle Instant Client on macOS Mojave, so I had to spend days to figure out and try out on how to get it installed (easy) and how to get the oci8 shared library installed (the hard and most time-consuming part) for use with PHP at both the CLI and in Apache. I have been on many, many websites and read many, many instructions, and I want to thank everyone who put so much effort in clarifying something that actually should be very simple nowadays. After having read and tried so many tips and tricks, I ended up summarizing what worked for me, which I wrote down on Oracle Instant Client + OCI8 on Macos Mojave for PHP .

ICSviewer 4.0


My ical/ics calendar file viewer ICS Viewer is updated to version 4.0

v4.0
Bug fixes:
- When the connection to MySQL fails, field mapping choices cannot be matched and the selected fields are invalid. But they were still visible as being matched and that was misleading.
- An empty message when no fields could be mapped at the time of a MySQL export.

ICSviewer 3.9


My ical/ics calendar file viewer ICS Viewer is updated to version 3.9

v3.9
Bug fixes:
- Fixed a possible hang when choosing a date-range.

ICSviewer 3.8


My ical/ics calendar file viewer ICS Viewer is updated to version 3.8

v3.8
Bug fixes:
- 'Last month' preference showed 12 months earlier, when in January of a new year.

ICSviewer 3.7


My ical/ics calendar file viewer ICS Viewer is updated to version 3.7

v3.7
Bug fixes:
- A hang with the new initial date-range preference setting 'Current month' has been fixed.
- The possibility to use the new initial date-range preference setting has been fixed.
- Various UI improvements in the preferences window.

ICSviewer 3.6


My ical/ics calendar file viewer ICS Viewer is updated to version 3.6

v3.6
What has changed:
- A new preference where you can set a predefined date range as startup. When you change the preference, the new date range is used immediately, so you do not have to quit & restart ICSviewer.
- When you enter a new date in 'From date' which is newer than the date in 'To date', 'To date' is automatically adjusted to the end of the month of 'From date'. And vice-versa, 'From date' is automatically changed to the first of the month of 'To date' when you pick a 'To date' which is earlier than 'From date'.
- The 'Year'-popup menu in the popup-calendar has been extended from 2039 to 2099.

ICSviewer 3.5


My ical/ics calendar file viewer ICS Viewer is updated to version 3.5

v3.5
What has changed:
- Resizing the modal sheet windows is now disabled.
- Some other UI and code improvemnts.

ICSviewer 3.3


The ical/ics calendar file viewer ICS Viewer is updated to version 3.3.

v3.3
What is new:
- New: Added Extra Database Fields to the MySQL export preferences and the MySQL export process.

What has changed:
- A bug preventing Unit to be exported to MySQL has been fixed.

ICSviewer 3.2

The ical/ics calendar file viewer ICS Viewer is updated to version 3.2.

v3.0
What is new:
- New: Added shareware serial number.
- New: Now also as a 64bit application on MacOS X and Windows.
- New: Added MySQL export for users who donated:

• A Preferences window for:
  - MySQL connection settings
  - mapping columns from the display with columns from the MySQL table
• An export button 'Export to MySQL' to export the calendar data directly into the MySQL table

What has changed:
- Handling of saving the states of the checkboxes has been fixed.
- Renamed the 'Export...' button to 'Export to CSV...'
- Default values for From date / To date are now the first / current day of the current month
- The selected sort-column is now saved.
- Long lines (description, dtstart/dtend) are now handled correctly.
- ICS file is now read once, not on every date-range change.
- Various code improvements.

v3.1
What has changed:
- Bug fix: loading another .ics file did not reset the table.

v3.2
What has changed:
- Bug fix MySQL export: concatenation-character ' | ' was added regardless.

[Repair] MySQL Upgrade on Mac OS X

Some time ago I did a MySQL upgrade without thinking ... that was not funny. So I retraced what I did to get the new version up and running and wrote it down as a sequence of steps to follow, when I need to upgrade to the next higher version.

I published these steps on the page [Repair] MySQL Upgrade (Mac OS X) , so they might be of help to you too.

ICSviewer 2.9

The ical/ics calendar file viewer ICS Viewer is updated to version 2.9.

What is new:
- New: Added an 'Export' feature, which exports to a .csv file.
- New: Added automatic save/restore of column checkboxes and decimal separator.
- New: Added column ATTENDEES.

What has changed:
- Moved LOCATION into its own column.
- No more rounding of hours. Hours are displayed with 2 decimals.
- Open and Save dialogs are now sheet windows on Mac OS X.
- When checking/unchecking columns or loading a new file, the chosen sort-column is now remembered.

ICSviewer 2.7

The ical/ics calendar file viewer ICS Viewer is updated to version 2.7.

From / To dates selection fixed.
From / To dates would take the chosen date, but with the current time as as start or endpoint.
For example: 01-01-2016 09:10:34 to 13-12-2016 09:10:34
This would cause events on 01 jan 2016 earlier than 09:10 and events on 13 dec 2016 later then 09:10 not to show up.
From / To dates now use 00:00:00 as From time and 23:59:59 as To-time.

About-window at start
The About-window will not show itself automatically anymore when opening the app.
The about window would pop-up each time you start the application until you donated; only then it would not pop-up anymore.
Since this is a bit annoying, I moved the Paypal-button to the main window. When you donate, this button wil disappear.

New version-detection
As of v2.7, the app will check for a new new version and pop-up a notification dialog with a link.

CSVviewer - Quicklook CSV files #utility #macos #linux #windows #csv #database

CSVviewer (formerly known as TABviewer) is a tool which shows the contents of text files, where data of each line is equally separated by either a semicolon, a comma or a tab-character.

You can download it here.

Mijn FileMaker Pro boekhoudsoftware geactualiseerd

Ik heb mijn FileMaker Pro 5 boekhoudprogramma's op verzoek geconverteerd naar recentere versies. U kunt de toepassingen nu downloaden voor alle versies vanaf versie 5. Voor elke compatibele versie heb ik een download-knop gemaakt, zoals in onderstaande afbeelding wordt getoond:

Quickly transfer MySQL databases to a new server

Again I needed to transfer all data from one server to another. I knew I documented the transfer of MySQL databases somewhere (it's deep inside in the Replication-how-to) and decided to post them again here, so they're quicker to find.

One can transfer MySQL databases in various ways:

1. Using mysqldump and zip + ftp
2. Zip the database itself + ftp (you might need to repair the tables after unzipping)
3. Use Navicat's Data Transfer module (not always good for tables with millions of records or blob data)

Personally, I prefer to use option 2, like below, in Terminal or an SSH session:

$ cd /var/mysql/ (or /var/lib/mysql/)
$ sudo zip -r ~/[database].zip [database]

Do this for each database that you want to copy. Then send all zip's per FTP to the new server.
Start an SSH session with the remote server and enter the following commands:

$ cd /var/mysql (or /var/lib/mysql/)
$ sudo unzip ~/[database].zip
$ sudo chown -R _mysql:admin [database]

For the above chown, check first with ls -l if _mysql:admin are the right owners. Then do this for each unzipped database.

Next, start Navicat and now you should see your databases in the connection of the new server. If not, you probably forgot to either do a Refresh Connection or the chown-command.

If you can access the tables and view data, good! If not, right click the table and choose Maintain->Repair Table->Quick or ->Extended and then try again.