Gallatin: Dump and import semi-works, as data is stored as utf8 in latin1 tables, php/mysql are set to latin1
Wessner: Imig: yeah, i know, let’s not comment it’s a bad idea, we all know it :
Imig: BerhanK: if they are indeed identical then stop the SQL server and binary copy the DB
Klingen: But dump and export should give identical data
Fitzsimmons: Imig: I have several db’s so I don’t copy the whole file, but export the db, then import on the other side
Imig: What’s wrong with that approach?
Chaix: The data looks in utf8 format
Clyatt: BerhanK: Dump the structure and data separately
Imig: BerhanK: I mean what goes wrong?
Inserra: The website shows the funny chars , to fix it, I copy say the name of a person, alter it to say 22, then paste back the same data that was there before, now the data looks right on the site
Swiger: Https://gist.github.com/e8fd13f5313fc9af82b4 Could I make the querying more efficient for this schema? This table just stores memory, cpu, and player count on those servers. I’m still not sure how often data should last before it gets deleted, but there will be an insertion every second or two.
Imig: BerhanK: check your locale and ch****t settings
Dougher: I did dump them separately, now importing the data alon, after the dbchema was imported separately
Imig: Or even better, use iconv
Imig: To fix the ch****t issues
Alsobrooks: That’s the thing, not sure the ch****t is an issue
Clyatt: BerhanK: Then create the new database using the first dump and before importing the data ALTER all tables to set ch****t to BINARY
Clyatt: BerhanK: If you have lot of tables it is easy to do it by replacing ch****t in the dump
Clyatt: BerhanK: Then import the data and after that try ALTER TABLE . SET CHARACTER SET utf8; do not use CONVERT at this point
Mcmellen: Importing only the data takes very long time
Rosella: The databases are already in utf8 col
Hultgren: Update: importing the data alone worked perfectly
Mynear: But I did dump the chema first, changed latin1 to utf8, then imported the chema in new VM
Kennerly: The issue, is the data import takes soooo long , almost 2-3 hours
Corre: While importing from say heidiSQL, read csv file pulls in the data in few minutes with errors
Chaconas: Dump db is very fast, exporting data only is slow
Delpozo: As is import data only
Manin: I’ll try http://www.garethsprice.com/blog/2011/fix-mysql-latin1-utf-character-encoding/
Keyworth: So my issue now really is export/import takes long time, as each record will be exported/imported by own statement, probably over 1M insert statements
Rumery: Delzer, no primary key?
Furutani: Ok I’ll stop repeating three times or it’s goin to be painful for my hands =
Florestal: Rumery, what would I make it out of?
Furutani: I’m playin around with timezone atm
Rumery: Delzer, you have to know ; can there be multiple rows with the same server_session_id ?
Rasulo: Rumery, yeah it records stats for many server_session_id
Furutani: And I’m a bit confused, I loaded the mysql.time_zone and time_zone_name tables as explained in the doc, and had a look at it and I can’t find CST.
Furutani: But a long list of city
Rumery: Delzer, so there are multiple stats for the same server session with different timestamps?
Furutani: Any idea what’s the name of CST tz in mysql ?
Palagi: Rumery, keep in mind, this table is meant to provide a graph in the future, and not necessarily querying per server.
Furutani: Or szhould I use a city name that uses CST ?
Rumery: Delzer, if you do not give any primary or unique key to an inoodb table, the server creates some sort of autoincrement automagically for the table to work, you cannot see it or use it but it is still there