I have been using ODBC v3.51 to select from MySQL DB's hosted by a RH v7.2 Linux VM
from within an application script. The DB's are normally imported in the early morning.
I now have a need to Insert into a table from an application script. The insert works
when submitted through phpMyAdmin.
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for
select purposes from within an application script. They are normally imported in the
early morning.
I now have a need to Insert into a table from an application script. The insert works
when submitted through
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I
also suspect that the default field separator in Solaris is not a Tab character. Check
these out. If these are in fact true, then it might go a long way in explaining why
your import failed.
Vidhya CS [EMAIL
If your query has worked in one account, but not in another, then your 1064 error is
probably related to privileges granted to the second account.
HTH
Ola Ogunneye [EMAIL PROTECTED] 07/29/03 09:08AM
I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web.
Using geeklog as been okay
attempt to insert.
David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote:
I cannot seem to find this in the MYSQL Reference. Are there other places I
should check?
It's a syntax error. A quick Google
(http://www.google.com/search?q
I suspect that this is some kind of issue with privileges. However, the account I am
using has been given 'ALL' privileges to the database I am trying to insert to. Am I
save to assume that ALL includes insert privileges?
---BeginMessage---
I cannot seem to find this in the MYSQL Reference. Are
I cannot seem to find this in the MYSQL Reference. Are there other places I should
check? The message text in my log started out with 'You have...'. But, it was
truncated and I could not see the rest. It occurred on a submitted insert statement
originating in an application. The insert
I streamlined the application so as to target the offending object more precisely for
testing purposes. And, now the error is 1602 with no text. I am currently still
looking for any error references.
Once again, thanks in advance for your time.
Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03
/v1n1tpserrorcodes.html
Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:07 AM
I cannot seem to find this in the MYSQL Reference. Are there other places I should
check? The message text in my log started out with 'You have...'. But, it was
truncated and I could not see the rest. It occurred
object more precisely for
testing purposes. And, now the error is 1602 with no text. I am currently still
looking for any error references.
Once again, thanks in advance for your time.
Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:05AM
I cannot seem to find this in the MYSQL Reference
I suspect that this is some kind of issue with privileges. However, the account I am
using has been given 'ALL' privileges to the database I am trying to insert to. Am I
save to assume that ALL includes insert privileges?
---BeginMessage---
I cannot seem to find this in the MYSQL Reference. Are
attempt to insert.
David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote:
I cannot seem to find this in the MYSQL Reference. Are there other places I
should check?
It's a syntax error. A quick Google
(http://www.google.com/search?q
I would like to copy the values from each record in the Program table to another table
(tblPrograms). This is the syntax I came up with:
select * from Program insert tblPrograms set ProgramCode=Location,
ProgramName=Description;
However, it fails without telling me why. Perhaps someone could
It appears that we both are climbing the same mountain. The best approach is to hire a
consultant to come in and get you started in the right direction. If, as is our case,
this is unlikely, I will attempt to relay to you some of what I have encountered so
far.
Typically we prefer downloading
You might also wish to consider downloading and installing Webmin. It's one of the
easiest installs I have encountered. Simply tar the tarball and proceed into the new
subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy
access to your server via a web browser.
I had a similar experience right down to the error message you are getting. Based on
that experience, I am inclined to recommend the following:
1) Abandon your current installation which I perceive that your are attempting from a
MySQL tarball.
2) Download the webmin-1.030 tarball and execute
I recently installed the following RPM's:
MySQL-3.23.41-1a.s390.rpm
MySQL-devel-3.23.41-1a.s390.rpm
MySQLclient9-3.23-22-6a.s390.rpm
MySQL-server-3.23.41-1a.s390.rpm
Afterwards, I was able to start the mysqld daemon ok and install an application I
downloaded for a demonstration of the
After taring mysql-3.23.53-unknown-linux-gnu-s390.tar.gz successfully on our Linux VM
and linking the new directory to simply mysql, I ran into the following error trying
to start the mysql daemon:
[root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english
Fatal error: Please read Security
This happens when I try to start the mysql daemon. I have checked the manual, but
cannot fathom what else I am supposed to do.
Here is what has been done so far:
./scripts//mysql_install_db seemed to initialize the MySQL db's ok.
I also executed the following statements without issue:
chown
Mysqld.log shows this error:
021122 11:29:05 mysqld started
021122 11:29:06 Can't start server : Bind on unix socket: Permission denied
021122 11:29:06 Do you already have another mysqld server running on socket:
/var/lib/mysql/mysql.sock ?
Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application?
It's my first attempt at running a MySQL aplication. Here is the link:
http://www.hotscripts.com/Detailed/14498.html
The installation seemed to go flawlessly. Apache webserver was running as well as
MySQL
21 matches
Mail list logo