Professional Web Applications Themes

MySQL Administrator Error - MySQL

Hi, tried to import a backup-file with MySQL Administrator on Linux (SuSE SLES 9). I get immediately. Error Reading Backup File File:/hdb/backup_mysql.sql Error: Unknown object in backup file. Reading via Apple OSX SQL Administrator is OK, but fails at the very end. File size is 70 GB. Any ideas? Toni -- Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner...

  1. #1

    Default MySQL Administrator Error

    Hi,

    tried to import a backup-file with MySQL Administrator on Linux (SuSE
    SLES 9).

    I get immediately.

    Error Reading Backup File
    File:/hdb/backup_mysql.sql
    Error: Unknown object in backup file.

    Reading via Apple OSX SQL Administrator is OK, but fails at the very end.

    File size is 70 GB.

    Any ideas?

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  2. #2

    Default Re: MySQL Administrator Error


    MySQL Server is: 5.0.41 from XAMPP.
    MySQLAdministrator is: 1.2.12

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  3. #3

    Default Re: MySQL Administrator Error

    > tried to import a backup-file with MySQL Administrator on Linux (SuSE 

    This could be due to case sensitive table names.

    My first guess would be wrongly cased foreign key clauses (a known MySQL
    bug). Use grep to search on lines containing 'FOREIGN KEY' and check if
    the table names in the REFERENCES clause have the correct case.

    Another question (forgive me for being a real Linux newbie): does /hdb/
    exist? I thought it was a device.

    Best regards,
    --
    Willem Bogaerts

    Application smith
    Kratz B.V.
    http://www.kratz.nl/
    Willem Guest

  4. #4

    Default Re: MySQL Administrator Error

    Hi Willem,
     
    I did a: grep "FOREIGN KEY" backup.sql
    without an occurence.
     

    Yes. It may be misleading. /hdb is just a hardware raid-filesystem

    thanks,

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  5. #5

    Default Re: MySQL Administrator Error

    MySQL dump is 10.11

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  6. #6

    Default Re: MySQL Administrator Error

    In Windows it tells me IIRC:

    file was exported by mysqldump cannot import.

    So it seems to be -not- possible to import a mysqldump file via MySQL
    Administrator,

    regards,

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  7. #7

    Default Re: MySQL Administrator Error

    A. Dischner wrote: 
    not so fast friend! isn't osx end of line and carriage return different
    than win32 and linux. you may want to test with different eol and cr
    when backing up. let us know how goes it.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. Replies: 4
    Last Post: April 11th, 11:33 AM
  2. MySQL Administrator Sheduler backup !
    By ParazaR in forum MySQL
    Replies: 4
    Last Post: June 13th, 02:37 PM
  3. Replies: 0
    Last Post: January 29th, 02:03 PM
  4. Getting an error when trying to add a MySQL datasourceto Coldfusion administrator
    By Napoleon_Dynomite in forum Coldfusion - Getting Started
    Replies: 18
    Last Post: December 2nd, 03:57 AM
  5. adding mysql datasource in CF administrator
    By BillVB in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: July 16th, 12:53 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139