user group
hi, pls tell me how to create user group in mysql? thanks felik __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dumb Newbie Keyword Search Question
I have been looking through the mailing list archives but I can seem to find a straight forward answer anywhere. I have a MySQL table with a variety of text columns I would like to search. Pretty basic... A web search form returning the users input $keywords. Some type of relevance system would be great but it is not necessary. I have been messing around with LIKE, IN and to an extent REGEXP but I can't seem to get it to work. For example if the user inputs "red fire engines" I would like to query across "colour", "type" and "description" for each of the words. Can this easily be done? Do I need to create a "keywords" column each time I update any of the keyword columns I would like to search? Any help would be greatly appreciated. I am also on digest mode so please CC me if you reply to the list or via versa. Thanks, Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myisamchk and table corrupt
Hello list, There's an corruption in my mysql table. I tried to use myisamchk -o to recovery, but still exists when I use myisamchk -s. What is the possible reason of the problem? linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: error: Size of datafile is: 5947722 Should be: 6016194 myisamchk: error: Keyblock size at page 284672 is not correct. Block length: 1022 key length: 2 MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted Fix it using switch "-r" or "-o" linux95:/var/lib/mysql# -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.46 corrupts MYD and MYI files frequently
Dear All, I having issues with MySQL on Linux corrupting our MYD and MYI files frequently. We get errors such as "Can't open file: 'TABLE.MYD' which tells me the table data is corrupt/damaged. I can rebuild the index and recover the data correctly but this is the 2nd time in 2 weeks that this has occured. The server would average a few thousand reads and writes per minute, notably to the table we are having problems with. This server is in production and is part of a two system fail over mechanism so downtime for short periods is acceptable the system is mirrorred to another fail over server. The other server does not experience the same problem, notably probably due to the lower amount of reads/writes. This server is a Primary (the one with the MYD problem) and the other one (without the problem) is a Secondary and gets at least 95% less requests per/second. The server is a decent sized dell server with raid5, ultra 160 drivers, 512mb of ram, 1gig swap, and a 1000mhz CPU. The load average for this server is always around 0.15 or less and is very rarely any higher. Has anyone experienced this in the past? What is the recommended solution? Is this a bug? Any ideas of advice on this would be greatly appreciated Here are some stats I've gathered in case these help in working out a solution Kernel Linux server01 2.4.7 #3 SMP Tue Dec 18 07:59:25 EST 2001 i686 unknown MySQL Version mysql Ver 11.15 Distrib 3.23.46, for pc-linux-gnu Server Uptime 4:00pm up 59 days, 1:45, 1 user, load average: 0.03, 0.00, 0.75 File sizes NOTE: The MYD is in fact 3.7GB and contains over 12million records. -rw-r-1 mysqlmysql3749779904 Mar 24 03:50 OURTABLE.MYD -rw-r-1 mysqlmysql119045120 Mar 25 16:01 OURTABLE.MYI -rw-r-1 mysqlmysql9090 Jan 15 09:19 OURTABLE.frm Regards, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgently required
Dear Arjen and Iko Rein, As I had been contacting you relating the MySQL related queries, I nned some more clarifications on that. 1. Can you please send me a write up on how to back up and restore in MySQL database. 2.Also I had got a mail from one of our customers could you please answer to this as well. Dear Pramod, We need to access MySql open source database into SQl Server 7.0. The version of MYSQL that our customer, is using is the one which they downloaded from internet. Can you find out what type of license it can be - GPL or Commercial or anything else? I wonder, if there is no difference between GPL and Commercial versions, why one would go for commercial version? Therefore, there should be some advantages of Commercial version. Can you find it out for us? It would be better, if we know what shortcomings / limitations if any, are there in MySQL (the version which is freely downloadable from internet, whether it is called GPL or otherwise) This is an immediate requirement.Could you please send me as soon as possible. Thanks & Regards, Pramod ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqldump : help needed very urgent
thank u very much... but I am planning for one approach is it right .. as by mysqldump we can take back up of Table structure and Insert values separately.. As my database will remain constant through out for the application I can insert the foreign key lines in the dumped file once and as the insert values are in the separate file, when ever I will do backup first I will use the Table structure file which will be constant(will not be backup every time) and then the backup data file. This way I am able to make get the Foreign key even my using the mysqldump.. What do u say ..?? anybody who can suggest me any idea.. I have also tried for the "Alter table Add " but it is not working. Thanks and regards. Chetan Lavti -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 4:33 PM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: mysqldump : help needed very urgent Hi! > "Chetan" == Chetan Lavti <[EMAIL PROTECTED]> writes: Chetan> Hi, Chetan> I am using Mysql version 3.23.47-Max client and server and using Innodb Chetan> table type. Chetan> I am doing my database backup using the mysqldump utility. Chetan> Once I have done with database backup, I am deleting all my database and Chetan> again recovering(creating) the database using the dumped file. Chetan> Now, the question is after recovery of the database, I am not getting Chetan> the foreign key relationship between the tables. Chetan> Why this happens...? is it the problem with mysqldump...?? and if it Chetan> really the case then how can i re-create my whole database and keep all Chetan> my database retaining the foreign keys. Chetan> If anyone can suggest me alternative method for doing the same then it Chetan> will be very usful for me. Chetan> Waiting for response. The problem here is that in MySQL 3.23 FOREIGN KEY definitions is not part of the mysqldump output. This will be fixed in MySQL 3.23.50 and 4.0.2, both which will be available shortly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
At 21:32 -0500 3/24/02, alan4100 wrote: >mysql >Michael, > >It is clear now after typing in p-a-s-s-w-o-r-d >into the password for the user root. > >It then went through fine, but I never set up the password for the root user. Sure you did: At 18:09 -0500 3/24/02, alan4100 wrote: > >mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; >Query OK, 0 rows affected (0.00 sec) That statement specifies that the password for root is "password". >Hope it will be clear later how the password had been stored for the >user root. It had to occur before or during the installation. Nope. *You* specified it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wildcard and users...
Hi, I am wondering is there a way to set up user that can log in from anyplace? I know I need to set this user up with the %(I hope this is the wildcard for) mysql. Thanks, Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
At 18:09 -0500 3/24/02, alan4100 wrote: >mysql > >mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; >Query OK, 0 rows affected (0.00 sec) >== >At this point the priveleges are granted to root@localhost. > >mysql> \q >Bye >I had to type \q to quit and type in the following: > >But . see what happened when I then typed in below.. >= >C:\mysql\bin>mysql -u root -h localhost > >ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > >I am asking why my access is still denied after I was GRANTED in the >beginning!!! >C:\mysql\bin> In the GRANT statement, you specified that from that point on root would need to specify a password in order to connect. In the subsequent mysql command, you attempted to connect as root, but you specified no password. You see why those actions are self-contradictory? :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow search on INDEX?
Hi, I have this table: mysql> describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10) unsigned | | PRI | NULL| auto_increment | | timestamp | int(10) unsigned | | MUL | 0 || | type| tinyint(4) | | MUL | 0 || | source | char(10) | | MUL | || | description | char(100)| | | || +-+--+--+-+-++ Currently, this table has 300,000+ entries and 39MB in filesize. I made some observations based on the following search: 1. SELECT * FROM eventlog WHERE description LIKE "%DENIED%" ORDER BY id DESC LIMIT 20; 2. SELECT * FROM eventlog WHERE source = 'ERROR' ORDER BY id DESC LIMIT 20; 3. SELECT * FROM eventlog WHERE SOURCE = 'ERROR' and description LIKE "%DENIED%" ORDER BY id DESC LIMIT 20; Of the 3 queries, #1 gives me the fastest result (<5 secs), and #2 comes very far second (>10 secs), and #3 comes ALMOST equal in time with #2. I'd like to point out that the pattern '%DENIED%' is only present when source = 'ERROR'. AND source='ERROR' is about 1/3 of the table's entry. Furthermore, the pattern '%DENIED%' occurs 1/5 of the time. Considering the fact that I do not have any INDEX on description, the search *description LIKE "%DENIED"* should be very slow as this will try to apply the search on ALL entries. Likewise, since I have an INDEX on source, the search source='ERROR' should be fairly fast at least faster than the first one. YET, I dont get any improvement and it turned out even a lot slower. Why was it this way? thanks for your inputs. jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re MySQLGUI
I have installed MySQLGUI ( Win32 static binary of MySQLGUI 1.7.5-2 <../Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip ) and have been able to connect the the server successfully. platform used: Win95 The Help function is not available. Is configuration required to access Help? your assistance will be greatly appreciated. with thanks Phil Lambert es2 Project Manager Contact es2: http://www.es2.com.au [EMAIL PROTECTED] Fax: ++ 612 9225 9007 Phone ++ 61 409 817 422 Postal: PO Box 287 Glebe NSW 2037 Australia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regarding Licence
http://www.mysql.com/support/arrangements.html is pretty clear on what you need... M;) -Original Message- From: nagendra [mailto:nagendra%bartronicsindia.com] Sent: Sunday, March 24, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: Regarding Licence Hai, I have one doubt regarding Licence of MySql. I want to develop one software based on MySql. And i want to distribute it in the market. To do this shall i need Licence for MySql. Why i am asking is MySql is available on InterNet at free. So, i am thinking i can distribute my software without licencing. because those who takes my software they can download it at free of cost. So where is the matter of Purchaging licence. Please clarigy all of mydoubts as soon as possible. Regards Nagendra K. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during the installation.
Regarding Licence
Hai, I have one doubt regarding Licence of MySql. I want to develop one software based on MySql. And i want to distribute it in the market. To do this shall i need Licence for MySql. Why i am asking is MySql is available on InterNet at free. So, i am thinking i can distribute my software without licencing. because those who takes my software they can download it at free of cost. So where is the matter of Purchaging licence. Please clarigy all of mydoubts as soon as possible. Regards Nagendra K. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
mysql Michael, You can look at the results after the dash lines. You will notice mysql -u root -h localhost -p does not help at all. I clicked enter to by pass the password;it is acceptable for the root, but look at the results. C:\mysql\bin>mysql -u alan -h localhost -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 28 to server version: 3.23.49-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. === mysql> grant all on mysql.* to root@localhost identified by"password"; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye C:\mysql\bin>mysql -u root -h localhost -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) That is why I stayed with alan as the user instead of the root until the solution is fixed.
Connect Mysql on Linux from Windows
Dear Miliser I am new member here, and I would like to ask about connection at Mysql. I have MySQL on linux server and I want to connect that MySQL engine from windows, how can I connect to that mysql now I've been install Mysql-ODBC and MySQLFront on windows, but there is still an error connection message the message of MysqlFront is like this "1130. Host 'ipwindows' is not allowed to connectto this MySQL server" wish u all to give some solution to solve my problem many thanks and highly appreciate for yr all support Best regards, Afif mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table created on script Err
mysql
Paul,
I was afraid to hear that. It had said about line 2 in the error message.
This line #2 looks normal.
May I ask you to check this script below, but I am afraid it may be
annoying. I will eventually put this on posting. Remember I use Windows XP.
I would like to know if there is such an mysql "reader" to check syntax
before I run the script. I am using MySQL by Sams in 21 days.
Alan
==
CREATE db db2;
USE db db2;
CREATE TABLE Customers (Customer_ID INT NOT NULL
PRIMARY KEY AUTO_INCREMENT, First_Name VARCHAR(20)
NOT NULL,Last_Name VARCHAR(30) NOT NULL,
Address VARCHAR(50), City VARCHAR(20),
State VARCHAR(2), Zip VARCHAR(20),
E_Mail VARCHAR(20), Age INT, Race VARCHAR(20),
Gender ENUM('M','F') DEFAULT 'F',
Eye_Color VARCHAR(10), Hair_Color VARCHAR(10),
Favorite_Activity ENUM('Programming', 'Eating',
'Biking', 'Running', 'None') DEFAULT 'None',
Favorite_Movie VARCHAR(50), Occupation VARCHAR(30),
Smoker Char(0));
Re: Grant all on my mysql.*
mysql Michael, This time it went through fine only when I typed in mysql -u alan -h localhost -p It went through fine because I already set up alan for username as well as the pasword for (alan). You said I could only use mysql -u root -p to go through! Perhaps, it will go through even thou I never set up password for the root. I think all I may have to do is to skip the password, but use -p for the root. >From now on I will just use alanand the password as long as possible. Thanks for >the reply.
Re: Grant all on my mysql.*
You set a password for root, so you must use it to connect as root. That is, you must use -p, like this: C:\mysql\bin>mysql -u root -h localhost -p You'll then be prompted for the password. This is covered in the manual. Michael On Sun, 24 Mar 2002, alan4100 wrote: > mysql > > mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; > Query OK, 0 rows affected (0.00 sec) > == > At this point the priveleges are granted to root@localhost. > > mysql> \q > Bye > I had to type \q to quit and type in the following: > > But . see what happened when I then typed in below.. > = > C:\mysql\bin>mysql -u root -h localhost > > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > > I am asking why my access is still denied after I was GRANTED in the beginning!!! > C:\mysql\bin> > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Grant all on my mysql.*
mysql mysql> Grant all on mysql.* to 'root'@'localhost' identified by "password"; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql> \q Bye I had to type \q to quit and type in the following: But . see what happened when I then typed in below.. = C:\mysql\bin>mysql -u root -h localhost ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I am asking why my access is still denied after I was GRANTED in the beginning!!! C:\mysql\bin>
Re: Table created on script Err
At 12:20 -0500 3/24/02, alan4100 wrote: >After creating a script to create customer table for Meet_a_Geek >with an editor and named it 032302.sql. It was saved in the folder >called. > >c:\my download files\. > >Then at at the mysql\bin> prompt I typed >mysql c:\my download files\032302.sql. hoping that this table would >be readed and created in the process, but the display read error >1064: You have an error in your SQL syntax near c:\my download >files\032302.sql. > > From the description of your error, it sounds like you had *already* invoked mysql and then typed that command at the mysql> prompt. Try this from the DOS prompt to invoke mysql with its input redirected to your file: mysql < "c:\my download file\032302.sql" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: StartTransaction
At 17:20 -0300 3/24/02, Edilson Vasconcelos de Melo Junior wrote: >Hi, >Is there anyway to start transaction, do rollback and/or commit changes >using mysql c api? Same way you issue any other statement. Use mysql_query() or mysql_real_query() to issue statements like "BEGIN", "COMMIT", "ROLLBACK", "SET AUTOCOMMIT = n", etc. Did you have something else in mind? > >Thank u very much, > >Edilson Vasconcelos de Melo Junior >www.jrsoftwares.com.br - Portal JR >[EMAIL PROTECTED] >Fone: (+55)(19)3256-3577 >Cel : (+55)(19)9111-5873 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem building DLL library, undefined references (mysql) - macros?
I am buiding an extension to tcl which involves linking to the mysql library. I have done this before on Microsoft VC5.0 but nolonger have access to that and so am using Cygwin & Mingw. Trying to build my extension I get the following output, any ideas or help would be greatly appreciated. NOW - I REMEMBER SOMETHING ABOUT these commands being defined as macros and this had something to do with the errors I am getting (eg: mysql_error, mysql_close, mysql_affected_rows etc). $ gcc -Wall -DWINDOWS -Ic:/tcl/include -Ic:/mysql/include fbsql.c -shared -o fbsql.dll - Lc:/tcl/lib -ltcl83 -Lc:/mysql/lib/o pt -lwsock32 -llibmysql -lz c:\windows\TEMP\ccd8QUfb.o(.text+0x3a):fbsql.c: undefined reference to `mysql_error@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x67):fbsql.c: undefined reference to `mysql_errno@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x1be):fbsql.c: undefined reference to `mysql_connect@16' c:\windows\TEMP\ccd8QUfb.o(.text+0x2af):fbsql.c: undefined reference to `mysql_close@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x447):fbsql.c: undefined reference to `mysql_select_db@8' c:\windows\TEMP\ccd8QUfb.o(.text+0x6f3):fbsql.c: undefined reference to `mysql_query@8' c:\windows\TEMP\ccd8QUfb.o(.text+0x743):fbsql.c: undefined reference to `mysql_use_result@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x772):fbsql.c: undefined reference to `mysql_field_count@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x7cf):fbsql.c: undefined reference to `mysql_affected_rows@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x828):fbsql.c: undefined reference to `mysql_fetch_row@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x920):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x953):fbsql.c: undefined reference to `mysql_free_result@4' c:\windows\TEMP\ccd8QUfb.o(.text+0xd8f):fbsql.c: undefined reference to `mysql_query@8' c:\windows\TEMP\ccd8QUfb.o(.text+0xde5):fbsql.c: undefined reference to `mysql_use_result@4' c:\windows\TEMP\ccd8QUfb.o(.text+0xe37):fbsql.c: undefined reference to `mysql_store_result@4' c:\windows\TEMP\ccd8QUfb.o(.text+0xe85):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccd8QUfb.o(.text+0xed3):fbsql.c: undefined reference to `mysql_field_count@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x10a9):fbsql.c: undefined reference to `mysql_fetch_row@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x11a1):fbsql.c: undefined reference to `mysql_fetch_field_direct@8' c:\windows\TEMP\ccd8QUfb.o(.text+0x1381):fbsql.c: undefined reference to `mysql_fetch_field_direct@8' c:\windows\TEMP\ccd8QUfb.o(.text+0x17ad):fbsql.c: undefined reference to `mysql_num_rows@4' c:\windows\TEMP\ccd8QUfb.o(.text+0x17fd):fbsql.c: undefined reference to `mysql_free_result@4' Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB monitor
Hi, Can anyone tell me how to use the InnoDB monitor please. After creating the table with the following command: "CREATE TABLE innodb_monitor(a int) type = innodb;" I don't know where to watch the output from the InnoDB monitor. Can anyone help? Balteo. (sql,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Warnings after LOAD DATA statement
At 10:50 -0800 3/24/02, Nick Arnett wrote: > > -Original Message- >> From: Maribel Piloto [mailto:[EMAIL PROTECTED]] >> Sent: Sunday, March 24, 2002 10:24 AM > >[snip] > >> The data is loading fine and the NULL values are in fact >> correctly entered >> as NULLs but I'm getting this warning after the LOAD statement: >> >> Records: 3 Deleted: 0 Skipped: 0 Warnings: 3 >> >> I don't understand why I'm getting the warnings or what they're about. > >When you load data from a file, there's no way to know exactly what the >warnings are. However, they are the same ones you'd get from a single >insert statement, or from too many or two few columns in your insert file >(extra columns are ignored). > >A suggestion here recently was to do a SELECT ... INTO FILE after your >insert, selecting the records you just inserted (easier if you just do this >into an empty table), then compare the output file with your input file. >Having done that myself, I'm still mystified by where the warnings are >coming from on my inserts. I need a better file comparison tool... http://www.kitebird.com/mysql-cookbook/ Check the "early release" distribution for the load_diag.pl utility. > >Of course, the alternative way to figure out what's going on is to do >individual INSERT statements and look at the actual warnings. > >See http://www.mysql.com/doc/L/O/LOAD_DATA.html > >Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Warnings after LOAD DATA statement
At 13:23 -0500 3/24/02, Maribel Piloto wrote: >Hi all, > >I'm new to the list and new to MySQL. I've been working on creating >my first db and I've encountered a problem I'm hoping someone here >can help me with. I have a text file with the following three lines: > >V-AIG001|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|\N| >V-AIG002|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|V-WAR001| >V-AMA001|AMAR'S MUSIC VIDS|http://www.angelfire.com/b/BElanna/xms.html|\N| > >I have a table called vsites I'm trying to load this data in. The >table looks like this: > >+---+--+--+-+-+---+ >| Field | Type | Null | Key | Default | Extra | >+---+--+--+-+-+---+ >| vsite_ID | varchar(10) | | PRI | | | >| vsite1| varchar(100) | | MUL | | | >| vurl1 | varchar(150) | | | | | >| vsite2_ID | varchar(10) | YES | | NULL| | >+---+--+--+-+-+---+ > >I'm using this statement to load the data into the table: > >LOAD DATA INFILE "vsites.txt" INTO TABLE vsites FIELDS TERMINATED BY '|'; > >The data is loading fine and the NULL values are in fact correctly >entered as NULLs but I'm getting this warning after the LOAD >statement: > >Records: 3 Deleted: 0 Skipped: 0 Warnings: 3 > >I don't understand why I'm getting the warnings or what they're about. Your table contains 4 columns and your data files have 5 columns. The warnings are problably related to the extra columns, one per each of your three lines. If you don't see the extra column, notice that your data lines end with "|". That means there's an extra empty column at the end of each line. You can test this theory by deleting the "|" at the end of the lines and loading the file again. > >I would appreciate it if anyone could clue me in as to what I may be >doing wrong. > >MP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
StartTransaction
Hi, Is there anyway to start transaction, do rollback and/or commit changes using mysql c api? Thank u very much, Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br - Portal JR [EMAIL PROTECTED] Fone: (+55)(19)3256-3577 Cel : (+55)(19)9111-5873 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Full Text Multicolumn search bug
>Description: It appears that adding a full text field to multiple columns can cause the database to crash. >How-To-Repeat: Set "ft_min_word_len=2". Create a database and run the SQL script at http://gear.moregadgets.com/~nickkral/newscrash.sql >Fix: Unknown >Submitter-Id: Nick Kralevich >Originator:Nick Kralevich >Organization: Nick Kralevich >MySQL support: none >Synopsis: Full Text Multicolumn search bug >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 1 min 7 sec Threads: 1 Questions: 15 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 8 Queries per second avg: 0.224 >Environment: System: Linux gear.moregadgets.com 2.4.17 #2 Fri Dec 28 15:52:32 PST 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 30 08:18 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 06:04 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 06:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 06:02 /usr/lib/libc.so lrwxrwxrwx1 root root 10 May 31 2001 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rpm rebuild failure
Hello. I would value your help in resolving a problem I had which makes it impossible for me to install MySQL on my system. I would like to report that : rpm --rebuild MySQL-3.23.49-1.src.rpm FAILED on my system - Redhat 6.2 on an i686 box. I had to do this as I had glibc devel 2.1.3-15, which was expected to fail with your published binary. (I tried it anyway - it can be installed, the daemon runs, but mysql-test hangs, and there is no mysqladmin command at all) I attach the last few lines of output below, for your interest. Will I have any better luck with the tarball, rather than the srpm? make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:195: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 Bad exit status from /var/tmp/rpm-tmp.89414 (%build) [root@localhost temp-mysql]# Any suggestions for a solution would be much appreciated. Ray Wright - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Warnings after LOAD DATA statement
> -Original Message- > From: Maribel Piloto [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 24, 2002 10:24 AM [snip] > The data is loading fine and the NULL values are in fact > correctly entered > as NULLs but I'm getting this warning after the LOAD statement: > > Records: 3 Deleted: 0 Skipped: 0 Warnings: 3 > > I don't understand why I'm getting the warnings or what they're about. When you load data from a file, there's no way to know exactly what the warnings are. However, they are the same ones you'd get from a single insert statement, or from too many or two few columns in your insert file (extra columns are ignored). A suggestion here recently was to do a SELECT ... INTO FILE after your insert, selecting the records you just inserted (easier if you just do this into an empty table), then compare the output file with your input file. Having done that myself, I'm still mystified by where the warnings are coming from on my inserts. I need a better file comparison tool... Of course, the alternative way to figure out what's going on is to do individual INSERT statements and look at the actual warnings. See http://www.mysql.com/doc/L/O/LOAD_DATA.html Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The table 'SQL746e7_0' is full
On Sun, Mar 24, 2002 at 08:22:59AM -0700, Tom Brettin wrote: > What are the various reasons that could explain the following error > message. It happens as a result of an equi-join. > > The table 'SQL746e7_0' is full > > How can I get additional information such as where is that table being > written to disk (I could check the amt of free disk space). Try adjusting tmp_table_size. This is a FAQ. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Warnings after LOAD DATA statement
Hi all, I'm new to the list and new to MySQL. I've been working on creating my first db and I've encountered a problem I'm hoping someone here can help me with. I have a text file with the following three lines: V-AIG001|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|\N| V-AIG002|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|V-WAR001| V-AMA001|AMAR'S MUSIC VIDS|http://www.angelfire.com/b/BElanna/xms.html|\N| I have a table called vsites I'm trying to load this data in. The table looks like this: +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | vsite_ID | varchar(10) | | PRI | | | | vsite1| varchar(100) | | MUL | | | | vurl1 | varchar(150) | | | | | | vsite2_ID | varchar(10) | YES | | NULL| | +---+--+--+-+-+---+ I'm using this statement to load the data into the table: LOAD DATA INFILE "vsites.txt" INTO TABLE vsites FIELDS TERMINATED BY '|'; The data is loading fine and the NULL values are in fact correctly entered as NULLs but I'm getting this warning after the LOAD statement: Records: 3 Deleted: 0 Skipped: 0 Warnings: 3 I don't understand why I'm getting the warnings or what they're about. I would appreciate it if anyone could clue me in as to what I may be doing wrong. MP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table name including current date
At 19:00 +0200 3/24/02, Okan CIMEN wrote:
>Hello,
>
>I am trying to write a script that creates tables via a cronjob but I want
>to name these tables including the current date as a suffix -like
>transections_20020324- . Does anybody know the SQL statement that entegrates
>the table name with the current date?
If you're trying to do it entirely in SQL, you'll have a difficult time,
because table names must be literals. You can't construct them using a
function that returns the current date.
Otherwise, the way you construct the table name will depend on the programming
language you're using. In Perl, you could do something like this:
my ($day, $mon, $year) = (localtime (time ()))[3..5];
my $tbl_name = sprintf ("transactions_%04d%02d%02d", $year+1900, $mon+1, $day);
my $query = ("CREATE TABLE $tbl_name ... rest of definition here...");
>
>I tried to do it by storing the current_date value at a variable and then
>renaming the table with the variable but it did not work.
>
>Any help will be appreciated
>
>Regards
>Okan
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pattern matching (in text field)
At 17:02 + 3/24/02, julian haffegee wrote:
>Hi all,
>
>I currently have
>
>$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl
>WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%'
>AND title_id != '$myrow[title_id]'");
>
>this works to an extent, but 'keywords' is a text field and if $temp is for
>example 'stem' I want it to match stem, and maybe stems but not system
>
>I thought
>
>keywords RLIKE '[\s|^]$temp%[\s|s|$]'
>
>this would allow for a word at the start , end, surrounded by whitespace, or
>plural.
>
>Obviously this does not work (why else would I ask you all?).
>Can anyone tell me what simple concept I have overlooked!
For one thing, you're using [...] to try to construct alternations.
[...] is for character classes, (...) is for alternations.
>
>thanks
>
>Jules
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table created on script Err
After creating a script to create customer table for Meet_a_Geek with an editor and named it 032302.sql. It was saved in the folder called. c:\my download files\. Then at at the mysql\bin> prompt I typed mysql c:\my download files\032302.sql. hoping that this table would be readed and created in the process, but the display read error 1064: You have an error in your SQL syntax near c:\my download files\032302.sql.
table name including current date
Hello, I am trying to write a script that creates tables via a cronjob but I want to name these tables including the current date as a suffix -like transections_20020324- . Does anybody know the SQL statement that entegrates the table name with the current date? I tried to do it by storing the current_date value at a variable and then renaming the table with the variable but it did not work. Any help will be appreciated Regards Okan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pattern matching (in text field)
Hi all,
I currently have
$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl
WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%'
AND title_id != '$myrow[title_id]'");
this works to an extent, but 'keywords' is a text field and if $temp is for
example 'stem' I want it to match stem, and maybe stems but not system
I thought
keywords RLIKE '[\s|^]$temp%[\s|s|$]'
this would allow for a word at the start , end, surrounded by whitespace, or
plural.
Obviously this does not work (why else would I ask you all?).
Can anyone tell me what simple concept I have overlooked!
thanks
Jules
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to connect Windows client to a MySQL server in Linux
The full error is probably access for Host denied. Look at http://www.mysql.com/doc/A/c/Access_denied.html for the answerer and search the new's group archives on how to GRANT the HOST access to the database. -Original Message- From: TH Leung [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 3:21 AM To: '[EMAIL PROTECTED]' Subject: How to connect Windows client to a MySQL server in Linux Hi, I really frustrated because I could not connect my WIN98 client to the MySql server installed on a Linux Server. The MySQL is of version 4.0.1 in a RedHat Linux 7.2, also I install a MyODBC version 3.5 in the client machine. In fact, I am using PowerBuilder on Windows platform as a programming tool, and I setup the DSN on the Windows machine with hostname=server's IP and signon with "root" through PowerBuilder, but an error message returned telling that the MySQL database cannot be accessed. So, would anyone tell me the reason, proper procedures or just tell me where could I find manuals or other materials for this topic? Thank you very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The table 'SQL746e7_0' is full
What are the various reasons that could explain the following error message. It happens as a result of an equi-join. The table 'SQL746e7_0' is full How can I get additional information such as where is that table being written to disk (I could check the amt of free disk space). Thomas S. Brettin 505-665-3334 (office) 505-699-7540 (cell) 505-665-3024 (fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a tough(?) query problem
hi I need to select the ten latest entries from a diary-database, but i don't want to get any duplicate users, so if i want to select the ten latest entries and someone has written five entries of these latest ones, i only want to get the latest entries from each user. So far no problem, my query below fixes that. But the problem is that i also want to get the correct headline from the latset entries from each person. Since mysql dosen't support subselects i have tried to use userdefined variables and the max()-function in a where-clause, but i found that it's not possible to use these methods. If anyone got a solution i would be really happy. The fields in the database looks like this: referer - int time - datetime headline - varchar My current nonworking query looks like this: select referer,max(time) as maxtime,headline from diary group by referer order by maxtime desc limit 10; /tobias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump : help needed very urgent
Hi! > "Chetan" == Chetan Lavti <[EMAIL PROTECTED]> writes: Chetan> Hi, Chetan> I am using Mysql version 3.23.47-Max client and server and using Innodb Chetan> table type. Chetan> I am doing my database backup using the mysqldump utility. Chetan> Once I have done with database backup, I am deleting all my database and Chetan> again recovering(creating) the database using the dumped file. Chetan> Now, the question is after recovery of the database, I am not getting Chetan> the foreign key relationship between the tables. Chetan> Why this happens...? is it the problem with mysqldump...?? and if it Chetan> really the case then how can i re-create my whole database and keep all Chetan> my database retaining the foreign keys. Chetan> If anyone can suggest me alternative method for doing the same then it Chetan> will be very usful for me. Chetan> Waiting for response. The problem here is that in MySQL 3.23 FOREIGN KEY definitions is not part of the mysqldump output. This will be fixed in MySQL 3.23.50 and 4.0.2, both which will be available shortly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to connect Windows client to a MySQL server in Linux
Hi, I really frustrated because I could not connect my WIN98 client to the MySql server installed on a Linux Server. The MySQL is of version 4.0.1 in a RedHat Linux 7.2, also I install a MyODBC version 3.5 in the client machine. In fact, I am using PowerBuilder on Windows platform as a programming tool, and I setup the DSN on the Windows machine with hostname=server's IP and signon with "root" through PowerBuilder, but an error message returned telling that the MySQL database cannot be accessed. So, would anyone tell me the reason, proper procedures or just tell me where could I find manuals or other materials for this topic? Thank you very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
