HeidiSQL – Problem Migrating Databases

Published on Author JFLeave a comment

You’ve got a database you want to move or copy from, say, staging to production. You’ve had HeidiSQL open for a while and now it’s time to go live. You check your database in the left pane, then right click > Export database as SQL You check off “drop” to make sure all the tables… Continue reading HeidiSQL – Problem Migrating Databases

WordPress Error: Cookies are blocked or not supported by your browser

WordPress Must Enable Cookies Warning You’ve had this problem and it has driven you crazy, hasn’t it? ERROR: Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.   Here’s a possible solution: You might have accidentally copy/pasted a carriage return into your site URL or home field.  … Continue reading WordPress Error: Cookies are blocked or not supported by your browser

Make a list of files using the Command Line

Published on Author JFLeave a comment

This one is super easy: Open a Command window (on Windows, of course) CD to your directory Did you know you can type “cd” then drag the folder path from an open Windows Explorer window onto the command window and it will copy the path for you? Type: dir > filelist.txt Now look in that… Continue reading Make a list of files using the Command Line

Download older versions of Internet Explorer from Microsoft

Published on Author JFLeave a comment

Hallelujah! http://www.itechtics.com/download-internet-explorer-all-versions/ I’ve tried the IE10 x64 link and it works. Have not tried anything else. Note: all the downloads are from Microsoft, not some suspect third party! What am I using it for? Windows 8.1 (Probably available on 8) has the ability to install Hyper-V. So, I’m creating a bunch of Hyper-V’s for QA’ing… Continue reading Download older versions of Internet Explorer from Microsoft

Automatically create a URL/HREF in an Excel field

Published on Author JF1 Comment

You output 5000 rows of data into Excel for a client to review and need to make them all HREFs. The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article. We have this: ArticleID URL 456 And… Continue reading Automatically create a URL/HREF in an Excel field

View MySQL Char Set encoding for your database

Published on Author JFLeave a comment

Quick reference: For Schemas: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “schemaname”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = “schemaname” AND T.table_name = “tablename”; For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` C WHERE table_schema = “schemaname” AND table_name = “tablename” AND column_name = “columnname”; Thanks, as… Continue reading View MySQL Char Set encoding for your database