Got hacked.

[Minimii]

My database got hacked and everything got fucked up.

But I have a backup from yesterday, so how could I import that shit?
I get error message every time I try like

Thats the first error message , where should I input that line?

 

[Nikkster]

The hacker deleted your account table?

If you don't have any accounts/players there just import the database.sql again, or if you're using a newer version "Schema.Mysql".

Otherwise you could use your backup (?) if you got one.

/Nikkster

 

[Minimii]

The hacker deleted your account table?

If you don't have any accounts/players there just import the database.sql again, or if you're using a newer version "Schema.Mysql".

Otherwise you could use your backup (?) if you got one.

/Nikkster

Im using my database backup but I get errors like that when I import it.

 

[Nikkster]

Did you have any important accounts in it?

 

[Minimii]

Yea everything thats happen in my server in like 7 days =) Like peoples donation items and levels and everything.

I just want to know why I get this error message because the only thing I did was to export the database from the phpmyadmin, then now when I import it I get this shit.

 

[Minimii]

I fixed some but now I get another error message

#1146 - Table 'pure.guild_ranks' doesn't exist

What line should I input and where?

 

[Pietia]

Do in pma all options optimize repair check etc. Then if it won't help delete .TRG and .TRN and copy it from new database.

 

[Minimii]

Do in pma all options optimize repair check etc. Then if it won't help delete .TRG and .TRN and copy it from new database.

And how am I suppose to do that?

 

[Pietia]

And how am I suppose to do that?

LINUX:u have the database in /var/lib/mysql/database
windows in :/C:/xampp/mysql/data/database

 

[Minimii]

LINUX:u have the database in /var/lib/mysql/database
windows in :/C:/xampp/mysql/data/database

I don't have anything there? My ot got hacked and they deleted the whole database. But as I said I got a backup from yesterday but I get error messages when I try to import it.

 

[Mikuch]

did U tried importing using command line?

mysql -u root -p database_name < backup

 

[Master-m]

try this:
import the mysql.schema file and then after that import your backup.

 

[Minimii]

did U tried importing using command line?

mysql -u root -p database_name < backup

How do you mean?

try this:
import the mysql.schema file and then after that import your backup.

When I did that it just says like "accounts already exist"

 

[Master-m]

then remove the account 1/1 from the file

 

[Minimii]

then remove the account 1/1 from the file

Didn't work either.

Got the same error message:

#1050 - Table 'accounts' already exists

 

[Leo32]

Delete everything on the hacked database. then re-import the backup database.

 

[Minimii]

Delete everything on the hacked database. then re-import the backup database.

Yea thats what I did, see post #1

I get alot of error messages when doing that

 

[Mikuch]

I dont see any errors at first post

 

[Minimii]

I dont see any errors at first post

It says "Error, can not drop trigger blabla" when I import the database. Thats an error yes.

 

[Minimii]

Comman someone that knows whats the problem?

[B]#1146 - Table 'pure.guild_ranks' doesn't exist [/B]

Getting that error now, I know I must make it exist, but where in the database should I make it exist? And should I write like CREATE TABLE `guild_ranks` or how should I do?