LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
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, 07: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, 08: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, 08: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, 08: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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 01:00 PM
Importing a package Birgi Programming 4 03-17-2005 04:47 PM
Importing IE e-mails Rutnut Linux - General 5 05-29-2004 09:35 AM
Importing a script? Panzerfrost Slackware 1 11-04-2003 12:37 PM
Importing Favorites TX_metalhead Linux - General 0 01-23-2002 10:32 AM


All times are GMT -5. The time now is 04:27 AM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration