SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2002
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    problem importing SQL file.

    Hi;
    I have made a db contains couple of tables,
    and some data on it, just because I wanted to have a backup of my db, I exported my db as SQL, using MYSQL Front, anyway, sometime ago acidentally while working with MysQl front, I deleted one table of my DB, now I want to use the exported data which is in SQL format to recover the lost data, But I can not find anyway to import the db, in MYSQL FRONT, and DB TOOL
    there is no option of importing the sql data in these two porgram I have, but I can open the file as query in these programs, but I don't know how to transfer the table structure and data to my db,
    I even tried to open the file using MS Access, but not successful.
    Anyone know how to do it?

    Thanks

  2. #2
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not familiar with Mysql-front but if you are able to cut and paste SQL queries into it then just copy everything out of the .sql file and put it in there.

    Do you have access to phpmyadmin?
    I swear to drunk I'm not God.
    Matt's debating is not a crime
    Hint: Don't buy a stupid dwarf Clicky


Bookmarks

Posting Permissions

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