Cannot restore from dump (phpMyadmin)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • mojo jojo

    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


Working...