There are three levels of knowledge and according to the scope of knowledge, there are differences in human behavior...

There are three levels of knowledge and according to the scope of knowledge, there are differences in human behavior...

First level: When a person enters the first level of knowledge after acquiring some basic knowledges, he/she becomes arrogant and thinks that he/she knows or has learned everything.

Second level: When a person is able to understand something as soon as he/she knows it, it can be called the second level of knowledge. At this stage he/she becomes humble, and his/her curiosity grows for acquiring more knowledge.

Third level: When the complete knowledge comes on all matters and he/she enters the third or higher level of knowledge by easily acquiring the skill of understanding everything well, he/she easily realize his/her mistakes. Even after knowing a lot, he/she thinks or realize that he/she knows nothing.

We have to try to reach the higher level for acquiring knowledge.

-Collected

MySQL JDBC Driver - Time Zone Issue

MySQL JDBC Driver - timezone issue or the server timezone value 'unknown' is unrecognized or represents more than one value, etc. occurred then following step would help to resolve: 

Just add the following line end of JDBC connection string,

?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

Complete connection string below,

jdbc:mysql://hostname_or_ip:port/db_name?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

MySQL InnoDB ib_logfile0, ib_logfile1 & ibdata1 file size issue

Following steps would solve the issue:

Step-1: MySQLDump all databases into a SQL text file (e.g. SQLDataBackup.sql)

Step-2: Drop all databases (except mysql, information_schema and performance_schema schemas)

Step-3: Shutdown MySQL

Step-4: Add the following lines to (/etc/my.cnf if linux) or (C:\xampp\mysql\data\my.ini if xampp in windows)

[mysqld]

innodb_file_per_table 

innodb_flush_method=O_DIRECT 

innodb_log_file_size=1G 

innodb_buffer_pool_size=4G 

innodb_data_file_path=ibdata1:10M:autoextend 

Note: Whatever you set for innodb_buffer_pool_size, make sure innodb_log_file_size is 25% of innodb_buffer_pool_size.

Step-5: Delete ibdata1, ib_logfile0 and ib_logfile1  

There should only be the mysql schema in data location.

Step-6: Restart MySQL

This will recreate ibdata1 at 10MB (do not configure the option) , ib_logfile0 and ib_logfile1 at 1G each

Step-7: Reload SQLDataBackup.sql into MySQL

ibdata1 will grow but only contain table metadata and intermittent MVCC data. Each InnoDB table will exist outside of ibdata1

Suppose you have an InnoDB table named mydb.mytable. If you go into path/mysql/data, you will see two files representing the table

mytable.frm (Storage Engine Header) 

mytable.ibd (Home of Table Data and Table Indexes for mydb.mytable) 

ibdata1 will never contain InnoDB data and Indexes anymore.

With the innodb_file_per_table option in (/etc/my.cnf if linux) or (C:\xampp\mysql\data\my.ini if xampp in windows), you can run OPTIMIZE TABLE mydb.mytable OR ALTER TABLE mydb.mytable ENGINE=InnoDB; and the file will actually shrink.

Excel Digit Conversion

English to Bangla Digit Conversion and vice-versa

Download the Excel File

Number to words both in English & Bangla (PHP Version)

https://github.com/tomamuns/InWords-PHP-

Display Bangla Date using PHP

https://github.com/tomamuns/BanglaDate

BanglaDate

This simple php script will help to display bangla date in following format. e.g. আজঃ ১৭-পৌষ-১৪২৬ (বুধবার)

Use

include_once("./BanglaDate.php");
$bdate = new BanglaDate();

echo "".$bdate->PrintEngDate()."<br />";
echo "".$bdate->PrintBanglaDate()."<br />";

Number to words both in English & Bangla

https://github.com/tomamuns/InWords