List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:August 23 2004 12:16pm
Subject:Re: Re-installing db/tables from dumpfile
View as plain text  
"Joseph E. Maxwell" <jemaxwell@stripped> wrote:

> I am moving my database(s) from one server to another, did a full dump 
> of the data and have a large file with all the create instruction sets etc.
> My question, what is the best way to recreate these db, tables etc. on 
> the new server. MySQL is already installed & running.

run

	mysql -uroot -ppassword < this_file.sql





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Re-installing db/tables from dumpfileJoseph E. Maxwell21 Aug
  • Re: Re-installing db/tables from dumpfileEgor Egorov23 Aug
  • How to Reset a fieldYusdaniel Rodriguez Espinosa23 Aug
    • Re: How to Reset a fieldEgor Egorov25 Aug
RE: How to Reset a fieldVictor Pendleton23 Aug
  • Re: How to Reset a fieldV. M. Brasseur23 Aug
  • Re: How to Reset a fieldEWA Goodson-Wickes23 Aug