Do you want to do a one time import ?
Create an ODBC source that maps to the dBase datasource and write an
application to read it from there and import into mysql.
- Navneet
BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
Ehrin,
If you have dBase III or later, Clipper or FoxPro, you can export the
data comma-separated, then use a free csv-to-mysql utility eg
http://sourceforge.net/projects/csv-mysql/ to get it into mysql.
If you don't have an xbase executable, it's a little harder, but not
much provided there's
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
The kernel is 2.4.29.
failed: Can't create a new thread (errno 11). If you
are not out of available memory.
I have
Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art
LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID
LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID
LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID
WHERE
Actually I prefer to dump the dbase file on a Linux machine and directly import
it into MySQL.
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Ehrwin Mina [EMAIL PROTECTED]
Subject: Re: How to import data from Dbase3?
Date: Wed, 23 Mar 2005 02:21:48 -0600
Ehrin,
If
Hi list,
I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them
retrieve the columns' name and have a look in each of this column.
Is there a more elegant (fast) way to do that with mysql?
Somebody has some tips/doc
mel list_php [EMAIL PROTECTED] wrote on 23/03/2005 10:14:07:
Hi list,
I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them
retrieve the columns' name and have a look in each of this column.
Is there a more
Unfortunatly they are not, I have something like 30 tables, with I would say
10 to 15 fields per table.
The number of row per table is quite low, i think it won't exceed
500-1000/table. But I may sometimes have to search into dna sequences
(around 5000 atcg characters in any order), so that is
Your query can be made a lot simpler if I understand your description:
SELECT * FROM ae_articles AS art
JOIN ae_articlesections AS sec ON art.ID=sec.articleID
WHERE art.title LIKE '%bush%' AND sec.sectionID IN (1,2)
This has nothing to do with MySQL, but is a matter of knowing SQL syntax.
You
I am not quite sure I understand your question, then: you would have to
make your table structure a little clearer. Generally, however, puristic
database design would say that you do not have the same class of data in
different tables. Instead, you have one master table with all the
similar
Hello.
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
I recommend you to switch to the official binaries.
Does the problem remain on the latest release
I remember seeing some JDBC drivers for Java to read dbase 3 files. So
it might be a good idea to use that to understand the files and import
the data using the mysql jdbc drivers into the mysql database.
We can help you do it (provided you pay) since we have already done
similar exercise for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
Actually I prefer to dump the dbase file on a Linux machine and directly
import it into MySQL.
There are a bunch of ways of skinning that cat. The easiest of which
IMHO is to convert the data to comma separated files first
If you have ms access you can import the db3 into access and then export
thru odbc to MySql
Osvaldo Sommer
-Original Message-
From: BG Mahesh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:33 PM
To: mysql@lists.mysql.com
Subject: How to import data from Dbase3?
hi
How do
mel list_php [EMAIL PROTECTED] wrote on 03/23/2005 06:00:08 AM:
Unfortunatly they are not, I have something like 30 tables, with I would
say
10 to 15 fields per table.
The number of row per table is quite low, i think it won't exceed
500-1000/table. But I may sometimes have to search into
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select now();
select version();
Your help is appreciated,
-JM
--
MySQL General
Hi Daniel,
Jigal, thank you very much. However, this does not resolve my issue.
even when querying:
SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
AND sec.sectionID NOT IN (3)
What *is*
Justin Moore [EMAIL PROTECTED] wrote on 03/23/2005 10:38:48 AM:
Hi,
Anyone know why I can't run multiple commands from the query browser
using semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select
I can find the data, I was just wondering if mysql provides a kind of
generic scan of a whole table.
I could provide an advanced search, and ask the user what kind of info he
wants to retrieve but I first would like a quickSearch that may retrieve too
much info but is more intuitive.
As I
I am not aware of any SQL dialect that supports a query of the kind you
are asking about. If there were such a query it _might_ look something
like this
SELECT column list
FROM table reference
WHERE ANY_COLUMN(column name list) LIKE search parameter
but like I said, I can't think of any SQL
I forgot to mention that it is happening from my ant scripts too. So the
problem is occurring outside of the query browser as well. However, from the
command line I can execute the two statements.
Any ideas what could be causing this?
-Original Message-
From: Justin Moore
Sent:
The best I've been able to come up with involves some shell scripting.
If you're running Linux, using unpacked MyISAM tables, and have some
scripting ability from whatever language you're writing your application
in, you can run this in your MySQL directory:
strings -f *.MYD | grep search
Shawn, Mel
I am not aware of any SQL dialect that supports a query of the kind
you
are asking about. If there were such a query it _might_ look
something
like this
SELECT column list
FROM table reference
WHERE ANY_COLUMN(column name list) LIKE search
parameter
Right, but Mel can emulate
Normally, MySQL queries DO NOT end in a semicolon. The semicolon (;) and
the \G terminators are used by the command line client to differentiate
between normal (wide output) and vertical output. I have also used
semicolons in SQL scripts loaded by the source command to be processed
through
I have a compiled application that accesses a dedicated MySQL 4.1.1 server
with MyISAM tables on Win XP. For some reason when the application is in a
loop doing simple single table Select statements, the MySQL server after 48
seconds of processing will upchuck with the error Can't connect to
You say it usually crashes near the same record? Could you post the
record information and also the query which is being run?
Also, is there any information in your hostname.err file? If mysqld is
bailing (and it appears that it is), it ought to be writing something
useful to the error log.
mos [EMAIL PROTECTED] wrote on 03/23/2005 12:04:59 PM:
I have a compiled application that accesses a dedicated MySQL 4.1.1
server
with MyISAM tables on Win XP. For some reason when the application is in
a
loop doing simple single table Select statements, the MySQL server after
48
Unfortunatly I can't use the alias txt in the where clause:
Standard SQL doesn't allow you to refer to a column alias in a WHERE clause.
This is because when the WHERE code is executed, the column value may not
yet be determined. For example, the following query is illegal:
SELECT id, COUNT(*)
Hi,
How do I import data from Dbase3 into MySQL?
My software, libmygis, is mainly designed for loading a set of
Shapefiles into MySQL (.SHP, .SHX, .DBF) but it's perfectly well capable
of loading just the dBase III/IV component. Grab libmygis-0.5.1 from:
http://jcole.us/software/libmygis/
Actually, exporting data from an Oracle database is one of the weak
spots of Oracle. Oracle makes it easy to get data in, but hard to get
it back out. There are ways to do it, but nothing easy that an Oracle
DBA will have if they only read the Oracle docs. Spooling an output
file can get tedius
But you can use column aliases in a HAVING clause (a simple mistake when
you are typing as fast as you are thinking). The other option is to put
the CONCAT(...) into the WHERE clause in place of the alias. Either way,
you will absolutely NOT be using an index to search that table. You will
Lost connection to MySQL server during query
The last time I saw this mysqld was segfaulting on a specific query. The
solution was to run an extended repair on the tables in question.
http://dev.mysql.com/doc/mysql/en/repair-table.html
I would reccommend against doing this until after hours as
What device driver are you using to access the database? Can you run a sql
trace or maybe turn on the logging on the server side?
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 11:05 AM
To: MySQL list
Subject: MySQL server disconnects when
Right, my mistake, you would have to use HAVING.
PB
mel list_php wrote:
Unfortunatly I can't use the alias txt in the where clause:
Standard SQL doesn't allow you to refer to a column alias in a WHERE
clause. This is because when the WHERE code is executed, the column
value may not yet be
how do you search for an empty field ?
I want to filter out records where the ipAddress field is empty
SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ?
many thanks
g
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Wednesday, March 23, 2005 12:13, Graham Anderson wrote:
how do you search for an empty field ?
I want to filter out records where the ipAddress field is empty
SELECT * FROM 'userLog' WHERE 'ipAddress' IS [empty] ?
Searching for NULL's --
SELECT * FROM userLog WHERE ipAddress IS NULL
I discovered by accident that I can link any website
on my reseller account to one database. That would be
far more convenient than working with six separate
databases, and it would also cut down on file size
overall, since there are certain tables that I share
between websites.
But my host
David Blomstrom said:
I discovered by accident that I can link any website
on my reseller account to one database. That would be
far more convenient than working with six separate
databases, and it would also cut down on file size
overall, since there are certain tables that I share
between
I have an existing database/tables and would like to add a counter to a
table that would increment when a document is downloaded from the
database. I am sure it is an easy addition to the php page but struck-out
looking for info not related to auto-increment in the mysql manual. I
tried adding
Your theory that more tables won't slow down a client if it doesn't
access them is correct, it won't slow the client down. But it's slowing
down the server that you should be worried about, not the client. The
more tables you have, the more file handles MySQL has to have open
along with
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN
MODE);
sure there
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN
MODE);
sure there
--- Brent Baisley [EMAIL PROTECTED] wrote:
There are advantages to one large
table over many
smaller tables. A large table will take advantage of
query caching
better (if you have query cache enabled). Lots of
smaller table would
probably cause the query cache to get flushed more
often.
show variables like 'query%';
That will show you the setting for mainly your query cache. The
query_cache_type will tell you if it's on or not.
On Mar 23, 2005, at 3:08 PM, David Blomstrom wrote:
--- Brent Baisley [EMAIL PROTECTED] wrote:
There are advantages to one large
table over many
smaller
If Dbase3 has an odbc driver then you can use SQLyog
(www.webyog.com) to import data to MySQL.
Karam
--- Peter L. Berghold [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG Mahesh wrote:
Actually I prefer to dump the dbase file on a
Linux machine and directly
I couldn't find much on the variable you were trying to change.
Although it may have changed and now be called ft_boolean_syntax. But
that still won't help you since it doesn't appear to have an option to
change the default separator.
I think you will need to add the + to each word if you want
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text)
Hi that works fine only now if a user puts + in front of a word that word
becomes optional = OR?
What i would like is the search to work exactly like before only that it
defaults to AND instead of OR.
Almost every search engine i have tried, google etc. works like this.
black horse cat dog only
On Wed, 23 Mar 2005 22:22:34 +, Jessica Svensson
[EMAIL PROTECTED] said:
Hi that works fine only now if a user puts + in front of a word that word
becomes optional = OR?
What i would like is the search to work exactly like before only that it
defaults to AND instead of OR.
Almost every
stupidly
My DateTime field is in this format:
March 23, 2005, 3:49 pm
If I want to run this sql
SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
FROM userLog
I gather I need some extra function like..
SELECT TO_DAYS(MAX(Convert _Function(DateTime))) -
I have 3 different tables I need data from
And, the tables have the potential to get fairly large
I am using mysql 4.1.3
This working query below pulls up all media requests for 'Yolanda
Perez' in Los Angeles
Is there a appreciably speedier way to say the below ?
I have begun dipping my
Dear all,
How to change the Default Date/DateTime Format of MySQL server?
I'm using MySQL 4.1.10-nt on WinXP Pro.
Thanks.
Shuan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry if this is simple, but I'm a fairly new user and it's got me stumped.
Using PHP and MySql; I want to look up a specific record from a table of
people by using a select query to populate a PHP select /select
statement. I can do it with one field, but I need to do it with more
than one
Hi,
Which version of Mysql you are using? My query browser executes mutiple
commands -semicolon as seperated, and my ant script too works !! The
version Im using is 4.0.24.
Thanks
Usha
- Original Message -
From: Justin Moore [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent:
Hi All,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
regards
Digvijoy
I was trying to imnport a csv file into an online
databse table, but I kept getting error messages
alluding to a child row, foreign key, etc. So I
decided to delete both keys (primary and index), then
import the csv file.
I finally managed to delete the primary key, but I
can't zap the index.
Hello,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
Transactions are only used when you use the InnoDB or BDB table
types.
The
Gleb Paharenko wrote:
Hello.
I have mysql-server 3.23.49-8.9 in a debian woody,
chosen for its stability. It looks like the server
stops accepting connections when it has created
more than 1024 threads.
I recommend you to switch to the official binaries.
Does the problem remain on the latest
58 matches
Mail list logo