{"id":4831,"date":"2018-07-12T04:06:32","date_gmt":"2018-07-12T09:06:32","guid":{"rendered":"https:\/\/secure.rosehosting.com\/blog\/?p=4831"},"modified":"2022-12-29T10:54:54","modified_gmt":"2022-12-29T16:54:54","slug":"basic-mysql-database-administration-on-linux-vps-part-2","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/","title":{"rendered":"Basic MySQL Database Administration on Linux VPS – Part 2"},"content":{"rendered":"
<\/div>

\"Basic<\/p>\n

In this tutorial, we will show you how to insert into and manipulate data in your tables. To find out how to create and manage databases and tables you can check out our previous tutorial: Basic MySQL database administration on a Linux VPS<\/a>. If your Linux VPS<\/a> is up and running and has MySQL installed, then you are good to go.<\/p>\n

<\/p>\n

One of the most essential database administration tasks is to insert data into your tables. To do this, you’ll need to log in to your Linux VPS<\/a> via SSH, log into your MySQL database server as described in the previous tutorial<\/a>, and use the correct database. To insert data into your tables, you will need to make sure that you are entering all information for its corresponding column. If you have followed our previous tutorial<\/a>, you created the ‘test_table’ table in your ‘test’ database by using the command:<\/p>\n

CREATE TABLE test_table (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(30) NOT NULL, comment VARCHAR (100));<\/pre>\n

You can enter data using the ‘INSERT INTO’ command. Here are two example entries:<\/p>\n

INSERT INTO test_table (name,comment) VALUES (\"Jim\",\"Sample comment\");\r\nINSERT INTO test_table (name,comment) VALUES (\"John\",\"Another comment\");<\/pre>\n

Now, if you execute the command:<\/p>\n

SELECT * FROM test_table;<\/pre>\n

You will see something like this:<\/p>\n

mysql> SELECT * FROM test_table;\r\n+----+------+-----------------+\r\n| id | name | comment         |\r\n+----+------+-----------------+\r\n|  1 | Jim  | Sample comment  |\r\n|  2 | John | Another comment |\r\n+----+------+-----------------+<\/pre>\n

In normal circumstances, you will eventually need to update the data entries in your tables. To update entries, you can use the UPDATE and SET commands. Here’s an example:<\/p>\n

UPDATE test_table SET comment=\"New comment\" WHERE name=\"Jim\";<\/pre>\n

To see the result, run:<\/p>\n

SELECT * FROM test_table;<\/pre>\n

This is the result:<\/p>\n

mysql> SELECT * FROM test_table;\r\n+----+------+-----------------+\r\n| id | name | comment         |\r\n+----+------+-----------------+\r\n|  1 | Jim  | New comment     |\r\n|  2 | John | Another comment |\r\n+----+------+-----------------+<\/pre>\n

Sometimes you may want to delete a record in your tables. You can do that using the DELETE command:<\/p>\n

DELETE FROM test_table WHERE name=\"John\";<\/pre>\n

Execute this to check the changes:<\/p>\n

SELECT * FROM test_table;<\/pre>\n
mysql> SELECT * FROM test_table;\r\n+----+------+-------------+\r\n| id | name | comment     |\r\n+----+------+-------------+\r\n|  1 | Jim  | New comment |\r\n+----+------+-------------+<\/pre>\n

One of the most useful commands in MySQL is ‘ALTER TABLE’. This command can be used to add, modify or delete columns in your tables. Here are some examples:<\/p>\n

To add a new column to your ‘test_table’ you can use:<\/p>\n

ALTER TABLE test_table ADD age INT;<\/pre>\n

This is the result:<\/p>\n

mysql> SELECT * FROM test_table;\r\n+----+------+-------------+------+\r\n| id | name | comment     | age  |\r\n+----+------+-------------+------+\r\n|  1 | Jim  | New comment | NULL |\r\n+----+------+-------------+------+\r\n<\/pre>\n

The age column for ‘Jim’ is null because no age value has been set.<\/p>\n

To delete a column from your table you can use:<\/p>\n

ALTER TABLE test_table DROP COLUMN age;<\/pre>\n

This is the result:<\/p>\n

mysql> SELECT * FROM test_table;\r\n+----+------+-------------+\r\n| id | name | comment     |\r\n+----+------+-------------+\r\n|  1 | Jim  | New comment |\r\n+----+------+-------------+\r\n<\/pre>\n

And if you like to modify a certain column, for example you want to change the data type, you can use:<\/p>\n

ALTER TABLE test_table MODIFY COLUMN comment INT;<\/pre>\n

This sets the ‘comment’ column to be of the integer type. Here is the result:<\/p>\n

mysql> SELECT * FROM test_table;\r\n+----+------+---------+\r\n| id | name | comment |\r\n+----+------+---------+\r\n|  1 | Jim  |       0 |\r\n+----+------+---------+\r\n<\/pre>\n

These are some of the most essential and useful commands to insert and manipulate data in MySQL on your Linux VPS. Of course, it goes without saying that if you are a database administrator, these are rather basic commands – you will need to look into more advanced commands. For that, you can use the Internet, which has many useful tutorials written by MySQL experts.<\/p>\n


\n

Of course, you don\u2019t have to do any of this if you use one of our MySQL VPS hosting<\/a> services, in which case you can simply ask our expert Linux admins to do this for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n

PS<\/span>. If you liked this post, please share it with your friends on the social networks using the buttons below, or simply leave a comment. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this tutorial, we will show you how to insert into and manipulate data in your tables. To find out … <\/p>\n

Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":27481,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,21],"tags":[576,577,578],"yoast_head":"\nBasic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting<\/title>\n<meta name=\"description\" content=\"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-12T09:06:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-29T16:54:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"371\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"Basic MySQL Database Administration on Linux VPS – Part 2\",\"datePublished\":\"2018-07-12T09:06:32+00:00\",\"dateModified\":\"2022-12-29T16:54:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\"},\"wordCount\":498,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg\",\"keywords\":[\"Basic MySQL administration\",\"MySQL administration on Linux VPS\",\"MySQL Linux VPS\"],\"articleSection\":[\"Databases\",\"Tips and Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\",\"name\":\"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg\",\"datePublished\":\"2018-07-12T09:06:32+00:00\",\"dateModified\":\"2022-12-29T16:54:54+00:00\",\"description\":\"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg\",\"width\":742,\"height\":371,\"caption\":\"Basic MySQL Database Administration on Linux VPS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Basic MySQL Database Administration on Linux VPS – Part 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","description":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","og_description":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2018-07-12T09:06:32+00:00","article_modified_time":"2022-12-29T16:54:54+00:00","og_image":[{"width":742,"height":371,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"Basic MySQL Database Administration on Linux VPS – Part 2","datePublished":"2018-07-12T09:06:32+00:00","dateModified":"2022-12-29T16:54:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/"},"wordCount":498,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg","keywords":["Basic MySQL administration","MySQL administration on Linux VPS","MySQL Linux VPS"],"articleSection":["Databases","Tips and Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/","url":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/","name":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg","datePublished":"2018-07-12T09:06:32+00:00","dateModified":"2022-12-29T16:54:54+00:00","description":"Basic MySQL Database Administration on Linux VPS - Part 2 - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Basic-MySQL-Database-Administration-on-Linux-VPS.jpg","width":742,"height":371,"caption":"Basic MySQL Database Administration on Linux VPS"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/basic-mysql-database-administration-on-linux-vps-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Basic MySQL Database Administration on Linux VPS – Part 2"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/4831"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=4831"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/4831\/revisions"}],"predecessor-version":[{"id":42639,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/4831\/revisions\/42639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/27481"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=4831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=4831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=4831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}