Pinned Loading

1. Dump `mysql` db by tables (See more ... Dump `mysql` db by tables (See more here : https://codewander.blogspot.com/2019/12/dump-mysql-db-by-tables.html )

   1

   for T in `mysql -h <host>-P 3306 -uroot -p -N -B -e 'show tables from YOURDBNAME'`

   2

   do

   3

   echo "Backing up - $T"

   4

   mysqldump --skip-comments --compact -h 127.0.0.1 -P 3306 -uroot -p YOURDBNAME $T > /path/to/destination/folder/$T.sql

   5

   done;

2. Messed up varchar after/before impor... Messed up varchar after/before importing into mysql db (See more here : https://codewander.blogspot.com/2019/12/recover-messed-uplost-utf-8-characters.html )

   1

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

3. The final object demonstration (Desc... The final object demonstration (Description is here : https://codewander.blogspot.com/2020/01/the-final-keyword-in-java.html)

   1

   import java.awt.Point;

   2

   public class MyClass {

   3

       static final Point p = new Point(0,0);

   4

       public static void main(String args[]) {

   5

           p.x = 10; //Will run successful

4. Import multiple db files from folder... Import multiple db files from folder into mysql db (Details : https://codewander.blogspot.com/2020/02/import-multiple-db-files-from-folder.html)

   1

   for fileName in `ls /path/to/db/files/dir`;

   2

   do

   3

   echo "Importing - $fileName";

   4

   mysql --user=root --password --host=127.0.0.1 --port=3306 dbName < /path/to/db/files/dir/$fileName;

   5

   done;

5. girishsalaskar.github.io girishsalaskar.github.io Public

   Professional portfolio website.

   JavaScript 2

6. node-project node-project Public

   JavaScript