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

Reply via email to