Some of you may be wondering what a DirectoryIndex is. DirectoryIndex a command which allows you to specify a file that is loaded as your default page whenever a directory or URL is requested that does not specify a specific page like for example http://www.free-installations.info/index.html. To change the DirectoryIndex you [...]
Changing the collation for all tables in a MySQL database can be time consuming depending on how many tables you have. An easier and less time consuming way is the following PHP script that changes the collation for all tables at a time:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
<?php
$db = mysql_connect('localhost','myuser_mydbuser','mypassword');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?> |
Make sure to substitute in the [...]
This guide is provided to show how to do a basic (vanilla get up and go) install of Elasticsearch (0.18.7), the Elasticsearch Service Wrapper and the required Java Runtime Environment (JRE) (1.7.0_02) on Debian/Ubuntu. This guide will not cover running a dedicated Elasticsearch user. This guide assumes the user has [...]
Our RSS Feed
Twitter
Facebook
Google+
