SiteFixit.com

Using PHPMyAdmin to change table collations is a tedious task because you have to change each table one-by-one. In order to change ALL the tables’ collations at once, you’ll need to use a PHP script to help you. The following code does the trick: 1 2 3 4 5 6 7 8 9 10 11 [...]

WordPress is a great CMS, but it can get cluttered over time, and there’s no better way to remove all the unnecessary junk than to go clean it up in MySQL. Here are 3 quick SQL queries you can run to clean up your MySQL database. SQL command to delete all spam comments in WordPress: [...]

I knew phpMyAdmin had a function that allowed the import of CSV files, so I saved my data in CSV format using Excel 07, but when I tried importing it into my MySQL table using phpMyAdmin, it kept giving me this error: “Invalid field count in csv input on line 1″ This was very annoying, [...]

PrestaShop is a fantastic, versatile, open-source (i.e. FREE!) e-commerce shopping cart script based on PHP and MySQL. Tens of thousands of online shops are based on this script, and here are just some of the very best examples on PrestaShops sites, and how they’ve customised PrestaShop to look completely different from the stock script. Tartine-Et-Chocolat [...]