How to easily convert a single database or all databases from MyISAM storage engine to InnoDB storage engine

InnoDB is a more robust engine and a better database table type for modern applications.  Using InnoDB will increase your sites performance, speed, and they will have better chances to survive most More »

Dropbox users report spam emails amidst fears of data breach

Dropbox users are reporting receiving spam messages through the unique email addresses associated with their accounts on the file hosting service. The issue is a particular cause for concern given Dropbox’s high-profile security More »

Why IT security pros can be scarier than the ‘bad guys’

I thought I harbored a healthy amount of paranoia before I went to this week’s RSA Conference for IT security professionals in San Francisco. But now I’m just plain scared—and not about hackers More »

OruxMaps Lets You Go as Far as Your Mapmaking Skill Takes You

OruxMaps Donate, a mobile app from Jose Vazquez, is available for US$2.62 at Google Play. Have you ever considered becoming a cartographer? It’s not as hard as you might think. I’ve been More »

Game of Thrones Fun

Let’s say I wanted to put a spin on Game of Thrones and say what I think 🙂

Who’s Who Facts:

Robert Baratheon – 17th ruler of the Seven Kingdoms, Lyanna Stark was betrothed to him.

Stannis Baratheon – Brother of Robert Baratheon and the wielder of a sword said to be Lightbringer but his sword would only glow, it did not radiate heat like legend tells of Lightbringer.

Rickard Stark – Lyanna Stark’s father

Rickard Stark – Eddard “Ned” Stark’s father

Arya Stark – Eddard “Ned” Stark’s daughter and Jon Snow’s cousin

Aerys and Rhaella Targaryen – parents of Rhaegar Targaryen

Jaqen H’ghar known “No One” or “Faceless Man”

Samwell Tarly (Sam)- a steward and Jon Snow’s closest friend

R’hllor “Red God” – Lord of Light

Melisandre “The Red Woman” – R’hllor’s Red Priestess Melisandre has been searching for Azor Ahai, the “Prince That Was Promised,” who will fight the coming darkness. She has not always been accurate in her predictions, at first, she thought that man was King Stannis Baratheon because she could resurrect him and her resurrecting “Azor Ahai” was foretold. She wears a choker with a ruby that she uses to work her magic and change her appearance.

Facts:

Aerys and Rhaella Targaryen had a son Rhaegar Targaryen because a witch prophesied to them that a prince of their line would be reborn as “Azor Ahai” and save the world from darkness “White Walkers”

Azor Ahai will wield a sword called “Lightbringer” “hint, hint”

Azor Ahai would fight with Lightbringer but also would not fight alone but with a creature

Lyanna Stark married Rhaegar Targaryen and were truly in love

Lyanna desired to carry a blade, yet Rickard Stark forbade her from carrying a sword

Rickard Stark made comments that Lyanna had a touch of wildness in her that he described as “the wolf blood”

Lyanna Stark and Rhaegar Targaryen had a son “Aegon Targaryen”, when Lyanna spoke to Ned Stark, she made him promise to take care of him and to call him his own. Ned named the baby Jon Snow and claimed him as his own bastard son.

Rhaegar Targaryen was killed by Robert Baratheon

Rhaegar was struck down with a massive blow from Robert’s Warhammer, which scattered the rubies encrusted in Rhaegar’s armor into the water. While Rhaegar lay dead in the stream, soldiers of both armies scrabbled in the water to search for the rubies.

Arya’s Favorite brother: Jon Snow “Aegon Targaryen”

Arya was trained by No One – Faceless Man – Jaqen H’ghar

Jaqen H’ghar found Arya, he positioned himself as a prisoner and when found, he knew her name. She was timid so not easy to befriend. So, when Arya saved him from the fire, he said to her, The Red God “Lord of Light” has his due, sweet girl, and only death may pay for life. This girl took three that were his. This girl must give three in their places. Speak the names, and a man will do the rest.

Jaqen H’ghar is strong, kind, soft spoken and good with a sword but also has a darkness 🙂

Jaqen’s mission was to make sure Arya could protect herself with any weapon

Jon Snow was brought back to life, reborn by “Lord of Light” through Melisandre “The Red Woman” 🙂

Samwell Tarly “Sam” gave Jon Snow the Tarly family ancestral sword called “Heartsbane”

Fun Fact:

Jaqen has a long blond almost white streak in his hair “hint”

Jaqen made comment to Arya.. “You have a wildness in you child “the wolf blood” My father used to call it 🙂

Jaqen also made the comment to Arya.. “Lyanna might have carried a sword, if my lord father had allowed it 🙂

Catching on?

Age Facts:

Jon Snow “Aegon Targaryen” age 20-21

Rhaegar Targaryen age at death 23-24

Jaqen H’ghar – No One – Faceless Man – age 43-45

Theories:

Rhaegar Targaryen’s body was never found

Is Jaqen H’ghar – No One – Faceless Man, Rhaegar Targaryen and using the ultimate disguise to stay hidden?

Did Jaqen H’ghar train Arya because she is the “Azor Ahai” that will kill the Night King?

