Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/d/e/d/dedic83d/html/includes/joomla.php on line 2826

Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/d/e/d/dedic83d/html/includes/joomla.php on line 2927

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/includes/joomla.php on line 699

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/index.php on line 226

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/index.php on line 227

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/index.php on line 228

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/index.php on line 229

Warning: Cannot modify header information - headers already sent by (output started at /home/content/d/e/d/dedic83d/html/includes/joomla.php:2826) in /home/content/d/e/d/dedic83d/html/index.php on line 230
UNLIMITED DYNAMICS - WEB | PHOTO | WRITE | DESIGN - How To Change A MySQL Table Name Using phpMyAdmin
Advertisement
How To Change A MySQL Table Name Using phpMyAdmin
Software - MySQL phpMyAdmin
Wednesday, 25 July 2007

If you, as a database administator (DBA), are looking to change an existing MySQL database table name, using phpMyAdmin, the operation is quite simple and requires a simple command. Open up your MySQL phpMyAdmin for the database in question. Select the database you desire to modify. Click the SQL tab. In the query (queries) window that appears, past in the code seen below, changing the names between the parenthesis to reflect the desired tables and table names. Then press "Go" in order to run the query. 

RENAME TABLE (insert existing table name) TO (new table name); 

It is a good idea to make a backup prior to modifying the database. This way, if there is a problem, you can restore the previous MySQL database to normal. It is also a good idea to inform any applicable users and shut down any applications using the tables. In this case, I was modifying a website database to import the latest off-road events calendar onto an e-commerce website. Since the database table name was from an old install of the events calendar, I had to modify it to reflect the latest install.

MEDIA TAGS:  mysql phpmyadmin php sql dba rename table name tables query queries
 
NEXT >
Fix The Virtuemart Cookie Check &vmcchk=1 Error Warning And Redundant SEF URLs

The cookie session check in Virtuemart E-Commerce Shopping Cart Software Component within the Joomla Content Management System (CMS) may serve a purpose but creates some...
+ THE COMPLETE STORY

VirtueMart Category Browse Page And Product Flypage Tags List

The Virtuemart E-Commerce Shopping Cart software solution offers two primary pages within its product category and product page structure. Within the Virtuemart product...
+ THE COMPLETE STORY

Joomla / Mambo Templates Front End Preview Module Positions URL index.php?tp=1

When developing or modifying custom Joomla Templates, Mambo Templates and Virtuemart Templates, being able to quickly referece the various module positions available...
+ THE COMPLETE STORY

UNLIMITED DYNAMICS Web Site Template Design Complete

After diligently tending to the demanding surge of new and on-going client projects throughout the months of September and October, the UNLIMITED DYNAMICS.com website...
+ THE COMPLETE STORY

MORE UNLIMITED NEWS

WEB SITE DESIGNERS / DEVELOPERS -- E-COMMERCE | SHOPPING CARTS | ONLINE STORES | PORTALS | CONTENT MANAGEMENT SYSTEMS | CMS | BLOGS | SOFTWARE | PHOTO GALLERIES
JOOMLA | DRUPAL | VIRTUEMART | WIKI | GALLERY2 | MAMBO | PHP-NUKE | MYSQL | SMF | phpBB | vBULLETIN | XOOPS | WORDPRESS | b2EVOLUTION | osCOMMERCE | ZEN CART | COPPERMINE
PHOTOGRAPHY / PHOTOGRAPHERS / PHOTOJOURNALISTS -- PORTRAITS | PRODUCT | PHOTOJOURNALISM | EVENT | LOCATION SCOUTS | MOTORSPORTS | ARCHITECTURE | AERIAL | WEDDING
COPY WRITING / WRITERS -- PRESS RELEASES | SLOGANS | PRODUCT RELEASES | ADVERTISING | TECHNICAL | FEATURES | NEWS | SYNDICATION | EDITORIAL | NEWSLETTERS | CATALOG | SEO
PRIMARY LOCATIONS -- HESPERIA | APPLE VALLEY | VICTORVILLE | PHELAN | HIGH DESERT | ONTARIO | RANCHO CUCAMUNGA | INLAND EMPIRE | SAN GABRIEL VALLEY | PASADENA
LOS ANGELES COUNTY | RIVERSIDE COUNTY | VENTURA COUNTY | SOUTHERN CALIFORNIA | NEW MEXICO | COLORADO | BAJA CALIFORNIA | NEVADA | MOUNTAINS | DESERTS
OFF-ROAD | POWERSPORTS | UTV | ATV | QUAD | SIDE-X-SIDE | DIRT BIKE | STREET BIKE MOTORCYCLE | 4X4 | ROCK CRAWLING | ROCK CRAWLER | PRERUNNER | TRANSAMERICAN WHOLESALE
| KEYSTONE AUTOMOTIVE | TUCKER ROCKY | PARTS UNLIMITED | 4WD | 4 WHEEL PARTS | FOUR WHEELER
WEDJ