Delete connections via mysql database

Support › Delete connections via mysql database

0 Vote Up Vote Down

adrian Staff asked 7 years ago

Hi, i want to delete all my connections/services at once. How are the databases called? Thanks a lot!

2 Answers

0 Vote Up Vote Down

Nikola Loncar Staff answered 7 years ago

Hi, you can do that easily. Table names are _ea_connections and _ea_services. But first delete connections then services. Best regards, Nikola

adrian_milz Staff replied 7 years ago

Thank you! But i can’t find any of these in my database. Any advice for me to find these? I tried also: DELETE * FROM _ea_connections but this table doesn’t exist.

0 Vote Up Vote Down

Nikola Loncar Staff answered 7 years ago

Hi Adrian, you are missing prefix for those tables. Most likely it is wp_ so table name should be wp_ea_connections. Also please check without prefix ea_connections. Best regards, Nikola

adrian_milz Staff replied 7 years ago

thank you, correct. my prefix is some cryptic one. Now i found my tables!