954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Upload Database

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

ashwinperti
Newbie Poster
22 posts since Aug 2005
Reputation Points: 10
Solved Threads: 0
 

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.

g0rb4ch3v
Junior Poster in Training
86 posts since Oct 2003
Reputation Points: 10
Solved Threads: 0
 

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

hooknc
Posting Whiz in Training
219 posts since Aug 2005
Reputation Points: 11
Solved Threads: 8
 

I had tried on the command line but was unsuccessful.

Please help me further.

Ashwin Perti

ashwinperti
Newbie Poster
22 posts since Aug 2005
Reputation Points: 10
Solved Threads: 0
 

you can mysql query browser and open the file directly and run it.

Vote4WillFree
Newbie Poster
7 posts since Jul 2006
Reputation Points: 10
Solved Threads: 0
 

finally...that's the answer i was lookin for not all this command line bs.

timmay
Newbie Poster
1 post since May 2006
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You