LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices



Reply
 
Search this Thread
Old 06-09-2006, 04:09 AM   #1
Ameii83
Member
 
Registered: Dec 2004
Location: malaysia
Posts: 56

Rep: Reputation: 15
Unhappy to restore the database


i have "test.sql" .. the mysql file.Then i have create one database that called "test".So i want to restore the test.sql into the "test" database. What command i should use?? I have try many types commands but it never works for me
 
Old 06-09-2006, 04:29 AM   #2
prozac
Member
 
Registered: Oct 2005
Location: Australia
Distribution: slackware 12.1
Posts: 753

Rep: Reputation: 32
i think you should just run the 'test.sql' in your sql | sqlplus prompt.
 
Old 06-09-2006, 04:49 AM   #3
Ameii83
Member
 
Registered: Dec 2004
Location: malaysia
Posts: 56

Original Poster
Rep: Reputation: 15
can u give the exactly/proper command line ??
 
Old 06-09-2006, 05:11 AM   #4
prozac
Member
 
Registered: Oct 2005
Location: Australia
Distribution: slackware 12.1
Posts: 753

Rep: Reputation: 32
I am joggling it out of memory. its the same as running any of your sql commands. just copy/paste the content of the .sql file in to your prompt and run it.or you can use the edit command in sql which opens up a notepad (i guess) where you can copy/paste the content of .sql file. the save-exit the editor and back at the prompt just type / and hit enter. your commands in the .sql file should run.
 
  


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
How do I restore a MySQL database simply dobriain Linux - Software 2 04-19-2006 01:05 PM
I lost my urpmi database...how to restore it ? riccisit Mandriva 14 01-22-2006 04:14 AM
Restore chris2pher_28 Linux - Newbie 1 09-04-2005 11:37 PM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 07:58 PM
Had to restore database from backup - about 5 minutes lost jeremy LQ Suggestions & Feedback 0 01-21-2001 11:31 PM


All times are GMT -5. The time now is 10:50 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration