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

Open source software (OSS) began as a marketing campaign for free software. OSS can be defined as computer software for which the human-readable source code is made available under a copyright license (or arrangement such as the public domain) that meets the Open Source Definition.