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 acces

Re: alter table syntax

Dear Kayamboo, dear Dan, > > mysql> alter table town_db drop primary key ; > > ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db' > > (errno: 150) > > mysql> > The alter table failed because of error 150. Run the command "perror 150" > at your shell prompt (not the mysql p

Re: Table copy problem

Dear Oláh, > "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]> Geschäftsführer / CEO iConnect GmbH

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: 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

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: 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: 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

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) >