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]