---

Info about the numbers in the downloads.

---

To load With command line...

1. To load: mysql -u root -p mysql <....sql
2. To dump back into csv: mysqldump -T /tmp/ -u root -p mysql mapbyid_?? users alliances

Change "root" + "mysql" to whatever the user name/database name is.
And is whatever the MapId number is.

---

With GUI in windows...

1. Download mysql (for windows, click on the "development" tab and use >=v5.5 the older versions have problems with too many opened files.)
2. For windows: Download HeidiSql
3. Make a new session, you only need to set the password on this screen if mysql was installed on the same computer.
4. In HeidiSQL click:
1. Select a database on the left, "mysql" is usually there.
2. Import -> Load sql data -> pick the .sql file that you had extracted
3. Tools -> Preferences -> export -> change "fields separated by" to , (comma). Change "Limit Copy as CSV Copy" to 50MB
4. Tools -> Preferences -> data -> change "Number of rows displayed in data tab" to "1000000"
5. Click the "Refresh" icon, then select the table in the database, which is either users,alliances,map,mapbyid_???
6. Go to the "data" tab, press ctrl-end to load all the data into the grid.
7. Export -> export grid

---

Foreign characters
To get the foreign characters to appear correctly for some games. Before running any queries, use...

set character_set_connection = 'latin1';
set character_set_client = 'latin1';
set character_set_results = 'latin1';

Video instructions here