Hacked Yesterday

[pspuser007]

Thank you for the reply my friend!
I am using now bigdump but i got this error:

Processing file: filename.sql.gz
 Starting from line: 3001
 
Error at the line 3021: SET character_set_client = @saved_cs_client;
 Query: SET character_set_client = @saved_cs_client;

 MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
 Stopped on error"

What can I do?

[loki]

Try deleteing your sql database and making a new one with exact same info and try to import again

[SplitIce]

Thank you for the reply my friend!
I am using now bigdump but i got this error:

Processing file: filename.sql.gz
 Starting from line: 3001
 
Error at the line 3021: SET character_set_client = @saved_cs_client;
 Query: SET character_set_client = @saved_cs_client;

 MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
 Stopped on error"

What can I do?

I have had that problem before, open the dump file (Use UltraEdit or some large file editor if needed) and remove that line.

[pspuser007]

I have extracted the SQL file and edited it trough ultra edit.
Now what?

Thank you for the reply!

[pirateaccess]

I have extracted the SQL file and edited it trough ultra edit.
Now what?

Thank you for the reply!

dont remove that line
instead install xampp in ur pc copy the forum files in htdocs folder (make a new folder in htdocs name "forum")
go to http://localhost/security/xamppsecurity.php
change PhpMyAdmin authentification: to http and create a password for the root.

now go to http://localhost/phpmyadmin/
and create a database table.
restore your whataver big db is in the phpmyadmin.
it wont create any problem

edit the config.php according to the settings of phpmyadmin

go to localhost/forum/admincp/ and do a database backup through maintanience tab
if needed do repair optimize table and run fix unique indexes

now restore that db through bigdump

remember the process may be long but the result is effective.

i face the exactly same problem same error fewtimes but the above trick always work for me.
deleting lines from db is not a solution.

now rest depend on you whether u apply it or not.

have a nice day,
regards pirateaccess

[tdsii]

Read this!

In most cases if 1 sql injection failed the whole proccess fails.
try mysql dumper >> www.mysqldumper.de/en

make sure after u set it up, to gto options and disable something that makes it stop incase restore failed. it is important, in this way u can restore ur database and if any query failed for any reason it will pass over it and simply ignore.
u can either restore the .sql or the compressed file.

[Prince]

indeed mysql dumper is the best backup tool, fit to work with bigger databases.

[pspuser007]

I have imported the db by deleting the lines (Did it before I see your messagees) .
We are going to buy a new server.
So I am going to upload the files of my forum there.
What should I do with the DB?


EDIT:
Thread about Sever here.

[pirateaccess]

do as i said

[pspuser007]

OK i managed to save the backup from Admin Cp.
Now the only thing i have to do is use bigdump to upload it in example at the new server?