FrontAccounting forum — Replicating data for test environment

Re: Replicating data for test environment

2014-05-23T22:17:02Z

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

2014-05-21T14:34:31Z

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

2014-05-21T14:00:22Z

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

2014-04-05T16:10:40Z

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

2014-04-05T16:04:10Z

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.