• From: Saudi Arabia, Jeddah
  • Registered: 12/12/2017
  • Posts: 43

Topic: database

Hi All
  i try to download database 1 for company 1 and upload it to another company but it is not work

example
i created 2 companies company1 company2  i want to put backup company 1 database in company 2 for testing
company1 has Table Pref _0  company to has Table Pref _1 is this make problem? if yes how i can change the Table Pref?

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: database

Change all occurrences of 0_ or 1_ to 2_ or what ever number company you want to restore to...

You need to read about database prefix's

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: database

If you have different databases for each company, then there is no need to change the table prefix. Just put in the correct prefix into the company_db.inc file for the specific company's array element before usage.

apmuthu's Website