On 08/10/11 15:29 +0200, Jeff Brown wrote:
On Sat, 2011-10-08 at 08:49 -0400, James Rome wrote:
If you have SSH access:
mysqldump -u username -p yourdatabase > yourdatabase.sql
[...]
mysql -u username -p yourdatabase < yourdatabase.sql
I ran into encoding problems doing it this way. It might have been caused by different mySQL versions on the servers. YMMV. I would recommend using options to specify the encoding (f.i. --default-character-set=utf8).
regards Rolf