Need help creating table using phpMyAdmin
Sorry for this easy question but I'm kind of a newbie and I'm wondering if someone could assist me with creating a new table for a postnuke module? I need to copy the following content into a table I create named nuke_zc_ads: ( `ad_id` smallint(5) unsigned NOT NULL auto_increment, `cat_id` smallint(5) unsigned NOT NULL default '0', `user_name` varchar(20) NOT NULL default '', `email` varchar(50) NOT NULL default '', `price` text NOT NULL, `condition` varchar(10) NOT NULL default '', `city` varchar(20) NOT NULL default '', `state` varchar(20) NOT NULL default '', `country` varchar(20) NOT NULL default '', `lastup_date` int(11) NOT NULL default '0', `subject` text NOT NULL, `descript` text NOT NULL, `url` text NOT NULL, `views` int(11) NOT NULL default '0', `paypal` char(3) NOT NULL default 'No', `add_date` int(11) NOT NULL default '0', `exp_date` int(11) NOT NULL default '0', PRIMARY KEY (`ad_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; I see where to create the table but I'm not sure about the number of fields to add. My instincts are telling me I need 18 fields but I just need to confirm. Any responses are appreciated.
Re: Need help creating table using phpMyAdmin
Marvin Cummings wrote: Sorry for this easy question but I'm kind of a newbie and I'm wondering if someone could assist me with creating a new table for a postnuke module? I need to copy the following content into a table I create named nuke_zc_ads: ( `ad_id` smallint(5) unsigned NOT NULL auto_increment, `cat_id` smallint(5) unsigned NOT NULL default '0', `user_name` varchar(20) NOT NULL default '', `email` varchar(50) NOT NULL default '', `price` text NOT NULL, `condition` varchar(10) NOT NULL default '', `city` varchar(20) NOT NULL default '', `state` varchar(20) NOT NULL default '', `country` varchar(20) NOT NULL default '', `lastup_date` int(11) NOT NULL default '0', `subject` text NOT NULL, `descript` text NOT NULL, `url` text NOT NULL, `views` int(11) NOT NULL default '0', `paypal` char(3) NOT NULL default 'No', `add_date` int(11) NOT NULL default '0', `exp_date` int(11) NOT NULL default '0', PRIMARY KEY (`ad_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; I see where to create the table but I'm not sure about the number of fields to add. My instincts are telling me I need 18 fields but I just need to confirm. 17 would do, so long as you check the primary button on the first one (ad_id), but this would be much simpler to do with the mysql client. Connect with mysql -u root -p nameofdb replacing nameofdb with whatever you've named the database this table will belong to. After you've supplied the password and gotten in, enter CREATE TABLE nuke_zc_ads ( `ad_id` smallint(5) unsigned NOT NULL auto_increment, . . . ) TYPE=MyISAM AUTO_INCREMENT=1 ; In other words, copy what you have above and paste it in after entering the CREATE TABLE line. That's it -- you're done -- table created. You could do it with phpmyadmin, but it'll take awhile filling in all those boxes. Any responses are appreciated. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to connect to mysql with phpmyadmin
Marvin Cummings wrote: I finally managed to get this working. It turns out I was using the wrong password for the root account and once I remembered what the correct password was I was able to log in via phpMyAdmin. I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6. Now I want to switch the 'auth_type' to 'HTTP'. I change it to HTTP and remove the password. I try to log in as root, localhost\root and [EMAIL PROTECTED] and get a You are not authorized to view this page error. What do I need to do to change the auth_type? Thanks again for the help. Did you set up the controluser? phpmyadmin needs to have a user and password it can use to access mysql to read the user table to compare the username/password you supply with auth_type HTTP against what's set up in the db. You have to create the controluser in mysql, then edit your config.inc.php to set the controluser variables accordingly. See the phpmyadmin manual http://www.phpmyadmin.net/documentation/ for the details. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql and mysql crashing
Christine Ross wrote: I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS=03 -felide-constructors -fno-exceptions -fno-rtti because of some instances of mysql crashing. When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). Im using CXX=gcc. It would be helpful if you would tell us what OS you have and which version of mysql you are building, as well as pasting in the message you got from gcc. 1) Has anyone had instances if it crashing without those parameters? I can't have mysql crashing but if the gcc indicates it doesn't support it, do those flags get built in? Also when I included it in the build, my statement about --localstatedir=/usr/local/mysql/data was ignored because it never built the data directory. 2) I just built it with --prefix and --localstatedir. Has anyone had problems with this? That depends on what you mean by build (out of `configure`, `make`, or `make install`). The data directory is created when you install mysql with `make install`. Are you saying that didn't happen when you installed? 3) If I want to recompile mysql, do I also have to recompile all apache, php and mod_ssl? That depends. Did you build php against your build of mysql, or did you keep php's built-in mysql support? Thanks for any suggestions. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Grouping problem
Hi, Can I ask MySQL to GROUP BY id on MAX(something). For example, the query below: mysql SELECT diary.date, diary.time, diary.id AS diary_id, diary.title, - link.to_id AS friend_id - FROM link - JOIN diary ON diary.member_id = link.to_id - WHERE link.from_id=10 - ORDER BY diary.id DESC - LIMIT 5 - ; ++--+--+-+---+ | date | time | diary_id | title | friend_id | ++--+--+-+---+ | 2004-04-02 | 18:27:49 | 57 | tes |22 | | 2004-02-23 | 13:55:30 | 20 | fdas| 6 | | 2004-02-23 | 13:55:16 | 19 | dfasfsd | 6 | | 2004-02-23 | 13:55:03 | 18 | fasd| 6 | | 2004-02-23 | 13:54:55 | 17 | daf | 6 | ++--+--+-+---+ 5 rows in set (0.01 sec) What I want is: ++--+--+-+---+ | date | time | diary_id | title | friend_id | ++--+--+-+---+ | 2004-04-02 | 18:27:49 | 57 | tes |22 | | 2004-02-23 | 13:55:30 | 20 | fdas| 6 | ++--+--+-+---+ I only need the row with the MAX(diary_id) from the same friend_id. Here is what I tried, but failed :( mysql SELECT diary.date, diary.time, diary.id AS diary_id, diary.title, - link.to_id AS friend_id - FROM link - JOIN diary ON diary.member_id = link.to_id - WHERE link.from_id=10 - GROUP BY link.to_id - ORDER BY diary.id DESC - LIMIT 5 - ; ++--+--+---+---+ | date | time | diary_id | title | friend_id | ++--+--+---+---+ | 2004-04-02 | 18:27:49 | 57 | tes |22 | | 2004-02-21 | 11:08:57 |4 | test | 6 | ++--+--+---+---+ 2 rows in set (0.00 sec) The diary_id for friend_id 6 is 4. I want it to be 20 which is the biggest diary_id value for friend_id 6. How do I do this? Thank you very much. Regards, --Batara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: starting mysql daemon
hello a few days ago i had this problem in starting mysql daemon.. (described below by previous messages).. which was solved. i changed the permissions of the data directory. but now again i am facing the same problem. but the error message is of binding the unix socket. something like this..(not exact) unix socket bind error. do you have another mysql daemon running on the socket mentioned in the file .. /var/run/mysql/?.sock (?.. means i dont remember the exact name of the file probably mysql.sock actually i am mailing from college computer lab not from my home due to some problem) but there is nothing in the dir /var/run/mysql its empty. the mysql user mysql have all the permissions of the data dir . plz tell me what to do.. if this much details are sufficient for understanding the problem.. otherwise i will mail with exact details. regards alqama - Original Message - From: muhammad alqama [EMAIL PROTECTED] Date: Fri, 02 Apr 2004 00:45:27 +0800 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: starting mysql daemon hello the directory /var/lib/mysql/mysql (datadir) has read/write permissions for user mysql and for root group drwx-- 2 mysql root... but the file /var/lib/mysql/mysql/host.frm (as well as all the files in dir .../mysql/mysql) has permissions only for root -wr-wr- 1 root root should i change the permissions for the file host.frm or the directory...for user mysql regards alqama - Original Message - From: [EMAIL PROTECTED] Date: Thu, 1 Apr 2004 10:02:22 -0600 To: [EMAIL PROTECTED], [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: RE: starting mysql daemon Errno 13 indicates a permissions error. Please check the ownership of the data directories you're using to make sure that the mysql user group. Dave -Original Message- From: muhammad alqama [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:46 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: starting mysql daemon hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file : './mysql/host.frm' (errno 13) what to do now... regards alqama -- Are you a Proud Pakistani ? Get your free Pakistani email from http://www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Are you a Proud Pakistani ? Get your free Pakistani email from http://www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I need support
kimandy [EMAIL PROTECTED] wrote: I can only connect to mysql with the username root and no password I have the ini file configured with a username and password but I can't connect with them. I am using win xp and winmysqladmin ver. 1.4 I cant genarate a report because it says I must be connected first. On the environment tab myodbc window says not found driver 3.51 not found. You must first create user to connect and assign password to the 'root' user: http://www.mysql.com/doc/en/Adding_users.html http://www.mysql.com/doc/en/Windows_post-installation.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: starting mysql daemon
Try this one: Copy share/mysql/my-medium.cnf file to /etc/my.cnf and run mysql_install_db and chown -R mysql mysql data dir and mysqld_safe command. Find the mysql datadir from mysql_install_db file (line no 77 : e.g. ldata=/var/opt/mysql) Thanks, Mathan - Original Message - From: muhammad alqama [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:19 PM Subject: Re: starting mysql daemon hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file : './mysql/host.frm' (errno 13) but in the directory /var/lib/mysql/mysql the file host.frm exists...(/var/lib/mysql/ being the data dir) what to do now... regards alqama - Original Message - From: Victor Pendleton [EMAIL PROTECTED] Date: Wed, 31 Mar 2004 16:03:43 -0600 To: muhammad alqama [EMAIL PROTECTED] Subject: Re: starting mysql daemon This file is normally located in the data directory On Wed, 31 Mar 2004, you wrote: hi can u tell me where this file hostname.err lies as i have searched and not found it . - Original Message - From: Victor Pendleton [EMAIL PROTECTED] Date: Wed, 31 Mar 2004 15:17:54 -0600 To: muhammad alqama [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: starting mysql daemon Did you check in the hostname.err file to see why MySQL ended? On Wed, 31 Mar 2004, muhammad alqama wrote: hello i am using slackware linux and i installed mysql server with the installation. now i am trying to start the mysql daemon but it is not being start. i have run mysql_install_db --user=mysql .. it runs successfully. but as i run the command mysqld_safe to run daemon it gives the following output.. i run.. root../usr/bin mysqld_safe --user=mysql the output is [1] 1273 root../usr/bin starting mysqld daemon with database from /var/lib/mysql 040325 01:57:32 mysqld ended (the prompt root../usr/bin is not returned.. i have to press ctrl+c) also if i run root../usr libexec/mysqld the message is fatal error : please read security section of the manual to find out how to run mysqld as root 040325 2:10:39 aborting 040325 2:10:39 libexec/mysqld shutdown complete please tell me what to do to start the daemon -- Are you a Proud Pakistani ? Get your free Pakistani email from http:// www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/ mysql To unsubscribe:http://lists.mysql.com/ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/ [EMAIL PROTECTED] -- Are you a Proud Pakistani ? Get your free Pakistani email from http:// www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- Are you a Proud Pakistani ? Get your free Pakistani email from http://www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 3/24/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binlog strangeness?
hello, I came upon a strange thing just recently. I was trying to pipe a few sql statements but got a 1025 error all the time. I restarted, erased database manually but nothing worked so I tried deleting the binlogs and then my error disapered and everything was as normal. In what way does the bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? Anyone ? /Jonas
reindex auto_incroment field in myism table?
would anybody know how to reindex an auto_increment field in a table??
Re: starting mysql daemon
muhammad alqama [EMAIL PROTECTED] wrote: hello a few days ago i had this problem in starting mysql daemon.. (described below by previous messages).. which was solved. i changed the permissions of the data directory. but now again i am facing the same problem. but the error message is of binding the unix socket. something like this..(not exact) unix socket bind error. do you have another mysql daemon running on the socket mentioned in the file .. /var/run/mysql/?.sock (?.. means i dont remember the exact name of the file probably mysql.sock actually i am mailing from college computer lab not from my home due to some problem) but there is nothing in the dir /var/run/mysql its empty. the mysql user mysql have all the permissions of the data dir . plz tell me what to do.. if this much details are sufficient for understanding the problem.. otherwise i will mail with exact details. Check if you have another mysqld running: ps ax | grep mysqld -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why MySQL is used instead of MaxDB?
Hi Friends, I am working on a pilot project that will introduce open source databases in my organisation. In my search I have found that MySQL and MaxDB both are open source databases, but MaxDB is being used very less in comparison to MySQL. If I link this with the fact that MaxDB provides many advanced features that MySQL dowsn't provide, first question that hits my mind is why is it so? Why MySQL is used more in comparison to MaxDB I am unable to find any genuine reason behind this, hope you can help me out Thanks Regards... Pratik Ajmera Tata Consultancy Services Raheja Green, Kulupwadi Road, Borivali (East) Mumbai - 400 066,Maharashtra India Ph:- +91-22-56688712 Mailto: [EMAIL PROTECTED] Website: http://www.tcs.comDISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Services takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: reindex auto_incroment field in myism table?
Why would you want to? Although the easiest way I know of if to rename and take of auto_increment from the one field. Then recreate the field. Andy B wrote: would anybody know how to reindex an auto_increment field in a table?? -- With regards, Say_Ten This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137 or return the E.mail to [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why MySQL is used instead of MaxDB?
The answers are wide and varied: * History - MySQL has been an open source product for longer * Flexibility - MySQL's different table types are ideal for some situations * Performance - MySQL is the fastest database on the planet for most tasks * Support - There are massive amounts of software out there that will interface with MySQL [EMAIL PROTECTED] wrote: Hi Friends, I am working on a pilot project that will introduce open source databases in my organisation. In my search I have found that MySQL and MaxDB both are open source databases, but MaxDB is being used very less in comparison to MySQL. If I link this with the fact that MaxDB provides many advanced features that MySQL dowsn't provide, first question that hits my mind is why is it so? Why MySQL is used more in comparison to MaxDB I am unable to find any genuine reason behind this, hope you can help me out Thanks Regards... Pratik Ajmera Tata Consultancy Services Raheja Green, Kulupwadi Road, Borivali (East) Mumbai - 400 066,Maharashtra India Ph:- +91-22-56688712 Mailto: [EMAIL PROTECTED] Website: http://www.tcs.com DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Services takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I need support
BTW, when I start Winmysqladmin from a new installation, it always asks me for a username and password. Since this is a single-user machine I simply use root and a password. Does this setup those passwords in MySQL? From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: I need support Date: Mon, 05 Apr 2004 11:35:24 +0300 kimandy [EMAIL PROTECTED] wrote: I can only connect to mysql with the username root and no password I have the ini file configured with a username and password but I can't connect with them. I am using win xp and winmysqladmin ver. 1.4 I cant genarate a report because it says I must be connected first. On the environment tab myodbc window says not found driver 3.51 not found. You must first create user to connect and assign password to the 'root' user: http://www.mysql.com/doc/en/Adding_users.html http://www.mysql.com/doc/en/Windows_post-installation.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Tax headache? MSN Money provides relief with tax tips, tools, IRS forms and more! http://moneycentral.msn.com/tax/workshop/welcome.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Binlog strangeness?
Jonas Lind?n [EMAIL PROTECTED] wrote: hello, I came upon a strange thing just recently. I was trying to pipe a few sql statements but got a 1025 error all the time. I restarted, erased database manually but nothing worked so I tried deleting the binlogs and then my error disapered and everything was as normal. In what way does the bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? What SQL statements have you tried to execute? Which version of MySQL do you use? What OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Binlog strangeness?
Hi MySQL 5.0.0, Mandrake 9.2 and the error pointed to my alter table statement where tried to add a foreign key constraint. I have been fiddling a little bit with replication priot to this error but I commented all of that data out of the my.cnf file. Regards /Jonas - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 05, 2004 2:17 PM Subject: Re: Binlog strangeness? Jonas Lind?n [EMAIL PROTECTED] wrote: hello, I came upon a strange thing just recently. I was trying to pipe a few sql statements but got a 1025 error all the time. I restarted, erased database manually but nothing worked so I tried deleting the binlogs and then my error disapered and everything was as normal. In what way does the bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? What SQL statements have you tried to execute? Which version of MySQL do you use? What OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why MySQL is used instead of MaxDB?
Chris Nolan wrote: The answers are wide and varied: * History - MySQL has been an open source product for longer * Flexibility - MySQL's different table types are ideal for some situations * Performance - MySQL is the fastest database on the planet for most tasks * Support - There are massive amounts of software out there that will interface with MySQL --8 Just to add a few more thingies: Even though MaxDB has better looking admin tools (even the documentation is visually more appealing) MySQL is by a _BIG_ far easier to manage, learn and use (even easier to install!). I have been using both data bases for a few years now, I belong to both lists, the maxdb and the mysql list, i generally feel more confortable using mysql than max db, even the syntax used to admin the db seems to be easier to learn and use that the one that comes with dbcli(maxdb command line client). You can embed mysql server, you cannot embed maxdb is another nice thing. You can get mysql for free in almost every isp and webhosting on planet earth, maybe even in outter space, we'll see... =) I guess the average is about 1000 persons that knows about mysql against 1 that knows about maxdb You can even find more books on mysql. On the other side, maxdb is a _VERY_ feature rich data base, it has triggers, views, and every thing that you might expect from any other comercial grade db. A lack of this things in MySQL does not mean that mysql is a rather inferior choice, most of this feature can be replaced or simulated with a little tweaking and a good knoledge of the sql and mysql api. In the long run, i would like mysql to provide tools comparable to the ones provided by maxdb, things like a good gui to REALLY manage the db (i mean a tool that let me manipulate the my.cnf, just as an example) and implementing long awaited features like views and triggers (i know they are planned for 5.1 and above) (I WISH) i could get a nice mix of features of the best of maxdb and mysql, called it MEGA DB =) CONCLUSION: Download both, try both, subscribe to both list, evaluate them, there are certainly jobs, that both databases can perform equally, there are task that are better suited for one or the other. It's up to you. Anyway, we are here to help! =) Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql and mysql crashing
Michael Stassen wrote: Christine Ross wrote: I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS=03 -felide-constructors -fno-exceptions -fno-rtti ---8 It's not a CERO, it's an letter O, the correct syntax is: CXXFLAGS=-O3 -felide-constructors -fno-exceptions-fno-rtti If you are using a recent intel processor you can even add: -march=i686 -mcpu=i686 You don't even have to add the -O3 since it will be automatically added by the mysql configure script. Just export CXXFLAGS with the other optional optims flags, you can check out what they mean by reading them in the gcc man: man gcc When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). Im using CXX=gcc. --8 What distro are you using? What mysql server are you trying to compile? Also when I included it in the build, my statement about --localstatedir=/usr/local/mysql/data It's irrelevant, the localstatedir is where mysql, once compiled and configured will look for data by default, this default can _ALWAYS_ be overriden by changing the configuration file. It's just a default. Once compiled, you must run a script that will create the default databases and tables, _BUT_ once compiled and _INSTALLED_, not before. The script is called: mysql_install_db and it should be (normally i mean) in /usr/bin Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
opinion please
I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I was thinking of having one database to store all records for all users. I would store a user_id against records where appropriate to relate them to a particular user. The database will have a contacts table, users table, session_data table the contacts table will contain a field user_id to identify which contact is associated with which user. This will lead to a very large contacts table (million records???) Alternatively I could create a database for each user database_user1, database_user2 etc, each one of these databases could be then referenced dynamically in my application code, depending on the user logged in. Each one would have its own contacts table, specifically for that user. Which is the better way to go, in the opinion of any gurus out there..one very large database or multiple instances of user particular databases. Any guidance would be greatly appreciated. Regards Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: opinion please
A million rows is not a lot for mysql. The pro of doing it in one table is that the coding is much easier. Reporting is much easier. The pro of doing it as individual databases would be easier locking, quicker responses on queries (not so much), and the ability to secure it much more (dynamically create logins to database). You have to weigh out how much work you want to do I guess. I did something the second way for a web statistic package. Sheer volume made me do that (and locking issues). I do not think that it will be quite as much of a problem in your case, as I can't imagine it being hammered either way. Hope that helps a bit P joe collins [EMAIL PROTECTED] 04/05/2004 09:00 AM To: MySQL [EMAIL PROTECTED] cc: Subject:opinion please I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I was thinking of having one database to store all records for all users. I would store a user_id against records where appropriate to relate them to a particular user. The database will have a contacts table, users table, session_data table the contacts table will contain a field user_id to identify which contact is associated with which user. This will lead to a very large contacts table (million records???) Alternatively I could create a database for each user database_user1, database_user2 etc, each one of these databases could be then referenced dynamically in my application code, depending on the user logged in. Each one would have its own contacts table, specifically for that user. Which is the better way to go, in the opinion of any gurus out there..one very large database or multiple instances of user particular databases. Any guidance would be greatly appreciated. Regards Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
alter table query
I have a table that has a column : session_id INTEGER UNSIGNED NOT NULL, I now want to store a hexadecimal value in this column instead. the column already contains values for some records.can I alter the data type of this column (make it a varchar) without loosing the data already stored? or must I drop the column and then add it using the new data type. I would loose my data by dropping the column. (I can extract the data and repopulate the table (with the new data type field) if necessary but would like to avoid this) any ideas? Regards Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: alter table query
If you are unsure you should make a copy of the table and perform you test actions on that table. The answer is yes you can convert your unsigned integer column to a varchar column. On Mon, 05 Apr 2004, joe collins wrote: I have a table that has a column : session_id INTEGER UNSIGNED NOT NULL, I now want to store a hexadecimal value in this column instead. the column already contains values for some records.can I alter the data type of this column (make it a varchar) without loosing the data already stored? or must I drop the column and then add it using the new data type. I would loose my data by dropping the column. (I can extract the data and repopulate the table (with the new data type field) if necessary but would like to avoid this) any ideas? Regards Joe Content-Type: text/plain; name=unnamed Content-Transfer-Encoding: 7bit Content-Description: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: alter table query
If you are unsure you should make a copy of the table and perform you test actions on that table. The answer is yes you can convert your unsigned integer column to a varchar column. Yep, first make a backup copy of your table, then alter the column to varchar type. To convert the existing decimal data to hexadecimal format you could do a UPDATE table SET column = HEX(column); (MySQL = 4.0.1) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Copy Database
How can I copy all the tables in a database that I am developing using 5.0 to a production database that uses 4.1.8? All the tables are InnoDB tables. Regards, Maru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Copy Database
mysqldump Maru, Mulugeta wrote: How can I copy all the tables in a database that I am developing using 5.0 to a production database that uses 4.1.8? All the tables are InnoDB tables. Regards, Maru -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
where clause query
does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as used in oracle. select * from tableX where tableX_id IN ('1', '2', '3') i.e. if I have a comma delimited list of values for a certain field on a table...I can search for all records that have the values in my comma delimited list.using the one where clause? Thanks for your patience...I could not find this in the documentation. Regards Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: where clause query
Hello joe, Monday, April 5, 2004, 3:17:27 PM, you wrote: jc does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as jc used in oracle. Yes. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FileMaker Pro compared to MySQL
It's tough comparing databases that are not in the same class. MySQL is better than FileMaker (even v7) in lots of way, but then, Filemaker is better in some ways too. MySQL will be far more scalable than FileMaker. But you'll be more productive in FileMaker based on it's ease of use. At least until you get really good at PHP or whatever front end language you choose. I'm actually using both at my company. I have a few FileMaker databases with over 100K records (Emails, Journal) with almost no performance issues. The largest databases increase by about 50-100 records a day. But I have one database with less than 20K records that was just getting too slow for complex full text searches in a large text field. MySQL takes about 2-3 seconds to do the same complex search that FileMaker did in about 20. There's also the problem of other FileMaker clients pausing while a search takes place. All of my test searches are actually faster in MySQL than in FileMaker. About 6 months ago I decided I was going to switch everything over to PHP/MySQL. Mainly because I want a web front end and have never been impressed with Filemaker as a web backend. I've used CDML, Lasso and now fxPHP for my web front end to FileMaker. But FileMaker is just slow when accessed via the web. The short answer is that yes, MySQL would speed things up if you do things right. MySQL is as scalable (compared to FileMaker) as FileMaker is easy to use. Two extremes. I wouldn't recommend using FileMaker as a front end to MySQL through a plug-in or ODBC. On Apr 1, 2004, at 6:26 PM, Justin Tulloss wrote: I am currently using FileMaker Pro for a relatively large database and I am wondering how to speed it up. Would MySQL speed things up? Is FileMaker in some way inferior to MySQL? If so, how? Would it be easy to use a FileMaker plugin to access the MySQL database, or should I write a PHP front? Thanks for you help, Justin Tulloss Network Administrator InterChez Logistics Systems, Inc. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: where clause query
does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as used in oracle. MySQL supports this syntax exactly. See http://www.mysql.com/doc/en/Comparison_Operators.html (halfway the page) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication error
Ugo Bellavance [EMAIL PROTECTED] wrote: Hi, I'm trying to do a replication of two servers (one is mysql version = 4.1.0-alpha-debug-debug (slave) on debian and the other is = 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for = now. What I've done is that I stopped the master, copied the data folder to = the slave. I got the data from SHOW MASTER STATUS and input it in the = slave, and created the user on the master, as directed. The problem is that when I START SLAVE, I get this error: ERROR 1200: = The server is not configured as slave, fix in config file or with CHANGE = MASTER TO The problem might be caused by the fact that I have a firewall with nat = between them, but I set up the user accordingly ([EMAIL PROTECTED] = name of the firewall]. The slave is able to reach port 3306 on the = master and port-forwarding is enabled on the firewall, forwarding port = 3306 to the slave. SHOW MASTER STATUS on the master: mysql show master status; +--+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--+--+--+--+ | bobby-bin.23 | 79 | | | +--+--+--+--+ 1 row in set (0.00 sec) Did you put replication option to the my.cnf or use CHANGE MASTER TO command to configure your slave? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems Reinstalling mysql
I broke it and can't fix it or reinstall it. I installed the MacOS X package, 'mysql-standard-4.0.18'. It seemed to be working. I started 'mysqld_safe'. Nothing happened but the prompt no longer appeared. As per the instructions, I hit control-z and it said the process was suspended, so I figured that was good. I then ran 'mysql' and it started a process which gave me prompts. I went in and out of that a few times. But the documentation told me to assign a password to the root account. It told me to enter the following two lines. /usr/local/mysql/bin/mysqladmin -u root password newpwd /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password newpwd I entered the first one. Where it says newpwd, I entered my desired password, but not within quotations. Still, it made no complaint. I entered the second one (again using my desired password in place of newpwd but not using quotations), but it failed. After that, nothing worked. I restarted, but now when I tried to start mysqld_safe it always immediately said that it ended. Finally I used 'rm' to kill both mysql (the link) and 'mysql-standard-4.0.18-apple-darwin6.8-powerpc/' (the directory). I ran the installer. It would not offer to 'install', only to 'upgrade'. I told it to 'upgrade', which it did without complaint, but it made no difference.I restarted. No difference. Reinstalled. No difference. I tried 'ps -U mysql'. Nothing was running. I tried '/usr/local/mysql/bin/mysqld_safe --skip-grant-tables'. It says: chown: mysql: Invalid argument Starting mysqld daemon with databases from /usr/local/mysql/data 040405 08:08:03 mysqld ended I tried running 'sudo scripts/mysql_install_db' to reset the grant tables. That seemed to work fine. It just made no difference. I even deleted and recreated the mysql user identity. I found an old shell script by Marc Liyanage, called remove-old-mysql.sh. It said it couldn't find the installation record so I reviewed it. It looks for a receipt in /Library/Receipts. I found a directory for mySQL there, so killed that. After that, the installer now was willing to 'install' as opposed to 'upgrade'. It installed the files just fine, but after that it said it was running a 'script', and shortly after that it said it failed. I restarted and tried again with the same result. I had thought that the script it was supposed to run was the 'mysql_install_db' script which I had run without problem (or effect) as described above. The installer has no 'uninstall'. In short, my attempt to assign a password to the mysql root user broke it. Then I killed the directory, and finally the Receipt and even recreated the mysql user identity, but can't either reinstall or get it working. Help! -- Sincerely, Kevin Jaques (at home) Use [EMAIL PROTECTED] for work related messages Send lawyers, guns and money! Dad get me out of this! - Warren Zevon
Scratch with alias in MySQL
Hi People!! I'm have something so curious: In my application on Java I defined a Statement like this: stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATAB LE); and execute this query: stmt.executeQuery(select * from users as usr where (usr.id = 34)); So this throw a SQLException: SQLException: General error, message from server: Table 'db.usr' doesn't exist The application doesn't throw the SQLException if I define a statement by default, like this: stmt = con.createStatement(); Alternatively I execute this query in MySQLFront and it's work fine, obviously the statement is not UPDATABLE!! I think: the answer is that RecordSet UPDATABLES or SCROLL_SENSITIVE doesn´t work with alias, is that correct?? Any coments... Thanks in advanced!!! Atte. Alexis Guédez López Sistemas EPA, ext. 308
Create my First Stored Procedure ...
Hello, Help Me!! I must create this simple stored procedure : create procedure simpleproc (out param1 INT) begin select count(*) from clz.articoli; end; I use MySql Control Center Editor and database MySql 5.0.0-alpha-max-nt for compile this procedure! this is the error: [root] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySql Server version for the right syntax to use .. where is the problem ?? I'm a novice developer!!! Best Regards Mirco __ Social price: l'ADSL diventa per tutti Tiscali ADSL Senza Canone 640Kbps: GRATIS fino al 15 aprile costo di adesione, attivazione e il modem per tutto il 2004. E per i primi 3 mesi, con il Tiscali social price, navighi a 1,5 euro l'ora! Affrettati! http://point.tiscali.it/adsl/prodotti/640Kbps/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.1 on Mac OS X 10.3.3
Has anyone been successful installing the develoment release of MySQL (4.1.1 I believe) on Panther? I'm running 10.3.3, full updates and all of that, and I tried for days to get the latest MySQL running on my machine. I ran into permission problems, couldn't get mysqld to run. I finally settled for 4.0.18, and that's running fine, but I'd really like to get the dev. release up and running. Anyone have experience in getting it to run? Any suggestions, tips are greatly appreciated. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create my First Stored Procedure ...
Hi, Help Me!! I must create this simple stored procedure : You might want to read some documentation on this... http://www.mysql.com/doc/en/Stored_Procedures.html create procedure simpleproc (out param1 INT) begin select count(*) from clz.articoli; end; select count(*) into param1 from clz.articoli; I use MySql Control Center Editor and database MySql 5.0.0-alpha-max-nt for compile this procedure! this is the error: [root] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySql Server version for the right syntax to use .. where is the problem ?? And make sure to set the statement delimiter. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant compile embedded mysql server in Windows
Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... libmysqld.def : error LNK2001: unresolved external symbol max_allowed_packet libmysqld.def : error LNK2001: unresolved external symbol myodbc_remove_escape libmysqld.def : error LNK2001: unresolved external symbol mysql_affected_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_autocommit libmysqld.def : error LNK2001: unresolved external symbol mysql_change_user libmysqld.def : error LNK2001: unresolved external symbol mysql_character_set_name libmysqld.def : error LNK2001: unresolved external symbol mysql_close libmysqld.def : error LNK2001: unresolved external symbol mysql_commit libmysqld.def : error LNK2001: unresolved external symbol mysql_data_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_debug libmysqld.def : error LNK2001: unresolved external symbol mysql_dump_debug_info libmysqld.def : error LNK2001: unresolved external symbol mysql_eof libmysqld.def : error LNK2001: unresolved external symbol mysql_errno libmysqld.def : error LNK2001: unresolved external symbol mysql_error libmysqld.def : error LNK2001: unresolved external symbol mysql_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field_direct libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_lengths libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_row libmysqld.def : error LNK2001: unresolved external symbol mysql_field_count libmysqld.def : error LNK2001: unresolved external symbol mysql_field_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_field_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_free_result libmysqld.def : error LNK2001: unresolved external symbol mysql_get_client_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_host_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_proto_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_version libmysqld.def : error LNK2001: unresolved external symbol mysql_info libmysqld.def : error LNK2001: unresolved external symbol mysql_init libmysqld.def : error LNK2001: unresolved external symbol mysql_insert_id libmysqld.def : error LNK2001: unresolved external symbol mysql_kill libmysqld.def : error LNK2001: unresolved external symbol mysql_list_dbs libmysqld.def : error LNK2001: unresolved external symbol mysql_list_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_list_processes libmysqld.def : error LNK2001: unresolved external symbol mysql_list_tables libmysqld.def : error LNK2001: unresolved external symbol mysql_more_results libmysqld.def : error LNK2001: unresolved external symbol mysql_next_result libmysqld.def : error LNK2001: unresolved external symbol mysql_num_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_num_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_odbc_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_options libmysqld.def : error LNK2001: unresolved external symbol mysql_ping libmysqld.def : error LNK2001: unresolved external symbol mysql_query libmysqld.def : error LNK2001: unresolved external symbol mysql_read_query_result libmysqld.def : error LNK2001: unresolved external symbol mysql_real_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_real_query libmysqld.def : error LNK2001: unresolved external symbol mysql_refresh libmysqld.def : error LNK2001: unresolved external symbol mysql_rollback libmysqld.def : error LNK2001: unresolved external symbol mysql_row_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_row_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_select_db libmysqld.def : error LNK2001: unresolved external symbol mysql_send_query libmysqld.def : error LNK2001: unresolved external symbol mysql_server_end libmysqld.def : error LNK2001: unresolved external symbol mysql_server_init libmysqld.def : error LNK2001: unresolved external symbol mysql_shutdown libmysqld.def : error LNK2001: unresolved external symbol mysql_sqlstate libmysqld.def : error LNK2001: unresolved external symbol mysql_ssl_set libmysqld.def : error LNK2001: unresolved external symbol mysql_stat libmysqld.def : error LNK2001: unresolved external symbol mysql_store_result libmysqld.def : error LNK2001: unresolved external symbol mysql_thread_id libmysqld.def :
Re: Cant compile embedded mysql server in Windows
Karam Chand wrote: Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... ---8 You can download the .zip (precompiled) file from mysql.com and save a lot of time. Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot build mysql using a code coverage tool
Hi, I am trying to do code coverage for mysql tests and for that using Bullseye Code coverage tool. I enable the code coverage and then try to build mysql, but I am getting following compilation error: -- note cov902: running /usr/bin/gcc -E -D_BullseyeCoverage=6803 -DCCOVER=_BullseyeCoverage -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I/home/akhandel/cvs-root/oss/core/dbms/mysql/src/readline -I.. -I/home/akhandel/cvs-root/oss/core/dbms/mysql/src/readline/../include -I/home/akhandel/cvs-root/oss/core/dbms/mysql/src/readline/.. -I.. -O3 -DDBUG_OFF readline.c -MT -MD -MP -MF .deps/readline.TPo cpp0: you must additionally specify either -M or -MM note cov927: program failed /usr/bin/gcc note cov909: exit status 1 make[2]: *** [readline.o] Error 1 make[1]: *** [all-recursive] Error 1 -- I am not sure how to get around with this problem. It expects some -M or -MM option in the cpp0 of gcc-lib. Please let me know if you have any idea about how to get around the problem. Abhishek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
two questions on starting and stopping mysld
Hi again, I became frustrated with a RH9 mysql server install so I removed it and installed the latest stable from mysql.com on the machine. Things are working much better now, but I'm having problems with 2 things: I've tried to make the server start at boot by copying the mysql.server file (from support-files) to /etc/init.d and /etc/rc.d ... neither worked. I also tried appending /usr/local/mysql/bin/mysqld_safe --user=mysql to the rc.local file, but the machine would hang, it wouldn't read past that line. What's the best way to make the server start at boot? Also,what's the best way to stop the server? Currently, I'm doing a killall mysqld, is there a more graceful way? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why can't I use an AS value in the WHERE clause.
I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE active = 1; It's so obnoxious, especially since I can do this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE unix_timestamp()-unix_timestamp(last_seen) 600; Why do I have to do the math TWICE?! *sigh* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why can't I use an AS value in the WHERE clause.
At 17:29 -0700 4/5/04, Daevid Vincent wrote: I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE active = 1; I think you'll never be able to do it. The stuff after the SELECT is calculated based on the rows selected by the WHERE. The WHERE therefore cannot be based on the stuff after the SELECT. It's so obnoxious, especially since I can do this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE unix_timestamp()-unix_timestamp(last_seen) 600; Why do I have to do the math TWICE?! *sigh* -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MSSQL Server to MYSQL migration problems
Hello list, Recently I've been in the job of migrating a large (about 1.5GB) database build in MSSQL Server to MYSQL. The migration was done OK, I used the SQLYog utility to do this. The problem is that one table has image column types ... I tried to view this column types (blob data types now) but I can't in the MYSQL migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Rodrigo Galindez Information Management Assistant Center for Human Rights and Environment (CEDHA) Gral Paz 186 10 A 5000 - Cordoba - Argentina Tel/fax 54-351-4256278 [EMAIL PROTECTED] www.cedha.org.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql and phpBB
I'm working with a script that is made for phpBB to rebuild the search engine. The script does work. I've been able to use it with limited success. The problem is I haven't been able to use it with complete success. The problem I'm having is that when it attempts to run its query, which selects X post texts from a table $sql = SELECT post_id, post_subject, post_text FROM . POSTS_TEXT_TABLE . LIMIT $start, . $HTTP_GET_VARS['post_limit']; $result = $db-sql_query ($sql); I will eventually get Warning: mysql_query(): Unable to save result set Which comes from the connection script line: $this-query_result = mysql_query($query, $this-db_connect_id); Someone suggested I use mysql_unbuffered_query() on another site. I've never had this kind of error before with this site. Its a new server I've deployed. Are there my.cnf settings I need have in order to run a script that will work on 300,000 records doing 10 at a time even? Even if I try this with 1 or 2 posts text I get this error. Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
You can't? How are you trying to display? What are you using? A CGI script? A database utility? Something else? We need a bit more information to answer the question. j- k- On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: Hello list, Recently I've been in the job of migrating a large (about 1.5GB) database build in MSSQL Server to MYSQL. The migration was done OK, I used the SQLYog utility to do this. The problem is that one table has image column types ... I tried to view this column types (blob data types now) but I can't in the MYSQL migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
MySQL is very stable on large databases...I would suspect inefficient indexes. What does your query look like? What is the output when you put EXPLAIN in front of your query? I don't know anything about SQLYog blob display, so can't comment there. j- k- On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like: Im using SQLYog to display results. It lets me to display blob data types. By the way, i was trying to do some queries with phpmyadmin ... but, it hungs ... hmmm ... inestability with large databases in mysql maybe ? :S Joshua J. Kugler wrote: You can't? How are you trying to display? What are you using? A CGI script? A database utility? Something else? We need a bit more information to answer the question. j- k- On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: Hello list, Recently I've been in the job of migrating a large (about 1.5GB) database build in MSSQL Server to MYSQL. The migration was done OK, I used the SQLYog utility to do this. The problem is that one table has image column types ... I tried to view this column types (blob data types now) but I can't in the MYSQL migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and phpBB
Mark, You may have a corrupt table. I would recommend printing the $query just before mysql_query() is ran. This will give you the query that is failing and the table that it is attempting to write to. May want to try a check table on this table. Bryan - Original Message - From: Mark Susol | Ultimate Creative Media [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 05, 2004 8:21 PM Subject: Mysql and phpBB I'm working with a script that is made for phpBB to rebuild the search engine. The script does work. I've been able to use it with limited success. The problem is I haven't been able to use it with complete success. The problem I'm having is that when it attempts to run its query, which selects X post texts from a table $sql = SELECT post_id, post_subject, post_text FROM . POSTS_TEXT_TABLE . LIMIT $start, . $HTTP_GET_VARS['post_limit']; $result = $db-sql_query ($sql); I will eventually get Warning: mysql_query(): Unable to save result set Which comes from the connection script line: $this-query_result = mysql_query($query, $this-db_connect_id); Someone suggested I use mysql_unbuffered_query() on another site. I've never had this kind of error before with this site. Its a new server I've deployed. Are there my.cnf settings I need have in order to run a script that will work on 300,000 records doing 10 at a time even? Even if I try this with 1 or 2 posts text I get this error. Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why can't I use an AS value in the WHERE clause.
On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote: At 17:29 -0700 4/5/04, Daevid Vincent wrote: I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE active = 1; I think you'll never be able to do it. The stuff after the SELECT is calculated based on the rows selected by the WHERE. The WHERE therefore cannot be based on the stuff after the SELECT. So why not the reverse? Allow aliasing in the WHERE clause, that we can use in the select clause. Probably not ANSI, but MySQL isn't shy about that. -- Joe Rhett Chief Geek [EMAIL PROTECTED] Isite Services, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why can't I use an AS value in the WHERE clause.
Hi, This is what HAVING is for. :-) Matt - Original Message - From: Joe Rhett Sent: Monday, April 05, 2004 8:59 PM Subject: Re: Why can't I use an AS value in the WHERE clause. On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote: At 17:29 -0700 4/5/04, Daevid Vincent wrote: I'm curious when will I be able to do something like this: SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) 600),1,0) as active FROM wifi_table WHERE active = 1; I think you'll never be able to do it. The stuff after the SELECT is calculated based on the rows selected by the WHERE. The WHERE therefore cannot be based on the stuff after the SELECT. So why not the reverse? Allow aliasing in the WHERE clause, that we can use in the select clause. Probably not ANSI, but MySQL isn't shy about that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: two questions on starting and stopping mysld
On 04/05/2004 6:16 PM, Brad Tilley [EMAIL PROTECTED] wrote: I've tried to make the server start at boot by copying the mysql.server file (from support-files) to /etc/init.d and /etc/rc.d ... neither worked. I also tried appending /usr/local/mysql/bin/mysqld_safe --user=mysql to the rc.local file, but the machine would hang, it wouldn't read past that line. What's the best way to make the server start at boot? Try chkconfig -- it works nicely: /sbin/chkconfig --level 2345 mysql on Also,what's the best way to stop the server? Currently, I'm doing a killall mysqld, is there a more graceful way? /usr/bin/mysqladmin [OPTIONS] shutdown Pablo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
read_key: Got error 146 when reading table
Hi, Found that error in .err log file: read_key: Got error 146 when reading table './databasename/tablename' Its an InnoDB table that gets a lot of reads/write with multiple millions records. Does someone as more informations on that error ? Philippe -- --- Probably the best way to create web sites: http://www.htmlfusion.com/ --- [EMAIL PROTECTED]- 310 370 3365-http://sqlfusion.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant compile embedded mysql server in Windows
Hello, I want a debuggable compiled library. Is Deug version of embedded server available. Karam --- Victor Medina [EMAIL PROTECTED] wrote: Karam Chand wrote: Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... ---8 You can download the .zip (precompiled) file from mysql.com and save a lot of time. Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
Since you have used SQLyog, I will say you contact the SQLyog people about this. Karam --- Joshua J. Kugler [EMAIL PROTECTED] wrote: You can't? How are you trying to display? What are you using? A CGI script? A database utility? Something else? We need a bit more information to answer the question. j- k- On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: Hello list, Recently I've been in the job of migrating a large (about 1.5GB) database build in MSSQL Server to MYSQL. The migration was done OK, I used the SQLYog utility to do this. The problem is that one table has image column types ... I tried to view this column types (blob data types now) but I can't in the MYSQL migrated data base, ... it just don't display anything. Any ideas ? Is there any issue problem when migrating MSSQL image column types to MYSQL ? Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and phpBB
You may have a corrupt table. I would recommend printing the $query just before mysql_query() is ran. This will give you the query that is failing and the table that it is attempting to write to. May want to try a check table on this table. SELECT post_id, post_subject, post_text FROM phpbb_posts_text LIMIT 30 , 10 MySQL said: #1030 - Got error 127 from table handler This is really weird. I'm showing a gap in posts_ID from 240915 to 4089168. This script has run before from 300,000 to the end before. Now if I check this table I get: Checking MyISAM file: phpbb_posts_text.MYI Data records: 324989 Deleted blocks: 0 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: Error reading file 'phpbb_posts_text.MYD' (Errcode: 5) myisamchk: error: got error: 5 when reading datafile at record: 3627 MyISAM-table 'phpbb_posts_text.MYI' is corrupted record: 3627 is where my script give me the error. Warning: mysql_query(): Unable to save result set I've run a check on this table before and it was ok. I don't know how this datafile would have been corrupted. Now, how can I remove that datafile specifically? I fear trying to rebuild that table for fear of it failing. Mark Susol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]