Error Message: No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration

Today I was trying to import a number of databases into MySQL using the phpmyadmin console, and got this error: No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration After some investigation, I found…

Continue reading

MySQL Tuning Script

MySQLTuner is a Perl script that analyzes your MySQL performance and based on the statistics it gathers, gives recommendations on which variables you should adjust in order to increase performance. To download and run, use the following steps: wget http://blogs.barlow.uk.net/content/downloads/mysqltuner.pl chmod +x mysqltuner.pl sudo ./mysqltuner.pl References: http://mysqltuner.pl/mysqltuner.pl

Continue reading

Managing MySQL user accounts

Adding MySQL accounts To create a new account: CREATE USER ‘adm’@’localhost’ IDENTIFIED BY ”; Here the ‘adm’ user is created, which can only connect from localhost. The password is encrypted by MySQL using the PASSWORD() function. In MySQL a user is always associated with a host in this way. Multiple…

Continue reading

Useful MySQL Commands

Using mysqladmin The mysqladmin tool has various switches to simplify common commands, for example to determine basic server status: mysqladmin -u root -p status If run as root the mysql user account details need not be specified, making this is best suited to simple monitoring scripts and administrative tasks. Verify…

Continue reading