How to load a backup? My server just got hacked agian :/

[christiandb]

Hey,

after my last hack my database got deleted by the hacker and I made backups (open the database > export). I hope this is the right way but when I try to import it says I says that "#1146 - Table 'otserv.guild_ranks' doesn't exist ". So my question was how to load this backup? I'm really getting tired of all this hacks.

A sad,

Chris

 

[pierroth]

mmm bumps~
I got this question too. Trying to save and export tables to another database.

 

[Znote]

I hate the export function, if your server is big, the export function will be to big to be imported again. >.<

To make backups, you should go xampp/mysql and backup the "data" folder. Then you got a backup of all databases, then when your hacked, just delete the current data folder and replace with the old one, and you would have done a perfect backup.

 

[Dark Warrior]

I hate the export function, if your server is big, the export function will be to big to be imported again. >.<

To make backups, you should go xampp/mysql and backup the "data" folder. Then you got a backup of all databases, then when your hacked, just delete the current data folder and replace with the old one, and you would have done a perfect backup.

Use navicat instead of phpmyadmin...

And if you are using InnoDB you can't do it with simply copy/paste, The best thing to do when your using other type of storage than myisam is via php script or any type of tool...

Ill atach the php script i use for make my backups... <The script will make a backup of all your database but of course you can set some databases to not be backuped and all the databases will be in one file (Unless you change the configuration) for save space so you have to use navicat in order to upload it..

EDIT: you have to edit backup_dbs_config.php with your configurations...

 

[pierroth]

Is there a way to move tables to another database??

 

[Pietia]

<br />
<b>Warning</b>:  mkdir() [<a href='function.mkdir'>function.mkdir</a>]: Permission denied in <b>/var/www/backup/backup_dbs.php</b> on line <b>156</b><br />
<br />
<b>Notice</b>:  Undefined index:  f_log in <b>/var/www/backup/backup_dbs.php</b> on line <b>86</b><br />
Backup directory could not be created in /db_backups
<br />
<b>Notice</b>:  Undefined index:  f_err in <b>/var/www/backup/backup_dbs.php</b> on line <b>86</b><br />
Backup directory could not be created in /db_backups
Backup directory could not be created in /db_backups

what's up ?