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?

 

[Minimii]

Hello?=)

 

[Migxxx]

Didn't work either.

Got the same error message:

#1050 - Table 'accounts' already exists

edit the backup file duhhh? or are u so lazy to edit it?

 

[Minimii]

edit the backup file duhhh? or are u so lazy to edit it?

Im not to lazy to edit it lol, i've edited it alot. But I don't know how I should edit it to fix this error, thats why im asking.

 

[Migxxx]

Im not to lazt to edit it lol, i've edited it alot. But I don't know how I should edit it to fix this error, thats why im asking.

If you have the same error as above just delete the line on your backup that says
create table accounts
because it is already created....
duh a bit logic ;s

 

[Minimii]

If you have the same error as above just delete the line on your backup that says
create table accounts
because it is already created....
duh a bit logic ;s

I fixed that problem, But i've got another one that I don't know how to fix, read my other post. http://otland.net/f16/got-hacked-25591/index2.html#post256876

 

[Migxxx]

I fixed that problem, But i've got another one that I don't know how to fix, read my other post. http://otland.net/f16/got-hacked-25591/index2.html#post256876

about the trigger problem idk since i import all the DBS via command line and never had this problem....

 

[Minimii]

about the trigger problem idk since i import all the DBS via command line and never had this problem....

How can I import the database with a command line then?

 

[Migxxx]

How can I import the database with a command line then?

mysql -u root -p (leave it in blank) -D (database name) < PATH TO YOUR .SQL file

 

[Minimii]

mysql -u root -p (leave it in blank) -D (database name) < PATH TO YOUR .SQL file

So basicly i'll write like this mysql -u root -p -D backup.sql if the name on the sql file is backup? :O And where should I input it?

 

[Migxxx]

So basicly i'll write like this mysql -u root -p -D backup.sql if the name on the sql file is backup? :O And where should I input it?

on winblow if you have mysql-server (not xampp) you type it on the cmd and is
mysql -u root -p -D DATABASE NAME < PATH/to/back/up/file
(u have first to create the db) and yes with <
example:
mysql -u root -p -D theforgottenserver < /home/migxxx/Desktop/theforgottenserver.sql

and on linux is on terminal

 

[Minimii]

on winblow if you have mysql-server (not xampp) you type it on the cmd and is
mysql -u root -p -D DATABASE NAME < PATH/to/back/up/file
(u have first to create the db) and yes with <
example:
mysql -u root -p -D theforgottenserver < /home/migxxx/Desktop/theforgottenserver.sql

and on linux is on terminal

When I write this: mysql -u root -p -D Pure < C:/Users/Administrator/Desktop/Pure/backup.sql in the CMD I just get the error message

[B]mysql is not recognized as an internal or external command, operable program or batch file.[/B]

 

[tae]

nice ;P

 

[Minimii]

Hello anyone?