csv import issues - good solution found

A week or so ago, I was seeking a solution for breaking lines for importing csv to phpmyadmin interface Found a slick solution: http://csv2sql.evandavey.com/ create table in database, upload the csv file to above page, copy/paste the resulting code into SQL field for the database (not the ta

Re: many-inserts go faster the second time

Hi Bennett, all, sorry about the delay, I was somewhat busy. Bennett Haselton wrote: > At 02:53 AM 10/2/2009, Joerg Bruehe wrote: >> Hi Bennett, all! >> >> >> Bennett Haselton wrote: >> > [[...]] >> >> Your "fairy dust" is called "access pattern", evaluated by a LRU or >> similar policy. >> >> D

RE: Optimizing my.cnf

If it's a dedicated MySQL server I would increase the key buffer to at least half the available main memory and leave the rest for filesystem cache. You'll probably get the biggest performance increase this way. Cheers, A -Original Message- From: sangprabv [mailto:sangpr...@gmail.com]

Bin log unsafe events with log_bin_trust_function_creators option.

Hello, In description of log_bin_trus_function_creators I found: "This variable applies when binary logging is enabled. It controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log". Could somebody explain

RE: mysql odbc connection problem

Make sure you have granted permissions in the db for root to connect from the host you are trying to connect from. Something like GRANT priv ON db.table TO 'root'@'hostname' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; regards Regards John Daisley Mobile +44(0)7812 451238 Email j...@butter

Re: troubles with complex UTF-8 characters

On Martes, 6 de Octubre de 2009 11:03:12 Daniel Drake escribió: > Hi, > > I'm having trouble working with specific UTF-8 characters. For > example, the U+10330 character (UTF8: 0xF0 0x90 0x8C 0xB0). MySQL currently only supports Basic Multilingual Plane characters: up to 3- byte utf8 on its stab

mysql odbc connection problem

Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'hostname' (using pas

troubles with complex UTF-8 characters

Hi, I'm having trouble working with specific UTF-8 characters. For example, the U+10330 character (UTF8: 0xF0 0x90 0x8C 0xB0). Background: I am trying to clone wiktionary onto local intranets in a series of (disconnected) schools in Nepal. I'm encountering these problems when trying to import th