http://www.hersoncruz.com

  • Increase font size
  • Default font size
  • Decrease font size

Web development

Joomla, Drupal, Compiere, TinyERP, vtigerCRM, Openbravo, GLPI, OOZ Your company must be open to the power of Internet and provide your customer and employees with tools to integrate work and communications,

#000000

Linux Servers

Samba, Bind9, DHCP, Apache, OpenSSH, Apache, OpenLDAP, Squid Free software has many users on corporate market. I provide quality solutions for all your needs in servers technology. Free software brings you

#000000

Security

Firewall, FreeBSD, Bastille, Tripwire, IPCop, Untangle, E-Box Give us the oportunity to protect your network against Internet threats with the most efficient software ever created. We implement firewalls, DMZ zones, network

#000000
http://www.hersoncruz.com/components/com_gk2_photoslide/images/thumbm/2811300001.jpg
http://www.hersoncruz.com/components/com_gk2_photoslide/images/thumbm/2332880003.jpg
http://www.hersoncruz.com/components/com_gk2_photoslide/images/thumbm/2313660002.jpg
thumbnailthumbnailthumbnail
Home Blog Howto backup and restore MySQL database with character set intact

Howto backup and restore MySQL database with character set intact

If you want to preserve characters like ñ, ó, ç, etc. when migrating a MySQL database use mysqldump to export the database with this options:

mysqldump -u root -p --default-character-set latin1 --skip-character-set <dbname> > mydump.mysql

create the target database with:

mysqladmin -u root -p create <dbname> --default-character-set latin1 --collate latin1_swedish_ci

then restore:

mysql -u root -p --default-character-set latin1 <dbname> < mydump.mysql


 

Newsflash

'F/OSS' is an inclusive term generally synonymous with both free software and open source software which describe similar development models, but with differing cultures and philosophies. 'Free software' focuses on the philosophical freedoms it gives to users and 'open source' focuses on the perceived strengths of its peer-to-peer development model.