{"id":34690,"date":"2022-01-05T18:22:36","date_gmt":"2022-01-05T18:22:36","guid":{"rendered":"https:\/\/www.hostduplex.com\/kb\/?post_type=ht_kb&#038;p=34690"},"modified":"2022-01-05T18:22:36","modified_gmt":"2022-01-05T18:22:36","slug":"how-to-change-mysql-table-name-in-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/www.hostduplex.com\/kb\/article\/how-to-change-mysql-table-name-in-phpmyadmin\/","title":{"rendered":"How to change mySQL table name in phpMyAdmin"},"content":{"rendered":"\n<p>1. Log in to your cPanel account<\/p>\n\n\n\n<p>2. Click on phpMyAdmin. You can find it by using the search bar or by scrolling to the Databases section<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"454\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-1024x454.png\" alt=\"\" class=\"wp-image-34691\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-1024x454.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-300x133.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-768x340.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-50x22.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-1536x681.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-60x27.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1-100x44.png 100w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1.png 1852w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Navigate to the database containing the table you want to modify and click on the SQL tab at the top<\/p>\n\n\n\n<p>4. Type in the following statement:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE old_table_name RENAME TO new_table_name<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-1024x332.png\" alt=\"\" class=\"wp-image-34692\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-1024x332.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-300x97.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-768x249.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-50x16.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-1536x498.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-2048x664.png 2048w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-60x19.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.00-PM-100x32.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>5. Click on the Go button. You will see the below message and your updated table name:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"257\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-1024x257.png\" alt=\"\" class=\"wp-image-34693\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-1024x257.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-300x75.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-768x193.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-50x13.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-1536x385.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-2048x514.png 2048w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-60x15.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.27.08-PM-100x25.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-background has-purple-background-color has-purple-color is-style-dots\"\/>\n\n\n\n<p><meta charset=\"utf-8\">If you are a Host Duplex customer and still have questions, please open a ticket in the\u00a0<a href=\"https:\/\/secure.hostduplex.com\/clientarea.php\" target=\"_blank\" rel=\"noopener\">Host Duplex client portal.<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log in to your cPanel account 2. Click on phpMyAdmin. You can find it by using the search bar or by scrolling to the Databases section 3. Navigate to the database containing the table you want to modify and click on the SQL tab at the top 4. Type&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[20],"ht-kb-tag":[23,255,139,253],"class_list":["post-34690","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel","ht_kb_tag-cpanel","ht_kb_tag-databses","ht_kb_tag-mysql","ht_kb_tag-queries"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=34690"}],"version-history":[{"count":1,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34690\/revisions"}],"predecessor-version":[{"id":34694,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34690\/revisions\/34694"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=34690"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=34690"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=34690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}