girishsalaskar

for fileName in `ls /path/to/db/files/dir`;
do
echo "Importing - $fileName";
mysql --user=root --password --host=127.0.0.1 --port=3306 dbName < /path/to/db/files/dir/$fileName;
done;

girishsalaskar

import java.awt.Point;
public class MyClass {
    static final Point p = new Point(0,0);
    public static void main(String args[]) {
        p.x = 10; //Will run successful
        System.out.println(p);
	p = new Point(10,0); // Will give compile time error
    }
}

girishsalaskar

for T in `mysql -h <host>-P 3306 -uroot -p -N -B -e 'show tables from YOURDBNAME'`
do
echo "Backing up - $T"
mysqldump --skip-comments --compact -h 127.0.0.1 -P 3306 -uroot -p YOURDBNAME $T > /path/to/destination/folder/$T.sql
done;

girishsalaskar

UPDATE tblName set varcharCol = CONVERT(CAST(varcharCol AS BINARY) USING utf8) where pid=1;