This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE tblName set varcharCol = CONVERT(CAST(varcharCol AS BINARY) USING utf8) where pid=1; |