One of the classes that I’m sharing on phpclasses and I never talk about is DBConv or Database Conversion. The idea of the package is to convert SQL from proprietary structure into standard structure which could be used on different database servers.
I use this class specially to convert from Oracle to MySQL, to have a local database that I can work on more easily and keep compatibilities with the original oracle database.
Oracle users generally have this tool called TOAD, I use it to generate a dump of the oracle database. From menu choose Database, then Schema browser. Select tables you want to convert, then right click and choose “Create script” from the menu. The window below will be displayed :
Continue reading Convert Oracle database Schema to MySQL
WebDevRadio posted its first podcast, it cover a few new products/programs which may make your life a bit easier, and cover future topics. Thoughts on AJAX, Web services, internationalization, XP, performance, unit testing and more
Listen to Podcast #0 (31:34min / 28.9MB)
Continue reading The firsts WebDevRadio Podcast
I just discovered today ezpdo a simple solution for PHP 5 Object Relational Mapping and Data Persistence.
The goal of this project is to design a lightweight and easy-to-use persistence solution for PHP. This is how the project got its name, Easy PHP Data Objects (EZPDO). Simplicity is the key. Constantly we keep the following requirements in mind when designing EZPDO.
Continue reading ezpdo : PHP5 Object Relational Mapping and Data Persistence
Russell Dyer, author of MySQL in a Nutshell, have just published an article on ONLamp about Live Backups of MySQL Using Replication :
One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. Otherwise, a backup may slow down the system and there may be inconsistency with data, since related tables may be changed while another is being backed up. Taking the server down will ensure consistency of data, but it means interruption of service to users. Sometimes this is necessary and unavoidable, but daily server outages for backing up data may be unacceptable. A simple alternative method to ensure reliable backups without having to shut down the server daily is to set up replication for MySQL.
Read the article
ILoveJackDaniels have just published a MySQL Cheat Sheet :
The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database.
Great job as usual ! Visit the MySQL Cheat Sheet.
MySQL Backup Pro 1.0.8PRE3 have been released today. I just replaced the GonxTabs with something that you’ll reconize. Italian translation have been added.
I’m working to finish the 1.0.8 very soon, wich include major features enhancement and bug fixes.
Also concerning the license problem with GPLed software, The license is still “Free For non commercial use”, but you can just contact me to include it in any GPLed software. And this will not charge any fees to the GPL software or its users.
Download MySQL Backup Pro 1.0.8PRE3 here
MySQL have published the MySQL application of the year .
The MySQL Application of the Year is awarded to the developers of some of the best production applications that showcase MySQL’s innovative features and provide tangible benefits to their organization and its users.
Continue reading MySQL Application of the Year
I thought nobody is using this application anymore, but today I received the italian translation, now it’s translated to 11 langages … I think I’ll make an update soon… specially to remove the gonxtabs 
I thought mysqldump was great tool to export large databases, but noway ! I was trying to export a small database of 500Mo, and it hangup at 300Mo, I need ram or mysql backup pro .. or anything else ! I dunno. My machine have just 128Mo ram is it not enough ?
Just a small tips to find duplicated fields in database :
SELECT id,field,count(*) as c FROM `tablename` group by field having c>1
We always set unique or index fields that we don’t want them to duplicate, but if you want to do some reports or maintenance this is a great way.
Continue reading Find duplicates in mysql
