FrontAccounting forum — Removing the database entries from backend (phpMyAdmin)

Re: Removing the database entries from backend (phpMyAdmin)

2012-03-22T08:04:09Z

Thanks thanks thanks a lot, Joe.

You great... Proud...

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

2012-03-22T07:52:17Z

COA = Chart of Accounts. This is a name for the scripts, f.i. en_US-new.sql that is included in FA. Look in the /sql folder.
The en_US-new.sql script is a COA for a new US company with only the needed data inside it. Use this COA as a model when creating your own from a backup.

/Joe

Re: Removing the database entries from backend (phpMyAdmin)

2012-03-22T07:35:36Z

And where I can find "en_US-new.sql" file?

Is it by default table with data?

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

2012-03-22T07:27:18Z

Thanks for your response.

But what is COA?

Can you guide me on this?

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

2012-03-22T06:48:57Z

This is very dangerous. You should use an empty COA from the beginning or make a backup of an existing one and remove all the data that you do not need (look into en_US-new.sql to see which table contents to preserve) and create a new client from this new COA.

/Joe

Removing the database entries from backend (phpMyAdmin)

2012-03-22T05:49:40Z

Hello!

Can I remove all the entries of table from back-end (phpMyAdmin)?

Can it will effect to any functionality of FA?

Can anybody guide me on this?

Which tables' entries must be remain if I am going to empty data of tables?

Thanks In Advance.

Mayank Jani