Advertisement:

Author Topic: Where is database sql file located?  (Read 321 times)

Offline Finn_958

  • Semi-Newbie
  • *
  • Posts: 43
Where is database sql file located?
« on: February 10, 2019, 09:55:36 PM »
Due to hacker attack, I need to manually backup (download) sql database from ftp before forum is restored. I looked in every ftp directory but I do not find the sql database file.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,517
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Where is database sql file located?
« Reply #1 on: February 10, 2019, 10:03:13 PM »
You won't find it there.
You can find it your cpanel in an area called phpmyadmin if you are on shared hosting.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,244
Re: Where is database sql file located?
« Reply #2 on: February 10, 2019, 10:15:16 PM »
If you have a backup utility in cpanel, use that.  phpmyadmin will sometimes crap out without error on large databases.  Whichever you use, dump it 2-3 times, make sure file size is the same.

Offline Finn_958

  • Semi-Newbie
  • *
  • Posts: 43
Re: Where is database sql file located?
« Reply #3 on: February 10, 2019, 11:46:40 PM »
Thank you but forum is hacked I cannot access admin interface. Is sql database located somewhere in ftp folders?

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,551
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Where is database sql file located?
« Reply #4 on: February 10, 2019, 11:50:43 PM »
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Finn_958

  • Semi-Newbie
  • *
  • Posts: 43
Re: Where is database sql file located?
« Reply #5 on: February 11, 2019, 12:03:35 AM »
Understood, thank you

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,551
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Where is database sql file located?
« Reply #6 on: February 11, 2019, 12:07:32 AM »
If you fail to find an export method, your host should be able to help you further.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas