XAMPP – MySQL shutdown unexpectedly

Rename the folder mysql/data to mysql/data_old (you can use any name)Create a new folder mysql/dataCopy the content that resides in mysql/backup to the new mysql/data folderCopy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)Finally copy the ibdata1 file from mysql/data_old and…

Continue Reading XAMPP – MySQL shutdown unexpectedly

MySQL operations

Change a table name ALTER TABLE old_table RENAME new_table; Move a table from one database to another CREATE TABLE new_database_name.new_table_name LIKE original_database_name.original_table_name; INSERT new_database_name.new_table_name SELECT * FROM original_database_name.original_table_name; Difference between…

Continue Reading MySQL operations

Database normalization

Notes taken from Brian Green's excellent video on normalization on youtube : https://www.youtube.com/watch?v=QqlPXKxN6LQ Normalisation is a process of removing anomalies from a database. These anomalies include: insertion, update and deletion…

Continue Reading Database normalization

Getting Mercator crop of Iceland map (with known extremes of longitude and latitude)

Go to https://planet.openstreetmap.org/ and download the latest openstreetmap .pbf file. It's big so you will have to wait a while. 2) Download OSMConvert - we need this software to crop…

Continue Reading Getting Mercator crop of Iceland map (with known extremes of longitude and latitude)