Restore database by script

abcde · 03-10-2005, 10:12 AM

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 · 03-10-2005, 11:07 AM

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 · 03-10-2005, 11:13 AM

what is ssh and where to get it?

theparrot · 03-10-2005, 11:25 AM

Quote:

Originally Posted by abcde

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 · 03-10-2005, 01:11 PM

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 · 03-10-2005, 07:43 PM

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 · 03-11-2005, 09:28 AM

Quote:

Originally Posted by abcde

what is ssh and where to get it?

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 · 03-11-2005, 01:06 PM

Quote:

Originally Posted by redking

This game is not for kids like you.

we all had to start somewhere.

03-10-2005, 10:12 AM	#1 (permalink)
abcde NamePros Regular Join Date: Feb 2005 Posts: 543 1,458.47 NP$ (Donate)	Restore database by script 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.

03-10-2005, 11:07 AM	#2 (permalink)
theparrot NamePros Regular Join Date: Mar 2004 Posts: 638 502.35 NP$ (Donate)	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. __________________ Need a break? Check out TheDamnBlog.com Free $6.95 directi accounts at Directi Name Bin Instant free $8.95 eNom accounts at Dncube.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
60.000 Templates, scripts, fonts, banners etc. $9.95	atkims	Web Development Wanted	19	11-16-2004 09:48 AM
HOWTO: Backup and Restore your MySQL databases with phpMyAdmin	deadserious	Webmaster Tutorials	2	04-05-2004 02:15 PM
Domain Rating Script for Sale : $200.00 - only 10 scripts will be sold	fonzerelli_79	Scripts For Sale	3	08-31-2003 08:41 AM

03-10-2005, 11:13 AM	#3 (permalink)
abcde NamePros Regular Join Date: Feb 2005 Posts: 543 1,458.47 NP$ (Donate)	what is ssh and where to get it?

03-10-2005, 01:11 PM	#5 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	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

03-10-2005, 07:43 PM	#6 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)