SitePoint Sponsor

User Tag List

Results 1 to 16 of 16
  1. #1
    blonde.... Sarah's Avatar
    Join Date
    Jul 2001
    Location
    Berkshire, UK
    Posts
    7,442
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    mysql error?? Error: Can't create/write to file '\#sql2a_52_0.MYI' (Errcode: 13)

    I ahve just got thisnew error

    Error: Can't create/write to file '\#sql2a_52_0.MYI' (Errcode: 13)

    on a system that has been working for months.. I reloaded a new dB and a backup ciopy and this happened.

    On a different machine with same dB and same code it works fine

    any ideas guys?

    Sarah
    Regular user

  2. #2
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I assume you're using Windows...

    open your MySQL my.cnf file and under [mysqld] make sure you have tmpdir=your temporary directory. Something like

    [mysqld]
    tmpdir=c:/temp

    Alternatively, for Linux (or Windows for that matter) run

    mysqld --tmpdir=\tmp (or whatever your temp folder is)


    HTH.

    Sketch
    Aaron Brazell
    Technosailor



  3. #3
    blonde.... Sarah's Avatar
    Join Date
    Jul 2001
    Location
    Berkshire, UK
    Posts
    7,442
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Okay.. yes win NT (sorry)

    firstly

    where is my.cnf file??

    also did the

    mysqld --tmpdir=c:/temp

    and

    mysqld --tmpdir=/temp

    and it just says

    can't initialize InnoDB as 'innodb_data_file_path' is not set

    and then does nothing I have to close the prompt down to get a prompt back??




    Sarah
    Regular user

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it should be in your c:/mysql or whatever directory your mysql is in...Not exactyl sure if it's in a subdir or not...you'll have to look./ I'm not at home right now or I'd look.

    sketch
    Aaron Brazell
    Technosailor



  5. #5
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wrong forum Sarah!

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  6. #6
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    how so?! It's in the Files, DATABASES, and XML forrum..

    Sketch
    Aaron Brazell
    Technosailor



  7. #7
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Psst, Aaron: http://www.sitepointforums.com/forum...?s=&forumid=34

    Tom-die-dom-die-die-die-dom ...

  8. #8
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ignore the man behind the curtain...

    Sorry, Sean

    Sketch
    Aaron Brazell
    Technosailor



  9. #9
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


    Anyway, Sarah, with a typical install of MySQL, the my.cnf file should be somewhere in your system root. Try looking in C:/my.cnf. It sits there nice and quitly with me .

  10. #10
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Sketch
    Sorry, Sean
    That's ok!

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  11. #11
    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)
    MySQL doesn't install any my.cnf/my.ini by default. check C:\ for my.cnf or Windows\ on 9x or WINNT\ on NT for my.ini. see if you have `tmpdir=path' under the `[mysqld]' section. if you do, try removing it (since mysqld should use the system's temp directory by default), or point it to a directory that you know exists. you can see where the tmpdir is currently with this query:

    Code:
    SHOW VARIABLES LIKE 'tmpdir';
    - 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

  12. #12
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Mark T.
    Psst, Aaron: http://www.sitepointforums.com/forum...?s=&forumid=34

    Tom-die-dom-die-die-die-dom ...
    now that was funny lol

    the my.cnf file, if you can't find it in your root directory (c:\) as my.cnf, or in your winnt directory as my.ini, would be available in your mysql folder (probably c:\mysql)... it's probably named my-example.cnf or my-small.cnf (and a few others)... pick the one that suits you best, make a copy of it, rename it to my.cnf, make your changes, then place it in your root directory (you can also rename it to my.ini and place it in your winnt dir)

    that's in the off-chance that it isn't already there

  13. #13
    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)
    i don't like any of those my-xxx.cnf's. the variables are either too small or too big. i would just recommend using this as a "base" my.cnf:

    Code:
    [mysqld]
    # Uncomment and change the next line if you installed
    # MySQL somewhere other than the default C:/mysql
    #basedir=C:/mysql
    port=3306
    skip-locking
    set-variable = table_cache=512
    set-variable = thread_cache_size=8
    set-variable = wait_timeout=3600
    
    [client]
    port=3306
    # Here you can put your username and password
    # if you want so that you don't have to manually
    # enter them when using mysql, mysqldump, etc.
    # Uncomment the lines if you do!
    #user=<username>
    #password=<password>
    
    [mysql]
    no-auto-rehash
    
    [mysqldump]
    quick
    and of course in this case add `tmpdir=path' if you need it under [mysqld].

  14. #14
    blonde.... Sarah's Avatar
    Join Date
    Jul 2001
    Location
    Berkshire, UK
    Posts
    7,442
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    sorry sean was having a bad day and I lumped it with php see other thread in php forum where H kindly took the **** out of me too !!! I'm blonde [and hungover today] thats all I can say in my defense

    cheers sketch, Mark, dr_larry_peper, redemption

    that sample file you gave me worked a treat thank you so much (I added in tmpdir didn't like it if I didn't)

    cheers resolved a nasty problem that would have slowed me up all day..

    's all round [on me of course]

    Thanks

    Sarah
    Regular user

  15. #15
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What about skip-innodb Matt?

    Don't worry Sarah

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  16. #16
    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)
    Originally posted by seanf
    What about skip-innodb Matt?
    well yeah, add that too under [mysqld] if you're using a version of MySQL with InnoDB support (-max probably...?) and don't want to use it, or if you're getting errors about starting InnoDB.


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
  •