problem restoring large database

I have a database.. 250mb
i tried to restore and it always gives a '10457 error' to my server.

i tried to download and restore it locally on my PC
and it either hang or timeout error.

if there any software or better way to restore a large sql database ?

 

There is. Do you have root access to the server?

 

yes i have. my backup.sql is still siting there.
but it always hang my server when i try to restore.
i'm on shared hosting, so i can configure the server.

 

in cron or ssh...

mysql -u DB_USER_NAME -pDB_PASSWORD DB_NAME < /home/ACCOUNT_NAME/BACKUP_FILE_NAME.sql

 

use bigdump: http://www.ozerov.de/bigdump.php

otherwise try with a file splitter and upload the database, one part at a time:

http://freeware.intrastar.net/filesplit.htm
http://www.softdd.com/filesplt/index.htm

*splitting may require a little manual fine tunning to avoid dumping errors
.

 

my host dun allow cron and ssh. it's shared hosting..

 

thanks for the lead. i'll try that, but many are just text file splitter.
i have a SQL splitter. but the apps hand when reading my database backup

 

Use bigdump OR if you upload the database to your server as a file ask your webhost to do it for you with there ssh access, 9 times out of ten they will

If not get a new host.

 

thanks!.. i managed to split the file and will suery them one by one!
total 130 over files!!! will take my sloooow time!

forget about my host.. they're not as helpful after my recent renewal..

 

Are you aware you're gonna have to re-group all these 130 files? You would've been better off if you used a program that will allow you to continue downloading where you started..

 

Get a new host if they can't use SSH for you.

 

Try SQLyog