Professional Web Applications Themes

Having trouble with mysqldump - MySQL

Hi, I'm new to MySQL - having used Microsoft SQL Server for about 10 years. I'm not terribly impressed. All of my attempts to move data from mssql to mysql through the data migration tool failed - and this was on a really simple schema with six tables. I finally had to write a Java program to do the job right. Now I'm having problems with mysqldump. I took what I thought was a backup of my database and tried to load it into another server to make sure it worked - it didn't. When I execute the script, I ...

  1. #1

    Default Having trouble with mysqldump

    Hi,

    I'm new to MySQL - having used Microsoft SQL Server for about 10 years.

    I'm not terribly impressed. All of my attempts to move data from mssql
    to mysql through the data migration tool failed - and this was on a
    really simple schema with six tables. I finally had to write a Java
    program to do the job right.

    Now I'm having problems with mysqldump. I took what I thought was a
    backup of my database and tried to load it into another server to make
    sure it worked - it didn't. When I execute the script, I get an error
    saying the syntax of "UNLOCK TABLES" is wrong. Then I get about a dozen
    more syntax errors, all of which look like they are being caused by
    column data containing quote marks which was not properly escaped by
    the dump application. (I did specify both "--quote-names" and
    "--allow-keywords" on the command line, but it's hard for me to imagine
    that any program purporting to dump data in a generic fashion would not
    automatically account for strings with quotes in them).

    Finally, the script ends with a series of errors that say, "MySQL
    server has gone away".

    Can anyone offer any guidance? I read the manual page for mysqldump
    several times.

    Thanks,
    Frank

    flarosa Guest

  2. #2

    Default Re: Having trouble with mysqldump

    I am also seeing that the blue dots in the editor, which I think are
    supposed to indicate the beginnings of statements, are often not at the
    beginnings of statements.

    I strongly suspect that the editor in the query browser is not parsing
    lines over a certain length correctly - I'm running the Windows version
    of the query browser.

    flarosa Guest

Similar Threads

  1. Backup & restore MySQL, not using mysqldump
    By Jerry T in forum PHP Development
    Replies: 2
    Last Post: November 15th, 09:49 PM
  2. mysqldump file - interpreting syntax
    By roch77@gmail.com in forum MySQL
    Replies: 2
    Last Post: June 2nd, 12:18 PM
  3. [PHP] mysqldump
    By Marios Adamantopoulos in forum PHP Development
    Replies: 2
    Last Post: July 25th, 05:53 PM
  4. mysqldump
    By Marios Adamantopoulos in forum PHP Development
    Replies: 2
    Last Post: July 25th, 03:53 PM
  5. Replies: 1
    Last Post: July 25th, 11:51 AM

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