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
0
Newbie Poster
Recommended Answers
Jump to PostYou 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.
Jump to Postmysql --user={user name} --password={password} {database name} < {file name}.sql
and example would be...
mysql --user=root --password=password ss < ss.sql
Regards,
Nate
All 5 Replies
g0rb4ch3v
0
Junior Poster in Training
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.
hooknc
1
Posting Whiz in Training
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
ashwinperti
0
Newbie Poster
I had tried on the command line but was unsuccessful.
Please help me further.
Ashwin Perti
Vote4WillFree
0
Newbie Poster
you can mysql query browser and open the file directly and run it.
timmay
0
Newbie Poster
finally...that's the answer i was lookin for not all this command line bs.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.