SQL's statement to evenly distribute results select a.gallery_id , a.gallery_title , b1.image_id , b1.image_date_added from galleries as a inner join images as b1 on a.gallery_id = b1.image_gallery_id inner join images as b2 on a.gallery_id = b2.image_gallery_id and b1.image_adddate &l Continue reading...

To do a backup (also known as a dump) of a MySQL database: %mysqldump -u$username -p$password $database > $database.sql $username - replace with the value of your mysql username (or login) $password - your database password $database - replace with the name of your database $da Continue reading...

Question: Why set up a custom backup (dump) routine on my website? Answer: Web hosting provider commonly run backups, but they may be infrequent and depending on the age, may be stored offsite.  If you configure your own backups you can probably restore a file s Continue reading...

Background: I developed a PHP scripts for Joomla/Virtuemart that could be used to import shipping/handling fees from a .csv file into Joomla's shipping_rate table. Problem: Although the script executes and imports the data correctly whenever I would check the dat Continue reading...

MySQL doesn't have a core function to delete multiple tables matching a pattern.  This is a simple script that you configure, then run command-line to delete multiple tables matching a pattern.  Be careful to ensure that the pattern will not also match database you do not wish to delete. Continue reading...

To do a backup (also known as a dump) of a MySQL database: %mysqldump -u$username -p$password $database > $database.sql $username - replace with the value of your mysql username (or login) $password - your database password $database - replace with the name of your database $da Continue reading...

Question: Why set up a custom backup (dump) routine on my website? Answer: Web hosting provider commonly run backups, but they may be infrequent and depending on the age, may be stored offsite.  If you configure your own backups you can probably restore a file s Continue reading...

SQL's statement to evenly distribute results select a.gallery_id , a.gallery_title , b1.image_id , b1.image_date_added from galleries as a inner join images as b1 on a.gallery_id = b1.image_gallery_id inner join images as b2 on a.gallery_id = b2.image_gallery_id and b1.image_adddate &l Continue reading...

Background: I developed a PHP scripts for Joomla/Virtuemart that could be used to import shipping/handling fees from a .csv file into Joomla's shipping_rate table. Problem: Although the script executes and imports the data correctly whenever I would check the dat Continue reading...

MySQL doesn't have a core function to delete multiple tables matching a pattern.  This is a simple script that you configure, then run command-line to delete multiple tables matching a pattern.  Be careful to ensure that the pattern will not also match database you do not wish to delete. Continue reading...