Re: Can't connect error 10061 - nothing but Mascon works remotely.

Dear Daevid, [root@daevid]# mysqladmin ping -h daevid.com -uroot -p [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive So this means a connection is possible, and it doesn't matter whether you issue a host name or an ip number. Now you have two programs that can access

Re: mysqldump error

Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server,

Re: Table copy problem

Dear Olh, SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null In MySQL, you simply do: CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0 That's even simpler, 100% reliable and FAST! :) HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschftsfhrer / CEO iConnect GmbH

Re: MySQL: Select Not In Table

Dear Henning, SELECT Table1.ID FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2); SELECT Table1.ID FROM Table1 LEFT JOIN Table2 USING (ID) WHERE Table2.ID IS NULL Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de

Re: MySQL 4.0.5(a) is released

Dear Lenz, `Show_db_priv` enum('N','Y') NOT NULL default 'N' i.e. User must be granted explicitly this privilege in order to be able to use: SHOW DATABASES; Suggested way for setting this Ptivilege is ofcourse command: GRANT SHOW DATABASES; Sound it bit strange in a GRANT select, show

Re: MySQL secure access

Dear Alice, but what i meant is my customer want to have the access on their database. and i don't want them to view those databases that not belongs to the particular customer. customer only access their own database only. In MySQL 4.0.5a: Start the server with --safe-show-databases In

Re: Is it possible to export data from access to MySQL?

Dear Steve, Is it possible to export data from MS Access into MySQL? If you don't care to export every single table manually, this is what you do: 1. Install MyODBC 3.51.04 2. Configure a system DSN for your MySQL server. 3. In Access, right-click the table to be exported. 4. Choose Export...

Re: Select statement problem

Dear John, probably the problem does not derive from MySQL, but from the URL encoded search string, e.g.: Search for oneword = oneword Search for two words = two%20words If you match against two words, there will be no match, as it should match against two%20words. I am not informed which

Re: problem with replication

Dear Soenke, i wanna setup replication, everything works so far, but the slave can'tconenct to the master, access denied. but if i connect with the 'mysql' program from slave machine to master machine, it works! Before you go crazy, check if the slave (user) has sufficient privileges. Let's

Re: Strange Error with MySQL 4.0.4 under Win2K

Dear Egor, thanks for your great advice, finally pointing out the reason for the problem. SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This