• From: India, Ahmedabad
  • Registered: 02/17/2012
  • Posts: 26

Topic: Removing the database entries from backend (phpMyAdmin)

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Removing the database entries from backend (phpMyAdmin)

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

  • From: India, Ahmedabad
  • Registered: 02/17/2012
  • Posts: 26

Re: Removing the database entries from backend (phpMyAdmin)

Thanks for your response.

But what is COA?

Can you guide me on this?

Mayank Jani

  • From: India, Ahmedabad
  • Registered: 02/17/2012
  • Posts: 26

Re: Removing the database entries from backend (phpMyAdmin)

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

Is it by default table with data?

Mayank Jani

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Removing the database entries from backend (phpMyAdmin)

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

  • From: India, Ahmedabad
  • Registered: 02/17/2012
  • Posts: 26

Re: Removing the database entries from backend (phpMyAdmin)

Thanks thanks thanks a lot, Joe.

You great... Proud... smile

Mayank Jani