Software Development Blog

Archive for October, 2009

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”/]

phpMyImporter released

Tuesday, October 27th, 2009

For many months, I wanted to be able to import backups of databases created by my other project, phpMyDumper, without using phpMyAdmin. The php configuration limits the filesize that phpMyAdmin can import. By default the filesize limit is 2 MB, which is potentially a problem if you are not able to change the php configuration, eg when using an external webhost.