SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2002
    Location
    Texas
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PLEASE HELP! How to restore MySQL database?

    I made a major mistake and messed up the data in one of my MySQL tables. I have a backup file created with mysqldump. But I can't restore the database! I tried this from the command line:

    Code:
    mysql [database name] < [backup file name]
    But it's not working. It is showing me the mysql setup or something, but the backup database is not being restored.

    Thanks for your help!

  2. #2
    SitePoint Enthusiast
    Join Date
    Apr 2002
    Location
    Texas
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I just realized that I could open the backup file and restore the table by using the CREATE TABLE and INSERT commands in the backup file.

    I just dropped the table and then pasted all of those commands. That worked OK, but I thought there might be an easier way.


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
  •