MySQL Check All Tables in Database

If you need to check (not repair) all your tables at once , run the following command in your shell;You will be prompted to enter the password.-A means check all databases -c means Click here to view how to repair all tables.
Rate this blog entry:
Continue reading
19 Hits
0 Comments

Git Ignore All Except Some Files

If you already have a .gitignore file with rules, you can change them.My .gitignore looked like this;Let's say you now want to include a file located at /lib/config.php. You would add this line;Next run git status and you should see ;untracked files /libNow you can run git add lib/ After another git status you should see;new fil...
Rate this blog entry:
Continue reading
23 Hits
0 Comments

MySQL Repair All Tables in Database

Open a shell and run the following command;​You will be prompted to enter your password.
Rate this blog entry:
Continue reading
29 Hits
0 Comments

Airbnb £25 Discount Code

​Click this link to get your £25 off!
Rate this blog entry:
Continue reading
40 Hits
0 Comments

PhpMyAdmin Invalid Column Count in CSV input on line 1

If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table.I had an existing table with 10 columns, the first column was `id` an auto-increment field. I omitted this from my CSV file presuming it would be auto geberated but it's not.number of c...
Rate this blog entry:
Continue reading
455 Hits
0 Comments

REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.Before;|aShakespeare, William,|d1564-1616.Regex;REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')After;Shakespeare, William, 1564-1616.
Rate this blog entry:
Continue reading
396 Hits
0 Comments