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 <[EMAIL PROTECTED]> wrote: >
> >
> > Rajendra Kumar <[EMAIL PROTECTED]> 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
> > >  / /|_/ / // /\ \/ /_/ / /__
> > > [EMAIL PROTECTED]
> > > /_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]
> >
> > ________________________________________________________________________
> > Missed your favourite TV serial last night? Try the new, Yahoo! TV.
> >        visit http://in.tv.yahoo.com

-- 
================================================
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 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
================================================


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to