Is Jaqen H’ghar if he is indeed “Rhaegar Targaryen” or Jon Snow the reborn “Azor Ahai”?, we know Jon Snow is Aegon Targaryen born from the Aerys and Rhaella Targaryen bloodline. Jon Snow was also resurrected “reborn” by the R’hllor “Lord of Light” through Melisandre “The Red Woman”

Did Stannis Baratheon have the true Lightbringer as that sword would only give off a glow but no heat or was it simply not functioning correctly because he was not the true “Azor Ahai”, The “One True King”

Is Heartsbane really Lightbringer which would make Samwell Tarly “Sam” a descendant of the original Azor Ahai?

If Jon Snow “Aegon Targaryen” is “Azor Ahai”, when will he be reunited with Lightbringer? For Lightbringer to be reborn, a sword must be thrusted into a certain living heart, will that be Melisandre’s heart 🙂 She said she is only alive because the Lord of Light isn’t done with her and that she is to help Jon win the war and has one last thing to do… hmm

Last but not least, if Jon is Azor Ahai and is reunited with Lightbringer, who is the creature that will fight beside him? Will it be Rhaegal’s, the second strongest dragon, Drogon, the strongest dragon and who Daenerys rides or something else?

These are just my thoughts, let me know your thoughts below 🙂

Joe Lovrek

How to easily convert a single database or all databases from MyISAM storage engine to InnoDB storage engine

InnoDB is a more robust engine and a better database table type for modern applications.  Using InnoDB will increase your sites performance, speed, and they will have better chances to survive most database hiccups that can occur

The steps below will allow you to update “Individual” or “ALL” existing database installations using the MyISAM storage engine to the InnoDB storage engine.

Requirements

You’ll need the following in order to convert your databases:

1. The current version of phpMyAdmin or an SSH client

2. A database version that supports full text indexes for InnoDB table types

I will show you three different processes to convert your database(s).

Processes Used Below:

1. Using phpMyAdmin to convert a single database from using MyISAM engine to InnoDB engine

2. Using phpMyAdmin to convert all databases from using MyISAM engine to InnoDB engine

3. “easiest” Using SSH to convert all databases from using MyISAM engine to InnoDB engine

Single Database Conversion From MyISAM to InnoDB using phpMyAdmin:

1. Backup Your Database “Just in case”

2. Launch phpMyAdmin. You must explicitly click on the name of your database in the top of the left column. There are sometimes multiple databases, so make sure you are clicking the correct database. “Do not click on the one labelled information_schema.”

3. Click the Query tab

4. In the query box, paste the following code replacing “your-db-name” with your actual DB name and press the submit query button, this will pull up a list of tables that need to alter to InnoDB.

SELECT CONCAT(‘ALTER TABLE ‘,TABLE_NAME,’ ENGINE=InnoDB;’)

FROM INFORMATION_SCHEMA.TABLES

WHERE ENGINE=’MyISAM’

AND table_schema = ‘your-db-name’;

5. Select dropdown to show 500 rows and then Click the “+Options” link above the results, choose the “Full texts” option, and press the “Go” button in the shaded area at the lower right

6. Select the “Show all” checkbox

7. Copy all the queries using the “Copy to clipboard” link in the “Query results operations” box below the results

8. Paste the result into a text editor to see the full output and copy all the lines STARTING with “ALTER TABLE” to your clipboard, they will look like the example below

example:

ALTER TABLE wp_commentmeta ENGINE=InnoDB;          

ALTER TABLE wp_comments ENGINE=InnoDB;   

ALTER TABLE wp_links ENGINE=InnoDB;

9. Click the SQL tab above the results, make sure you are still in the database you were working with

10. Paste the ALTER TABLE statements into the textarea and press the “Go” button in the lower right shaded area, there will be a pause, depending on how many tables are getting converted, it can take a few minutes to complete

To confirm your database was successfully converted, click your database name in the left column, and all table types should now say InnoDB.

All Database Conversion From MyISAM to InnoDB using phpMyAdmin:

1. Backup Your Database(s) “Just in case”

2. Launch phpMyAdmin. You will see all your databases on the left, you are in the main phpMyAdmin section.  Instead of seeing a query tab, you will see an SQL tab.

3. Click the SQL tab

4. In the SQL box, paste the following code and press the “Go” button in the lower right, this will pull up a list of all the databases and their tables that need to be altered to InnoDB.

SELECT CONCAT(‘ALTER TABLE ‘, TABLE_SCHEMA,’.’,TABLE_NAME, ‘ ENGINE = InnoDB;’)

FROM information_schema.TABLES

WHERE ENGINE=’MyISAM’

AND TABLE_SCHEMA NOT IN(‘mysql’,’information_schema’,’performance_schema’)

5. Select dropdown to show 500 rows and then Click the “+Options” link above the results, choose the “Full texts” option, and press the “Go” button in the shaded area at the lower right

**IMPORTANT** Due to the number of databases and tables, you will have to repeat steps 1-10 till step 4 produces 0 results other than the mysql database results as they will not be converted due to permissions.

6. Select the “Show all” checkbox

