View Single Post

  #3 (permalink)  
Old 30-01-2007, 08:57 AM
kae's Avatar
kae kae is offline
Byte Wrangler
 
Join Date: Sep 2006
Location: monaghan
Posts: 54
Nominated 0 Times in 0 Posts
TOTW/F/M Award(s): 0
kae will become famous soon enough
Default

assuming it's MySQL that you're talking about, all you need to do is use the console-based "mysqldump" application to grab the dump, and "mysql" to install the dump.

mysqldump -uusername -ppassword dbname -hhostname > dump.sql
mysql -uusername -ppassword dbname -hhostname < dump.sql

if you find there are timeout issues, then upload the file to the server, and either run the "mysql" line above yourself, or ask your ISP to run it, if you don't have ssh access.
__________________
verens.com, webworks.ie
kfm.verens.com
Reply With Quote