Export a MySQL database in JSON format using HEIDISQL
HeidiSQL allows exporting any MySQL database in JSON format. Read more… [Read more…]
HeidiSQL allows exporting any MySQL database in JSON format. Read more… [Read more…]
This post outlines how to configure MariaDB or MySQL on Centos 7 in order to store a specific database outside of the typical /var/lib/mysql/DBNAME directory. Or in other words, how you can have each of your databases residing on a different drive (or a different folder on the same drive), while running only a single instance of MariaDB or MySQL. [Read more…]
This article describes how to fix MySQL connection error: (“Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]”), experienced during MySQL or MariaDB authentication (typically during establishing a database connection). [Read more…]
I get this asked quite often, so here is a simple example of using MySQL command for replacing one string with another in multiple rows: [Read more…]
This article illustrates how to create MySQL database containing entire Wikipedia out of downloaded Wikipedia XML dump (enwiki-latest-pages-articles-multistream.xml)
There are two linux tuning scripts I would recommend to anyone who wants to tweak MySQL installation for the best possible performance. [Read more…]
Following is a batch file I’ve created to backup my MySQL database. It compresses the backup to a passworded WinRar file. Which is then uploaded by the same batch file to my free 25gb Microsoft SkyDrive account (you can use any cloud storage provider which can be mapped to drive letter). Batch script then automatically names created backup using the current date and time stamp. It then deletes all WinRar files older than 30 days on SkyDrive, thus rotating backups for me automatically. Batch file can be scheduled to run as often as needed. [Read more…]
If you need to auto restart Apache and MySQL in case one or both are crashed, just schedule this SH script on Centos (RHEL) in your cron section. [Read more…]
This is a simple one liner to automatically check, repair and optimize all MySQL tables and all databases: [Read more…]
This is very simple: [Read more…]
It just came to me that it shouldn’t very hard to write an application, which would create pretty large online hard drive. Ok, ok, I know this is pretty far fetched and I didn’t spent much time pondering this question, but here is the idea in it’s most simplest form: Almost every person knows someone who has a website…, this in many cases means that person got an online account with a web space provider, where most of the provided space will simply never get used. There is also many of us, who are running their own servers and there is tons of unused space… [Read more…]