SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2002
    Posts
    38
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    restoring logs with mySQL

    I have created update logs with the following command in the my.ini file:
    [mysqld]
    log-update=update

    this created the file update.001 in the data folder of mySQL.

    I was able to flush the logs with:
    mysqladmin -u root -pmypasswd flush-logs
    and it created a new log file update.002 in the data folder.

    When I try to run the restore log command I get this error:
    C:\mysql\bin>mysql -u root -pmypasswd --one-database na < update.001
    File not found


    what am I doing wrong? Do I have to specify the full path?

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: restoring logs with mySQL

    Originally posted by OpticChild
    Do I have to specify the full path?
    yeah, since i imagine it's looking in the C:\mysql\bin directory because that's where you're working from.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


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
  •