Control Web Panel

WebPanel => How to => Topic started by: thanhblog.info on March 25, 2020, 09:40:25 AM

Title: Recover deleted database
Post by: thanhblog.info on March 25, 2020, 09:40:25 AM
I just deleted my data in SQL management. Can I get it back, I don't have backup for users of this website
I want to find the location of the mqsl file, then access the path on SFTP.
Tks
Title: Re: Recover deleted database
Post by: ejsolutions on March 25, 2020, 10:08:34 AM
This is a spoof post?  :o Perhaps it's just to spam a Vietnamese website?
No chance! (See my sig.)
Title: Re: Recover deleted database
Post by: thanhblog.info on March 25, 2020, 10:33:27 AM
Im not spam, Im newbie. Can you help me?
Title: Re: Recover deleted database
Post by: pixelpadre on March 25, 2020, 11:00:12 AM
Im not spam, Im newbie. Can you help me?

Yeah, its gone and nothing you can do about it.  Check your /backup directory.  You might get lucky.
Title: Re: Recover deleted database
Post by: thanhblog.info on March 25, 2020, 02:12:39 PM
Im not spam, Im newbie. Can you help me?

Yeah, its gone and nothing you can do about it.  Check your /backup directory.  You might get lucky.

Where can I access the sql directory on SFTP?
Title: Re: Recover deleted database
Post by: Nazgile on March 25, 2020, 02:21:23 PM
are u sure ur rdy to manage a server with a maybe a gigabit per second? that can be hijacked and do a tons of dmg to another people? cant search for basic stuff like directorys?
or maybe try to find it out by yourself?

i dont want to flame or be rude, but maybe u should switch to a professional webhoster and dont host by your own without experience :/

no backup = no recovery
no snapshot = no recovery

use root login for sftp or manage via ssh

or go both with a programm like bitvise ssh client (sftp + ssh both together with just login to ur sever..)
Title: Re: Recover deleted database
Post by: thanhblog.info on March 25, 2020, 02:25:28 PM
are u sure ur rdy to manage a server with a maybe a gigabit per second? that can be hijacked and do a tons of dmg to another people? cant search for basic stuff like directorys?
or maybe try to find it out by yourself?

i dont want to flame or be rude, but maybe u should switch to a professional webhoster and dont host by your own without experience :/

no backup = no recovery
no snapshot = no recovery

use root login for sftp or manage via ssh

or go both with a programm like bitvise ssh client (sftp + ssh both together with just login to ur sever..)

I only have a few small websites, so I want to manage it myself.
I just want to know where my sql file is located for quick search.
ex: / usr / local ...
Title: Re: Recover deleted database
Post by: Nazgile on March 25, 2020, 02:28:43 PM
/var/lib/mysql and /etc/mysql/
...


i dont want to be rude but spend the 2 bucks monthly for a professional hosting provider (webspace) think about all other users, if ur server will be a open relay , hijacked, or something else.. u damage a lot of persons on the world ^^...

or try a good time in a virtual machine for testing purpose..

Title: Re: Recover deleted database
Post by: thanhblog.info on March 25, 2020, 02:32:35 PM
/var/lib/mysql and /etc/mysql/
...


i dont want to be rude but spend the 2 bucks monthly for a professional hosting provider (webspace) think about all other users, if ur server will be a open relay , hijacked, or something else.. u damage a lot of persons on the world ^^...

or try a good time in a virtual machine for testing purpose..

I want to experience to learn more, watching as leisure in my free time. Anyway, thank you for the reply