To optimize every table in all databases on the server, just run this command:

mysqlcheck -o --all-databases -u root -p

In case you want to optimize tables for a single database:

mysqlcheck -o <db_name> -u root -p

I will provide basic code that’s needed to turn Excel or LibreOffice Calc file (.xlsx, .xls, .csv, .ods and some other formats) into a MySQL table with all the corresponding fields and data. This code will assume the first row of the document contains (unique) column names. That’s pretty much the only requirement.

First thing we need is PHPExcel package (it’s free and open source) for reading spreadsheet files. You can download it here: https://phpexcel.codeplex.com/. Download, extract and move it a folder where you can execute php files. We will include them in the following scripts. Continue reading →

I have one server with a lot of MySQL databases, and I wanted to know witch ones are taking up most of the disk space. Continue reading →