TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)

2006-06-27 Thread Denis Gerasimov
Hello list, I have a question related to the two MySQL data types mentioned in the subject. Are they totally identical or not? I am asking this question due to the problem I am facing right now. The thing is that yesterday I downloaded a tool named Advanced Data Generator for MySQL (by Upsc

[OT] List of countries, regions and cities

2006-01-11 Thread Denis Gerasimov
Hello list, I am in a need of a database that contains the list of all countries, regions and cities in the world, in RUSSIAN language. Does anybody know where can I find it? I searched Google but all of the databases are in English. Have a great day, Denis S Gerasimov Web Develope

RE: The best way to transfer data to another server

2005-03-30 Thread Denis Gerasimov
> > > > Are there any standard MySQL tools available for doing that (I mean > > > MySQL > > > > Administrator/Query Browser etc.) > > Have you looked at mysqldump and mysqlhotcopy? I know about standard mysqldump utility but I actually needed something with GUI interface. > > I assume that tha

RE: The best way to transfer data to another server

2005-03-30 Thread Denis Gerasimov
> > > > Hello list, > > > > I have two MySQL 4.1 servers, one local and one remote. I need to > transfer > > database from one server to another. What actually is the best way of > > handling this task? > > > > Are there any standard MySQL tools available for doing that (I mean > MySQL > > Adminis

The best way to transfer data to another server

2005-03-29 Thread Denis Gerasimov
regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to specify autoincrement primary key value

2005-02-18 Thread Denis Gerasimov
nt to have _one and only_ root category)? > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 2:31 PM > To: Denis Gerasimov; [EMAIL PROTECTED]; 'MySQL General List' > Subject: Re: How to specify autoincrement pr

RE: How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
> > > > > Hello, > > > > One simple question... AFAIK I can specify value for an autoincrement > > primary key (int) when inserting a record like this: > > > > INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') > > > > But it doesn't work for id = 0. Why? > > > > I would like to use some p

How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
al purpose, e.g. id 0 means root/default record and so on. Is that recommended? Are there any alternative ways? Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

RE: [PHP-DB] mysqli connection problem

2005-02-08 Thread Denis Gerasimov
> > Hello, > > > > This question was asked many times, but I can't find a good answer. > > I am getting this error message while trying to connect to MySQL server > (PHP > > + PEAR::DB_DataObject): > > > > "Can't connect to local MySQL server through socket '' (111)" > > > > (notice '' - is that

mysqli connection problem

2005-02-07 Thread Denis Gerasimov
Hello, This question was asked many times, but I can't find a good answer. I am getting this error message while trying to connect to MySQL server (PHP + PEAR::DB_DataObject): "Can't connect to local MySQL server through socket '' (111)" (notice '' - is that right?) Does anyone have any ideas

RE: TINYTEXT field uniqueness question

2004-12-23 Thread Denis Gerasimov
s error in case of duplicate 'abcd' (>= 3 chars). Why? Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru > -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 9:56 PM > To: MySQL Ge

TINYTEXT field uniqueness question

2004-12-21 Thread Denis Gerasimov
Hello, Is that possible to ensure uniqueness for a TINYTEXT field? I tried to create an index (with UNIQUE constraint) but my GUI tool always says me 'Duplicate entry 'X' for key N' Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- M

RE: Default connection codepage

2004-12-21 Thread Denis Gerasimov
.0.2 PEAR's DB + DB_DataObject (both latest) Does anybody have the same problem? > > "Denis Gerasimov" <[EMAIL PROTECTED]> wrote: > > > > Hello, > > > > Is there any way to change default MySQL _connection_ codepage? > > (e.g. by ini/cnf

Default connection codepage

2004-12-21 Thread Denis Gerasimov
Hello, Is there any way to change default MySQL _connection_ codepage? (e.g. by ini/cnf files setting, by startup parameters or some other way) Please, do not suggest running SET CHARACTER SET blah123 Thanks. Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd