<div>
How are you executing the mysqldump command, i.e. what arguments are you using? &nbsp;you can use the --xml flag to output things in XML or you may want to pipe your output into a file (mysqldump [arguments] &gt;&nbsp;$filename
</div>


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

<div>
This is the statement structure I'm using:<br />

<pre><code id="code-20-36713173-1"> mysqldump -u username -p database_name &gt; dumpfile.sql</code></pre>
</div>


This is the statement structure I'm using:


 mysqldump -u username -p database_name > dumpfile.sql

<div>
Solved it myself but can't remember how.
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
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 &quot;£&quot; sign, quotes, dashes and double quotes.<br />
<br />
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?<br />
<br />
Thank you
</div>
</div>


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

Moving databse via SSH, collation issues?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.