changing the database table name

[lcshunter]

hi there , i well like to ask that is there any possible way that i can change the database table name such as (skuo_virtuemart_category) using a tool or software because just changing the database table name manually well cause the system to crash unless i have to manually change all the table name at the coding part and may lead to miss out of the name in the code

[PRO]

hi there , i well like to ask that is there any possible way that i can change the database table name such as (skuo_virtuemart_category) using a tool or software because just changing the database table name manually well cause the system to crash unless i have to manually change all the table name at the coding part and may lead to miss out of the name in the code

export database


create new database under new name

IMport database into new one

THEN: You "should" be able to change it in joomla global configuration

TEST THIS first

[WebStuff]

If you mean the table prefix then AKEEBA "Admin Tools" component can do this. It's available at http://extensions.joomla.org/search?q=admin+tools

[lcshunter]

i mean the database table name such as show in red box at the picture, so is there any way to chance it without needed to edit the source code manually because it is easy to corrupt everything

[attachment cleanup by admin]

[PRO]

lcshunter,

what are you trying to do?

[lcshunter]

i well like to change the table name in the database. as example the table name in the red box

[PRO]

i well like to change the table name in the database. as example the table name in the red box

what are you trying to accomplish?

why?

[lcshunter]

i want to have a shorter table name and i well be more familiar to the database