<code>

mysql –database=DATABASENAME -u USERNAME -p -B -N -e “SHOW TABLES” | awk ‘{print “ALTER TABLE”, $1, “CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;”}’

<code/>

This will bring an output like: which you can just run in as an sql command under your phpmyadmin:

 ALTER TABLE eaglesystems_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_listings_allowed_fields CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_listings_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_listings_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_listings_updates CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_message_template CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_plugins_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_users_friends CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ES_users_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_advanced_gallery_conf CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_announce_flag CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_announce_read CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_announcement_flags CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_announcements CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_banner_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_banners CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_banners_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_banners_locations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_blog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_blog_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_blog_categories_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_blog_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_blog_followers CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_cancellations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_captchas CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_categories_fields CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_categories_related CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_classifieds CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_classifieds_images CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_contact_requests CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_cron CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_cron_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_discount_codes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_documents CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_campaigns CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_lists CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_lists_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_marketing CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_marketing_queue CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_queue CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_schedules CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_email_templates CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_error_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_exports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_faq_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_faq_questions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_favorites CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_feeds_external CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_fields CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_fields_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_gateways CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_gateways_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_image_flags CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_images CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_imports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_invoices CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ip_limits CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_language_phrases CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_languages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_listings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_listings_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_listings_claims CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_listings_suggestions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_locations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_log_sql CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_maxmind_blocks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_maxmind_location CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_memberships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_menu_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_messages_posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_orders CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_pages CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_plugins CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_products CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_products_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_products_pricing CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ratings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_ratings_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_redirects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_reviews CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_reviews_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_reviews_quality CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_search_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_settings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_site_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_sms_gateways CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_statistics CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_statistics_raw CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_tax CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_temp_language_phrases CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_templates CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_templates_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_transactions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_updates CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_upgrades CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_api_keys CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_cards CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_groups_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_groups_permissions_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_login_fails CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_login_providers CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_users_permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE pmd_v1_zip_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;