PDA

View Full Version : Restoring database is not taking place.. why?


LittleBird
Thu 12th Apr '01, 2:52pm
Hi everyone.

I have a backup of a database (xx.sql) in which i made using phpmyadmin. Now when i try to restore the database, what i do is browsing for the xx.sql in hard disk then i press GO. Things go fine after awhile and i get a confirmation message saying something like files is successfuly done... but in fact when i look at the tables i don't see any changes.... my backed up threads and posts do not get restored.........

Anyone has any idea of what is going wrong. Please this is very important to me. thanks in advance.

steven
Thu 12th Apr '01, 5:16pm
First do you have telnet access? PhpMyAdmin has a lot of problems for users who try to import files because it adds a lot of html garbage to the dump. So if you have telnet access it would take a total of 1 minute to backup and import your database.

LittleBird
Thu 12th Apr '01, 5:58pm
unfortunatly not :(

Do you think my backup file is empty that is why not affects is taking place? I tried opening the xx.sql file with notepad & all threads and posts .. etc were there.

This is urgent pls.... thank you very much.

auto
Thu 12th Apr '01, 6:20pm
put it up on your server somewhere,
and ask you host to do it for you.
thats the only way if you dont have telnet.

Mas*Mind
Thu 12th Apr '01, 7:50pm
...or use a script that can execute it from the server for you