it doesn't return from the mysql_query processing

I hope that my contacting you is not an imposition in any way. My name is Koki Takeda. This time, I made the php program using MySQL. The child process is generated in the program, and MySQL query are transmitted two or more times in the child process. That's my problem. There is

Re: speeding imports

On Tue, July 17, 2007 13:31, Baron Schwartz wrote: Mogens Melander wrote: On Tue, July 17, 2007 04:29, Baron Schwartz wrote: B. Keith Murphy wrote: The problem is that I am realizing that this dump/import is going to take hours and in some cases days. I am looking for any way to speed this

RE: quickly copying a database

InnoDB HotBackup but it costs money. http://www.innodb.com/hot-backup -Original Message- From: Ofer Inbar [mailto:[EMAIL PROTECTED] Sent: 18 July 2007 00:12 To: mysql@lists.mysql.com Subject: quickly copying a database I've got a server with a database that's about 10G. I need several

Re: why are tmp tables being created on disk?

Ofer Inbar wrote: I've been running this for a few hours and it consistently shows lots of writes but no reads at all on sdb1, the partition where I have my binary logs and tmpdir. Is MySQL writing lots of tmp files and not reading them? Or, how else can I interpret this? -- Cos Perhaps

MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

I was unable to get 3.51.17 to work with MS Access 2002. I installed it from the msi bundle. The connector passes a test when creating or configuring a System DSN, but when I try to link tables from MS Access I get an error message: [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]Access denied

RE: MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

Hmm... I tried this again with a user that has full access to all databases on the host, and it worked. This read-only user worked on the previous version of the connector, but it only worked on 3.51.17 when I gave it SELECT privilege on the mysql database. Problem solved. Regards, Jerry

Re: it doesn't return from the mysql_query processing

Hi Koki, You have to re- establish the database connection in each child process. Otherwise the packets get mangled and you get the errors you're seeing. Koki Takeda wrote: I hope that my contacting you is not an imposition in any way. My name is Koki Takeda. This time, I made the php

Query Problems

Hello everydoby, I'm having a problem executing a query in the MySQL server version 4.1, the same query works fine in my other server with MySQL version 4.0. My PHP code is attached, and the query is one on the line 13. Please somebody help me, Thanks, Douglas dbFlashDadosSonabra.php

mysqld works but not mysqld_safe

Hi Everyone. I had a perfectly good working version of MySQL and then I decided to try something new... Now, I can start up as root with mysqld, but when I start with mysqld_safe as I always have in the past, mysqld quits immediately. Here's the saga: I decided to use phpmyadmin to

Re: mysqld works but not mysqld_safe

Chris Africa wrote: - 070717 22:44:12 mysqld started 070717 22:44:12 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 070717 22:44:12 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used;

Re: mysqld works but not mysqld_safe

Hi Gerald. Actually, mysql should have access, as it owns the entire directory. drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4- i686 and nested inside that is drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data Thanks! -- Chris Africa Web Project Manager

Re: mysqld works but not mysqld_safe

You have bin log enabled and it might be looking for the last bin log before the last shutdown ('/usr/local/mysql-5.0.41-osx10.4-i686/data/me-web2-bin.27') You can either: - move the missing binlog file where mysql is looking for it - delete the $hostname.index file that keeps track of

Re: mysqld works but not mysqld_safe

Chris Africa wrote: Hi Gerald. Actually, mysql should have access, as it owns the entire directory. drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4- i686 and nested inside that is drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data Thanks! Error 13 is a

Replication broken - fatal error 1236: 'error reading log entry'

MySQL 5.0.27 from RPM, on Redhat EL4. One master, two slaves, one database. Slaves have been up for 5 days. This afternoon, both slaves stopped at the same place, with the same error: 070718 17:28:00 [Note] Slave SQL thread initialized, starting replication in log 'hlgbinlog-oil.15' at

RSS Style Feeds from Itunes.xml to External Publicly Accessible DB

Greetings All: It's been a while since I've posted, but I wanted to see if any of you have approached the following challenge. I have a Mac that runs iTunes a few hours a day, sometimes with Ampache feeding playlists, to it and I'd like to expose my recently listened to songs to a public

Restore take lot of time

Hi All, I have taken dump of two table using mysqldump. The size of the dump file is 175 MB. To restore dump file to another machine. It takes about more than 30 minutes. Why it is taking a lot of time for such a small file. Please help me. Regards, Krishna

Tune my.cnf

Hi All, I have a pentium box 3.0 GHz processor and 2 GB ram. I want to configure my.cnf in such a way that it should give the best performance. So, how should I configure the my.cnf parameter. What are the components on which the most attention should be paid. I am using innodb parameters.

Unique Rowid

Hi Folks, I am in the process of putting together a web application. I have decided to add a 'RowId' field to all my tables and assign it a unique number so that I use it to retrieve data. In concept this number might be passed back to the server as part of an ajax request etc. My