Archive | PHPMyAdmin RSS feed for this section

How To Change Multiple MySQL Tables’ Collation At Once In Bulk

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 [...]

Continue reading...

How To Fix “Invalid field count in csv input on line 1″ phpMyAdmin Error

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, [...]

Continue reading...