Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
taskr36
Lv 4
taskr36 asked in Computers & InternetProgramming & Design · 1 decade ago

How do I open an SQL file?

I'm trying to restore a backup for a website which is all in one sql file. so far the only thing that can open it is notepad. I've tried downloading and installing xampp with mysql, apache, and all that stuff, but I can't figure out how to use those programs to open this file. Has anyone worked with these programs before?

6 Answers

Relevance
  • doyler78
    Lv 5
    1 decade ago
    Favorite Answer

    Xampp will have phpmyadmin installed.

    Type

    http://localhost/phpmyadmin (or whatever phpmyadmin is named in your configuration) into your web browser

    Log into phpmyadmin with your username and password.

    This will connect you to mysql. Choose databases. In the tabs along the top you will see one for imports. Browse to the sql file and hit go.

    All should import. If there are any problems with the import it may be because client version of phpmyadmin may be too low for the sql file being imported in which case you will have to run sql file directly from a command line in the mysql client itself.

  • thorvald
    Lv 4
    5 years ago

    Open Sql File

    Source(s): https://shrink.im/baAcu
  • bill91173
    1 decade ago

    If you are trying to restore the database from your site, you will want to import the sql file at the site you are trying to restore. The SQL file is only the database content and does not have any of thwe files that were on your site.

    Most servers have some sort of administration for their database. If your server has a control panel, look for database (frequently MySQL) or phpMyAdmin. From there you can select the correct database and then import the sql file.

  • Anonymous
    1 decade ago

    If you mean that you want to restore a SQL file that was created with mySQLdump, then, in a DOS window, in the folder where the file is, type mysql -u whatever is the root password -ppassword name of database to restore to < name of SQL file

  • How do you think about the answers? You can sign in to vote the answer.
  • Anonymous
    7 years ago

    A good link where you can get winrar is: http://bit.ly/1t6dcCg

    You can use winrar to unzip zip file and loads of other formats. A few more programs you can use are 7zip or winzip but I still beleive winrar is the best choice. They work pretty much in the same way: you can compress or decompress files easily with a right-click.

    The big advantages of Winrar are: it's free (it's available under a trial version that never expires) and can open all the formats: .zip, .rar, .7z / 7zip, .iso, .tar, .jar etc.

    That's why I strongly recommend winrar.

  • Anonymous
    7 years ago

    Ehm..

    To open compressed files (zip rar jar iso 7z cab uue gz....) you have to use WinRar. With WinRar you can easily decompress files and folders.

    get Winrar for free here http://j.mp/1p3PhOu

    Regards

Still have questions? Get your answers by asking now.