Cannot restore from dump (phpMyadmin)

[mojo jojo]

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

[Too Sexy]

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

[Too Sexy]

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

[Too Sexy]

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