Strainu onLine

Automatic MySQL Backups

Posted by Strainu | Filed under SQL

Ever had a database crush before you made any backups? Then you now how important it is to have regular backups. But why bother doing them yourself, when you can have a script to do it for you?

automysqlbackup.sh is a simple script that automates your backups. It keeps daily backups for the last week, weekly backups for the last month and monthly backups for older versions of the database. The files are gzipped text files, so you can easily check them manually.

The script has many options, including the possibility to send emails with the new backup files and to use a single file for multiple databases.

Database design project

Posted by Strainu | Filed under SQL, Software

Database design project 4th year, Computer Science Faculty, Bucharest, prof. Mircea Petrescu. (more…)

Tags: Oracle, PHP, Software, SQL

Quotes (C++)

Posted by Strainu | Filed under C++, SQL, Software

Quotes (C++) A program that demonstrates the communication between VisualC++ and the MySQL server. To run, you need the MySQL server and the “quotes” table(use the quotes.sql file) from the archive.

The software is distributed under CC-GNU GPL license.

Download (source)

Tags: C/C++, MySQL, Quotes, WebBrowse

Quotes (Java)

Posted by Strainu | Filed under Java, SQL, Software

Aforisme (Java) A program that demonstrates the communication between Java (I have used the NetBeans IDE) and the MySQL server. To run the program, you need the MySQL server and the “quotes” table(use the quotes.sql file).
(more…)

Tags: Java, MySQL, Quotes, WebBrowse