Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    139

    Unanswered: May an .sql file viewed in excel ? restore a database from .sql file can be done ?

    In PHPMyAdmin extract the database in .sql file includes and data and structure ? May an .sql file viewed in excel ? restore a database from .sql file can be done ?

    In PHPMyAdmin the .sql files in the most common way backup all the database in phpmyadmin ?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, the .sql file can include both structure and data

    no, you can view it in a text editor instead (e.g. notepad)

    yes, you can restore from a .sql file

    yes, this is a common way to back up tables

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •