Menu

SuietASSURED Banner

Save

Save

Welcome, Guest
Username: Password: Remember me

TOPIC: Clear data but keep contact records

Clear data but keep contact records 5 days 49 minutes ago #57992

  • tombaumgratz
  • tombaumgratz's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hello,

We have Suite 7.6.6/Sugar 6.5.23. We are basically wanting to delete everything and start over but not have to redo settings or re-import contact names. Is there a simple way to clear attachments, notes etc but leave everything else...

thanks in advance for any assistance with this.

Tom
The administrator has disabled public write access.

Clear data but keep contact records 4 days 8 hours ago #58017

  • pgr
  • pgr's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 3537
  • Thank you received: 570
  • Karma: 135
You can delete from the database via phpMyAdmin or MySQL command-line.

Apart from (obviously) getting a full backup before attempting anything, I would recommend you try to understand a bit of the table structure before starting.

For example accounts you will find tables like this
- "accounts" the actual accounts records
- "accounts_cstm" any custom fields you created for accounts
- "accounts_contacts" the relationship table between accounts and contacts

So you'll find quite a few relationship tables where you should also delete records from. But if you don't delete them, things will still work fine, only you will be left with a bunch of orphaned rows in your database.

Maybe you'll like reading this from my blog:
pgorod.github.io/Database-tables-size/

That SELECT command will guide you towards where your data is stored.

Good luck and share your findings/tips when you're done.
The administrator has disabled public write access.

Clear data but keep contact records 1 day 4 hours ago #58213

  • tombaumgratz
  • tombaumgratz's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Thank you for your reply and assistance, but I'm new to this stuff, downloaded myphpadmin but there doesn't seem to be a setup to get it going. and command line sounds ok to me but was really hoping for a way to visually see and delete say all attachments. Not really sure where everything is located but have access to the pc as admin
The administrator has disabled public write access.

Clear data but keep contact records 16 hours 25 minutes ago #58228

  • pgr
  • pgr's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 3537
  • Thank you received: 570
  • Karma: 135
The "visual way" you want is phpMyAdmin. What is your environment like, Windows, Linux? If Linux, which one?

I normally don't "download" phpMyAdmin, I just tell it to install with "apt-get install phpmyadmin" and it just works.
The administrator has disabled public write access.
Time to create page: 0.046 seconds
Powered by Kunena Forum