7. Copy all the output results which will look similar to the results produced using the above single database query output but have the database.table instead of just the table

8. Paste the result into a text editor to see the full output and copy all the lines STARTING with “ALTER TABLE” to your clipboard, they will look like the example below.

In this example, since you are doing an SQL query on all your databases, the ALTER TABLE strings will look slightly different

ALTER TABLE user_database.wp_commentmeta ENGINE=InnoDB;            

ALTER TABLE user_database.wp_comments ENGINE=InnoDB;    

ALTER TABLE user_database.wp_links ENGINE=InnoDB;

If in your text editor you notice the output has spaces between some query’s, remove the spaces

ALTER TABLE user_database.wp_commentmeta ENGINE=InnoDB;            

ALTER TABLE user_database.wp_comments ENGINE=InnoDB;

ALTER TABLE user_database.wp_links ENGINE=InnoDB;

Should look like

ALTER TABLE user_database.wp_commentmeta ENGINE=InnoDB;            

ALTER TABLE user_database.wp_comments ENGINE=InnoDB;    

ALTER TABLE user_database.wp_links ENGINE=InnoDB;

9. Again, Click the SQL tab above the results

10. Paste the ALTER TABLE statements into the textarea and press the “Go” button in the lower right shaded area, there will be a pause, depending on how many databases and tables are getting converted, it can take a few minutes to complete

To confirm all your databases were successfully converted other than the mysql database, click eack of your database names in the left column, and all table types should now say InnoDB except for some tables in the mysql database.

All Database Conversion From MyISAM to InnoDB using an SSH client:

1. LOGIN TO ROOT SERVER USING YOUR SSH CLIENT, I USE PUTTY

user: root

Root Password: password

[root@server ~]#

“You will need your MySQL password for step #3” “If you know your MySQL password, continue to step #3, if not, go to next step

On servers running cPanel, the root MySQL credentials are stored locally in a file that only the root user can access. You can open the file using an explorer client like WinSCP or by connecting to root via SSH like in step #1.

By running the command in #2 “cat /root/.my.cnf”, you can view the MySQL credentials

2. [root@server1 ~]# cat /root/.my.cnf

That should output a result containing the MySQL password, which will appear similar to the following:

[root@server1 ~]# cat /root/.my.cnf

[client]

user=root

password=”password123456789″

Make a note of the current password that shows between the quotations on your output

3. LOGIN TO MYSQL

[root@server1 ~]# mysql -u root -p

Enter password: “enter the password you received from step #2”

4. at the command line: mysql>

you will need to enter: SELECT CONCAT(‘ALTER TABLE ‘,TABLE_NAME,’ ENGINE=InnoDB;’)FROM INFORMATION_SCHEMA.TABLES;

example:

mysql> SELECT CONCAT(‘ALTER TABLE ‘,TABLE_NAME,’ ENGINE=InnoDB;’)FROM INFORMATION_SCHEMA.TABLES;

5. Press enter and all done if executed properly

This query will produce output similar to what’s below. Note this is just an example which will show output for all the databases and tables.

+——————————————————————————-+

| CONCAT(‘ALTER TABLE ‘,TABLE_NAME,’ ENGINE=InnoDB;’)

+——————————————————————————-+

| alter table CHARACTER_SETS engine=INNODB;

| alter table COLLATIONS engine=INNODB;

| alter table COLUMN_PRIVILEGES engine=INNODB;

| alter table ENGINES engine=INNODB;

| alter table EVENTS engine=INNODB;

| alter table COLLATION_CHARACTER_SET_APPLICABILITY engine=INNODB;

| alter table COLUMNS engine=INNODB;

| alter table FILES engine=INNODB;

| alter table GLOBAL_STATUS engine=INNODB;

| alter table GLOBAL_VARIABLES engine=INNODB;

| alter table KEY_COLUMN_USAGE engine=INNODB;

| alter table OPTIMIZER_TRACE engine=INNODB;

| alter table PARAMETERS engine=INNODB;

**NOTE** If you want to change engines of a specific database instead of all databases then execute the below query.

mysql> SELECT CONCAT(‘ALTER TABLE ‘,TABLE_NAME,’ ENGINE=InnoDB;’)FROM INFORMATION_SCHEMA.TABLES; WHERE TABLE_SCHEMA=’database name’;

Press enter and all done if executed properly

I know this tutorial seems repetitive in some areas depending on your skill level. The tutorial was written to help even the unskilled succeed in the conversion.

If something was missed or you see an in accuracy, please let me know in the comments below. I wrote this tutorial while actually doing each step to ensure accuracy but could have a mistype.

Written by: Joe Lovrek

uninstalling Mobileiron app on Android


I get this question all the time and its fairly easy. First thing you have to understand is that you gave the app permissions when you installed it to be an administrator.  You have to revoke administrator privledges before you can uninstall the app.

 

Go to Settings

“Lock screen and security” or some phones have it labeled as “Location & Security”

Look for “Device administrators”, if its not there, go to “Other security settings””Select device administrators”

Once you find “Device administrators or administrators, click on it and remove or un check “MobileIron”

 

Now you can back out and uninstall it in your apps.