Setting MySQL innodb_buffer_pool_size

I was confused how big i should set my “innodb_buffer_pool_size” value. Then i find this post in stackexchange. I can run this query to get what is the suggestion of “innodb_buffer_pool_size” value. SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes FROM information_schema.tables WHERE engine=’InnoDB’) A; The result will be in GB.

Exporting MySQL Databases Command Line in Linux

To export a mysql database by linux command line, for example your database name is my_database, your mysql username is my_username, and your mysql password is my_password, you can use this command : mysqldump –opt –single-transaction -umy_username -pmy_password my_database > /your/path/here/export.sql Note: after “-u” and “-p”, there is NO space. 🙂