Restoring Database Already On Server

[Rene27]

I've been reading threads/topics on restoring databases all morning, and I can't seem to find the answer to my question. So, here goes....

I saved a backup of my database via the boards admin control panel, and the database was saved as a file on my server. I then downloaded a copy of the backup file to my PC, and tried to upload it via mymsql. The file size is 19.8mb, so of course I recieved a timeout error.

I've read many topics about telnet/ssh, but according to my host:

"at this time, we do not provide telnet access or SSH to your files. You may, however, use telnet to connect to port 110 (incoming mail) and port 25 (outgoing mail). You will not be able to access files using telnet or SSH on our shared hosting plans."

Outside of asking my host to restore the database for me, is there any other route I can take? If I have to, I'll ask the hosting company to do it for, but I'd like to learn how to do it myself so that I don't have to contact them each and every time I run into this issue.

Since the file is already on the server in my backup folder, is there a way for me to restore it without the use of telnet/ssh?

Thanks in advance for your assistance!

Best regards,

Rene'

[Barrikin]

You could try.

http://www.php.net/manual/en/function.exec.php

[Steve Machol]

Only backing and restoring via the shell is reliable. However you can try this:

Restore with phpMyAdmin:
http://www.vbulletin.com/docs/html/m...yadmin_restore