Restore database by script

[abcde]

What script you think its best. i use some, but fail to restore big file.

i want to restore table by table, but with table "post.sql" i can't do it by anyway.

 

[theparrot]

usually timeouts are set for web requests. So using a script to restore a large file like you say is probably not the most reliable way. Use ssh and shell command, it would be more reliable for this.

 

[abcde]

what is ssh and where to get it?

 

[theparrot]

what is ssh and where to get it?

Well I made a few assuption, one was that you script/db is on a Unix like host?

You have to check if you get ssh access to you account, if you are not on a dedicated server. If you do and you are running windows, search for putty.

Since it seems you have not used shell before, you may want to send a request for help to your host, and/or also hire someone to give you a quick hand with the restore.

 

[adam_uk]

you could use ssh and mysql commands to do it(its quite easy really)

but another way you could do is break the file down into 2mb chunks and upload them bit buy bit

 

[deadserious]

You could also make the script execute the ssh/mysql commands for you. I have backup/restored nearly 1 Gigabyte databases for users who who didn't have ssh access and were unable to get it done via phpMyAdmin or any other way.

 

[redking]

what is ssh and where to get it?

LOL :lol:

This game is not for kids like you.

Ssh (Secure Shell) is a program to log into another computer over a network, to execute commands in a remote machine, and to move files from one machine to another. It provides strong authentication and secure communications over unsecure channels. It is intended as a replacement for rlogin, rsh, and rcp.

 

[Peter]

This game is not for kids like you.

we all had to start somewhere.