{"id":29888,"date":"2021-01-17T18:44:49","date_gmt":"2021-01-17T10:44:49","guid":{"rendered":"https:\/\/web.mwwsb.com.my\/pjci\/?post_type=kb&#038;p=29888"},"modified":"2022-09-07T18:52:57","modified_gmt":"2022-09-07T10:52:57","slug":"how-to-rename-a-table-in-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.casbay.com\/guide\/kb\/how-to-rename-a-table-in-phpmyadmin","title":{"rendered":"HOW TO: Rename a table in phpMyAdmin"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"29888\" class=\"elementor elementor-29888\" data-elementor-post-type=\"kb\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89cbeda elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89cbeda\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d6eba3\" data-id=\"2d6eba3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-24de10a elementor-widget elementor-widget-heading\" data-id=\"24de10a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">HOW TO: Rename a table in phpMyAdmin<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc16769 elementor-widget elementor-widget-text-editor\" data-id=\"dc16769\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>It\u2019s very easy to rename a table in phpMyAdmin. To do so, simply follow these steps:<\/p><ol><li>Firstly, log in to cPanel.<\/li><li>From the\u00a0<strong>Databases<\/strong>\u00a0section, click on the\u00a0<strong>phpMyAdmin<\/strong>\u00a0icon.<\/li><li>In the narrow left column, select the database containing the table you wish to rename. The screen will refresh with all of the tables found in that database.<\/li><li>Then, click on the table you wish to rename; the screen will refresh with the selected tables\u2019 information.<\/li><li>After that, click on the <strong>Operations<\/strong>\u00a0tab found on the top right; the screen will refresh again.<\/li><li>In the\u00a0<strong>Table options<\/strong>\u00a0group, type a new name for the table in the\u00a0<strong>Rename table<\/strong>\u00a0to field.<\/li><li>Lastly, click the <strong>Go<\/strong>\u00a0button in the lower right and the table will be renamed.<\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-830ce0d elementor-widget elementor-widget-heading\" data-id=\"830ce0d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Database Operations<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b62e03 elementor-widget elementor-widget-text-editor\" data-id=\"0b62e03\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>First, open the\u00a0<strong>phpMyAdmin<\/strong> tool, then go to the <strong>Databases<\/strong>\u00a0tab. Select a database and navigate to the\u00a0<strong>Operations<\/strong>\u00a0tab. A new page opens on which you can find all the possible operations which you can use on a database.<\/p><figure><\/figure><p>The first section is <strong>Create table<\/strong>. It allows you to create a new table under the current database. Enter the table name and the number of the fields. Then click on\u00a0<strong>Go<\/strong> to start the creation of the new table.\u00a0<\/p><p>The second section is <strong>Rename database to<\/strong>. Renaming a database cannot be performed directly through the phpMyAdmin area due to lack of privileges for the user. If you want to rename the database, you should\u00a0<a title=\"Create a New MySQL Database\" href=\"https:\/\/www.casbay.com\/guide\/kb\/how-to-create-mysql-database\/\" target=\"_blank\" rel=\"noopener noreferrer\">create a new MySQL database<\/a>,\u00a0<a title=\"Export and Import MySQL Database\" href=\"https:\/\/www.casbay.com\/guide\/kb\/how-to-import-export-a-mysql-database-using-cpanel-phpmyadmin\/\" target=\"_blank\" rel=\"noopener noreferrer\">export the database tables and import them<\/a> in the new one. Then you should delete the old database.<\/p><p>The same is the case with the\u00a0<strong>Copy database to<\/strong>\u00a0section. The difference with the above one is that you should not delete the source database.<\/p><p>The last section allows you to change the database\u00a0<strong>Collation<\/strong>. Pick the preferred one from the drop-down menu and confirm the modification by clicking on\u00a0<strong>Go<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2165059 elementor-widget elementor-widget-heading\" data-id=\"2165059\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Database Table Operations<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16ce40f elementor-widget elementor-widget-text-editor\" data-id=\"16ce40f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To perform the corresponding operations on a database table, you should select the desired table in phpMyAdmin and click on the\u00a0<strong>Operations<\/strong>\u00a0tab.<\/p><figure><\/figure><p>The\u00a0<strong>Move table to<\/strong>\u00a0section allows you to move the table with a new name under the current database or to move it under a different database.<\/p><p>In the\u00a0<strong>Table options<\/strong>\u00a0section, you can rename the table, insert comments, change the storage engine and the collation.<\/p><p>Using the\u00a0<strong>Copy table to<\/strong>\u00a0section you can copy the table with a new name under the current database or it can be duplicated in another database.<\/p><p>Under the\u00a0<strong>Table Maintenance<\/strong>\u00a0section you will find different options which will help you to maintain your database table:<\/p><ul><li><strong>Analyze table<\/strong>\u00a0\u2013 analyses and stores the key distribution for the table. Then the MySQL server uses the stored key distribution for JOIN operations and for decisions which index to be used in a table query;<\/li><li><strong>Check table<\/strong>\u00a0\u2013 checks the table and the views associated with it for errors and problems;<\/li><li><strong>Repair table<\/strong>\u00a0\u2013 repairs a possibly corrupted table;<\/li><li><strong>Optimize table<\/strong> \u2013 the action should be performed when you delete or modify many records from the table. It will reclaim the used space, defragment the data file removing the overhead and sort the indexes.\u00a0<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>HOW TO: Rename a table in phpMyAdmin It\u2019s very easy to rename a table in phpMyAdmin. To do so, simply follow these steps: Firstly, log in to cPanel. From the\u00a0Databases\u00a0section, click on the\u00a0phpMyAdmin\u00a0icon. In the narrow left column, select the database containing the table you wish to rename. The screen will refresh with all of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[],"kbtag":[106],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/29888"}],"collection":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/comments?post=29888"}],"version-history":[{"count":1,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/29888\/revisions"}],"predecessor-version":[{"id":31700,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kb\/29888\/revisions\/31700"}],"wp:attachment":[{"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/media?parent=29888"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=29888"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/kbtag?post=29888"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.casbay.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=29888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}