Moving to another server as a template for a new site

[keneb]

Hi

I have a live Zencart site (latest Zencart version) and have a question about moving it to another server to use it as a template for a new site.

I have read extensively on the forum and Tutorials/FAQ and am fairly confident that I will be able to follow the instructions on moving the site.

The existing site has a DB_prefix that is unrelated to the subject matter of the new site and i cannot find insttructions on how to change the DB_prefix.

The instructions for moving a Zencart site clearly state that the DB_prefix of the source and destination site must be the same.

Would I have to move the site, then change the DB_prefix? Would it be matter of creating a new database, then deleting the old one.

I did many changes to the classic template including adding the zones shipping module, so it would be much quicker starting with this as a base for the new website. When it is working I will merely delete the products and then do further changes.

Theroretically it would not matter that the DB_prefix is cushjons and the new website is about about movies, but that is just not professional.

So, is it easy to change the DB-prefix?

[Vger]

Take a backup of your existing database and open in a plain text edtor like PS Pad or Text Pad and use the "Find and Replace" feature. Tell it to look for all instances of cushjons_ in the Find box and leave the Replace box empty. It will then remove all prefixes from every database table. Save it after edting and Import it into the new and empty db using phpMyAdmin.

Vger

[keneb]

Vger, thanks for the prompt response. I will try your suggestion.

[Z3NN3D]

The cushjons_ prefix would normally only be in the filename of a database dump taken from PhpMyAdmin, not in the MySql statements inside the file.
If any prefixes exist in the sql file itself, they are likely to be zen_ Example: zen_admin , zen_address_book etc.

[keneb]

Hi, thanks for the responses. However I do not know how to proceed. The database dump is in compacted format, so cannot edit that.

Can the DB-prefix be changed after I move the Zencart installation to a different server. I would really appreciate some help on how to do that?

[keneb]

Apologies, it is not DB_prefix that I want to change but
DB_SERVER_USERNAME', 'cushions_xxxx'); and define('DB_DATABASE', 'cushions_XXXX').

I know how to change this in the config files, but not the database side.

I want to change cushions to movies

[Vger]

The cushjons_ prefix would normally only be in the filename of a database dump taken from PhpMyAdmin, not in the MySql statements inside the file.

Well, that's nonsense. Each table would have the prefix in the dump of the db.

Apologies, it is not DB_prefix that I want to change but
DB_SERVER_USERNAME', 'cushions_xxxx'); and define('DB_DATABASE', 'cushions_XXXX').

I know how to change this in the config files, but not the database side.

You don't have to change it in the db, only in the two configure.php files.

Vger

[keneb]

Thanks Vger