FrontAccounting forum — Replicating data for test environment

Re: Replicating data for test environment

null@example.com (pinoyaccountant) — Fri, 23 May 2014 22:17:02 +0000

joe wrote:

If you have any table prefix it is in fromt of the table names in the .sql file.
If you need to change this into Another number, then use a texteditor.
/Joe

Hi Joe,

Sorry tried i cannot find it, too many codes there, wisc you can show me where to find it? it's not in the filename right?

Thanks more power

Eve

Re: Replicating data for test environment

null@example.com (joe) — Wed, 21 May 2014 14:34:31 +0000

If you have any table prefix it is in fromt of the table names in the .sql file.

If you need to change this into Another number, then use a texteditor.

/Joe

Re: Replicating data for test environment

null@example.com (pinoyaccountant) — Wed, 21 May 2014 14:00:22 +0000

joe wrote:

Create a backup file. Take this file into a text editor replace the table prefix, X_, where X is your company number, with the new table prefix for your test company. Use this file to be restored on your test company.
Joe

Hi Joe,

Where can i exactly find the prefix X_, how many are they? sorry for the question.

I have already a backup of my test company and i want to transfer that data to final location.

Regards from Philippines,

Thanks.

Eve

Re: Replicating data for test environment

null@example.com (joe) — Sat, 05 Apr 2014 16:10:40 +0000

Create a backup file. Take this file into a text editor replace the table prefix, X_, where X is your company number, with the new table prefix for your test company. Use this file to be restored on your test company.

Joe

Replicating data for test environment

null@example.com (geo77) — Sat, 05 Apr 2014 16:04:10 +0000

Hello all,

I would like to copy the data in my production system to a dummy company I created. How can I accomplish this? what tables do I need to copy ? how can I accomplish this easily?

Thanks for any help.