Greetings!
Is there a relatively painless way to import database structure from Paradox db?
Can MySQL support be inserted instead of BDE into Delphi application
without rewriting large part of it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is there a relatively painless way to import data and database structure from Paradox
to MySQL.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I dont know if I am the only one who has ever asked this. But I dont seem
to be able to find any information about it. Here is what I want to do.
Create table Company
Id int auto_increment primary key,
Name varchar(20);
Create table Employee
Id int
Hi.
In MySql I create this table:
CREATE TABLE `prova` (
`Gruppo` int(11) NOT NULL default '0',
`Prog` int(11) NOT NULL default '0',
`Descrizione` varchar(100) default '',
PRIMARY KEY (`Gruppo`, `Prog`)
) TYPE=MyISAM;
Running this:
UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog=1
I have not used paradox but in most database you can do: (A mysql example)
show create table tblName
and it will generate the create table sql for a table.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 12:41 AM
To: [EMAIL
Irwin,
DROP FOREIGN KEY was implemented after 4.1.0.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
-
Randy Chrismon [EMAIL PROTECTED] wrote:
I read the MysQL documentation re the Server Gone Away error but
nothing there applied to my situation. On a whim, I re-created the
table I was trying to import into but without the foreign key
constraint (I had only disabled the foreign key constraint
David,
030916 17:30:21 InnoDB: Error: page 120855 log sequence number 11
2122008369
InnoDB: is in the future! Current system log sequence number 0 100503279.
InnoDB: Your database may be corrupt.
I assume that you have some 18 GB of data in the database? Then the log
sequence number cannot
Hi
Install MyODBC
Set it up for your mysql database
then from Paradox copy table to the mysql datasource.
You should get a correctly structured table. Depending on the fieldtypes you
may have to do a little manual tweaking.
You may also not be able to do memo fields.
MyODBC can be used as a
Andrea [EMAIL PROTECTED] wrote:
In MySql I create this table:
CREATE TABLE `prova` (
`Gruppo` int(11) NOT NULL default '0',
`Prog` int(11) NOT NULL default '0',
`Descrizione` varchar(100) default '',
PRIMARY KEY (`Gruppo`, `Prog`)
) TYPE=MyISAM;
Running this:
UPDATE Prog SET
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
The original problem is because MySql dosen't support deferrable
constraint.
I solve this problem with this workaround:
UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog=1;
UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)=1;
Use ORDER BY clause in UPDATE statement:
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
Kim G. Pedersen [EMAIL PROTECTED] wrote:
Kim G. Pedersen [EMAIL PROTECTED] wrote:
I once red that using truncate table xx instead of delete from xx
should reset autoincrement , but it seem not to happend.
but when I try to insert data with insert or load data in
it remember the old
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version 3.23 the - sign and the decimal point, there's an extra
space reserved.
I've a decimal column : DECIMAL(5,2), and my problem (maybe manual
Wakan wrote:
I bag your pardon if I post this question again,
but I can't find a clear answer.
I've Mysql version 3.23.41 and 4.0.12, and the manual says
that for version 3.23 the - sign and the decimal point, there's an
extra space reserved.
I've a decimal column : DECIMAL(5,2), and my problem
Daniel Baughman [EMAIL PROTECTED] wrote:
I have a mysql server running on a dual processor pentium 233 (a real power
house :) ). And I have serveral php web sites that access it locally. One
of about 15 reads results in the following error being generated:
Error
MySQL said:
Lost
Bogdan TARU [EMAIL PROTECTED] wrote:
So, back to the problems with auto_increment columns and replication
problems. I have noticed this problem always occures when using INSERT
SELECT syntax with an auto_increment key
simple example:
CREATE TABLE test1 (value INT);
INSERT INTO test1
Carl Anthony-uzoeto [EMAIL PROTECTED] wrote:
I need to periodically load a dumpfile from another DB into
mysql. Now, since this is a cronjob, and for which I would
need to avoid interactivity, I DO NEED to run this as a
non-root user.
I have setup such a user, and have granted the user
Can anybody help me sort my results in the correct way.
My Table description is:
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| id
Hi all,
My company(situated in Poland) produce cross platform software based on
Borland Delphi/Kylix. We also use mysql server to store all our date.Server
is configured with latin2 character set. Nowadays several users work on
Linux boxes(Debian + XFree 4.3.1 + KDE 3.1.3 + iso 8859-2 with
Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like %job% [group by
keywords] order by bid;
I am fairly new to both linux and mysql. I have a cron job that runs
every minute to move data from one mysql table to another (both tables
are in the same database), see below:
Cron job is:
mysql -u *** --password=*** syslog /var/scripts/updsysklog2
Script is:
INSERT INTO sysklog2
Hmmm, have you tried putting is a folling mysqladmin flush-threads command?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Ladies and Sirs,
I tried
SELECT * FROM Table WHERE Column LIKE '%ü%';
to find out if german umlauts (öäü) are imported.
In the resultset where some ds with 'ü' and some with 'y'.
So the charset itself seems to be OK but why did I get 'y'.
They sound sometimes the same, but they are not the
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the most relevant
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the search
Is it possible to Join 2 tables in 2 different databases? Can someone give
a quick example?
-- Keith
Keith Hamilton
Information Technology
[847] 451-0451 x121
[EMAIL PROTECTED]
Is it possible to Join 2 tables in 2 different databases? Can someone
give a quick example?
select database1.table1.* from
database1.table1, database2.table2 where
database1.table1.common_field = database2.table2.common_field.
Chris
-mysql,query,blah
--
MySQL General Mailing List
For list
Figged it would be easy enuf. Thanks
-- Keith
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:38 AM
To: Keith Hamilton; MySQL
Subject: Re: JOIN Statement on 2 Database Tables?
Is it possible to Join 2 tables in 2 different
Let me rephrase. I insert a row and recieve a 1062 error (Key violation).
How do I determine, at run-time, which of the 3 possible columns has the
error. I guess I could parse the mysql_error message string. But, that
seems likely to change in the future. Or, I can test each column for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matt W wrote:
Yep, verified here with .15-nt on Win2k. :-/
I'm sending this to the Bugs and General lists because I'm assuming it
affects all platforms; or is it only Windows?
Matt
I was able to repeat this behavior, and have filed a bug at
Egor Egorof said:
If I've got you right, you get Lost connection error when foreign
key constraints is turn on?
Could you provide your table structure and some data for testing?
Well, I designed the table with a foreign key constraint, then I
disabled keys, tried to LOAD and got the lost
I'm stumped by this query that I think will involve multiple self joins and
left joins.
My data looks like:
+--+--++
| id | Category | description |
+--+--++
|1 | color| red|
|2 | color| blue |
|3 | color|
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks around here. The
second
form is too
At 12:16 PM -0400 9/17/03, Randy Chrismon wrote:
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the
I was wondering if anyone can give a direction on this sub-query issue. Do I
must upgrade it to MySQL 4.1 alpha or is there an alternative on MySQL 4.0.13 as
a workaround to sub-query
Thanks
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08
There's no place like
Hi there,
A mysqlhotcopy issue has stumped no less than three of us here today at
work, ensuring that the solution is glaringly obvious. We're trying to
use mysqlhotcopy to copy a few databases. We want to make a local copy,
nothing exotic, just want to move the database backups to the directory
- Original Message -
From: Gary Huntress [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 12:14 PM
Subject: Multiple Self Joins and Left Joins ?
I'm stumped by this query that I think will involve multiple self joins
and
left joins.
My data looks like:
+--++--+
+
| Table| Op | Msg_type | Msg_text
|
+--++--+
+
| xx.users | repair | info | Found wrong stored
Checking and repairing a table is faster using myisamchk when the mysqld
process is down. This fact is due to more of the resource of a system is
dedicated to myisamchk and the system is not trying to process locked
queries, this is the main motivation (for me) to have a db down to do a
repair.
On Wednesday 17 September 2003 09:16 am, Randy Chrismon wrote:
form is too restrictive for me. Will this work?
grant ... to randy@'%.host.name'
yup... sure will, this is exactly what we do, works like a charm.
gabe.
--
MySQL General Mailing List
For list archives:
Tried it... didn't do anything. Also, there are 11 different instances
of mysql running. Any ideas why? Or is that just how it works?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:37 AM
To: [EMAIL PROTECTED]; [EMAIL
The WHERE-clause for these searches sometimes is a combination
of different columns in the table, and I have noticed some
very sub-optimal index-usage
Adding correct estimations for MATCH is in todo.
Until it's done you can use USE_INDEX/IGNORE_INDEX as a simple
workaround.
Bruce Feist has initiated a discussion with me off the list, and
has forced me to refine the way I express my position somewhat.
The combination of on-list and off-list discussion has been interesting,
but it's getting overwhelming, and reminds me that I have a tendency to
overindulge in
Hi Everyone;
I have been experimenting with a new add-on for my VB/MySQL forums, and as a
result I now have a new mirror for the general list. The mirror is available at
http://www.vbmysql.com/forums/viewforum.php?f=17 but only took effect today, so
there is not too much to search through yet.
Anything that anyone can suggest that might point me in some direction would
be very helpful. I'm just at a complete lose right now ...
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: random
On Thu, Aug 14, 2003 at 10:50:55AM -0700, Dathan Vance Pattishall wrote:
I want to get the most out of my Dedicated Red-Hat Linux 6 drive (3
RAID-1 / 3 RAID-10 ) mysql servers using Reiser-fs.
Currently I have this in my fstab
/dev/sda6 /var/lib/mysql reiserfsdefaults
On Wed, Sep 17, 2003 at 08:01:07AM -0700, Scot Campbell wrote:
Let me rephrase. I insert a row and recieve a 1062 error (Key violation).
How do I determine, at run-time, which of the 3 possible columns has the
error. I guess I could parse the mysql_error message string. But, that
seems
On Sat, Aug 30, 2003 at 03:35:44AM +1000, Chris Nolan wrote:
Hi all,
Now that technologies such as Reiser4 are emerging that offer atomic
filesystem operations, is it expected that MySQL
will take advantage of them?
When word of ReiserFS 4.x first emerged a year or two ago(?), the MySQL
LinuxThreads look like processes in a process list. There is only one
mysqld instance and 11 connections to it.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Jason Linden
Dear list:
I`ve just to install the binary RPM MySQL-serverv 4.0.15 into my Linux
RH7.3 box. The installation was successfull however when I tried to edit
the /etc/my.cnf file to configure error and query path logs, my Linux
system says :
/etc/cnf: No such file or directory
However when I
Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and
find the one that works for you and copy it the /etc
Jamie
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:17 PM
To: [EMAIL PROTECTED]
Subject:
Yup :). I just don't know if activating noatime (for instance) will mess
with mysql's ability to check tables at startup in the event of bad
tables.. etc.
So, I should rephrase the question, what are some good options that work
with mysql and not degrade or inhibit its service.
- Dathan Vance
These will be random atomic Inserts originating from a Web page.
I'm not sure I catch your drift. The inserts are not in a batch.
I need to notify the user on the page which field was in error. I'd like to
refer to the index name in the schema and relate it to the field that
contains the
On Wed, Sep 17, 2003 at 03:01:35PM -0700, Dathan Vance Pattishall wrote:
Yup :). I just don't know if activating noatime (for instance) will mess
with mysql's ability to check tables at startup in the event of bad
tables.. etc.
Using noatime should be fine. It provides a minimal performance
We are currently using an access database going through an odbc connection in vb.net
for our application (which is still in development). The plan was to use MySQL in the
end and we are needing to cross that bridge.
I was wondering the Performance differences between running MySQL on a Linux
At 03:09 PM 9/17/2003, you wrote:
Anything that anyone can suggest that might point me in some direction would
be very helpful. I'm just at a complete lose right now ...
James,
See the Google Group search:
After specify the variablies for innodb in my.cnf file, I started mysql
server. Why I did not see the creating output? But I can see it in err file.
thanks
Hsiu-Hi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
How does one go about revoking a user's GLOBAL privileges with a REVOKE statement?
TIA,
Tore
At 6:33 PM -0400 9/17/03, Tore Bostrup wrote:
How does one go about revoking a user's GLOBAL privileges with a
REVOKE statement?
TIA,
Tore
REVOKE priv_name ON *.* FROM ...
*.* means global
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of course this isn't the same as mysql/pam
Paul DuBois wrote:
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
Our backups are quick large - over 500 MB. Opening the file and adding
the above
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of course this isn't the same as mysql/pam
At 20:12 2003-09-17, Mike Klein wrote:
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of
you just need to restart mysql now as long as you put the file into
/etc/my.cnf
shutdown mysql: mysqladmin -u root -p shutdown
start: safe_mysqld
The file never installed from me from the RPM either, i had to manually copy
it in, yet the server will work without it.
Hope that helps.
Jamie
yes
Kerberos is the ticket
use stashticket to cache your unix credentials
http://www.cs.wisc.edu/csl/doc/info/kerberos/
then put the runauth script in ~/public/.forward check the link for details
-Martin
- Original Message -
From: Tomasz Korycki [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
This is a repost of sorts...
I have a simple stored procedure in MySQL-5.0 from the bk tree:
create procedure sp_BillingByID(input_BillID int)
select * from Billing where BillID=input_ID
When I use the mysql console, and type:
call sp_BillingByBillID(4000)
I get the rows I expect - those with
Hi there is there any possible modular way to simulate a resitrict delete on myisam
tables ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bob Hall wrote:
Bruce Feist has initiated a discussion with me off the list,
Off the list by accident, by the way. I sometimes forget that in this
list I need to do a REPLY ALL. I generally don't go private unless I
want to avoid embarassing someone or need to discuss something genuinely
of
MySQL 3.23.36 (yeah, I know it's getting old...):
What permission do I need to run the following query:
REVOKE ALL
ON mydb.* FROM 'sdaf'@'%';
I get an error 1044:
Access denied for user: 'Admin@IP address' to database 'mydb'
My user has GRANT permission on mydb (database) and GRANT
At 3:25 PM -0700 9/17/03, Hsiu-Hui Tseng wrote:
After specify the variablies for innodb in my.cnf file, I started mysql
server. Why I did not see the creating output? But I can see it in err file.
If there is an error file, that's where you'll see the output.
If you mean you want to see it on the
Don't applications have to be kerberized first?
I don't believe mysql is...kerberos libs don't show up when using ldd.
mike
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 6:24 PM
To: Tomasz Korycki
Cc: [EMAIL PROTECTED]
Subject: Re:
At 10:33 AM +1000 9/18/03, Daniel Kasak wrote:
Paul DuBois wrote:
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
Our backups are quick large - over
On Wed, Sep 17, 2003 at 09:58:16PM -0400, Bruce Feist wrote:
Bob Hall wrote:
Bruce Feist has initiated a discussion with me off the list,
Off the list by accident, by the way. I sometimes forget that in this
list I need to do a REPLY ALL. I generally don't go private unless I
want to
On Wed, Sep 17, 2003 at 08:18:32PM -0700, Mike Klein wrote:
Don't applications have to be kerberized first?
I don't believe mysql is...kerberos libs don't show up when using ldd.
Correct. MySQL is not kerberized(sp?).
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
On Wed, Sep 17, 2003 at 03:07:41PM -0700, Scot Campbell wrote:
These will be random atomic Inserts originating from a Web page.
I'm not sure I catch your drift. The inserts are not in a batch.
I need to notify the user on the page which field was in error. I'd like to
refer to the index
On Mon, Sep 08, 2003 at 05:50:15PM +0200, Bertil Wergelius wrote:
I have an application, where I use the following select-query:
select h.huvud_id,datum, start_tid, stopp_tid,l.lokal_beteckning,
namn,adress,rubrik,amne,grupp,kursnamn,lr.signatur
from huvud_schema as h,lokaler as
On Wed, Sep 03, 2003 at 01:21:24PM -0700, David Griffiths wrote:
Looks like an interesting benchmarking tool.
BTW, I thought http://highperformancemysql.com/ looked interesting; when's
it due to be published?
As soon as it's done. :-)
But it's rather behind now. However, it *is*
On Tue, Sep 02, 2003 at 05:34:12PM -0500, Lewis Watson wrote:
I currently have three mysql machines replication from A-B-C-A type
fashion. I need to replace A. I am thinking that I could add D and have it
pull from C. Then once A is removed restart D as A. Is this a good way to
do this or is
Hi there i have a couple of projects which required fulltext searching so
was unable to setup innodb on these. I was wondering if lock tables is a
secure way to make the transaction on these tables and does this prevent
being read upon aswell?
--
MySQL General Mailing List
For list archives:
On Wed, Aug 27, 2003 at 11:17:36AM -0400, Asif Iqbal wrote:
Hi Jeremy Zawodny (and all)
I am using your mytop and this is what I am seeing
MySQL on localhost (4.0.13-standard-log)
up 0+10:48:22 [11:14:37]
Queries: 85.6k qps:2 Slow: 207.0 Se/In/Up/De(%):86/05/05/02
In my network there are one master 4.0.13 and 3 slaves with 4.0.15.
STarting the slaves's update to 4.0.15 from 4.0.13 during the night when on
the master there are not update I read on slaves's logs as follow:
30918 3:41:06 Error reading packet from server: Lost connection to MySQL
server
I wonder if my user can follow section 1.7.4.1 in mysql.com for what he wants to
do without me upgrading the MySQL from 4.0.x to 4.1 alpha
This is what my user wants
[snip]
I believe I will need sub-selects for the following type of query. Subqueries
are not supported until MySQL 4.1.
I will
Dear Ladies and Sirs,
I tried
SELECT * FROM Table WHERE Column LIKE '%ü%';
to find out if german umlauts (öäü) are imported.
In the resultset where some ds with 'ü' and some with 'y'.
So the charset itself seems to be OK but why did I get 'y'.
They sound sometimes the same, but they are not the
84 matches
Mail list logo
