Re: FULLTEXT index on InnoDB tables (looking for a workaround)

At 02:32 PM 1/28/2005, you wrote: And, of course, another option is to contact Heikki and coax him into hiring somebody to add FULLTEXT to InnoDB tables. And bring lots of cash with you. :-) I've pestered Heikki a couple of years ago and he's willing to do it only if there is someone willing to f

age of last checkpoint / log group capacity

Hi, I'm running a conditional delete against a large table. Every 20 seconds or so, an error message gets written to the logfile: 050129 19:32:26 InnoDB: ERROR: the age of the last checkpoint is 1334658464, InnoDB: which exceeds the log group capacity 483180135. InnoDB: If you are using big BLOB

Re: Connection latency reduction attempt for load balancing mysql slaves.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin A. Burton wrote: > I'm experimenting with using ConnectorJ 3.1.7 to connect to MySQL slaves > to handle load balancing queries. > > The environment would either include a hardware loadbalancer or round > robin DNS (or static configuration). T

Re: Data and strucuture importing from MSAccess to MySQL

Paul: For database conversion, take a look @: [http://access2sql.sourceforge.net/] or [http://sourceforge.net/projects/dbconverter/] For database modeling and development, try: [http://www.fabforce.net/dbdesigner4/] and [http://www.gnome.org/projects/dia/] All of these are free utilities. Harsh P

Connection latency reduction attempt for load balancing mysql slaves.

I'm experimenting with using ConnectorJ 3.1.7 to connect to MySQL slaves to handle load balancing queries. The environment would either include a hardware loadbalancer or round robin DNS (or static configuration). The main component though is having the JDBC driver continually reconnect (to ac

Re: Problem with query and password

Lancer Emotion 16 wrote: I have this table named users : + | ID | user | pass | thegroup | firstname | surname | enabled +++--+--+---+-+- | 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr| Admin | 1 The pas

Problem with query and password

Hello everbody,i have a problem with mysql and i wish you could help me. I have this table named users : +++--+--+---+-+- + | ID | user | pass | thegroup | firstname | surname | enabled | +++-

Re: SuSE 9.2 Professional, Runlevel editor via telnet & innodb

Ed Patterson wrote: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns You want `mysqladmin [command]` -- try `mysqladmin --help` for a quick list of available commands. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuit

SuSE 9.2 Professional, Runlevel editor via telnet & innodb

Greetings, I need help with a few things: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns chroot: No such file or directory Aborting mysqld -shutdown returns: Can't start server: Bind on TCP/IP port: Address already in use Do you already have anoth

Re: mysqlimport --replace

Please do not consider the previous email. I found my error. mysqlimport is behaving exactly as expected. Regards, Clodoaldo Pinto On Sat, 29 Jan 2005 15:53:48 -0200, Clodoaldo Pinto <[EMAIL PROTECTED]> wrote: > I need to update a table with mysqlimport. > > I would like to update the table lin

Re: Hebrew Characters

Hello. I think, that you should start with reading the appropriate pages of the manual: http://dev.mysql.com/doc/mysql/en/charset.htm [snip] Our host runs MySQL 4.1 and we have a number of datasets with Genealogical data in them. When a grave stone is translated to English often th

Re: Mysqldump unusable, bugged?

On Thu, 27 Jan 2005, matt_lists wrote: > Having repeatable problems doing restores, 4.1.8 and 4.1.9 both do the > same error > > Is there some setting I'm missing? > > mysqldump -u username-pPassword --all-databases --quote-names > > /intranet/backup/backup.sql > > > E:\intranet\backup>mysql -u x

mysqlimport --replace

I need to update a table with mysqlimport. I would like to update the table lines with the same unique key and mantain the other lines untouched. When I use "mysqlimport --replace" the table lines with the same unique key are updated but the others are deleted. Is it the expected behavior? How t

build problem on solaris 8

Hi all, I got the following error during the configure phase: configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section "Presen

libmysql10 missing for fedora core 3 x86_64

Hi All, We are using Fedora core 3 x86_64 with Intel Xeon EM64T. We have also installed MySQL-4.1 with Intel x86_64 RPMs form mysql.com and upgraded php to php-4.3.10-3.2 with RPM. The problem which we encountered then, is connecting mysql from php. From the archives we could trace that the soluti

RE: Data and strucuture importing from MSAccess to MySQL

Suggest you download MYdbPAL from www.it-map.com . It is FREE, will do the complete import of structure and data for you (in next to no time) and you can carry on using it for modeling and database development. There is a great write-up this week at : http://blogs.ittoolbox.com/database/solution

Data and strucuture importing from MSAccess to MySQL

Which way is easier to import data and structure of database from MSAccess to MySQL. I know that there is several commercial softvare tools, but is there some open source tool or other way in MySQL itself? -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Ve

Hebrew Characters

Hi Our host runs MySQL 4.1 and we have a number of datasets with Genealogical data in them. When a grave stone is translated to English often the meaning is lost or the translation is simply not accurate. So how easy or difficult would it be to actually hold the text in Hebrew purely for displa