Restoring from a mysqldump file

2003-03-01 Thread Jeff Mao
Greetings all,

May be a dumb question,...if I have a text file generated from 
mysqldump, how do I reload that file into mysql? In the past I've 
always copied and pasted it into mysql, but that takes a lot of 
time,...especially as the databases grow! I do not have local access 
to the server, but I can connect to it remotely using the normal 
tools,...

Thanks,
Jeff
--

Jeff Mao
[EMAIL PROTECTED]
-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Re: Restoring from a mysqldump file

2003-03-01 Thread Zak Greant
On Sat, Mar 01, 2003 at 05:11:29PM -0500, Jeff Mao wrote:
 Greetings all,
 
 May be a dumb question,...if I have a text file generated from 
 mysqldump, how do I reload that file into mysql? In the past I've 
 always copied and pasted it into mysql, but that takes a lot of 
 time,...especially as the databases grow! I do not have local access 
 to the server, but I can connect to it remotely using the normal 
 tools,...

  mysql -h host.name.tld -u user -p  dump.file

-- 
Zak Greant [EMAIL PROTECTED]
  MySQL AB Community Advocate
  Personal Blog: http://zak.fooassociates.com

EFF: Protecting Freedoms on the New Frontier (http://eff.org)

Support Global Human Rights - Amnesty International (http://amnesty.org)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php