29
January
2005

DB Design

I have decided to move over to using a MySQL based data layer rather than the XML documents I was using to store data. This will give me much greater flexibility and functionality. I found a great case tool for doing DB design with MySQL called DB Designer from fabForce.net. The tool allows for a simple and nice graphical UI to design tables and relationships and then synchronize with the MySQL server. It can also generate the scripts required to create the database structure a different server.

Reference:
DB Designer

WordPress database error: [Table 'd60338014.wp_comments' doesn't exist]
SELECT * FROM wp_comments WHERE comment_post_ID = '5' AND comment_approved = '1' ORDER BY comment_date

 

Leave a comment