|
|
MySQL DB Export Issues
|
|
|
|
Mac Elite
Join Date: Dec 2002
Location: Silicon Valley
Status:
Offline
|
|
I work for a university newspaper I've recently redesigned(and still working on it @ columbiachronicle.com.). I exported the old DB and imported it into the new server. The problem is all of the quotation marks are now "?" in the old archive stories. Is there a way to fix this?
The old DB is gone and can't re-export it. I think it's a hexadecimal problem, or something...
Help me! It sucks have a bunch of journalists mad at you! They are crazy in the first place...
|
Anyone who would letterspace blackletter would steal sheep. - Frederic Goudy
|
|
|
|
|
|
|
|
Senior User
Join Date: Nov 2003
Location: Middle of the street
Status:
Offline
|
|
Originally Posted by Webscreamer
I work for a university newspaper I've recently redesigned(and still working on it @ columbiachronicle.com.). I exported the old DB and imported it into the new server. The problem is all of the quotation marks are now "?" in the old archive stories. Is there a way to fix this?
The old DB is gone and can't re-export it. I think it's a hexadecimal problem, or something...
Help me! It sucks have a bunch of journalists mad at you! They are crazy in the first place...
First thing you might want to do is backup the current database.
Second, If you have access to phpmyAdmin, export the database out. This will create the database structure and data in one plain-text file. You can then open it and find-replace the "?" in it and import this file back into MySQL using phpmyAdmin.
Or It could be a "Collation" problem. Make sure you have the correct collation (character set) set for the database.
Hope this help; otherwise let me know; but keep in mind that I am not an expert on MySQL.
Cheers.
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Dec 2002
Location: Silicon Valley
Status:
Offline
|
|
If I find the "?" and replace, it will delete all of real "?"s
There are over 3000 articles in the database....
I think i'm **** out of luck.
How do I change the "Collation" and character set?
|
Anyone who would letterspace blackletter would steal sheep. - Frederic Goudy
|
|
|
|
|
|
|
|
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status:
Offline
|
|
Originally Posted by Webscreamer
If I find the "?" and replace, it will delete all of real "?"s
i guess you could try and use context - like if the ? is not at the end of a sentence it would be a quote, and there should always be pairs of quotes. sounds like a tricky one.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|