VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: lcshunter on November 01, 2012, 14:04:07 PM

Title: changing the database table name
Post by: lcshunter on November 01, 2012, 14:04:07 PM
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
Title: Re: changing the database table name
Post by: PRO on November 01, 2012, 14:10:23 PM
Quote from: lcshunter on November 01, 2012, 14:04:07 PM
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
Title: Re: changing the database table name
Post by: WebStuff on November 06, 2012, 19:27:05 PM
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
Title: Re: changing the database table name
Post by: lcshunter on November 06, 2012, 19:47:41 PM
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]
Title: Re: changing the database table name
Post by: PRO on November 06, 2012, 19:55:33 PM
lcshunter,

what are you trying to do?

Title: Re: changing the database table name
Post by: lcshunter on November 11, 2012, 06:16:50 AM
i well like to change the table name in the database. as example the table name in the red box
Title: Re: changing the database table name
Post by: PRO on November 11, 2012, 19:05:24 PM
Quote from: lcshunter on November 11, 2012, 06:16:50 AM
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?

Title: Re: changing the database table name
Post by: lcshunter on November 12, 2012, 10:00:15 AM
i want to have a shorter table name and i well be more familiar to the database