I have this database that i want to move to other server i dumped it to a .sql file, i can open it with any text reader like notepad++ ( windows ) and evey character looks ok... the database is in portuguese and so some are special characteres... they all look ok, but when i upload the file to the server those chars get al messed up. i edited the file with pico and there they are.. all messed up... i try upload via ftp using binary mode... but it didnt solve anything... any ideas on how to fix this? the file is too big to load on phpmyadmin
Make sure the encoding is set the same on the database, the connection from the client, and on the tables (MySQL 4.1+) as the source encoding. All have to match up or there will be corruption.
everything were mached. but someway the text file had a diferent seting. "ascii as ansi" or something. i solved it by creating a blank text file on my local machine and copy-paste the text. what the heck.... where do i define a textfile enconding?
error-proof: use an old phpMyadmin version to import/export your database. The newer the version, the fancier, buggy and plenty of annoying iframes, javascript errors, etc. etc. No to mention that (IMO) useless charset function in addition, if the file is too big use this script to perform the task: BigDump http://www.ozerov.de/bigdump.php