#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    USA
    Posts
    67
    Rep Power
    15
    i made a backup of a databse into a file.sql file, but how can i use this ?

    i would like to make a backup database with this file, but how do i do this? what other usages are for the files with sql extension?

    thanks for the info

    -david
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4476
    sql files usually contain a bunch of sql commands to recreate the database. to load this sql file back into a database, you can use

    mysql -uuser -p database_name < yourfile.sql

    that's assuming the database is already created.

    ---John Holmes...
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    USA
    Posts
    67
    Rep Power
    15
    cool, thanks a lot for the help.

    -david

IMN logo majestic logo threadwatch logo seochat tools logo