#!/usr/bin/php
<?

$_user = 'root';
$_pass = '';

$c = mysql_connect ('localhost', $_user, $_pass);

if ( $c ) :
	mysql_query ('set names euckr');

	# get db list
	$r = mysql_query ('show databases');
	$n = mysql_num_rows ($r);

	for ( $i=0; $i<$n; $i++ ) :
		$_db = mysql_result ($r, $i, 'Database');

		printf ("* %s Database", $_db);
		if ( $_db == 'mysql' ) :
			echo " ... skip\n";
			continue;
		else :
			echo "\n";
		endif;

		# get table name
		$_r = mysql_db_query ($_db, 'show tables', $c);
		$_n = mysql_num_rows ($_r);

		for ( $j=0; $j<$_n; $j++ ) :
			$_tb = mysql_result ($_r, $j, "Tables_in_{$_db}");
			printf ("%4s%-40s ... ", '', $_tb);

			$_e = mysql_db_query ($_db, "alter table {$_tb} convert to character set utf8", $c);

			if ( $_e === FALSE ) :
				echo "failed\n";
			else :
				echo "ok\n";
			endif;
			sleep(1);
		endfor;
	endfor;

	mysql_close ($c);
endif;

?>