Author Topic: Recover deleted database  (Read 8272 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Recover deleted database
« 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

Re: Recover deleted database
« Reply #1 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.)
« Last Edit: March 25, 2020, 10:11:24 AM by ejsolutions »

Offline
*
Re: Recover deleted database
« Reply #2 on: March 25, 2020, 10:33:27 AM »
Im not spam, Im newbie. Can you help me?

Offline
***
Re: Recover deleted database
« Reply #3 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.

Offline
*
Re: Recover deleted database
« Reply #4 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?

Offline
*
Re: Recover deleted database
« Reply #5 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..)
« Last Edit: March 25, 2020, 02:23:15 PM by Nazgile »

Offline
*
Re: Recover deleted database
« Reply #6 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 ...

Offline
*
Re: Recover deleted database
« Reply #7 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..

« Last Edit: March 25, 2020, 02:31:47 PM by Nazgile »

Offline
*
Re: Recover deleted database
« Reply #8 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