Cannot restore from dump (phpMyadmin)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mojo jojo
    #1

    Cannot restore from dump (phpMyadmin)

    This may really be a phpMyAdmin problem, I think - but keen to hear your
    thoughts. Any help appreciated.

    Using phpMyAdmin to export an entire database works fine - I get a
    mydatabase.sql file.

    Restoring (using phpMyAdmin) usually work fine. However, if any of the data
    in any of the fields contains the '#' character, it bombs out citing a
    syntax error. I have tried escaping the character with '\' to no avail -
    still gives syntax errors.

    Seems strange that phpmyadmin dumps a file that will not restore...? I have
    tried this on several versions of phpMyAdmin and get the same result every
    time.

    Have searched for ages looking for a solution, anyone else experienced thia?
    solutions?

    Thanks a lot

    Peter Thomas


    Tags: None
    • Too Sexy
      #2
      Re: Cannot restore from dump (phpMyadmin)

      I experienced a similar problem,
      it seemed a difference in phpMyAdmin in the orignal (newer)
      and where I wanted it (older).
      No solution found except creating my own import script in PHP ;)


      "mojo jojo" <thomasp@chc.qu ik.co.nz> schreef in bericht
      news:EnkPb.1871 3$9k7.332178@ne ws.xtra.co.nz.. .[color=blue]
      > This may really be a phpMyAdmin problem, I think - but keen to hear your
      > thoughts. Any help appreciated.
      >
      > Using phpMyAdmin to export an entire database works fine - I get a
      > mydatabase.sql file.
      >
      > Restoring (using phpMyAdmin) usually work fine. However, if any of the[/color]
      data[color=blue]
      > in any of the fields contains the '#' character, it bombs out citing a
      > syntax error. I have tried escaping the character with '\' to no avail -
      > still gives syntax errors.
      >
      > Seems strange that phpmyadmin dumps a file that will not restore...? I[/color]
      have[color=blue]
      > tried this on several versions of phpMyAdmin and get the same result every
      > time.
      >
      > Have searched for ages looking for a solution, anyone else experienced[/color]
      thia?[color=blue]
      > solutions?
      >
      > Thanks a lot
      >
      > Peter Thomas
      >
      >[/color]


        Comment

        • Too Sexy
          #3
          Re: Cannot restore from dump (phpMyadmin)

          I experienced a similar problem,
          it seemed a difference in phpMyAdmin in the orignal (newer)
          and where I wanted it (older).
          No solution found except creating my own import script in PHP ;)


          "mojo jojo" <thomasp@chc.qu ik.co.nz> schreef in bericht
          news:EnkPb.1871 3$9k7.332178@ne ws.xtra.co.nz.. .[color=blue]
          > This may really be a phpMyAdmin problem, I think - but keen to hear your
          > thoughts. Any help appreciated.
          >
          > Using phpMyAdmin to export an entire database works fine - I get a
          > mydatabase.sql file.
          >
          > Restoring (using phpMyAdmin) usually work fine. However, if any of the[/color]
          data[color=blue]
          > in any of the fields contains the '#' character, it bombs out citing a
          > syntax error. I have tried escaping the character with '\' to no avail -
          > still gives syntax errors.
          >
          > Seems strange that phpmyadmin dumps a file that will not restore...? I[/color]
          have[color=blue]
          > tried this on several versions of phpMyAdmin and get the same result every
          > time.
          >
          > Have searched for ages looking for a solution, anyone else experienced[/color]
          thia?[color=blue]
          > solutions?
          >
          > Thanks a lot
          >
          > Peter Thomas
          >
          >[/color]


            Comment

            • Too Sexy
              #4
              Re: Cannot restore from dump (phpMyadmin)

              I experienced a similar problem,
              it seemed a difference in phpMyAdmin in the orignal (newer)
              and where I wanted it (older).
              No solution found except creating my own import script in PHP ;)


              "mojo jojo" <thomasp@chc.qu ik.co.nz> schreef in bericht
              news:EnkPb.1871 3$9k7.332178@ne ws.xtra.co.nz.. .[color=blue]
              > This may really be a phpMyAdmin problem, I think - but keen to hear your
              > thoughts. Any help appreciated.
              >
              > Using phpMyAdmin to export an entire database works fine - I get a
              > mydatabase.sql file.
              >
              > Restoring (using phpMyAdmin) usually work fine. However, if any of the[/color]
              data[color=blue]
              > in any of the fields contains the '#' character, it bombs out citing a
              > syntax error. I have tried escaping the character with '\' to no avail -
              > still gives syntax errors.
              >
              > Seems strange that phpmyadmin dumps a file that will not restore...? I[/color]
              have[color=blue]
              > tried this on several versions of phpMyAdmin and get the same result every
              > time.
              >
              > Have searched for ages looking for a solution, anyone else experienced[/color]
              thia?[color=blue]
              > solutions?
              >
              > Thanks a lot
              >
              > Peter Thomas
              >
              >[/color]


                Comment

                Previous template Next
                Working...