On 12/09/11 08:26 +0200, Davide Mirtillo wrote:
How are you dumping the db? Try with mysqldump:
mysqldump -u <username> -p <dbname> > dump.sql
Better use the --default-character-set=utf8 option, too, since whithout it can cause problems with the encoding of special characters (Umlaute f.e.).
mysqldump --default-character-set=utf8 -u <username> -p <dbname> > dump.sql
If you can't use mysqldump, you can use the backup and migrate module. http://drupal.org/project/backup_migrate
Have a nice day Rolf