importing zipped database through phpMyAdmin

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dinesh1985singh
    New Member
    • Apr 2010
    • 49

    importing zipped database through phpMyAdmin

    Hello Everyone,

    I am trying to import zipped database through phpmyadmin and getting this message.

    *

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br /> <b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tr' at line 1

    Could anyone suggest me how to fix this.

    Thanks
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    You have HTML code buried in the SQL syntax.
    This will have to be removed before executing the file.

    Comment

    • dinesh1985singh
      New Member
      • Apr 2010
      • 49

      #3
      Thanks code :)

      but could you have any idea how would I do that from zipped file. Because its not getting unzip.

      Comment

      • HaLo2FrEeEk
        Contributor
        • Feb 2007
        • 404

        #4
        Unzip it, remove the HTML, then rezip it?

        Comment

        Working...