Re: New to MySQL
Hi, Thank you for your help and nice tutorials An easy for installation is here: Thanks Andrew http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos Here is another link http://opensourcedbms.com/dbms/installing-mysql-5-6-on-cent-os-6-3-redhat-el6-fedora/ I have read few articles and will install using yum installation but before that i would like to fix the error, I checked what is installed already rpm -qa | grep -i mysql MySQL-client-5.6.16-1.el6.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64 ** MySQL-client-5.6.16-1.el6.x86_64 I have installed before and got the error file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64 Already in CentOS So mysql server is not installed and no mysqld in /etc/init.d/ Shall i remove mysql client and re install client and server 5.1 to fix the error yum remove mysql mysql-* or update mysql 5.1 and install mysql server and client 5.6 Thank you very much in advance. Best Regards, Rabe On Thu, Mar 6, 2014 at 4:44 AM, Brian Van der Westhuizen [DATACOM] brian.vanderwesthui...@datacom.co.nz wrote: Asma, I think maybe it is a good idea if you start reading Mysql for dummies or something similar. If you do not understand the basic concepts of unix/linux and mysql, I see a hard road for you. Google is you friend and I believe they would even have documentation in your native language. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Thursday, 6 March 2014 12:08 a.m. To: Andrew Moore Cc: Reindl Harald; mysql@lists.mysql.com Subject: Re: New to MySQL How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail
Re: New to MySQL
Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail
Re: New to MySQL
Am 05.03.2014 11:55, schrieb Asma rabe: I checked if mysql installed rpm -qa | grep mysql post outputs - it's respectless seek for help and hold back infos because as you said you are new you likely not understand really the output and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. yum install bash-completion chkconfig mysqlTABTAB will show you that the service is named mysqld and not mysql Google: enable and start mysql server on CentOS would have also shown that On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail signature.asc Description: OpenPGP digital signature
Re: New to MySQL
Am 05.03.2014 12:03, schrieb Andrew Moore: Next action is to review the MySQL error log for the reason that it failed. oh no - don't reply with no clue chkconfig comes long before mysqld is invoked even if he would have spelled the service name correctly enable *isa not* start see my last answer On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com mailto:asma.r...@gmail.com wrote: Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you signature.asc Description: OpenPGP digital signature
Re: New to MySQL
How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail
Re: New to MySQL
enable *isa not* start - :D This is true. The mailing list is not an interactive article on the basics of installing and starting MySQL. There are 1000s of blog articles, documentation and guides on doing this. Perhaps looking here; http://www.rackspace.com/knowledge_center/article/installing-mysql-server-on-centos If you have some error messages pending the completion of the steps please be complete with your problem and include the messages you receive. A On Wed, Mar 5, 2014 at 11:06 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 05.03.2014 12:03, schrieb Andrew Moore: Next action is to review the MySQL error log for the reason that it failed. oh no - don't reply with no clue chkconfig comes long before mysqld is invoked even if he would have spelled the service name correctly enable *isa not* start see my last answer On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com mailto: asma.r...@gmail.com wrote: Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you
Re: New to MySQL
Am 05.03.2014 12:07, schrieb Asma rabe: How to do that? Thank you besides that the reply was wrong - see my last one it is respectless acting like you do asking every single piece and not read any manual or search http://www.catb.org/esr/faqs/smart-questions.html Google exists https://www.google.com/search?q=CentOS+mysql+log On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com mailto:eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com mailto:asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you signature.asc Description: OpenPGP digital signature
RE: New to MySQL
Asma, I think maybe it is a good idea if you start reading Mysql for dummies or something similar. If you do not understand the basic concepts of unix/linux and mysql, I see a hard road for you. Google is you friend and I believe they would even have documentation in your native language. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Thursday, 6 March 2014 12:08 a.m. To: Andrew Moore Cc: Reindl Harald; mysql@lists.mysql.com Subject: Re: New to MySQL How to do that? Thank you On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore eroomy...@gmail.com wrote: Next action is to review the MySQL error log for the reason that it failed. A On Wed, Mar 5, 2014 at 10:55 AM, Asma rabe asma.r...@gmail.com wrote: Hi All, Thank you very much. I checked if mysql installed rpm -qa | grep mysql and found it is installed, so no need for yum installation. when i tried to start the service chkconfig mysql on error reading information on service mysql: No such file or directory sorry to disturb you. Regards, Rabe On Tue, Mar 4, 2014 at 9:40 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) Any idea? Thank you all for your kind help Rabe On Tue, Mar 4, 2014 at 12:30 AM, geetanjali mehra mailtogeetanj...@gmail.com wrote: Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So, this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi
Re: New to MySQL
Am 04.03.2014 13:20, schrieb Asma rabe: I have checked before installation if mysql is installed using which mysql i found no mysql is installed. which is pointless rpm -qa | grep mysql next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 clearly shows there are at least the libraries installed which is why i said which is pointless *do not* use the raw rpm command it can't solve any dependencies use yum which works also for local downloaded RPM files when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql i doubt that MySQL-server contains /bin/mysql nor that after the error above anything was installed expect you did not show all what happened on your machine Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' Any idea? installing something does not mean it gets started or even enabled mysql is the client CLI connecting to a server, without specify one it connects to the local unix socket but given that your install above failed nor that you have tried to start mysqld that must fail signature.asc Description: OpenPGP digital signature
RE: New to MySQL
Why don't you just use yum install . Should sort out most if not all your problems regarding installation of mysql. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Wednesday, 5 March 2014 1:21 a.m. To: geetanjali mehra Cc: Johan De Meersman; mysql@lists.mysql.com Subject: Re: New to MySQL Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) Any idea? Thank you all for your kind help Rabe On Tue, Mar 4, 2014 at 12:30 AM, geetanjali mehra mailtogeetanj...@gmail.com wrote: Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So, this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Percona, MariaDB and Oracle provide YUM repos now. Remove all traces of MySQL before starting install using ; rpm -e {package} --nodeps then grab your YUM packages. A On Tue, Mar 4, 2014 at 7:01 PM, Brian Van der Westhuizen [DATACOM] brian.vanderwesthui...@datacom.co.nz wrote: Why don't you just use yum install . Should sort out most if not all your problems regarding installation of mysql. Regards Brian vd Westhuizen -Original Message- From: Asma rabe [mailto:asma.r...@gmail.com] Sent: Wednesday, 5 March 2014 1:21 a.m. To: geetanjali mehra Cc: Johan De Meersman; mysql@lists.mysql.com Subject: Re: New to MySQL Thank you very much for responding. I have checked before installation if mysql is installed using which mysql ,i found no mysql is installed. next i did rpm installation and got the errors rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 when i check now which mysql i found it has installed in /bin/mysql when i try to run mysql Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) Any idea? Thank you all for your kind help Rabe On Tue, Mar 4, 2014 at 12:30 AM, geetanjali mehra mailtogeetanj...@gmail.com wrote: Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So, this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
use rpm -i --replacefiles MySQL-server*.rpm On Mon, Mar 3, 2014 at 11:30 AM, Asma rabe asma.r...@gmail.com wrote: I installed my sql using RPM as follows: rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 When i tested if the server has installed or not bin/mysqlshow -bash: bin/mysqlshow: No such file or directory Any help is appreciated . Best Regards, Rabe On Fri, Feb 28, 2014 at 1:36 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Asma rabe asma.r...@gmail.com Subject: Re: New to MySQL so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient way to download ALL the RPMs in one go. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi
Re: New to MySQL
- Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Hi Asma, It looks from this error that there is an existing 5.1 installation present. As well as RPM packages (which can be downloaded from http://dev.mysql.com/downloads/mysql/5.6.html), there is also a yum repo for Enterprise Linux 6. It is available here: http://dev.mysql.com/downloads/repo/ Instructions on upgrading are here: http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html I actually prefer (and would recommend) the yum repos, since the underlying rpm packages are in a newer format. - Morgan On Mar 3, 2014, at 1:00 AM, Asma rabe asma.r...@gmail.com wrote: I installed my sql using RPM as follows: rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 When i tested if the server has installed or not bin/mysqlshow -bash: bin/mysqlshow: No such file or directory Any help is appreciated . Best Regards, Rabe On Fri, Feb 28, 2014 at 1:36 AM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Asma rabe asma.r...@gmail.com Subject: Re: New to MySQL so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient way to download ALL the RPMs in one go. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Thanks for responding. MySQL installation ,here, do not require mysql-libs package. As far as I know, there is no harm on using this command. I too got the same problem, and I didn't face any problem after removing this package. This package is installed by default and not needed here. So, this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Re: New to MySQL use rpm -i --replacefiles MySQL-server*.rpm While that will work, it really shouldn't happen. I'm a Debian man myself, so I don't know wether it's a problem with the packages or if you simply don't need the -libs package when installing the server. I would, however, suggest using Rug, Zypper or a similar advanced package manager instead of barebones RPM, as those will actually find and install any necessary dependencies, too. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi
Re: New to MySQL
I installed my sql using RPM as follows: rpm -i MySQL-server-5.6.16-1.el6.x86_64.rpm I got the following errors file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.6.16-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64 When i tested if the server has installed or not bin/mysqlshow -bash: bin/mysqlshow: No such file or directory Any help is appreciated . Best Regards, Rabe On Fri, Feb 28, 2014 at 1:36 AM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Asma rabe asma.r...@gmail.com Subject: Re: New to MySQL so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient way to download ALL the RPMs in one go. -- Unhappiness is discouraged and will be corrected with kitten pictures.
Re: New to MySQL
Hi Asma, If you are new to MySQL and/or Linux. Start with Ubuntu + MySQL. Best Regards Iqbal Aroussi 514 451-9122 On Thu, Feb 27, 2014 at 10:43 AM, Asma rabe asma.r...@gmail.com wrote: Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageMySQL Server* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageCompatibility Libraries* *Thank you very much in advance* *Best Regards,* *Rabe*
New to MySQL
Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageMySQL Server* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageCompatibility Libraries* *Thank you very much in advance* *Best Regards,* *Rabe*
Re: New to MySQL
- Original Message - From: Iqbal Aroussi iq...@aroussi.ca Subject: Re: New to MySQL If you are new to MySQL and/or Linux. Start with Ubuntu + MySQL. Iqbal, Please don't start distro wars on this list. Everyone chooses the platform he or she wants. Rabe, The RPM bundle is a tar archive that will contain all the other RPMs in one download. It is offered for convenience. The Server package is what you will need to install on the server machine; and it's possible that you'll need the compatlibs, too. I /think/ that depends on your OS version; I'm not exactly sure. The installation guide should provide more details on that. On your client machine, you'll need to install the Client utilities - those contain the commandline client. If you want to install Workbench, too, you will need to download that separately from the Workbench section of the site. /johan -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New to MySQL
Thank you very much Iqbal ,Johan, Actually I have Linux redhat already installed so I have to install MySQL server and client. so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? Thank you very much. Rabe On Fri, Feb 28, 2014 at 12:50 AM, Iqbal Aroussi iq...@aroussi.ca wrote: Hi Asma, If you are new to MySQL and/or Linux. Start with Ubuntu + MySQL. Best Regards Iqbal Aroussi 514 451-9122 On Thu, Feb 27, 2014 at 10:43 AM, Asma rabe asma.r...@gmail.com wrote: Hi, I would like t install MySQL server on Linux and MYSQL client and GUI may be workbench on client machine. For server installation, I found several options for download, I would appreciate if anyone can tell me which is better to install *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageMySQL Server* *Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM PackageCompatibility Libraries* *Thank you very much in advance* *Best Regards,* *Rabe*
Re: New to MySQL
- Original Message - From: Asma rabe asma.r...@gmail.com Subject: Re: New to MySQL so,Is it recommended to install RPM bundle which has compatlibs, MySQL serveretc rather than installing the server only? The Server should suffice; the Bundle is merely a convenient way to download ALL the RPMs in one go. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server Released under the GPL License
Hello Gael, The technology is brand new and you'll need to ask them the question. Parallel Universe has no hardware dependencies (it'll need multi core/CPU server only if you enable parallel processing). Hope this helps, Hiromichi - Original Message - From: Daevid Vincent dae...@daevid.com To: 'Gael Martinez' gael.marti...@gmail.com; mysql@lists.mysql.com Cc: Sent: Wednesday, August 22, 2012 4:31 PM Subject: RE: New Fast MySQL Compatible Server Released under the GPL License Well, considering that MySQL/Sun/Oracle can't even figure out how to reduce an ibdata1 file from ever-expanding after a decade (http://bugs.mysql.com/1341), it doesn't surprise me that parallel computing is a brain-stumper for them. :-\ Besides, I would suspect that Oracle would see this as one more threat against their cash cow product if they were to make MySQL even faster/better. I've not tried this offering below, nor do I know anything about it, but when a big company is involved, usually it comes down to money -- making it or spending it. d -Original Message- From: Gael Martinez [mailto:gael.marti...@gmail.com] Sent: Wednesday, August 22, 2012 10:13 AM To: Hiromichi Watari Cc: mysql@lists.mysql.com Subject: Re: New Fast MySQL Compatible Server Released under the GPL License On Wed, Aug 22, 2012 at 11:43 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: [..] Available at www.paralleluniverse-inc.com Hello Pardon my question on that one, but why wasn't the concept detailed in that white paper implemented into the core version of mysql or the percona version (and MariaDB?) ? Too many hardware dependencies ? Regards -- Gaël Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
New Fast MySQL Compatible Server Released under the GPL License
Parallel Universe is an extension of MySQL server architecture, created to provide fast parallel query capability. Speed is achieved by processing tables in parallel, utilizing multi core/CPU of server hardware. Parallel Universe is released under the GPL license and fully compatible with MySQL and Percona servers. Available at www.paralleluniverse-inc.com
Re: New Fast MySQL Compatible Server Released under the GPL License
On Wed, Aug 22, 2012 at 11:43 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: [..] Available at www.paralleluniverse-inc.com Hello Pardon my question on that one, but why wasn't the concept detailed in that white paper implemented into the core version of mysql or the percona version (and MariaDB?) ? Too many hardware dependencies ? Regards -- Gaël Martinez
RE: New Fast MySQL Compatible Server Released under the GPL License
Well, considering that MySQL/Sun/Oracle can't even figure out how to reduce an ibdata1 file from ever-expanding after a decade (http://bugs.mysql.com/1341), it doesn't surprise me that parallel computing is a brain-stumper for them. :-\ Besides, I would suspect that Oracle would see this as one more threat against their cash cow product if they were to make MySQL even faster/better. I've not tried this offering below, nor do I know anything about it, but when a big company is involved, usually it comes down to money -- making it or spending it. d -Original Message- From: Gael Martinez [mailto:gael.marti...@gmail.com] Sent: Wednesday, August 22, 2012 10:13 AM To: Hiromichi Watari Cc: mysql@lists.mysql.com Subject: Re: New Fast MySQL Compatible Server Released under the GPL License On Wed, Aug 22, 2012 at 11:43 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: [..] Available at www.paralleluniverse-inc.com Hello Pardon my question on that one, but why wasn't the concept detailed in that white paper implemented into the core version of mysql or the percona version (and MariaDB?) ? Too many hardware dependencies ? Regards -- Gaël Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
Hi, Hope the following link helps. Hiromichi http://corp.sec.state.ma.us/corp/corpsearch/CorpSearchSummary.asp?ReadFromDB=TrueUpdateAllowed=FEIN=001067137 - Original Message - From: Giles Coochey gi...@coochey.net To: mysql@lists.mysql.com Cc: Sent: Friday, May 11, 2012 6:47 AM Subject: Re: New Fast MySQL Compatible Server (Take 2) On 11/05/2012 07:57, Johan De Meersman wrote: - Original Message - From: Hiromichi Watarihiromichiwat...@yahoo.com I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Just like when you posted this a couple of weeks ago :-) Last time I checked, MySQL already uses multiple cores, and the main comments from back then are still standing: no information or documentation whatsoever, no trace of licensing, et cetera. You probably mean well, Hirochimi, but the way you keep doing this makes it look like malware. I, and probably a lot of people with me, will not be trying this before more information is available. Just to add, you must be in a parallel universe, because I cannot find any information about the Incorporation of your company either. -- Best Regards, Giles Coochey, CCNA Security, CCNA NetSecSpec Ltd giles.cooc...@netsecspec.co.uk Tel: +44 (0) 7983 877 438 Live Messenger: gi...@coochey.net http://www.netsecspec.co.uk http://www.coochey.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
- Original Message - From: Hiromichi Watari hiromichiwat...@yahoo.com I uploaded the technology whitepaper to the website. Hmm, interesting idea, to allocate a thread per table - I can imagine it's going to be pretty heavy on the thread cache, though :-) How does it respond to self-joins, subselects and other fancy bits? Similar things get done in both NDB and Oracle's Exadata systems, but there the multiple search threads are on different bits of the same table, and cross-machine. I'm not sure wether they have something similar to what you're doing. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
Hi, I uploaded the technology whitepaper to the website. Hope this helps. Hiromichi - Original Message - From: Johan De Meersman vegiv...@tuxera.be To: Hiromichi Watari hiromichiwat...@yahoo.com Cc: mysql@lists.mysql.com Sent: Friday, May 11, 2012 2:57 AM Subject: Re: New Fast MySQL Compatible Server (Take 2) - Original Message - From: Hiromichi Watari hiromichiwat...@yahoo.com I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Just like when you posted this a couple of weeks ago :-) Last time I checked, MySQL already uses multiple cores, and the main comments from back then are still standing: no information or documentation whatsoever, no trace of licensing, et cetera. You probably mean well, Hirochimi, but the way you keep doing this makes it look like malware. I, and probably a lot of people with me, will not be trying this before more information is available. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
- Original Message - From: Hiromichi Watari hiromichiwat...@yahoo.com I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Just like when you posted this a couple of weeks ago :-) Last time I checked, MySQL already uses multiple cores, and the main comments from back then are still standing: no information or documentation whatsoever, no trace of licensing, et cetera. You probably mean well, Hirochimi, but the way you keep doing this makes it look like malware. I, and probably a lot of people with me, will not be trying this before more information is available. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
On 11/05/2012 07:57, Johan De Meersman wrote: - Original Message - From: Hiromichi Watarihiromichiwat...@yahoo.com I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Just like when you posted this a couple of weeks ago :-) Last time I checked, MySQL already uses multiple cores, and the main comments from back then are still standing: no information or documentation whatsoever, no trace of licensing, et cetera. You probably mean well, Hirochimi, but the way you keep doing this makes it look like malware. I, and probably a lot of people with me, will not be trying this before more information is available. Just to add, you must be in a parallel universe, because I cannot find any information about the Incorporation of your company either. -- Best Regards, Giles Coochey, CCNA Security, CCNA NetSecSpec Ltd giles.cooc...@netsecspec.co.uk Tel: +44 (0) 7983 877 438 Live Messenger: gi...@coochey.net http://www.netsecspec.co.uk http://www.coochey.net smime.p7s Description: S/MIME Cryptographic Signature
New Fast MySQL Compatible Server (Take 2)
Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server (Take 2)
Am 10.05.2012 21:16, schrieb Hiromichi Watari: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by the new patent pending technology which utilizes multi core/CPU of server hardware after reading new patent pending technology i can not eat enough as i would ike to spit out Please go to www.paralleluniverse-inc.com to download no, thanks signature.asc Description: OpenPGP digital signature
Re: New Fast MySQL Compatible Server
- Original Message - From: Singer X.J. Wang w...@singerwang.com Perhaps something called a VM can be use? Perhaps something called documentation can be provided? I also notice that the original poster seems to have vanished again, which makes the whole thing even more shady. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Singer X.J. Wang w...@singerwang.com Perhaps something called a VM can be use? Perhaps something called documentation can be provided? I also notice that the original poster seems to have vanished again, which makes the whole thing even more shady. I see this morning that the site says, Pre-release field evaluation will be conducted when licensing is arranged. The link to download the file is no longer there. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server
Perhaps something called a VM can be use? S On Tue, Mar 27, 2012 at 18:12, Mogens Melander mog...@fumlersoft.dk wrote: Guys, really... Is this a binary release? Need to sudo to root? Not on my watch! On Tue, March 27, 2012 16:40, Baron Schwartz wrote: The license of this software is unclear. The binary is clearly derived from the MySQL server with InnoDB, but no source code is provided. Is the software GPL-licensed? If so, where can I get a copy of the source code? - Baron On Tue, Mar 27, 2012 at 10:26 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- Later Mogens Melander -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
New Fast MySQL Compatible Server
Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server
The license of this software is unclear. The binary is clearly derived from the MySQL server with InnoDB, but no source code is provided. Is the software GPL-licensed? If so, where can I get a copy of the source code? - Baron On Tue, Mar 27, 2012 at 10:26 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server
Thanks Baron. I downloaded it and found it was dervied from the MySQL server as well. I was looking for the source and found nothing. Mr. Watari, is there source code available? Since you are using GPL source code in your code, you must provide the source code. S On Tue, Mar 27, 2012 at 10:40, Baron Schwartz ba...@xaprb.com wrote: The license of this software is unclear. The binary is clearly derived from the MySQL server with InnoDB, but no source code is provided. Is the software GPL-licensed? If so, where can I get a copy of the source code? - Baron On Tue, Mar 27, 2012 at 10:26 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
Re: New Fast MySQL Compatible Server
Please elaborate on what conditions your server will/won't process queries in parallel. On 3/27/12 7:26 AM, Hiromichi Watari wrote: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- Rick James - MySQL Geek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: New Fast MySQL Compatible Server
Guys, really... Is this a binary release? Need to sudo to root? Not on my watch! On Tue, March 27, 2012 16:40, Baron Schwartz wrote: The license of this software is unclear. The binary is clearly derived from the MySQL server with InnoDB, but no source code is provided. Is the software GPL-licensed? If so, where can I get a copy of the source code? - Baron On Tue, Mar 27, 2012 at 10:26 AM, Hiromichi Watari hiromichiwat...@yahoo.com wrote: Hi, I created Parallel Universe which is a MySQL 5.5 compatible server with fast query execution. Speed is achieved by processing tables in parallel utilizing multi core/CPU server hardware. Pre-release field evaluation is being conducted and MySQL users are solicited to try out the new server for feedback. Please go to www.paralleluniverse-inc.com to download. Thank you, Hiromichi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Baron Schwartz Win free MySQL conference tickets! http://goo.gl/mvZ4W -- Later Mogens Melander -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
New to MySQL
Hi all, I am Manish from India and i am new to mysql. These are the steps that i had taken: 1. Installed MySQL 4.0.20d-Winit came with a cd in a book i bought. 2. Executed the winmysqladmin file from mysql/bin. gave it a username and password. 3. went to command prompt and the troubles started. Problem 1: when i type show databases, it only gives me one data base: test. i read that it shud give me 2, test and sql. Problem 2: when i want to create database is shows: mysqlcreate database music; ERROR 1044: access denied for user: '@localhost' to database 'music' can someone please help me. thanx
Re: New to MySQL
Manish, Manish Gupta wrote: Hi all, I am Manish from India and i am new to mysql. These are the steps that i had taken: 1. Installed MySQL 4.0.20d-Winit came with a cd in a book i bought. 2. Executed the winmysqladmin file from mysql/bin. gave it a username and password. 3. went to command prompt and the troubles started. Problem 1: when i type show databases, it only gives me one data base: test. i read that it shud give me 2, test and sql. Problem 2: when i want to create database is shows: mysqlcreate database music; ERROR 1044: access denied for user: '@localhost' to database 'music' can someone please help me. do yourself a favor: Do not touch version 4.0.20, just drop it and get something current. MySQL 4.0 is past its end-of-life, you will not get any upgrades (within the 4.0 series) for it. Investing any effort in it is waste, you should immediately get a current version and use it. The candidates are: - Of the 5.0 series: version 5.0.75 - Of the 5.1 series: version 5.1.31 or 5.1.32 All these are available as free downloads via http://dev.mysql.com/downloads/mysql/ As I don't know your book, I can't tell which 4.0-specific instructions it contains that need to be adapted to 5.0 or 5.1, but there will be some. Nonetheless, it should be much easier to use general instructions for 5.0 or 5.1 together with your book, than now do anything based on 4.0 just to realize you then want to upgrade. Also, bear in mind that 5.0 and 5.1 have not only lots of functional improvements over 4.0 but also fixes for several security-related bugs, you do not want to run MySQL without these. Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL University session on December 4: What's new in MySQL optimizer
This Thursday (December 4th), Sergey Petrunia will highlight what's new in MySQL Optimizer, with a focus on MySQL 5.1. Since Sergey is one of the main developers in charge of MySQL Optimizer, you can expect to get some in-depth insights that only very few people could provide. The session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). MySQL University is an educational program run virtually on the 'net. Sessions are open to anyone. MySQL University focuses on MySQL internals and on Sun technology that can be used in connection with MySQL, but we're open to hear your suggestions for other topics. We'll be using the Dimdim conferencing system for this session. Dimdim has integrated voice streaming and chat. To attend, you need a browser with a recent Flash plugin. You may register a Dimdim account but you don't have to. The virtual meeting room will open 15 minutes before the hour. Point your browser to this URL: http://webmeeting.dimdim.com:80/portal/[EMAIL PROTECTED] Related URLs: - MySQL University: http://forge.mysql.com/wiki/MySQL_University - http://forge.mysql.com/wiki/What%27s_New_in_MySQL_Optimizer Here's the MySQL University schedule for the rest of this year. Only two more sessions to go in 2008. All sessions start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow): December 11 - Random Query Generator - Philip Stoev December 18 - Using DTrace with MySQL - MC Brown In January, we'll likely continue with a set of sessions on performance and scalabilty – straight from the Sun QA labs. Find the tentative 2009 schedule on the MySQL University home page. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: [EMAIL PROTECTED] Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm new to mySQL
Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James _ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: I'm new to mySQL
MySQL AB has a very good GUI tools Have a look in: http://www.mysql.com/products/tools/ You should try to use them, phpmyadmin also is good. For administration mysql-administrator To execute queries or create functions, procedures, etc mysql-querybrowser To migrate data from another RMDBS so use mysql-mitration-toolkit Those tools work on MAC Regards! Edwin. -Mensaje original- De: James Lumb [mailto:[EMAIL PROTECTED] Enviado el: Sábado, 24 de Diciembre de 2005 02:06 p.m. Para: mysql@lists.mysql.com Asunto: I'm new to mySQL Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James _ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk -- 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: New to MySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- This e-mail is virii free, it has been sent from a computer running Linux. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I'm new to mySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I'm new to mySQL
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James James, This is just coming from a person who's used MySQL from the commandline, phpMyAdmin, and even from OpenOffice. There's no one right way to access MySQL. Generally speaking, I use the command line for a multiple correction, i.e. if I have to fix a syntax difference on a non-normalized table, or for testing. I use phpMyAdmin for administration purposes (new users and so forth), and OpenOffice for actual data entry. You'll find that is the beauty of MySQL. There are hundreds of ways to access data, and each one has its ups and downs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
--- Kishore Jalleda [EMAIL PROTECTED] wrote: check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda I agree with Kishore, to elaborate his answer a little longer I would ask the following. - is the hardware all ok? - You said you created the table before, so u must had have access to the directories from the OS prespective, did you use the same method to connect to the server at the time of creation and at the time to alter it? - did u alter the tablespaces location? the configuration files? I am not 100% familiar with the Windows OS but I would expect the full path to the files not a relative one in the error message. - can u select anything from the different tables? - did you use the same userid, passsword and connection method to create the database and to try to alter it? Enrique Sanchez Vela email: [EMAIL PROTECTED] - It's often easier to fight for one's ||We live in the outer space principles than to live up to them||Rev. Kay Greenleaf Adlai Stevenson || __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
ps, I meant to delete the note from my draft folder... sorry Enrique Sanchez. Enrique Sanchez Vela email: [EMAIL PROTECTED] - It's often easier to fight for one's ||We live in the outer space principles than to live up to them||Rev. Kay Greenleaf Adlai Stevenson || __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: need help with foreign keys, new to mysql
Sorry for not replying as quickly as I usually do, I ran into some other server issues. Please take a look at my comments to your post. -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 11:11 PM Cc: John Gonzales; mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Sorry to reply to my own message, but I meant to add that you can read about defining foreign key constrints in the manual http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html. [jg.] thanks, this is what I originally based my command off of. Michael Michael Stassen wrote: There are a few possibilities here: 1. Both tables must be InnoDb. I can see table comments is InnoDb. Is table journal InnoDb? [jg.] yes both tables are innodb 2. Both ends of the foreign key must be the leftmost column in an index. I can see an index on comments.journal_id. Does column journal_id come first in an index in table journal? [jg.] I don't quite understand what you mean by leftmost column in an index, but yes journal_id is the first field in table journal, but that's probably not what you meant. Take a look at the result from SHOW CREATE TABLE: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, `journal_category` int(10) unsigned NOT NULL default '1', `journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP, `journal_datetime_modified` timestamp NOT NULL default '-00-00 00:00:00', `journal_title` varchar(50) NOT NULL default 'no title', `journal_entry` blob NOT NULL, PRIMARY KEY (`journal_category`), KEY `journal_category` (`journal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 3. You are misplacing your parentheses. MySQL looks at parenthesis placement to help distinguish between functions and non-function identifiers. In general, when there is no space between a word and a left parenthesis, '(', the word is a function name, but when there is a space in between, the word is not a function. Hence, journal( journal_id ) would be journal_id as input to the function journal(), where journal (journal_id) is what you want. Now, the parser may be smart enough to notice there is no function journal(), so this may not be a problem here, but it still something to be aware of, lest it bite you later. You could check on the first two with a simple SHOW CREATE TABLE journal; You could fix #3 by changing the CREATE TABLE statement for comments: CREATE TABLE comments ( comment_id INT, journal_id INT, INDEX jrn_ind (journal_id), FOREIGN KEY (journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB [jg.] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), FOREIGN KEY (comment_journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB; I got this as a respsone: Key column 'journal_id' doesn't exist in table Michael -- 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: need help with foreign keys, new to mysql
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, `journal_category` int(10) unsigned NOT NULL default '1', `journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP, `journal_datetime_modified` timestamp NOT NULL default '-00-00 00:00:00', `journal_title` varchar(50) NOT NULL default 'no title', `journal_entry` blob NOT NULL, PRIMARY KEY (`journal_category`), KEY `journal_category` (`journal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 [jg.] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), FOREIGN KEY (comment_journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB; I got this as a respsone: Key column 'journal_id' doesn't exist in table From the manual: http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. You've got an INT in comments table and an int(10) unsigned in the journal table. They need to match in signedness. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
Re: need help with foreign keys, new to mysql
Pat Adams wrote: On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, [snip] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), Here you are defining an index named jrn_id on a column called journal_id. This column must be defined in this table. I suppose it is a mistake, it should be: INDEX jrn_id (comment_journal_id), FOREIGN KEY (comment_journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB; I got this as a respsone: Key column 'journal_id' doesn't exist in table See above. From the manual: http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. You've got an INT in comments table and an int(10) unsigned in the journal table. They need to match in signedness. I don't dispute this, but it was not the reason for the error message. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: need help with foreign keys, new to mysql
Wow, thanks both of you. It worked... =) -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: August 24, 2005 9:17 AM To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: Re: need help with foreign keys, new to mysql Pat Adams wrote: On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, [snip] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), Here you are defining an index named jrn_id on a column called journal_id. This column must be defined in this table. I suppose it is a mistake, it should be: INDEX jrn_id (comment_journal_id), FOREIGN KEY (comment_journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB; I got this as a respsone: Key column 'journal_id' doesn't exist in table See above. From the manual: http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. You've got an INT in comments table and an int(10) unsigned in the journal table. They need to match in signedness. I don't dispute this, but it was not the reason for the error message. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: need help with foreign keys, new to mysql
i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales [EMAIL PROTECTED] wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
Yes but is the MySQL daemon running as root? I hope it isn't... Jasper John Gonzales wrote: i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales [EMAIL PROTECTED] wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. -- 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: need help with foreign keys, new to mysql
honestly... i don't even know. =( i'm new to mysql... how would i check? -jg -Original Message- From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 2:18 AM To: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Yes but is the MySQL daemon running as root? I hope it isn't... Jasper John Gonzales wrote: i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales [EMAIL PROTECTED] wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit : Hi John, #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) I've seen this error before. now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. You haven't by any chance deleted or moved your *.idb files by any chance ? If you do that, then you screw up the indexes that InnoDB needs to access the tables. This has happened to me previously when I changed from MySQL-Max to mysql standard versions, and on another occasion when I deleted the idb files because I didn't know what they were and why they were so big compared to the data I actually had in my tables. Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: need help with foreign keys, new to mysql
Hey Alex, Although I am not too sure what *.idb files are, I looked in the directory that I designated to store the InnoDB files and found the directory empty. Could this be it? I don't recall though ever deleting files from that directory. How did you go about fixing this problem? -jg. -Original Message- From: Thurgood Alex [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 3:22 AM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit : Hi John, #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) I've seen this error before. now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. You haven't by any chance deleted or moved your *.idb files by any chance ? If you do that, then you screw up the indexes that InnoDB needs to access the tables. This has happened to me previously when I changed from MySQL-Max to mysql standard versions, and on another occasion when I deleted the idb files because I didn't know what they were and why they were so big compared to the data I actually had in my tables. Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
John Gonzales wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) You can look up what error numbers mean with perror: ~: perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. There are a few possibilities here: 1. Both tables must be InnoDb. I can see table comments is InnoDb. Is table journal InnoDb? 2. Both ends of the foreign key must be the leftmost column in an index. I can see an index on comments.journal_id. Does column journal_id come first in an index in table journal? 3. You are misplacing your parentheses. MySQL looks at parenthesis placement to help distinguish between functions and non-function identifiers. In general, when there is no space between a word and a left parenthesis, '(', the word is a function name, but when there is a space in between, the word is not a function. Hence, journal( journal_id ) would be journal_id as input to the function journal(), where journal (journal_id) is what you want. Now, the parser may be smart enough to notice there is no function journal(), so this may not be a problem here, but it still something to be aware of, lest it bite you later. You could check on the first two with a simple SHOW CREATE TABLE journal; You could fix #3 by changing the CREATE TABLE statement for comments: CREATE TABLE comments ( comment_id INT, journal_id INT, INDEX jrn_ind (journal_id), FOREIGN KEY (journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
Sorry to reply to my own message, but I meant to add that you can read about defining foreign key constrints in the manual http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html. Michael Michael Stassen wrote: There are a few possibilities here: 1. Both tables must be InnoDb. I can see table comments is InnoDb. Is table journal InnoDb? 2. Both ends of the foreign key must be the leftmost column in an index. I can see an index on comments.journal_id. Does column journal_id come first in an index in table journal? 3. You are misplacing your parentheses. MySQL looks at parenthesis placement to help distinguish between functions and non-function identifiers. In general, when there is no space between a word and a left parenthesis, '(', the word is a function name, but when there is a space in between, the word is not a function. Hence, journal( journal_id ) would be journal_id as input to the function journal(), where journal (journal_id) is what you want. Now, the parser may be smart enough to notice there is no function journal(), so this may not be a problem here, but it still something to be aware of, lest it bite you later. You could check on the first two with a simple SHOW CREATE TABLE journal; You could fix #3 by changing the CREATE TABLE statement for comments: CREATE TABLE comments ( comment_id INT, journal_id INT, INDEX jrn_ind (journal_id), FOREIGN KEY (journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need help with foreign keys, new to mysql
i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with foreign keys, new to mysql
check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales [EMAIL PROTECTED] wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) i orginally created the comments table before i read about FOREIGN KEYS, so i tried executing the following command: ALTER TABLE comments ADD FOREIGN KEY(comment_journal_id) REFERENCES journal(journal_id) ON DELETE CASCADE ON UPDATE CASCADE; which resulted with the same error as listed above. so not really knowing what i was doing, i decided to try and create the comments table from scratch using the following the command thinking that it might work (which it didn't): CREATE TABLE comments( comment_id INT, journal_id INT, INDEX jrn_ind( journal_id ) , FOREIGN KEY ( journal_id ) REFERENCES journal( journal_id ) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB now before i go and do something stupid, i thought i might ask for some help on this issue :D both my blog and comments tables are InnoDB. -- 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: New to MySQL on Linux
Thanks, Joshua - just the sort of info I needed. Off to find a more recent distro Cheers Terry - Original Message - On Friday 11 February 2005 09:15, Terry Riley said something like: Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and install my first Linux instead, using an ancient RedHat 7.3 distribution. First suggestion: get something recent: Suse 9.2, Mandrake 10.1, Fedora Core 3, the latest Debian. A distro that old will have major security (and probably usability issues). Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). I would doubt the current MySQL RPM's would support something as old as RH 7.3. If you install something recent, there will be recent versions of MySQL (Mandrake even has 5.0 in the contrib section, I would assume Fedora would too. You will have to intstall the server portion, and probably the client portion. You then can use the MySQL GUI tools to admin the box from a Windows machine. Using something like Mandrake or Fedora, their installer tools will resolve all the dependencies for you. Hope that gets you started a little. If you need more detail, feel free to ask. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- 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]
New to MySQL on Linux
Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and install my first Linux instead, using an ancient RedHat 7.3 distribution. Having done that successfully, and increased the memory from 256 to 768Mb, I think I'm now ready to install the latest MySQL on it. All my previous MySQL experience, unfortunatley, has been on WinNT, usually installed with the msi installer. Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Suggestions, please? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL on Linux
On Fri February 11 2005 19:15, Terry Riley wrote: Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Well you should know that you can just install MySQL from withing your install cd. (at least with RH-9). If not, I recommend you use the RH update utility. up2date (requires root privileges) and then just choose MySQL from the list of items. Then installing it is as simple as clicking finish. Good luck and kind regards PS: if you prefer commandline utilities, you might interest yourself in apt-get See www.apt-get.org (it says it's for debian but I use it for my Fedora Core which is RedHat anyway) Once you've installed it, installing any package is as simple as typing (example for mysql) apt-get install mysql it will download the packages and perform the installation (note: root privileges required) Andy -- --- Registered Linux user number 379093 --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL on Linux
Terry Riley wrote: install my first Linux instead, using an ancient RedHat 7.3 distribution. Having done that successfully, and increased the memory from 256 to 768Mb, I think I'm now ready to install the latest MySQL on it. All my previous MySQL experience, unfortunatley, has been on WinNT, usually installed with the msi installer. Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Personally, I hate installers, so I'd get the non-rpm Linux distro. Unzip/untar and you have a nice self-contained directory, so *you* know where everything is, in case you want to de-install, install a later version in parallel, etc. And as it happens, that's at the very top of the list on the MySQL downloads page :-) Linux (x86, glibc-2.2, static, gcc) Standard 4.1.9 26.9M HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to MySQL on Linux
I'd have to agree with Hassan here, with MySQL having the binaries built, it's quite easy if you can set PATHs and make some symbolic links (for service mysql start to work). Michael -Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 2:31 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: New to MySQL on Linux Terry Riley wrote: install my first Linux instead, using an ancient RedHat 7.3 distribution. Having done that successfully, and increased the memory from 256 to 768Mb, I think I'm now ready to install the latest MySQL on it. All my previous MySQL experience, unfortunatley, has been on WinNT, usually installed with the msi installer. Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Personally, I hate installers, so I'd get the non-rpm Linux distro. Unzip/untar and you have a nice self-contained directory, so *you* know where everything is, in case you want to de-install, install a later version in parallel, etc. And as it happens, that's at the very top of the list on the MySQL downloads page :-) Linux (x86, glibc-2.2, static, gcc) Standard 4.1.9 26.9M HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- 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: New to MySQL on Linux
Thanks to all who replied - food for thought... Cheers Terry - Original Message - Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and install my first Linux instead, using an ancient RedHat 7.3 distribution. Having done that successfully, and increased the memory from 256 to 768Mb, I think I'm now ready to install the latest MySQL on it. All my previous MySQL experience, unfortunatley, has been on WinNT, usually installed with the msi installer. Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). Suggestions, please? Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL on Linux
On Friday 11 February 2005 09:15, Terry Riley said something like: Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and install my first Linux instead, using an ancient RedHat 7.3 distribution. First suggestion: get something recent: Suse 9.2, Mandrake 10.1, Fedora Core 3, the latest Debian. A distro that old will have major security (and probably usability issues). Now the question: If I'm only using this as a database (no development) on RH7.3, which is the preferred download? I am confused by the plethora of options available for Linux. Just need something that is relatively simple to install (either 4.1.9 or 5.0.x). I would doubt the current MySQL RPM's would support something as old as RH 7.3. If you install something recent, there will be recent versions of MySQL (Mandrake even has 5.0 in the contrib section, I would assume Fedora would too. You will have to intstall the server portion, and probably the client portion. You then can use the MySQL GUI tools to admin the box from a Windows machine. Using something like Mandrake or Fedora, their installer tools will resolve all the dependencies for you. Hope that gets you started a little. If you need more detail, feel free to ask. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- 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]
New to MySQL
I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to MySQL
Hi To use phpMyAdmin you need a webserver and php installed - the code suggests you either are not running through a webserver or that it is not configured for php. If you are not developing for php you might take a look at windows front ends for mysql - search the list for recommendations HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 10:25 To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- 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: New to MySQL
Why don't you try MySQLCC from the MySQL site? -Original Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 4:25 AM To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to MySQL
Thanks for the reply. I will have a look at MySQLCC. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 13:30 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: New to MySQL Why don't you try MySQLCC from the MySQL site? -Original Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 4:25 AM To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- 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: New to MySQL
Thanks Peter, Will try out XAMPP. Regards -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 10:50 To: Terry Smith; [EMAIL PROTECTED] Subject: RE: New to MySQL Hi To use phpMyAdmin you need a webserver and php installed - the code suggests you either are not running through a webserver or that it is not configured for php. If you are not developing for php you might take a look at windows front ends for mysql - search the list for recommendations HTH Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: 17 March 2004 10:25 To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- 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]
New to MySQL
wow, nice product. Pretty easy to use and install - I like it. I know enough about SQL and databases to just about break any flavor of them I put my hand on ;-). A couple of pointers would be great. I'm creating a handfull of tables that will inter-depend on eachother, using it within php. I have three basic questions: 1. Some of the tables have a unique ID, each new record should get the next number available. Is there an easy data type that will do this for me, or do I need to get a record count myself and use record count + 1 when I insert a new row? 2. Some of the tables will need a timestamp of the exact date/time the record was added. Does timestamp do this, or again do I need to get time( ) and use that value on the insert myself? 3. Some of the IDs from one table are used in another table, for example I have an accounts table and a sites table. Each account can have several sites, and each site entry has an account field that has the account ID (from question 1) to tell who the account owner is. Isn't there a joint query that I can run that is like 'SELECT * FROM `sites` WHERE `AccountID` = ( SELECT `ID` FROM `accounts` WHERE `Name` = 'First Last' )'??? Or do I need to run the inner select and get the ID myself, then run the outer select? I admit, I know just enough SQL to wipe the database and drop all the tables ;-), so any help would be greatly apreciate. Thanks! /dev/null -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL
Some answers within your message. I would suggest you to browse the reference manual. Bernard On Thursday 05 February 2004 17:27, /dev/null wrote: wow, nice product. Pretty easy to use and install - I like it. I know enough about SQL and databases to just about break any flavor of them I put my hand on ;-). A couple of pointers would be great. I'm creating a handfull of tables that will inter-depend on eachother, using it within php. I have three basic questions: 1. Some of the tables have a unique ID, each new record should get the next number available. Is there an easy data type that will do this for me, or do I need to get a record count myself and use record count + 1 when I insert a new row? You can use an AUTO_INCREMENT column See URL: http://www.mysql.com/doc/en/CREATE_TABLE.html for an explaination 2. Some of the tables will need a timestamp of the exact date/time the record was added. Does timestamp do this, or again do I need to get time( ) and use that value on the insert myself? I would suggest a DATETIME type and use now() when inserting new record. 3. Some of the IDs from one table are used in another table, for example I have an accounts table and a sites table. Each account can have several sites, and each site entry has an account field that has the account ID (from question 1) to tell who the account owner is. Isn't there a joint query that I can run that is like 'SELECT * FROM `sites` WHERE `AccountID` = ( SELECT `ID` FROM `accounts` WHERE `Name` = 'First Last' )'??? Or do I need to run the inner select and get the ID myself, then run the outer select? I admit, I know just enough SQL to wipe the database and drop all the tables ;-), so any help would be greatly apreciate. You want to establish a REFERENCE. Look at the same URL as above for information. Thanks! /dev/null -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL
- Original Message - From: /dev/null [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 05, 2004 11:27 PM Subject: New to MySQL wow, nice product. Pretty easy to use and install - I like it. I know enough about SQL and databases to just about break any flavor of them I put my hand on ;-). A couple of pointers would be great. I'm creating a handfull of tables that will inter-depend on eachother, using it within php. I have three basic questions: 1. Some of the tables have a unique ID, each new record should get the next number available. Is there an easy data type that will do this for me, or do I need to get a record count myself and use record count + 1 when I insert a new row? CREATE TABLE `pricelist` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `PRICE` float NOT NULL default '0', PRIMARY KEY (`ID`) ); The column ID will be automaticly incemented. You just write INSERT INTO pricelist (`NAME`,`PRICE` ) VALUES ('coffee',200); To get the ID of inserted record you just call mysql_insert_id() (in MYSQL API, in another just find similar function;) or call SELECT LAST_INSERT_ID(); 2. Some of the tables will need a timestamp of the exact date/time the record was added. Does timestamp do this, or again do I need to get time( ) and use that value on the insert myself? You can use TIMESTAMP data type. If you update the row with NULL for the TIMESTAMP field it will enter the current date and time. If you omit this column in INSERT statement, it will alos enter the current date and time. 3. Some of the IDs from one table are used in another table, for example I have an accounts table and a sites table. Each account can have several sites, and each site entry has an account field that has the account ID (from question 1) to tell who the account owner is. Isn't there a joint query that I can run that is like 'SELECT * FROM `sites` WHERE `AccountID` = ( SELECT `ID` FROM `accounts` WHERE `Name` = 'First Last' )'??? Or do I need to run the inner select and get the ID myself, then run the outer select? I admit, I know just enough SQL to wipe the database and drop all the tables ;-), so any help would be greatly apreciate. MySQL before versions 4.1 doesn't support subqueries (you sample works on 4.1 or greater). But you can write standart SQL joins. Some samples: SELECT sites.* FROM `sites`,`accounts` WHERE `sites`.`AccountID` =`accounts`.`ID` AND `accounts`.`Name` = 'First Last'; also this is possible: SELECT sites.* FROM `sites` INNER JOIN `accounts` ON (`sites`.`AccountID` =`accounts`.`ID`) WHERE `accounts`.`Name` = 'First Last'; when you need something like NOT IN (SELECT FROM ... WHERE) you can write this: mysql SELECT table1.* FROM table1 -LEFT JOIN table2 ON table1.id=table2.id -WHERE table2.id IS NULL; This example finds all rows in `table1' with an `id' value that is not present in `table2' (that is, all rows in `table1' with no corresponding row in `table2'). This assumes that `table2.id' is declared `NOT NULL', of course. *Note LEFT JOIN optimisation::. If there is no matching record for the right table in the `ON' or `USING' part in a `LEFT JOIN', a row with all columns set to `NULL' is used for the right table. You can use this fact to find records in a table that have no counterpart in another table: Thanks! /dev/null -- 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]
New To MySQL Connector J
Hi I am new to MySQL connector J. I do not know how to install it. I just downloaded the .zip file and I am using XP Home. I want to use it with tomcat which is already running OK. I need someone to help me how to install it and connect to MySQL which is also installed and working fine. Thank you. -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail)
New combined MySql and Html development platform
This site: http://www.everydaysoftware.biz Has a complete MySql and Html development environment running on the browser site itself, with debug, edit, run capability. To gain access to the development environment, click Develop on the left from of the opening page. The environment is written in URL code, called Uscript, which allows general intermixing of sql, html, and javascript syntax in a single script. The scripts are stored in Mysql which combines the functionality of a file directory and database. The entire application at http://www.everydaysoftware.biz includes demos of paging anchors, banners, paypal, database discovery and automatic generation of database function anchors, a help system (still developing), password, login, and a development environment. All written in the same coding that is used for URLs. The Uscript engine is less than 2,000 lines of c code. To gain access to the development environment, click Develop on the left from of the opening page. Matt Young Everyday Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (ANNOUNCE) New PHP MySQL Web Log Site
Does anyone know of similar site for Perl and MySQL ? On Friday, Oct 17, 2003, at 23:10 Europe/Brussels, Boaz Yahav wrote: Hello Just wanted to let anyone interested that after almost 6 years, http://www.weberdev.com now has a new brother (sister?) site called http://www.weberblog.com. This new site is a community site, where matters related to PHP MySQL are discussed. There are already a few interesting blogs and more will begin in the next few days. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(ANNOUNCE) New PHP MySQL Web Log Site
Hello Just wanted to let anyone interested that after almost 6 years, http://www.weberdev.com now has a new brother (sister?) site called http://www.weberblog.com. This new site is a community site, where matters related to PHP MySQL are discussed. There are already a few interesting blogs and more will begin in the next few days. I Hope you find the site helpful and would love to see you there adding your thoughts. I would appreciate any comments, suggestions you may have. It's a new site so be easy on me :) Sincerely berber Visit http://www.weberdev.com/ http://www.weberblog.com/ Today!!! To see where PHP might take you tomorrow. Share your code : http://addexample.weberdev.com Search for PHP Code from your browser http://toolbar.weberdev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Completely new to mySQL
Hi list, I have a few questions. I have to start a new project and I have to choose the db. The most difficult choice of all. My question is : could mySQL be used as a enterprise database with approx. 50 users connecting to db ? The db is financial critical, so everything should happen in the context of a transaction. Is mySQL most used as webdb ? Or could it be used as well to serve as a enterprise db ? And the second question is : is there a performance drop when used on Win32 ? Many thanks in advance, Nico Callewaert
New to MySQL, Suggestions welcome!
Dear All. I hope all is well with you. A projects requires that for the 1st time ever for me, install a bugzilla system with MySQL and Apache IWhat would you recommend when it comes to installing, designing, or tips about My SQL? perhaps stuff I should know no matter what. I am reading on information about MySQL and so far, I;m getting the picture of it all, however, would appreciate some feedback from the real world experiences or what to do and not to do, etc. Thanks in advance! Mike - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
New to Mysql
I am so new to mysql that I only know it can be used to as a database linked to WebPages via perl. This is what I want to do with. I have had such experience with asp. What are some good web tutorials to teach me installation and the basics of mysql adding perl is always a bonus. Make it a great day! Ben Ferderer System Administrator Radio TV Equipment [EMAIL PROTECTED] 800.288.9134
Re: New to Mysql
I only know good references: the manual: http://www.mysql.com/documentation/index.html the Bible: MySQL by Paul Dubois ;) for the access to mysql from webpages, you'll need to use perl dbi and acquire some notions about how CGI works Wavyx Ben Ferderer wrote: I am so new to mysql that I only know it can be used to as a database linked to WebPages via perl. This is what I want to do with. I have had such experience with asp. What are some good web tutorials to teach me installation and the basics of mysql adding perl is always a bonus. Make it a great day! Ben Ferderer System Administrator Radio TV Equipment [EMAIL PROTECTED] 800.288.9134 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to Mysql
Ben, You can also access MySQL databases from PHP, FYI. I've learned a lot from the book: PHP and MySQL Web Development By Luke Welling Laura Thomson ISBN: 0-672-31784-2 Hope that helps! Len -- Len French Technical Applications Specialist Lutron Electronics, Inc. [EMAIL PROTECTED] 1-800-523-9466 Ben Ferderer [EMAIL PROTECTED] 6/27/03 2:46:15 PM I am so new to mysql that I only know it can be used to as a database linked to WebPages via perl. This is what I want to do with. I have had such experience with asp. What are some good web tutorials to teach me installation and the basics of mysql adding perl is always a bonus. Make it a great day! Ben Ferderer System Administrator Radio TV Equipment [EMAIL PROTECTED] 800.288.9134
Re: New to Mysql
I'll second the recommendation of Welling Thomson's book. It's a great starter with numerous real-world examples, and it includes a CD of all the source code, which all decent books do. I find that I've generally outgrown it already, but they always told me I was a fast learner! Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU - Original Message - From: Leonard French [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, 27 June, 2003 16:56 Subject: Re: New to Mysql Ben, You can also access MySQL databases from PHP, FYI. I've learned a lot from the book: PHP and MySQL Web Development By Luke Welling Laura Thomson ISBN: 0-672-31784-2 Hope that helps! Len -- Len French Technical Applications Specialist Lutron Electronics, Inc. [EMAIL PROTECTED] 1-800-523-9466 Ben Ferderer [EMAIL PROTECTED] 6/27/03 2:46:15 PM I am so new to mysql that I only know it can be used to as a database linked to WebPages via perl. This is what I want to do with. I have had such experience with asp. What are some good web tutorials to teach me installation and the basics of mysql adding perl is always a bonus. Make it a great day! Ben Ferderer System Administrator Radio TV Equipment [EMAIL PROTECTED] 800.288.9134 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New to MySQL/PHP with Rank-Amateur Questions
I'm brand-new to MySQL/PHP and to this list, spending an interesting holiday weekend devoted to trying to start learning the MySQL/PHP/Apached axis. There're three things that had me thinking of just giving it all up. But after a night's sleep I can't deny still wanting to learn how to design and lay out database-driven websites. But three problems prevent me from getting into the meat of some really great tutorials I found ... 1) I have administrator rights on the G3 PowerBook on which I'm doing this learning. But that's not the same as MySQL recognizing me with administrator acces, is it? How can I make MySQL give me administrator access, so I can have permission to issue CREATE [and ALL other] commands. As it is now, when I try to create a table from the Terminal window--and I've decided I DO want to be able to do this in the Terminal also, not just thru a GUI--an error message appears, saying that access is denied. 2) If I create a table in phpMyAdmin, how do I plant it in, say, Dreamweaver--or, really, code it into the HTML Dreamweaver creates--so the table can be accessed, as part of a web page, from a browser? 3) I got to the end of November 2002 Macworld magazine's Serve It Up article, to the sidebar A Jump Start. I downloaded MacUser's .sit file for the 'start application' mentioned, unpacked it all, and put its folder in my SItes folder. I called it up thru my browse--using http://localhost/stephent/contacts/index.php--and was presented with a login page. I put in the username MySQL knows me by and a box drops down with 'Select a username' and three options: 'root', the one I'd put in, and a third name I use in my email address stiano. Whichever I choose, the password I use with each of them, specified earlier in MySQL, is put in the second field on the login page. I press the 'Log in' button, and a Netscape alert appears. It says: The information you have entered is to be sent over an unencryoted connection and could easily be read by a third party. Are you sure you want to continue sending this information? and a third line where I can check off to be alerted any time I submit unencrypted info. Plus two buttons. If I choose the default 'Continue', the process begins again, the box dropping with the three choices of user name. The only way to get out of this maddening circle is to choose 'Cancel', which of course just leaves me sitting on the login page without being logged in, and with the sample database nowhere to be seen. These three issues addressed, I'd be happy as a clam and moving on. Thanks, Steve Tiano - 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: New to MySQL/PHP with Rank-Amateur Questions
1) I have administrator rights on the G3 PowerBook on which I'm doing this learning. But that's not the same as MySQL recognizing me with administrator acces, is it? How can I make MySQL give me administrator access, so I can have permission to issue CREATE [and ALL other] commands. As it is now, when I try to create a table from the Terminal window--and I've decided I DO want to be able to do this in the Terminal also, not just thru a GUI--an error message appears, saying that access is denied. you need to be root something like: mysql -u root 2) If I create a table in phpMyAdmin, how do I plant it in, say, Dreamweaver--or, really, code it into the HTML Dreamweaver creates--so the table can be accessed, as part of a web page, from a browser? you need to write some php or perl to get the data from mysql - ive no idea about doing this in dreamweaver - do it by hand! ;) 3) I got to the end of November 2002 Macworld magazine's Serve It Up article, to the sidebar A Jump Start. I downloaded MacUser's .sit file... Mac? whats that.. ive never even heard of a .sit file -- --- === --- ::: ::: ::: ::: :::=== :::=== --- ::: === ::: :: === :: === === ::: === === --- === === === = === === === --- === === === === === === === === --- === === == === === www.dunkfordyce.co.uk== - 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: New to MySQL/PHP with Rank-Amateur Questions
Hello. On Mon 2003-01-20 at 09:26:18 -0500, [EMAIL PROTECTED] wrote: I'm brand-new to MySQL/PHP and to this list, spending an interesting holiday weekend devoted to trying to start learning the MySQL/PHP/Apached axis. There're three things that had me thinking of just giving it all up. But after a night's sleep I can't deny still wanting to learn how to design and lay out database-driven websites. But three problems prevent me from getting into the meat of some really great tutorials I found ... 1) I have administrator rights on the G3 PowerBook on which I'm doing this learning. But that's not the same as MySQL recognizing me with administrator acces, is it? Correct. Operating system users have nothing in common with users known to MySQL. The default administrator account for MySQL is called root and has an empty password in the default install, usually. How can I make MySQL give me administrator access, so I can have permission to issue CREATE [and ALL other] commands. As it is now, when I try to create a table from the Terminal window--and I've decided I DO want to be able to do this in the Terminal also, not just thru a GUI--an error message appears, saying that access is denied. As other already pointed out, you have to tell MySQL which user you want to log in as. If you don't do so, it will try to use the name with which you authenticated to your OS, which is not what you want in this case. Use somthing like mysqladmin -uroot create your_database 2) If I create a table in phpMyAdmin, how do I plant it in, say, Dreamweaver--or, really, code it into the HTML Dreamweaver creates--so the table can be accessed, as part of a web page, from a browser? You need some in-the-middle application that does the work. HTML is a language to describe pages, not a programming language. MySQL is a database, it knows nothing about webpages. You want to use a programming language to read the data from MySQL and create the HTML from the data you just read. Some well known are Coldfusion, ASP, PHP, and so on. Or you can use a general purpose programming language like Perl, C++, Java. If you have no preference already, I suggest using PHP. 3) I got to the end of November 2002 Macworld magazine's Serve It Up article, to the sidebar A Jump Start. I downloaded MacUser's .sit file for the 'start application' mentioned, unpacked it all, and put its folder in my SItes folder. I called it up thru my browse--using http://localhost/stephent/contacts/index.php--and was presented with a login page. I put in the username MySQL knows me by and a box drops down with 'Select a username' and three options: 'root', the one I'd put in, and a third name I use in my email address stiano. Whichever I choose, the password I use with each of them, specified earlier in MySQL, is put in the second field on the login page. I press the 'Log in' button, and a Netscape alert appears. It says: The information you have entered is to be sent over an unencryoted connection and could easily be read by a third party. Are you sure you want to continue sending this information? and a third line where I can check off to be alerted any time I submit unencrypted info. Even if it might be obvious, just to be sure: This message has nothing to do with your problem, but will appear any time you fill in a formular. It is just a note to make you aware that the data transmission is kind of unsafe. Plus two buttons. If I choose the default 'Continue', the process begins again, the box dropping with the three choices of user name. If it simply appears again, it means either the username or the password you entered is invalid. The only way to get out of this maddening circle is to choose 'Cancel', which of course just leaves me sitting on the login page without being logged in, and with the sample database nowhere to be seen. I think the problem is that you try the authentication data for MySQL, but you are accessing a web page. It is rather unusual that a web page would require the password for the database directly, except for pages that are meant to work on the database layout (like phpMyAdmin). Have a look if the article you mentioned doesn't list some test account or something like that. HTH, Benjamin. -- [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: I'm new in Mysql
Hi Beogradjanin As Paul mentioned yesterday, the final column defination does not require a comma because it is the final defination. Bhavin. - Original Message - From: Beogradjanin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:38 PM Subject: I'm new in Mysql Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin 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 - 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: I'm new in Mysql
On Mon, 6 Jan 2003, Beogradjanin wrote: Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; The last line of your table creation comments text null, does NOT need a comma. Drop that and you should be fine. -- Kip Turk, RHCE [EMAIL PROTECTED] Systems Administrator/Killer of Spam/Writer of Code/Penguin Proponent West Central Net - tel: 915.234.5678 / 800.695.9016 fax: 915.656.0071 -.-. --- -.. . / -- --- -. -.- . -.-- --..-- / .- -.-. -.- . .-. - 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: I'm new in Mysql
Please see last line comments text null, I do not believe you need the ',' between the End of statement and the ')' Try this: create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null ) ; Regards, Chuck http://68.43.100.7:81/aa8vs == Patriotism is the willingness to kill and be killed for trivial reasons. - Bertran Russell -Original Message- From: Beogradjanin [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:39 PM To: [EMAIL PROTECTED] Subject: I'm new in Mysql Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin 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 - 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
I'm new in Mysql
Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin 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: I'm new in Mysql
At 16:38 -0800 1/6/03, Beogradjanin wrote: Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql create table guestbook - ( - name varchar( 40 ) null, - location varchar( 40 ) null, - email varchar( 40 ) null, - url varchar( 40 ) null, - comments text null, No comma here, it's the final column in the definition. - ) - ; ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql Whats wrong here -- Best regards, Beogradjanin 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
New to MySQL, ported from MS Access. Using ASP MyODBC - UPDATE problem...
Hi, I've recently made the move over from Access to MySQL. So far, everything has been fine. I'm using: Win2K server (ASP) WinMySQLadmin 1.4, MyCC 0.8.4-alpha, MyODBC 3.51 and MySQL 3.23.51-nt First problem: (fixed) -- I had used some keywords as table names, but SQL in a Nutshell by O'Reilly put me on the straight track. Second problem: (also fixed) Then I had problems using this line: % If MyRS.recordcount 0 Then %... I discovered that under ASP, the recordcount is -1, so I worked around this by using the following line: % If MyRS.EOF = False Then %. All was fine, and exporting data straight from Access2000 into MySQL was easy. I then found one bizarre problem: Third Problem: (Circumvented) - I could edit any old record set - originally created on Access, but not newly created ones! Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Query-based update failed because the row to update could not be found. I spent quite some time looking for information on how to fix this, and drew a blank. I can display all the info from the new record set, but I can't update it... ..that is until I tried a different way to update it: Old way: 1) Open connection (sql=select * from mytablename where UserID = '1') 2) MyRS(UserName) = New Value 3) MyRS.Update '-- Error occurred at this line 4) MyRS.Close New way: 1) Open connection with update directly in sql statement: (sql=UPDATE mytablename SET UserName = 'New Value' WHERE UserID = '1') So... here's my questions to you knowledgeable lot: a) Why did the second method work, and not the first? - is this a MyODBC bug? b) Why is this only happening to NEW rows in the database? - is it a MyODBC bug? c) could I gain/fix anything by changing over to MySQL 4 ? d) how do YOU normally update MySQL records from within ASP? Many thanks for any insight. As I said, I've made it work, so I'm not too troubled, but I would like to code things in the 'standard' way. Luis. - 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: New to MySQL, ported from MS Access. Using ASP MyODBC - UPDATEproblem...
Luis Sanches wrote: Hi, I've recently made the move over from Access to MySQL. So far, everything has been fine. I'm using: Win2K server (ASP) WinMySQLadmin 1.4, MyCC 0.8.4-alpha, MyODBC 3.51 and MySQL 3.23.51-nt First problem: (fixed) -- I had used some keywords as table names, but SQL in a Nutshell by O'Reilly put me on the straight track. Second problem: (also fixed) Then I had problems using this line: % If MyRS.recordcount 0 Then %... I discovered that under ASP, the recordcount is -1, so I worked around this by using the following line: % If MyRS.EOF = False Then %. All was fine, and exporting data straight from Access2000 into MySQL was easy. I then found one bizarre problem: Third Problem: (Circumvented) - I could edit any old record set - originally created on Access, but not newly created ones! Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Query-based update failed because the row to update could not be found. I spent quite some time looking for information on how to fix this, and drew a blank. I can display all the info from the new record set, but I can't update it... ..that is until I tried a different way to update it: Old way: 1) Open connection (sql=select * from mytablename where UserID = '1') 2) MyRS(UserName) = New Value 3) MyRS.Update '-- Error occurred at this line 4) MyRS.Close New way: 1) Open connection with update directly in sql statement: (sql=UPDATE mytablename SET UserName = 'New Value' WHERE UserID = '1') So... here's my questions to you knowledgeable lot: a) Why did the second method work, and not the first? - is this a MyODBC bug? b) Why is this only happening to NEW rows in the database? - is it a MyODBC bug? c) could I gain/fix anything by changing over to MySQL 4 ? d) how do YOU normally update MySQL records from within ASP? Many thanks for any insight. As I said, I've made it work, so I'm not too troubled, but I would like to code things in the 'standard' way. You just need a correct OPTION value passed to the connect string or setting them in the DSN configuration. Check the following code, which has .update, .addnew and .delete methods from ADO: http://www.mysql.com/products/myodbc/manual.html#MyODBC_With_VB -- Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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