How to change collation on all tables and columns in MySQL – easy script
Today I had huge problem to change collation on
So how to solve problem ? You need to set all your database tables to utf8_unicode_ci !!!
1) DOWNLOAD script for database collation
2) Unzip the zip file and copy the folder ‘tool_phoca_changing_collation’ into your server (localhost). Run the index.php script included in the ‘Collation’ folder. Add the following information into the form:
- Database hostname (e.g. localhost)
- Database username
- Database password
- Database name
- Database collation (add here the collation you want to have for the database, all tables and all columns in all tables.
In 30 seconds everything will be done !!! How to change collation on all tables in MySQL at Wordpress – easy script
Write comments if you have better tips.
|
Special promotion : earn money with $100 earn
$10.000. Deposit $25. Work from home as trader. You earn evan currency increase or drop !!!
 |
|
Google Fusion Tables, simple on-line reporting and collaborativeGoogle surprised again with a one new service in beta called Google Fusion Tables is...
Change the browser’s address bar of Mozilla FirefoxThis article is dedicated to nothing more than those of Mozilla Firefox users to use...
Selling Change: 101+ Secrets for Growing Sales by Leading Change (Hardcover) newly tagged “internet” Selling Change: 101+ Secrets for Growing Sales by Leading Change (Hardcover)By Brett Clay Buy...
Eliminate the post of historical WordPress (Post Revision)With the release of WordPress 2.6, the version before the current version available, in my...
Learn how a CMS by creating a very simpleThrough Computer Practice, I find a very interesting article for those interested in web programming:...
Disable Revisions, plugins for WordPress that disables the historical postsLast month I remember I found the way to eliminate the post of historical WordPress...
Wordpress admin plugin notepad for service in the DashboardJP left with looking like the dashboard of notifications Articulos world and thus communicate issues...
Yahoo! and its attempts to not fail to resistance to changeIncredible entry that publish today in The New York Times, in explaining the process being...
Muphy passed nearLook to Murphy's law is fulfilled and then meet. And in the world of technology...
Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites (Animal Guide) (Paperback) newly tagged “internet” Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites (Animal Guide)...
How Google SearchWiki improve the quality of content – webmasters SEO tipsNew Google SearchWiki improve the quality of content In the U.S. Google has launched Google...
Being a Blogger’s girlfriend is a very interestingMy boyfriend is a Blogger, you have many blogs, so that really is not even...
Change the skin of Firefox in a clickWe all know the wonders and joys that Firefox offers us that likes to customize...
60 great free Wordpress themesAs compilations go around ... so they do not have to complain if you go...
Trojan blocks Pirate Bay and MininovaA Trojan that has been blocking access and downloads of Pirate Bay and Mininova, 2...
Retrieves unverified subscribers in FeedburnerProvide your email subscription increases, additional to the rss feed, adds significantly to the public...
It is now possible to download WordPress 2.7 Release Candidate 1As everyone should know we are in full development period of WordPress 2.7, which has...
Finder features used in WordpressWordpress is one of the platforms for blogs that have been evolving in recent years,...
User Driven Change: Give Them What They Want (Paperback) newly tagged “internet” User Driven Change: Give Them What They Want (Paperback)By Carlos del Rio Buy new:...
Is now available for download WordPress 2.7 Beta 2Thanks to that within the "Admin Panel" WordPress is possible to view the latest news...
