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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]