Member Avatar for ashwinperti

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

  • 5 Contributors
  • 5 Replies
  • 170 Views
  • 9 Months Discussion Span
  • Latest Post Latest Post by timmay
Member Avatar for g0rb4ch3v

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.

Member Avatar for hooknc

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

Member Avatar for ashwinperti

I had tried on the command line but was unsuccessful.

Please help me further.

Ashwin Perti

Member Avatar for Vote4WillFree

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

Member Avatar for timmay

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.