[shkhanal]

Hi,

I am using phpMyAdmin to restore mySql database but it is difficult and fails many times over slow internet connection. Is there any other way out so that we could restore database easily?

[BABA]

Yes, phpmyadmin often shows error to restore database. However, if you try many times then it will resume.

Ways :

1. Restore using cpanel Backup wizard. It works for me.
2. Use BigDump (Google it)

[shkhanal]

I tried to use cPanel Backup, it imported only a part of database 24 tables out of 70. I think it would be possible only when I'll buy ADSL connection.

Thank you for suggesting BigDump. I'll look for it and try if it is possible.

[pri2sh]

Easy way to restore database, compress it using zip and import it in phpmyadmin ..

[test]

hello SH, You can copy and paste. Like open the sql in notepad in PC. Copy and Paste in the Server SQL.

[shkhanal]

Originally Posted by pri2sh

Easy way to restore database, compress it using zip and import it in phpmyadmin ..

Dear test! the sql file will be of some MB like 7mb. It won't work copying and pasting that large file.