Sorry hit the wrong reply button ;-)
> Hi Rajendra,
>
> In case you are new to mysql the easiest way would be to do it on the
> command line base :
>
> 1) shutdown the server
> 2) go to your data directory f.e /var/lib/mysql/dbname1
> 3) copy the table files to the folder of dbname2
>
> f.e cp -r * ../dbname2
>
> 4) change the ownership of the copied tables in ../dbname2 to the Linux
> mysql account
>
> chown -r <username> <tablename>
> chgrp -r <usergrp> <tablename>
>
> 5) start your mysql server again
>
> Thats not the most professional way , put for beginners the easiest way to
> do it.
>
>
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 5月 30日 金曜日 11:24、Rajendra Kumar さんは書きました:
> > Hello Sir,
> >
> > thanks for the reply. i have one more doubt.
> >
> > i want to import 2 tables from one database to
> > another database like the tables structure and as well
> > as its records.
> >
> > have a nice day,
> >
> > Naren.
> >
> >
> >
> > --- Egor Egorov <egor.egorov@stripped> wrote: >
> >
> > Rajendra Kumar <rsrie@stripped> wrote:
> > > > i know little bit about mysql. i use mysql to use
> > > > the webportal system of phpnuke. can anyone help
> > >
> > > me
> > >
> > > > to import data in mysql. for exams i have a file
> > > > nuke.sql which contains like tables design and
> > >
> > > there
> > >
> > > > records.
> > > >
> > > > how to call this file when i am having sql
> > >
> > > prompt. i
> > >
> > > > use redhat linux for mysql.
> > >
> > > Execute from the shell:
> > >
> > > mysql -uuser_name -p database_name < nuke.sql
> > >
> > > and enter the user password.
> > >
> > >
> > >
> > > --
> > > 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
> > >
> > >
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=1
> >
> > ________________________________________________________________________
> > Missed your favourite TV serial last night? Try the new, Yahoo! TV.
> > visit http://in.tv.yahoo.com
--
================================================
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp/staff/nils
------------------------------------------------
有限会社ナレッジデザイン
〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F
Phone: 0424-40-7912 Fax: 0424-40-7913
URL: http://www.knowd.co.jp
================================================
