.
Any help would be appreciatedI'm new to this multiple language thing.
Thanks!
-Andy
--
--
Andrew Mull
Tower Communications, LLC
102 Carmen Drive
Blandon, PA 19510
Work: 610-926-9734
Cell: 484-794-9433
[EMAIL PROTECTED]
www.tower-communications.com
--
MySQL
Hello,
I'm having a problem with moving a database from one server to another using
mysqldump. Since the servers are different platforms, some ascii characters
are getting corrupted.
So, my thought was to copy the table from one database to the other via the
mysql interface.
I found this
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong
character
set.
Andrew Mull [EMAIL PROTECTED] wrote:
I'm moving a database from one server to another. Both are unix based,
however the original database
ascii characters (decimal 39 (') and 34 ()) --
not smart quotes? you shouldn't have any trouble with the standard
quote characters, but as the representation of smart quotes isn't
standard you will.
-- Original Message --
From: Andrew Mull [EMAIL PROTECTED]
To: mysql
On other instances, are escaped as \...I would think that should translate
correctly?
Thanks
Quoting Andrew Mull [EMAIL PROTECTED]:
When I look at the dump file, I see that one of the invalid characters is
represented as /226 I'll have to look to see if it is consistent, and just
in Address with the new ID assigned to Person that was created
with the merge?
Thanks for the help!
Quoting Philippe Poelvoorde [EMAIL PROTECTED]:
Andrew Mull wrote:
I'm working on a rather large database with many cross-linked tables
currently using auto increment IDs. The system
in the details later.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Andrew Mull [EMAIL PROTECTED] wrote on 12/21/2004 12:20:57
PM:
You are correct in that I need to merge two tables. However, I'm
not clear on
how to update the FKs in the sub tables
I'm working on a rather large database with many cross-linked tables
currently using auto increment IDs. The system is primarily a web based
system, however, there will be times that the system will be run as a stand
alone server...meaning no internet connection is available.
The question