{"id":534,"date":"2019-02-27T07:16:46","date_gmt":"2019-02-27T07:16:46","guid":{"rendered":"https:\/\/shujaahost.co.ke\/blog\/?p=534"},"modified":"2019-02-27T07:19:12","modified_gmt":"2019-02-27T07:19:12","slug":"how-to-rename-tables-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/","title":{"rendered":"How to rename tables in phpMyAdmin"},"content":{"rendered":"\n
  1. Start by logging into your cPanel<\/a>.<\/li>
  2. Scroll down to DATABASES <\/strong>section then click on phpMyAdmin.<\/li>
  3. From the left navigation tree in phpMyAdmin select database with table that you wish to rename.<\/li>
  4. Click the table that you want to rename.<\/li>
  5. Click the Operations tab at the top.<\/li>
  6. Locate Table options section,<\/strong> and in the Rename table to field, type the new table name.<\/li><\/ol>\n\n\n\n

    You now know how to rename tables in phpMyAdmin. Renaming tables doe not delete or modify your data thus nothing to worry about.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Start by logging into your cPanel. Scroll down to DATABASES section then click on phpMyAdmin. From the left navigation tree in phpMyAdmin select database with table that you wish to rename. Click the table that you want to rename. Click the Operations tab at the top. Locate Table options section, and in the Rename table ..<\/p>\n

    <\/div>\n

    Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-534","post","type-post","status-publish","format-standard","hentry","category-databases"],"yoast_head":"\nHow to rename tables in phpMyAdmin - Shujaa Host<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to rename tables in phpMyAdmin - Shujaa Host\" \/>\n<meta property=\"og:description\" content=\"Start by logging into your cPanel. Scroll down to DATABASES section then click on phpMyAdmin. From the left navigation tree in phpMyAdmin select database with table that you wish to rename. Click the table that you want to rename. Click the Operations tab at the top. Locate Table options section, and in the Rename table ..Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Shujaa Host\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/shujaahostKenya\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-27T07:16:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-27T07:19:12+00:00\" \/>\n<meta name=\"author\" content=\"Cosmas Korir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:site\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cosmas Korir\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\"},\"author\":{\"name\":\"Cosmas Korir\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\"},\"headline\":\"How to rename tables in phpMyAdmin\",\"datePublished\":\"2019-02-27T07:16:46+00:00\",\"dateModified\":\"2019-02-27T07:19:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\"},\"wordCount\":91,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\",\"name\":\"How to rename tables in phpMyAdmin - Shujaa Host\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\"},\"datePublished\":\"2019-02-27T07:16:46+00:00\",\"dateModified\":\"2019-02-27T07:19:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/shujaahost.co.ke\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to rename tables in phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"name\":\"Shujaa Host\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\",\"name\":\"Shujaa Host\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"contentUrl\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"width\":911,\"height\":770,\"caption\":\"Shujaa Host\"},\"image\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/shujaahostKenya\/\",\"https:\/\/x.com\/shujaahost_ke\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\",\"name\":\"Cosmas Korir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"caption\":\"Cosmas Korir\"},\"sameAs\":[\"https:\/\/shujaahost.co.ke\"],\"url\":\"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to rename tables in phpMyAdmin - Shujaa Host","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:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to rename tables in phpMyAdmin - Shujaa Host","og_description":"Start by logging into your cPanel. Scroll down to DATABASES section then click on phpMyAdmin. From the left navigation tree in phpMyAdmin select database with table that you wish to rename. Click the table that you want to rename. Click the Operations tab at the top. Locate Table options section, and in the Rename table ..Read more","og_url":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/","og_site_name":"Shujaa Host","article_publisher":"https:\/\/www.facebook.com\/shujaahostKenya\/","article_published_time":"2019-02-27T07:16:46+00:00","article_modified_time":"2019-02-27T07:19:12+00:00","author":"Cosmas Korir","twitter_card":"summary_large_image","twitter_creator":"@shujaahost_ke","twitter_site":"@shujaahost_ke","twitter_misc":{"Written by":"Cosmas Korir"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/"},"author":{"name":"Cosmas Korir","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59"},"headline":"How to rename tables in phpMyAdmin","datePublished":"2019-02-27T07:16:46+00:00","dateModified":"2019-02-27T07:19:12+00:00","mainEntityOfPage":{"@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/"},"wordCount":91,"commentCount":0,"publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/","url":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/","name":"How to rename tables in phpMyAdmin - Shujaa Host","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#website"},"datePublished":"2019-02-27T07:16:46+00:00","dateModified":"2019-02-27T07:19:12+00:00","breadcrumb":{"@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/shujaahost.co.ke\/blog\/how-to-rename-tables-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/shujaahost.co.ke\/blog\/"},{"@type":"ListItem","position":2,"name":"How to rename tables in phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/shujaahost.co.ke\/blog\/#website","url":"https:\/\/shujaahost.co.ke\/blog\/","name":"Shujaa Host","description":"","publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/shujaahost.co.ke\/blog\/#organization","name":"Shujaa Host","url":"https:\/\/shujaahost.co.ke\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","contentUrl":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","width":911,"height":770,"caption":"Shujaa Host"},"image":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/shujaahostKenya\/","https:\/\/x.com\/shujaahost_ke"]},{"@type":"Person","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59","name":"Cosmas Korir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","caption":"Cosmas Korir"},"sameAs":["https:\/\/shujaahost.co.ke"],"url":"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/"}]}},"_links":{"self":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":2,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":536,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions\/536"}],"wp:attachment":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}