How i can use Back Up file

[shzor]

once i lost my hosting account so i have to reinstall everything on different server i had saved my back up ...but i dont know how i can use it...plz guide me..

[Boby]

To restore your database use PHPMyAdmin or if it's really huge try out Bigdump (http://www.ozerov.de/bigdump.php)

And then copy all your files back to the server, set new permissions, reinstall and you should be ready.

Also read:
http://www.phplinkdirectory.com/forum/showthread.php?t=2160

Boby

[shzor]

thx boby ...plz ell me in detail.....bcoz i tried to import by phpmyadmin its show me this

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '

DROP TABLE IF EXISTS `PLD_BANLIST`' at line 1

[Boby]

Eighter the DB backup is corrupted or there is some charset conversion problem (because of ')

Open the backup file in an editor and look at this query:
Content visible to registered users only.
Show me some code above it or after it, there must be something with that strange characters. If they are in no query, just remove them and start again with the backup import.

Boby

[shzor]

thx boby for your time....check this boby i upload whole file.... database_backup_2006-06-22.sql ...plz also guide me little bit more about phpMyAdmin...bcoz i dont know much about it...i just only tried to import but its show me error....& secondly if its not work able can i get catagaries stucture for my directory...bcoz its very difficlt to add again & again...

Edit by Boby:
I have removed the link to the backup file.

[Boby]

When you login to PHPMyAdmin, select on the left side your database, then select "Import".
There you can browse for your file, load it, select UTF-8 as character set of the file and hit "Go".
I have tried it now and it worked :)

Sent you via PM the backup file that I cleaned up for unused text and chars.

Boby

[shzor]

really thx alot boby for your kindness :) ..