How to setup ownCloud 5 on Ubuntu Server 12.04

Installing Prerequisites For ownCloud We need to install additional libraries that will be used by ownCloud. Execute the following: sudo apt-get install php5-gd php-xml-parser php5-intl smbclient curl libcurl3 php5-curl Now we need to enable mod_rewrite and mod_headers Apache2 modules, that are needed for ownCloud to function normally. To enable mod_rewrite…

Continue reading

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

Backup all MySQL databases

If you want to backup all of the databases in MySQL you can run the following in the command line (assuming you have create a sqlbackup folder in your home drive): mysqldump –user=root –password –lock-all-tables –all-databases > ~/sqlbackup/backup.sql You will be prompted for the password of the MySQL root account

Continue reading