469,326 Members | 1,331 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

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
Jul 19 '05 #1
3 2795
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" <th*****@chc.quik.co.nz> schreef in bericht
news:En********************@news.xtra.co.nz...
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

Jul 19 '05 #2
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" <th*****@chc.quik.co.nz> schreef in bericht
news:En********************@news.xtra.co.nz...
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

Jul 19 '05 #3
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" <th*****@chc.quik.co.nz> schreef in bericht
news:En********************@news.xtra.co.nz...
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

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Ryan | last post: by
reply views Thread by mojo jojo | last post: by
2 posts views Thread by Kees | last post: by
2 posts views Thread by D. Dante Lorenso | last post: by
4 posts views Thread by Hardy | last post: by
2 posts views Thread by Jerry LeVan | last post: by
4 posts views Thread by africantract | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.