Software Development Blog

Archive for the ‘phpMyDumper’ Category

phpMyDumper 1.10 released

Wednesday, October 28th, 2009

Finally, I have released my next version of phpMyDumper. This new version includes improvements that I needed when used in my work as a web programmer.

First of all it now supports UTF-8 connections as default with the MySQL server. The php class will create files encoded as UTF-8 which is important when your database is used with non-US languages.

Another important feature is the option to dump AUTO_INCREMENT in table structures. Older versions of MySQL (before 4.0) does not dump AUTO_INCREMENT when using the SHOW CREATE TABLE statement.

When using phpMyDumper in a backup environment, you want to know which MySQL server version created your sql files. phpMyDumper now dumps this information in the top of the sql file.

At last, you will also be able to know the progress of phpMyDumper. It will display the name of the created sql file and information about which table is being processed. Progress information is only avaible when dumping to a sql file.

In the last version I forgot to include an example of how to use the stream feature of phpMyDumper. The following code shows how, and the example will also be included in the download package.
[file path=”phpmydumper-1.10-example2.php” tpl=”code”/]

phpMyDumper released

Friday, March 13th, 2009

After one week of coding I am ready to release my newest software project: phpMyDumper.

I wanted to do automatic backup of my website databases and normally you would do this using mysqldump and a cronjob. At the moment I am hosting my websites on my own server, but I plan to move the websites to an external webhost. However since I have no way to make sure that I have access to mysqldump on my future webhost especially if cost should be as low as possiible, I decided to write a php tool myself to do the job.