Got error 28 from storage engine – Mysql Database

Friday, 19. July 2013

I came to a surprising problem this morning with one of our client’s site where all of a sudden Magento was throwing error Got error 28 from storage engine on error logs

Had no clue what that means really so looking around the server ended up noting the server is actually run out of space!

Shame, but that happened to be the reason behind this problem and things went back to normal after fixing the space issue.

Oh, well, shift happen! :)

Can’t connect to local MySQL server through socket – Ubuntu xampp and MySql

Sunday, 30. October 2011

If you have come across this problem while connect to MySQL (possibly via command line tool) this solution may work for you. Th issue is mainly because the script is looking for a file – mysqld.sock – in order to be able to connect as localhost but in the wrong location.

MySQL Conenction Error

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Solution
On your terminal run the following two commands

sudo mkdir /var/run/mysqld/

Next run this

sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock

Now try again to connect to MySql using your configured MySQL username and password

mysql -u[username] -p[password]

Mysql – Got a packet bigger than ‘max_allowed_packet’ bytes

Friday, 12. August 2011

If you have been restoring a database backup via a command line utility and came across this type of error, this command my help you out if you give it a try!

It allows you to set up the max packet limitations only for this command run

mysql --max_allowed_packet=200M -uroot -p mydb < mydump.sql

If you want to alter you entire server configurations, you will need to do the following:

1) Locate your my.cnf or my.cnf file
2) Locate the section [mysqld] and somewhere underneath you can change/add this line:

[mysqldump]
max_allowed_packet = YOUR_VALUE

You can now change YOUR_VALUE to your new preferred limit.

You can also use command line facility to execute the following commands on your machine/server:

set global net_buffer_length=SOME_BIG_VALUE;  (i.e 1000000)
set global max_allowed_packet=SOME_BIG_VALUE; (i.e. 1000000000;