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*
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
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
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
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
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
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: 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]
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]
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]
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]
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]
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: 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
re: New to MySql
Mann, Wednesday, September 25, 2002, 10:29:55 PM, you wrote: MJ Hello all, I am brand new to MySql and I wanted to know if you could MJ recommend any books that are a good start on learning the mechanics of MJ MySql. Thanks! Paul DuBois's book MySQL :) It's really a good book. Searchable online manual at: http://www.mysql.com/doc/en/index.html also will help you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Pada Sun, 25 Aug 2002 15:24:43 +0100 Ray Healy (Data Net Services) [EMAIL PROTECTED] menulis : The one thing I cannot get into my head is how can you tell the database that all the days between the start and end dates are booked. Also when people search for a caravan on a specific date and say they want it for 7 day the database/PHP checks to see if the entire period is totally free for them and does not colide with another booking. just do query select count(*) from booking where booking_start = $wanna_book_start_date and booking_end = $wanna_book_start_date and villa_id = something; if the results is not 0 then there is someone book the caravan on that date. -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 66 days, Queries : 356.493 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL
Hello. On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote: Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to answer myself after a day on the web. 1. What is InnoDB? InnoDB is a table type for MySQL. ISAM (obsolete), MyISAM and BDB are other table types currently implemented. A table type determines (some of) the attributes of a table, i.e. how it is physically stored, which features it offers and so on. E.g. Transactions are only supported with InnoDB and BDB, but neither with ISAM or MyISAM. That said, as long you are not sure what you need, don't care. Simply go with MyISAM tables which are the default, until you learn that your needs differ: It is a one-liner to change the table type (ALTER TABLE) at any time, so there is no reason to decide early. 2. Are their direct API's for Apache and MySQL and how reliable are they? I am not sure, if I understand you correctly. If you mean if there is some build-in server-side (Apache) language, which you can use to query the database and create dynamic pages, the answer is No, because that goes against the design concept of Apache. It is an web-server, not a do-it-all. That said, Apache offers the facility to plug in Modules for tasks, and there are some modules readily available for this: The best-known is probably PHP, and I suggest to go with it, if you do not know better. There are also modules for e.g. Perl, Python and so on. If you meant something different, please elaborate. Regards, 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: New to MySQL
Subject: Re: New to MySQL From: Benjamin Pflugmann [EMAIL PROTECTED] === Hello. On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote: Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to answer myself after a day on the web. 1. What is InnoDB? InnoDB is a table type for MySQL. ISAM (obsolete), MyISAM and BDB are other table types currently implemented. A table type determines (some of) the attributes of a table, i.e. how it is physically stored, which features it offers and so on. E.g. Transactions are only supported with InnoDB and BDB, but neither with ISAM or MyISAM. That said, as long you are not sure what you need, don't care. Simply go with MyISAM tables which are the default, until you learn that your needs differ: It is a one-liner to change the table type (ALTER TABLE) at any time, so there is no reason to decide early. 2. Are their direct API's for Apache and MySQL and how reliable are they? I am not sure, if I understand you correctly. If you mean if there is some build-in server-side (Apache) language, which you can use to query the database and create dynamic pages, the answer is No, because that goes against the design concept of Apache. It is an web-server, not a do-it-all. That said, Apache offers the facility to plug in Modules for tasks, and there are some modules readily available for this: The best-known is probably PHP, and I suggest to go with it, if you do not know better. There are also modules for e.g. Perl, Python and so on. If you meant something different, please elaborate. Regards, 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 - 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
Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks Abdul Sheikh 14 Mahmood Cr. Maple, ON L6A 3A4 H# 905.303.5442 F# 905 417 9495 C# 647.222.4795 Your best bet is to get yourself some reference material if you haven't already. I suggest 'MySQL' by Paul DuBois. But for starters, what OS are you planning to install on? From your message, I gather you're installing on some flavour of Windows? Is your purpose to provide a development platform just for yourself, or to open it up to the world? When you see a reference to 'shell mysql', that's referring to the client - remember there are 2 things going on. First you have to start the server (mysqld for example), then you need to start a client (mysql) to access the server. -- Amer Neely, Softouch Information Services Perl / PHP / MySQL / CGI Programming e: [EMAIL PROTECTED] w: www.softouch.on.ca/ v: 519.438.5887 - 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 questions.
Ray: The only database you shouldn't mess with is the mysql database ... it is the equivalent of the 'master' database found in other systems, and contains all of the rights and privileges you invoke. Get to know the 'GRANT' command in the MySQL Manual (http://www.mysql.com/manual.php) ... therein you will find the answers to questions about user rights and privileges and a whole lot more. For PHP script samples, it is hard to beat http://www.hotscripts.com/PHP. Gerald Jensen - Original Message - From: Ray Healy (Data Net Services) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 6:25 AM Subject: New to mySQL questions. Hi Just a quick question. I was reading the manuals on the MySQL web regarding the initial setup of the program. I have installed the program and all is going well and have a user called root with full access and another user called mysql with limited rights (used mainly for PHPmyAdmin). There is a database called mysql which contains all the users, rights and privalages. The question I would like to ask is that there is another database called test whcih I belive from reading is a databse that users can connect to annoymously. Can I delete this database as I do not want anyone to connect without a user profile and password. Does it cause a problem deleting this database. Also while I am here can any one advise or tell me where to go in respects of accessing data to/from the database in a php form if the database users have a password. Or am I totally off track and you do not need a password or user in the php page as it is running locally. If anyone has a sample database and some php forms to interact with the databse they could let me see to learn from, it would be very much appreciated. Thanks for all your help Ray Healy - 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: new to mysql, what did I type wrong?
Try 'mysqlaccess root localhost' and see if there is a password set in the output. Try man mysqladmin and set the password there. If you've hosed your perms then stop the damon and restart it with --skip-grant-tables and start again. Remember to do mysqladmin reload or flush privileges from the mysql client. When In doubt try man mysql... Also, once you've got the password working you can save it in /root/.my.cnf so you don't have to type it all the time. Read the man pages carefully since setting the password from the command prompt mysql client syntax varies. Regards, Justin -Original Message- From: castopia [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: new to mysql, what did I type wrong? Hi, I try to change the root password after the first time connecting to mysql server. I followed the tutorial at http://www.mysql.com/articles/mysql_intro.html. Somehow, I got the error mesage, what did I type wrong? Please help. Thank you. ~ # mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.49 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass'); ERROR 1133: Can't find any matching row in the user table mysql set password for 'root'@'localhost' = password('mypass'); ERROR 133 : Can't find any matching row in the user table mysql - 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: new to MySQL
This pages might be helpful: http://www.mysql.com/doc/T/a/Table_types.html http://www.innodb.com/ Gurhan -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: new to MySQL Hey Everbody, I am still pretty new to MySQL and I was wondering if somone can explain the difference between ISAM tables and MyISAM, HEAP, innodb and Merge? Thanks alot, Steve - 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: New to MySQL
You could do that, but if you want to keep it simple, I would download some gui tools like mysql-front (mysqlfront.de) and do all of your development work remotely. Craig At 05:16 PM 4/7/2002, you wrote: Hi I'm new to sql but am familiar with Access \ SQL 7 \ ASP. My ISP offers MySql Support so I need to get up to speed. I can now using Myodbc and access or excel connect to the sample database they put online for me. OF course I have my own tables etc that I want to upload. I get the feeling that I install mysql on my own PC create the database structure etc and simply upload to my ISP after which I can get data into the structure via ASP \ Access \ Excel. Am I on the right lines ? Regards John Berman [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: New to MySQL - can't start server :-(
Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - 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 -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: new bee - Mysql Database Update Problem
It seems like you have hit a file size limit. Soalris has a 2 Gig ( or is it 4Gig) file size limit which is restricting your database. You could get past this by breaking up your data into different segments, eg. group the data by month and store it in monthly tables, reducing the size of the datafile, and then use a merge table to group it all back together into a virtual table. cheers richard samit darne [EMAIL PROTECTED] 01/11/02 09:25PM Hello, I am new to MYSQL platform: Sun Solaris 2.6 mysql version: 3.22.32 I upgrade the hard drive from 4G to 18G as database was increasing and causing problem now space problem is solved and got in to another problem. Database is not getting updated through C programs and perl scripts( that takes the raw data and update in database) which were working fine before the Hard drive upgrade. While C program is running looking at processlist I actually see data being inserted for a particular day in a particular table. After the program finishes I do a query for that particular day on a particular table I don't see any result. I get Empty Set. When I manually insert an entry and do query I do get result for that entry. I don't know what's going on has anyone ran in to this problem? Thanks __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Content-Type: text/plain; Content-Disposition: attachment; filename=disclaimer.txt . 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: NEW TO MYSQL
On 6 Jul 2001, Anoop K Gupta wrote: it prompts for password : it is blank so I just pressed enter. and Mysql prompt appeared.. mysql Well, do you have a password for the root user? If so, type it in! Note, root in mysql is NOT the root login for the server, so the passwords are probably different. If you don't know the root password, see the part in the manual about resetting passwords (it's searchable). If your server is hosted, you can probably get the hosting tech support to reset the mysql password for you. -- Sapere aude My mind not only wanders, it sometimes leaves completely. - 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
I agree. The online manual is wonderful: http://www.mysql.com/ ...and the book by Paul Dubois is fabulous: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=991937746/sr=2-1/ref=aps_sr_b_1_1/107-9361976-5006147 These two resources will have you up in no time. A little reading will get you a long way. Rob Hasan Niyaz wrote: Start with the manual - Original Message - From: Geoffrey Van Nuffelen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:34 PM Subject: New To mySQL Hi all, I am a new user of mysql DB. I am working with WN NT 4. I already downloaded the mysql binary package for window. I installed it. But, now I don't know where to begin. How to start the DB. Please, I would like to have some ways to begin. Thanks, Geoffrey... - 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 - 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
Hello Geoffrey, Thursday, June 07, 2001, 3:34:32 PM, you wrote: GVN Hi all, GVN I am a new user of mysql DB. GVN I am working with WN NT 4. GVN I already downloaded the mysql binary package for window. GVN I installed it. GVN But, now I don\'t know where to begin. How to start the DB. GVN Please, I would like to have some ways to begin. GVN Thanks, GVN Geoffrey... First of all read the manual (...\\mysql\\Docs\\manual_toc.html). The manual contains all the information you need. I began to use mysql not long ago. I spent an hour on reading manual and it was worth it. Run mysqld-nt.exe and mysql.exe with --help pparameter. It\'s very simple to start mysqld-nt (mysql server) in console or as a service. Run mysql.exe. To create a database use CREATE db_name; The open the database: USE db_name; To create a table in the database see chapter about CREATE TABLE. And so on. If you\'re familiar with SQL it\'s gonna be easy for you to use mysql. To run any SQL query just type it and press Enter. In any case look through the manual then try it yourself. And if there is a problem write a message to this mailing list. If you want to use mysql databases with some other clients (for example PHP), read manual for that client (for PHP http://www.php.net/manual/en/ref.mysql.php). -- Best regards, Olexandrmailto:[EMAIL PROTECTED] = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = ôÙ ÔÏÖÅ ÍÏÖÅÛØ ÚÁ×ÅÓÔÉ ÓÅÂÅ ÐÏÞÔÏ×ÙÊ ÑÝÉË ÎÁ http://www.mail-in.net/ mail-in.net - ÎÁÉÂÏÌÅÅ ÐÏÌÎÏÆÕÎËÃÉÏÎÁÌØÎÁÑ ÐÏÞÔÏ×ÁÑ ÓÌÕÖÂÁ × óÅÔÉ = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = - 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
Start with the manual - Original Message - From: Geoffrey Van Nuffelen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:34 PM Subject: New To mySQL Hi all, I am a new user of mysql DB. I am working with WN NT 4. I already downloaded the mysql binary package for window. I installed it. But, now I don't know where to begin. How to start the DB. Please, I would like to have some ways to begin. Thanks, Geoffrey... - 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: New To mySQL
Hello Geoffrey, Thursday, June 07, 2001, 3:34:32 PM, you wrote: GVN Hi all, GVN I am a new user of mysql DB. GVN I am working with WN NT 4. GVN I already downloaded the mysql binary package for window. GVN I installed it. GVN But, now I don't know where to begin. How to start the DB. GVN Please, I would like to have some ways to begin. GVN Thanks, GVN Geoffrey... First of all read the manual (...\mysql\Docs\manual_toc.html). The manual contains all the information you need. I began to use mysql not long ago. I spent an hour on reading manual and it was worth it. Run mysqld-nt.exe and mysql.exe with --help pparameter. It's very simple to start mysqld-nt (mysql server) in console or as a service. Run mysql.exe. To create a database use CREATE db_name; The open the database: USE db_name; To create a table in the database see chapter about CREATE TABLE. And so on. If you're familiar with SQL it's gonna be easy for you to use mysql. To run any SQL query just type it and press Enter. In any case look through the manual then try it yourself. And if there is a problem write a message to this mailing list. If you want to use mysql databases with some other clients (for example PHP), read manual for that client (for PHP http://www.php.net/manual/en/ref.mysql.php). -- Best regards, Olexandrmailto:[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