tool

MySQL Load Data Infile Syntax Generator Tool Download

The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. I have already written the basic how to follow that considering additional cases. A lot of questions I have seen for loading separated data to MySQL, so here I’ve created a very beginner level excel tool that will allow you to generate the LOAD DATA syntax as per your choices. Presently sample table name and field/line separators are specified, which you may alter as per your own file. Download the sheet...

Working with EditPlus Text Editor-Regular Expression How To

Editplus is a lot better than the regular text editor, Notepad. From all it’s features I like RegExp Support the most, and than comes the block select feature. Here are the quick lines to carry out regular tasks using regular expression in Editplus. It’s kinda downloadable cheetsheet list. Remove all empty lines: Find: “^\n” (Ignore double-quotes in all find/replace) Replace: “” Where, ^ – Beginning of the line \n – New Line Remove Multiple Spaces convert into single space: Find: ” +” Replace: ” “ Where, + – find one or more occurance of space character. Comment multiple line of...

MySQL master master replication monitor with php code

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: File: Present binary log Position: Binary log position Io run: Slave IO Thread Running status Sql run: SQL Thread Running status ErrorNum: Error number ErrorMeg: Error message You can easily stop / start each server’s slave (STOP SLAVE / START SLAVE) with a single...