LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
Reload this Page importing???
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-25-2003, 06:19 AM   #1
mojozoox
LQ Newbie
 
Registered: Jul 2003
Location: India
Distribution: RedHat 8
Posts: 9

Rep: Reputation: 0
Question importing???

how to import a database using mysql?
 
Old 08-25-2003, 07:05 AM   #2
nephilim
Member
 
Registered: Aug 2003
Location: Belgium
Distribution: Debian (server), Kubuntu (desktop)
Posts: 248

Rep: Reputation: 30
import from what? File, another DB,...?
 
Old 08-25-2003, 07:07 AM   #3
mojozoox
LQ Newbie
 
Registered: Jul 2003
Location: India
Distribution: RedHat 8
Posts: 9

Original Poster
Rep: Reputation: 0
i have exported a mysql database into a file how to import it?
 
Old 08-25-2003, 07:43 AM   #4
nephilim
Member
 
Registered: Aug 2003
Location: Belgium
Distribution: Debian (server), Kubuntu (desktop)
Posts: 248

Rep: Reputation: 30
If you exported your data, try

LOAD DATA INFILE 'file.txt' into table_name;

If you exported a db creation script, try

source 'file.sql'

both at the MySQL prompt of course.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help with importing subtitles vegetassj2 Linux - Software 2 08-09-2005 12:00 PM
Importing a package Birgi Programming 4 03-17-2005 03:47 PM
Importing IE e-mails Rutnut Linux - General 5 05-29-2004 08:35 AM
Importing a script? Panzerfrost Slackware 1 11-04-2003 11:37 AM
Importing Favorites TX_metalhead Linux - General 0 01-23-2002 09:32 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:07 AM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration