Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Finn_958 on February 10, 2019, 09:55:36 PM

Title: Where is database sql file located?
Post by: Finn_958 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.
Title: Re: Where is database sql file located?
Post by: vbgamer45 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.
Title: Re: Where is database sql file located?
Post by: Sir Osis of Liver 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.
Title: Re: Where is database sql file located?
Post by: Finn_958 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?
Title: Re: Where is database sql file located?
Post by: Aleksi "Lex" Kilpinen on February 10, 2019, 11:50:43 PM
Quote from: Finn_958 on February 10, 2019, 11:46:40 PM
Is sql database located somewhere in ftp folders?

Quote from: vbgamer45 on February 10, 2019, 10:03:13 PM
You won't find it there.

How do I backup my database? (https://wiki.simplemachines.org/smf/How_do_I_save_the_database_data)
Title: Re: Where is database sql file located?
Post by: Finn_958 on February 11, 2019, 12:03:35 AM
Understood, thank you
Title: Re: Where is database sql file located?
Post by: Aleksi "Lex" Kilpinen 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.