By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,666 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,666 IT Pros & Developers. It's quick & easy.

Cannot restore from dump (phpMyadmin)

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.