943,790 Members | Top Members by Rank

Web Development > Databases > MySQL > Upload Database
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 10186
  • MySQL RSS
Permalink
Sep 17th, 2005
0

Upload Database

Expand Post »
Sir,
I had mysql file ss.sql.

Now I want upload the file in the Database.

Is there any way to do the same.
Kindly help me in the matter.



Ashwin Perti
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ashwinperti is offline Offline
22 posts
since Aug 2005
Permalink
Sep 17th, 2005
0

Re: Upload Database

You want to REload your previous datebase save? Go into phpMyAdmin and in the SQL tab copy and paste what is in the SQL file or upload it...

If it times out you may want to upload it via FTP and then run restoration via SSH & PuTTy.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
g0rb4ch3v is offline Offline
85 posts
since Oct 2003
Permalink
Sep 17th, 2005
0

Re: Upload Database

mysql --user={user name} --password={password} {database name} < {file name}.sql

and example would be...

mysql --user=root --password=password ss < ss.sql

Regards,

Nate
Reputation Points: 11
Solved Threads: 8
Posting Whiz in Training
hooknc is offline Offline
216 posts
since Aug 2005
Permalink
Sep 17th, 2005
0

Re: Upload Database

I had tried on the command line but was unsuccessful.

Please help me further.

Ashwin Perti
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ashwinperti is offline Offline
22 posts
since Aug 2005
Permalink
Jul 12th, 2006
0

Re: Upload Database

you can mysql query browser and open the file directly and run it.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Vote4WillFree is offline Offline
7 posts
since Jul 2006
Permalink
Jul 13th, 2006
0

Re: Upload Database

finally...that's the answer i was lookin for not all this command line bs.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
timmay is offline Offline
1 posts
since May 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Grouping question
Next Thread in MySQL Forum Timeline: Its really a problem on INSERT statement





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC