Results 1 to 5 of 5

Thread: Problems with mysql-DB

  1. #1
    Join Date
    Jun 2008
    Location
    Gelnhausen, approx. 50 km east of Frankfurt
    Posts
    89

    Default Problems with mysql-DB

    Hi,

    I have set up and populated a database for my DVD collection on my Dell Mini 10v under Ubuntu 8.04. After copying the files
    HeinrichsDVDs.frm, HeinrichsDVDs.MYD, HeinrichsDVDs.MYI to my Lenovo TP 61 under openSUSE 11.1 I could open and read the database without problems.

    When trying this for the second time I got the following error message: ERROR 1017 (HY000): Can't find file: './mydvds/HeinrichsDVDs.frm' (errno: 13)

    Also, after copying the files from the netbook to the TP61 again, I still get this message. Access rights are OK.

    Any idea.

    Cheers.

    H.

  2. #2
    Join Date
    Jun 2008
    Location
    Podunk
    Posts
    26,130
    Blog Entries
    15

    Default Re: Problems with mysql-DB

    Quote Originally Posted by hgeis
    Hi,

    I have set up and populated a database for my DVD collection on my Dell
    Mini 10v under Ubuntu 8.04. After copying the files
    HeinrichsDVDs.frm, HeinrichsDVDs.MYD, HeinrichsDVDs.MYI to my Lenovo
    TP 61 under openSUSE 11.1 I could open and read the database without
    problems.

    When trying this for the second time I got the following error message:
    *ERROR 1017 (HY000): Can't find file: './mydvds/HeinrichsDVDs.frm'
    (errno: 13)*

    Also, after copying the files from the netbook to the TP61 again, I
    still get this message. Access rights are OK.

    Any idea.

    Cheers.

    H.
    Hi
    Does this help?
    http://forum.percona.com/index.php/t/685/

    --
    Cheers Malcolm (Linux Counter #276890)
    SUSE Linux Enterprise Desktop 11 (x86_64) Kernel 2.6.27.29-0.1-default
    up 1 day 22:49, 3 users, load average: 2.53, 2.20, 1.43
    GPU GeForce 8600 GTS Silent - Driver Version: 190.18


  3. #3
    Join Date
    Jun 2008
    Location
    /dev/belgium
    Posts
    1,946

    Default Re: Problems with mysql-DB

    you should really export your DBs with mysqldump and then import them on the new machine. Much easier than copying files around and changing perms

  4. #4
    Join Date
    Jun 2008
    Location
    Gelnhausen, approx. 50 km east of Frankfurt
    Posts
    89

    Default Re: Problems with mysql-DB

    Hi and thanks,

    But where does mysqldump write the output to? Couldn't find a file
    (the DB name is MyDVDs) and could not find a hint for name/location of output file in /etc/mysql/my.cnf either.

    Can you help?

    Cheers.

    H.

  5. #5
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: Problems with mysql-DB

    To standard output or to the file specified with the -r option. There is a man page for it.

Posting Permissions

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