• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Moving databse via SSH, collation issues?

Hi All,

I'm moving a Latin1 database to a new server but when used mysqldump via SSH there are a few problems with special characters like the "£" sign, quotes, dashes and double quotes.

Is there a way I could do do the MySQL dump while converting special characters to html entities or is there a way to make the changes before exporting the database via SSH?

Thank you
0
Mulith
Asked:
Mulith
  • 3
1 Solution
 
G23PlusLinuxEqualsNetworkSecurityCommented:
How are you executing the mysqldump command, i.e. what arguments are you using?  you can use the --xml flag to output things in XML or you may want to pipe your output into a file (mysqldump [arguments] > $filename
0
 
MulithAuthor Commented:
This is the statement structure I'm using:
 mysqldump -u username -p database_name > dumpfile.sql

Open in new window

0
 
MulithAuthor Commented:
Solved this myself
0
 
MulithAuthor Commented:
Solved it myself but can't remember how.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now