Hi Everyone.
I'm having a bit of a problem importing a dumpfile to mysql. When doing a
mysql -u database_mgr -p -h host.domain database file.dump I get this
error:
--cut--
ERROR 1064 at line 11: You have an error in your SQL syntax near '(15),
surname TEXT(15),
company TEXT(20),
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
table width=729 border=0 cellpadding=0 cellspacing=0
tr
td width=235 rowspan=2 valign=topa
href=http://www.xxx-porns.com/index.shtml?wmid=mailer10pop=yes;img src=blond.jpg
JvdW writes:
I'm having a bit of a problem importing a dumpfile to mysql. When doing a
ERROR 1064 at line 11: You have an error in your SQL syntax near '(15),
surname TEXT(15),
The first part of the dump file is:
--cut--
#
# mSQL Dump (requires mSQL 2.0 Beta 5 or newer)
There's
I'm trying to insert records from a file. These records are separated
with pipes.
use crous;
load data local infile aid.exp into table aid;
When I do select * from aid , the first column is OK but the
second and third columns are nulls for all rows.
It's weird!
Has anyone experienced this
Ok,
I was able to repeat the
InnoDB: error in sec index entry update in ...
error with a table containing just 2 rows :).
The error happens when you UPDATE or REPLACE
a character column where only the case of the letters
changes:
mysql update bob set b = 'AMBJORG' where a = 7400;
Query
GUYOT Carole writes:
I'm trying to insert records from a file. These records are separated
with pipes.
load data local infile aid.exp into table aid;
How is MySQL supposed to know that you're using a
non-standard way of separating your records if you don't
tell it? :-O
You need to specify
Hi,
I have strange problem with mysql. When I run mysqladmin processlist i get
output (I cut off selects):
| 4045633 | konkursy | targi1.wp.pl | konkursy2 | Query |
14| Locked | insert into bb2_ludzie_tak values
('Marzena')
Rafal,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
If you mean it shouldn't behave like this because it does concurrent
inserts, then note that they work only on
Hi All,
I am building a web site that will be connected to a mysql database. I
am testing both locally and on server. At the moment I have a problem.
Locally the connection is fine with no errors displayed. However, when
viewing the same file on the server I get the following error.
Warning:
Fred van Engen wrote:
Rafal,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
If you mean it shouldn't behave like this because it does concurrent
inserts,
Hello.
On Fri, Sep 21, 2001 at 04:29:04PM -0500, [EMAIL PROTECTED] wrote:
If I want to filter out records when SELECTing from a database, how do I do
it with an
and/or type of statement. Like this:
SELECT * FROM websites WHERE keywords LIKE '%akeyword%' AND/OR description
LIKE
Hi.
On Fri, Sep 21, 2001 at 02:31:44PM -0700, [EMAIL PROTECTED] wrote:
I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What
I downloaded the installation.zip mysql version onto a windowsNT machine
on a network.I installed it as a standalone server unfortunately I am
unable to find the command prompt inorder to begin executing commands,can
you specify for me the file I should open.
Hi,
If you want to enter MySQL commands for making tables etc, run
'c:\mysql\bin\mysql.exe' (If thats where its installed on your machine),
from either the DOS command line (cmd) or the windows 'Run...' box.
Andrew
-Original Message-
From: John Nyukuri [mailto:[EMAIL PROTECTED]]
Sent:
imho, the fact that mysql does not support joins in UPDATE and DELETE
statements is by far its greatest weakness. I have posted a couple of
messages to this group to see what creative work-arounds others
have used to
fill this gaping hole in functionality. Alas, no one has felt
like
Hi,
How much memory does mysql executable take in the ram?
What is its code memory foot print?
regards
Rock
=
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
Bonjour,
I've rebooted my server with sync;sync;reboot. It seems that
Mysql/InnoDB did not have enough time for shutting down properly
because when the server restarted I had these messages in the error
log of Mysql :
InnoDB: Doing recovery: scanned up to log sequence number
I'm not up on expect, but I would assume that since you can use sh then you
should ber able to use expect.
Generally speaking in sh you can do the following:
#!/bin/sh
MYSQLCMD=/usr/local/bin./mysql
USER=me'
HOST=some.host.com
PASSWD=whatever
QUERY=SELECT userId FROM thisTable WHERE id=1
Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Sunday, September 23, 2001 9:35 PM
Subject: Re: MySQL 4.0
On Sun, Sep 23, 2001 at 07:54:59PM -0500,
I'm working with a table that includes a field id INTEGER AUTO-INCREMENT
NOT NULL .
When I create a new record with the query INSERT, I don't give any value
for the id field, the value is automatically given by mySQL.
As the database is supposed to be used on the WEB, several queries INSERT
Hello Laurent and jeroen!
I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying
to import data from our filemaker pro database.
i've got the same problem with a french vocabulary database that I want to
import into a mySql database.
Has anyone seen
Hello!
I've had that same problem. I don't know the cause of the problem, but I solved it by
replacing:
my_socket fd; /* For Perl DBI/dbd */
by
/* my_socket fd;*/ /* For Perl DBI/dbd */
So, simply edit the mysql_com.h file and comment it out!
Hi Jacques!
I'm working with a table that includes a field id INTEGER AUTO-INCREMENT
NOT NULL .
When I create a new record with the query INSERT, I don't give any value
for the id field, the value is automatically given by mySQL.
As the database is supposed to be used on the WEB, several
I think no-one's replied because the answer is really simple
Oh I don't know Jay, I've seen some threads 4-5 responses deep to issues far
simpler than this.
create a recordset using Select for the records you are interested
in (using your joins), then use that recordset to perform your
Hi all,
I get MySQL-3.23.42-1.i386.rpm and made a full install
using rpm -i MySQL-3.23.42-1.i386.rpm which seems to
be ok. My big problem is : nowhere I can found mysql,
mysqladmin etc ?? Where are they gone ??
Thanks for all advices
Hi.
On Sat, Sep 22, 2001 at 03:38:45PM +0200, [EMAIL PROTECTED] wrote:
I have some questions about MySQL replication and table locking:
1. If I lock a table on the master server, the table will be locked on
the slave server?
It will be locked whenever the slave gets to execute the
I've tried to read through a fair bit of the manual, but I haven't quite
found out yet: does MySQL support Unicode? I'm talking Strings from Java,
using mm.mysql driver.
--
Mvh,
Endre
-
Before posting, please check:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 24 Sep 2001, jean.schuller wrote:
Hi all,
I get MySQL-3.23.42-1.i386.rpm and made a full install
using rpm -i MySQL-3.23.42-1.i386.rpm which seems to
be ok. My big problem is : nowhere I can found mysql,
Yes !! Marco Bizzarri find the trick : he said
You should install MySQL-client also and now mysql
and mysqladmin are there.
Thanks to all ans specially to Marco
Jean
On Mon, 24 Sep 2001 [EMAIL PROTECTED] wrote:
Date: Mon, 24 Sep 2001 16:28:23 +0200
Will,
First of all, if I sounded condescending, it was not my intent. I apologize
if that's how you (or anyone else) took it. I will, however, respond to
your smoking response to mine:
I think no-one's replied because the answer is really simple
Oh I don't know Jay, I've seen some threads
O' MyT SQL wizards!
I'm a total newbidiot w/ regard to MySql. I bought the O'Reilly
book and it's been a big help, but I have a problem that book
doesn't even gloss-over:
One table has a (large) list of developers (100,000+), each of
which can be a member of 0-5 project teams.
Another table is
Hi
I was wondering how easy or difficult it is to migrate from
MySQL
Radhakrishnan Sundaresan
Graduate Research Assistant
Cluster I/O Labs, Ohio State University
Ph: (Res) 614-291-1217
(Off) 614-292-8458
-
Very
There are tools to migrate from or to
oracle,XL,Access
Simon
-Original Message-
From: Radhakrishnan Sundaresan [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2001 15:52
To: [EMAIL PROTECTED]
Subject: Migrating to other databases
Hi
I was
At 04:03 24/09/01 -0700, John Nyukuri wrote:
Hi!
I downloaded the installation.zip mysql version onto a windowsNT machine
on a network.I installed it as a standalone server unfortunately I am
unable to find the command prompt inorder to begin executing commands,can
you specify for me the file I
Howdy all...
New to MySQL and I've got a question. I have an application that does a
good deal of hierarchical reporting. In order to do this one of the tables
in my database contains nothing more than an individuals id and the team to
which that individual reports
TABLE - TEAMREPORT
Alex,
at the maximum it has to scan the whole size of its log
files. In the 'applying log records to the database'
phase it may take a long time because of disk i/o.
Thus, it is really not possible to know the remaining
time precisely since the amount of disk i/o may vary
in different phases of
Hi. I'm looking for any support/help that one is willing to give to
assist me in convincing the company I work for to switch over to MySQL as
there sole database system. We currently use MS Access which we all know is
a some what to be desired database. I have to answer the following
Hi!
I built my database and then used the command:
ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid)
But if I try to search with this command:
SELECT title, recentdata, specialsound,uniqueid FROM disc WHERE MATCH
(title) AGAINST ('Superman')
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient
katty Iniguez [EMAIL PROTECTED] writes:
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius]
From: katty Iniguez [EMAIL PROTECTED]
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found
lmysqlclient)
This location probably isn't what you want. You
I am not sure if my problem is with MySQL or PHP. I am trying to learn
both using the book PHP and MySQL Web Development. In using an example
script for creating a password protected logon page I receive an message
Resource id #2 Does anyone know what this means?
Thank you very much for
I lost the .MYI file, I still have the FRM and MYD files.
There's any way to recover this table? Recreating the index file?
thanks
Thiago Lima.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi
Now I have quite a bit of information on all these questions.. my
main concern is to find a Windows MySQL GUI Client that will do everything
in a similar fashion as Access. I believe we would need the
basics but also
including visual query builder and reports. I've recently
Hi, I have used Er Studio to do my data modelling for a DB I am working on,
and now I would like to generate a MySQL DB from this data model. Problemis
that Er Studio doesnt directly support outputting to MySQL. Has anyone
found a work-around for this? Maybe I can output to SQL meant for
From: T. S. Parikh [EMAIL PROTECTED]
...I would like to generate a MySQL DB from this data model.
...Er Studio doesnt directly support outputting to MySQL.
This is an interesting topic, IMHO. Tim Bunce has a mysql-to-oracle converter that he
mentioned on this list:
ARCHIVE:
Hi Robert,
I have experience the similar issue with MySQL, MM.MySQL and JBOSS.
I was using CMP-EJBs with INNODB table from MySQL-Max and data did not
persist in the table as I called EJB create(). The issue resolved as I
'alt' the table back to MyISAM tables.
I have posted the
Now I have quite a bit of information on all these questions.. my
main concern is to find a Windows MySQL GUI Client that will do
everything
in a similar fashion as Access. I believe we would need the
basics but also
including visual query builder and reports. I've recently found
Hi!
On Sep 24, Thiago Madeira de Lima wrote:
I lost the .MYI file, I still have the FRM and MYD files.
There's any way to recover this table? Recreating the index file?
Sure.
See http://www.mysql.com/doc/R/e/Repair.html (Stage 3: Difficult repair)
Regards,
Sergei
--
MySQL
R Talbot wrote:
R Talbot wrote:
Still having compile problems and GNU binary
produces the following info
Michael Widenius wrote:
The problem is probably that your tar
program doesn't use user-names
but user-ids, in which case the files may
be owned by 'anyone.
What output do
Hi!
Just an update to this thread: the replication
failure of auto-inc columns has probably been
traced. Replication assumes that auto-inc
values for a multiline insert or
INSERT INTO ... SELECT ... are assigned strictly
consecutively, while InnoDB assigns them in parallel.
A symptom of the bug
Hi!
On Sep 24, Adam Douglas wrote:
my main concern is to find a Windows MySQL GUI Client that will do everything
in a similar fashion as Access.
If I'm not mistaken you can just continue to use Access as a GUI and for
rapid prototyping, connecting it to MySQL via ODBC.
Regards,
Sergei
--
After working with me on a project, att.beready.com tech support has noticed
something wrong with one of the downloads, they have downloaded the
mysql-3.23.40-pc-linux-gnu-i686.tar.gz
problem identified:
we have downloaded and ftped this file to three different boxes and continue
to get a
I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
server and connect to it from my machine using Telnet.
But everytime i try to connect using mysql client or through access 2000 i
get the following error:
Host 'ip address' is not allowed to connect to this MySQL server
So sprach »Erin Lilly« am 2001-09-24 um 14:53:27 -0500 :
After working with me on a project, att.beready.com tech support has noticed
something wrong with one of the downloads, they have downloaded the
mysql-3.23.40-pc-linux-gnu-i686.tar.gz
Any particular reason you're trying to setup such
After working with me on a project, att.beready.com tech support has
noticed
something wrong with one of the downloads, they have downloaded the
mysql-3.23.40-pc-linux-gnu-i686.tar.gz
problem identified:
we have downloaded and ftped this file to three different boxes and
continue
to get
From: Gerald Clark [EMAIL PROTECTED]
Default values must be constants.
Håkan Elmqvist wrote:
Now I want to register who changed it...
=== MY two cents worth:
With MySQL, this sort of thing usually gets handled in a piece of software. In Perl,
we might say something like:
$sth =
Description:
This is the log file (some characters are cyrillic KOI8):
Number of processes running now: 0
010924 21:57:51 mysqld restarted
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
clear as day, and I think that I have the configurations correctly. However
I really am a programmer, not a server admin. Could someone out
Hi,
i'm using Linux Red Hat 7.0 and i want to know how to add mysql to my
startup.
Thanks in advance
--
Moise Bertrand TACHAGO
Computer scientist
Volunteer DBMS Specialist
SDNP Cameroon, 506 Hajal Center Building
Yaounde CAMEROON
(237)22 24 90
E_mail [EMAIL PROTECTED]
[EMAIL PROTECTED]
mysql must own the database directories.
chown -R mysql /var/lib/mysql
( or whatever the database directory is )
Mike Eggleston wrote:
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
From: Bertrand TACHAGO [EMAIL PROTECTED]
i'm using Linux Red Hat 7.0 and i want to know how to add mysql to my
startup.
Your MySQL shipped with a file called 'mysql.server', this is the control script. Put
that into your RC tree and set it to be executable.
I've got this:
% cp
What causes this error:
3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c
mysqld.cc
mysqld.cc: In function `void *handle_connections_sockets (void *)':
/usr/include/tcpd.h:131: too many arguments to function `void sock_host
()'
mysqld.cc:2339: at this point in file
can anybody explain this to me?
mysql select count(*) from members where country_id = 1 and read_array not
like '%20270%';
+--+
| count(*) |
+--+
|34884 |
+--+
mysql select count(*) from members where country_id = 1 and read_array like
'%20270%';
+--+
|
What type of schema do mean here ? Because as you know, MySQL doesn't
explicitly supports any schema's except the catalogs( in MySQL term
'database'). If you can elaborate what exactly the problem
you are facing,
then we can provide a rapid solution.
Also, as for as I know, when I change
I've had the same issues. I have really avoided the dev side of things
for some time so I'm not sure whether there's a way around it. Mainly
just devoting myself to administration. Funny though I'm starting to
write jsp stuff to monitor the databases more effectively.
I agree with you on the
Harpreet wrote:
I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
server and connect to it from my machine using Telnet.
But everytime i try to connect using mysql client or through access 2000 i
get the following error:
Host 'ip address' is not allowed to
Hi Douglas and David !!
I have the following setup...
- MySQL 3.22.32 on OpenBSD v2.9
- MyODBC on Windows '98 SE
- MS Access 2000
Cool !!!
Now I've found when I do changes to a table schema the changes are not
entirely at least reflected in a the same table linked in Access.
I had
Now I've found when I do changes to a table schema the
changes are not
entirely at least reflected in a the same table linked in Access.
I had once
case where I changed a data type on one of the columns and
that data type
was not changed on the linked table in Access. I had to
Description:
I compiled MySQL 3.23.39 from the Source RPM
Compilation went fine. (These is 1.1MB log file for anyone interrested)
Compile command was:
sparc32 rpm -bb --clean mysql-3.23.29.spec 21|tee mysql.log
Starting mysqld however burbed with the following
Hi !!
As a quick note, I tried the same with MS SQL Server through its latest ODBC
driver by adding the new column, and I couldn't see any changes in the
linked tables from Access 2002.
So it shows clearly that, its some thing related to MS Access, not with the
driver. It might be a bug from
I would have to guess that you have a broken index.
bill
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: very strange query behavior
can anybody explain this to me?
mysql select count(*) from
Hi
Another small research in Access made me to see the changed table structure
completely. Please use this procedure to view or to refresh links when the
structure or location of a linked table has changed.
1. Open the database in access that contains links to tables.
2. On the Tools menu,
Hi everyone,
I was wondering how I could go about dropping all existing tables from a
database? Rather than using a DROP TABLE that lists each table I wish to
drop is there not some way to drop all existing tables in a database? Even
if I cannot remember all the table names?
I could delete
As a quick note, I tried the same with MS SQL Server through
its latest ODBC
driver by adding the new column, and I couldn't see any changes in the
linked tables from Access 2002.
So it shows clearly that, its some thing related to MS
Access, not with the
driver. It might be a bug from
On Mon, Sep 24, 2001 at 03:02:42PM -0700, Venu wrote:
Hi
Another small research in Access made me to see the changed table structure
completely. Please use this procedure to view or to refresh links when the
structure or location of a linked table has changed.
1. Open the database
Another small research in Access made me to see the changed
table structure
completely. Please use this procedure to view or to refresh
links when the
structure or location of a linked table has changed.
1. Open the database in access that contains links to tables.
2. On the Tools
Another small research in Access made me to see the changed
table structure
completely. Please use this procedure to view or to refresh
links when the
structure or location of a linked table has changed.
1. Open the database in access that contains links to tables.
2. On the Tools
What I did to handle global changes was have one access file on the
fileserver that everyone had a shortcut to. That way the updates
were global since they were all to the same file.
Dave
On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote:
Another small research in Access made me to
Hi all,
I'm a newbie. My question is : Is it possible to access a MySQL table using
RealBasic?
If any of you has an experience with it, thanks for sharing.
Regards,
Indramin
-
Before posting, please check:
Hi Guys,
The following query that I am using is returning duplicate rows.
For a two word search:
SELECT DISTINCT
pdf.title,
pdf.filename,
searchwords.ranking,
pdf.summary
FROM
pdf,
words,
searchwords
WHERE
words.id =
Nope, I'm trying to create a client program for Macintosh.
regards,
Indramin
From: Neil Zanella [EMAIL PROTECTED]
Out of curiosity, why would you want to do this?
Are you trying to use mysql with ASP
instead of with PHP? Just curious...
Neil
On Tue, 25 Sep 2001, Indramin
I am looking for a good programme to admin the database on the remote
server. Any advice? Anyone using one they could recommend? I have
DBTools
and using this I can view the database names on the remote but I cannot
connect. I can only connect to the local MySql server.
I am using Windows 2000
I think mysqlfront is excellent.
http://www.mysqlfront.de/
HTH
Andrew Braund
-Original Message-
From: mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 25 September 2001 14:36
To: Mysql
Subject: mysql remote administration
I am looking for a good programme to admin the database
I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i
get the following error message when I try and use DBI to connect to a
MySQL database to pull some data.
Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.0
0503
Hello,
I use 2 MySQL-3.23.41 servers. These serers do mutual replication.
I have problem with one table. In the table is a UNIQUE field. This field
is used by a RADIUS server which sometimes wants to store 2 (or more) rows
with the same ID (which is unique). For the master server it is
Dear sir,
Please help and drop me a email.([EMAIL PROTECTED])
I have Apache 1.3.17, MySQL 3.23.30 install on a Sparc Solaris 8 and Apache
1.3.20, MySQL 3.23.40 installed on a Interl RedHat Linux 7.1, I got
mod_auth_mysql-2.20 and following below instruction to compile and failed on
both
88 matches
Mail list logo
