phpmyadmin | h4x3d.com

Wrong character encoding – Latin-1, UTF-8 data in MySQL

By: jz

24-06-2011

0 comments

This article saved me quite some headache – also this is the cleanest solution of all. For several other workarounds, see Stackoverflow here.

The solution that works was:

mysqldump -h (your ip) -u (your username) -p  --opt --quote-names \
--skip-set-charset --default-character-set=latin1 (your db name) > (your db name)-dump.sql

mysql -h (your ip) -u (your username) -p \
--default-character-set=utf8 (your db name) < (your db name)-dump.sql

delete the brackets, dont fill in the brackets (your ip) = 127.0.0.1 for instance

Optimize your SQL-Database

By: jez

18-01-2008

Dailies

0 comments

It does what it says – it optimizes your sql-database (really hard!).
From time to time it makes sense to log into phpMyAdmin, click the desired database, select all tables and select “optimize” from the drop-down.

My WordPress Database went down 4MB (from 20MB to 16MB), here are some figures after the optimization:

16 tables total
47.081 entries
MyISAM type
language: utf8_general_ci
size: 16,8 MB
overhead: 0 Bytes (was insanely high before the optimization)

Duplicate entry ?0′ for key 1

By: jez

23-04-2006

code, Wordpress

0 comments

1. Go into your phpMyAdmin panel.
2. For each tables structure, edit the first entry (which should be a primary key such as ID).
3. Delete the 0 in the default value and select “auto_increment” in the drop-down menu next to it (on the right).
4. Save.
5. Go to the next table and do the same.

- h4x3d.com

Wrong character encoding – Latin-1, UTF-8 data in MySQL

Optimize your SQL-Database

Duplicate entry ?0′ for key 1

From the newsstand

Recent entries

Categories

Recent comments