Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
Thank you,
Huub
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andre Matos wrote:
I am using InnoDB and replication, is there any issues?
Thanks.
Andre
It depends what you're doing. If you use the binary log, there are no
issues - in replication uses the binary log to achieve it's goals.
Since the plain-text log is depreciated, you probably should
Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
Shawn,
- Original Message -
From: [EMAIL PROTECTED]
To: Dušan Pavlica
Cc: Michael Stassen ; list mysql
Sent: Wednesday, October 12, 2005 4:45 PM
Subject: Re: Help with query
Dušan Pavlica [EMAIL PROTECTED] wrote on 10/12/2005 10:00:53 AM:
Thanks, Michal, for your
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
On linux there is dbf2mysql
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import the tables in m$access
Hi Andrew, all!
[EMAIL PROTECTED] wrote:
[[...]] but I believe in security in depth and so for
read-only users I connect to the database with a SQL user that only has the
select privilege, and for read/write users I connect to the database with a
user with select,insert,update,delete
Hi Valentin, all!
[EMAIL PROTECTED] wrote:
Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Correct.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
What Oracle will do with Innobase is Oracle's
The test system that is included in MySQL Server's Unix source
distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run
a test against to the MySQL Server. But these tests only can be run on
Unix(linux). If you want to run the tests on Windows, you must use the
Cygwin
You can also set a plain logging of mysql activity by enabling this in my.cnf
log= /tmp/mysqld.log
tmpdir = /tmp/
restart mysql
Thanks,
At 02:32 PM 10/13/2005, Daniel Kasak wrote:
Andre Matos wrote:
I am using InnoDB and replication, is there any issues?
Thanks.
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
I tried this, set global date_format='%d-%m-%y';. The command executed and
when i did show variable it show the new format.
But when i tried the below test, i got wrong results. Can u please help.
mysql
hi ,
I have crerated a mysql database to store images , mp3 , video files..etc. In
my first stage i stored images as jpg , gif .
But when i try to store little but huge gif files it wont store . I used the
script as follows to upload images,
html
head
titleUpload File To MySQL
Hi List,
When I am trying to connect to mysql 4.0.20 database it is taking very long
time when I specified host like
Mysql -ux -p -h192.168.3.111
But it is connecting very quickly when I tried like below
Mysql -ux -p
It is an urgent issue. Please help me.
Thanks
Ananda Kumar wrote:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
The short answer: not.
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html
lists the variables you can change by the SET GLOBAL or SET SESSION
command.
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang` as
foreign (cascade-delete) keys to the master tables.
However mysql throws error (Cannot create table..)
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
Hi Guy,
Use SHOW INNODB STATUS and check foreign key error at there
Good luck
Guy Brom wrote:
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang`
as foreign
Peter Brawley [EMAIL PROTECTED] wrote on 10/12/2005 04:27:18
PM:
James,
Both ...
SELECT ...
FROM a, b LEFT JOIN c ON a.x=c.y
and
SELECT ...
FROM a
LEFT JOIN B USING (x )
LEFT JOIN c ON a.x=c.y
work up to and including version 5.0.10, not in 5.0.11, 12 or 13.
Dear MySQL,
A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign server 'pho.com' with IP of '192.168.1.1', I
should be able to GRANT using either:
mysql GRANT all ON test.* TO test@'192.168.%' IDENTIFIED BY 'test';
mysql GRANT all ON test.* TO
thanx for the reply , usually , i uploading jpg and gif files into mysql
database , there is no any issue. we can display them correctly.
when i try to upload such huge mp3 files and some .jar files into the databse ,
i used mysqlcc GUI and SQLYOG GUI , from those interfaces also giving
Hi folk!
I'm new to mysql and to databases...
I'm using Fedora Core 4 with mysql 4.1.11-2 I need some application clients
to connect the server using SSL connections. I've created and tested x509
certificates using the way mysql documentation explain, I've modified the
/etc/my.cnf [mysqld] and
Francesco R. wrote:
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
On linux there is dbf2mysql
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import
AS JIGAL SAID :
make sure you are not creating an INSERT statement bigger than the
max_allowed_packet setting for both your destination server and your
client library (whichever ones you are using). If you attempt to create a
packet that is too large, the server will _ignore_ it. Because the
A little more information:
If I use --skip-name-resolve then I get an odd error:
ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using
password: YES)
This seems to suggest that MySQL thinks my client is from '0.0.0.0' and
hence cannot match any GRANT syntax I use. Why would
Hi !
lu ming wrote:
The test system that is included in MySQL Server's Unix source
distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to
run a test against to the MySQL Server. But these tests only can be run
on Unix(linux). If you want to run the tests on Windows, you
Well I've done more than that I wrote a custom init script with the simplest
possible start function containig just the following line:
/usr/bin/mysqld_safe
and SSL does not work eather... please help...
best regards
Israel
-- Forwarded message --
From: RedRed!com IT
I'm using the default Fedora Core 4 Linux mysql RPM package... I just create
x509 certificates and modify the /etc/my.cnf file to use these certificates.
The default mysqld init script doesn't work in its normal' location, just
moving it to a different folder make it works. MySQL daemon runs by
What Oracle will do with Innobase is Oracle's matter, not much use in
speculating about that IMO.
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED how the
environment around Innobase / Innodb will change - and with it any support
options and other impacts that might have
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'id int(14) unsigned NOT NULL auto_increment,
forename varchar(40)
When you connect without specifing the host, the mysql client will try to
connect using the mysql socket file (usually /tmp/mysql.sock
or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try
to connect using a TCP connection to port 3306.
My guess is the you have name
On Thu, Oct 13, 2005 at 02:34:00PM +0900, Dave wrote:
I am curious to know if the MySQL mailing list uses MySQL in
managing the list and it's archives. The articles are surely archived in
a database, and I would assume that if the MySQL developers were to use
any database, it would be a
Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'id
It did not work Daniel. I added this into my.cnf file:
[mysqld]
log-bin=/var/log/mysql/binary.log
and saved the file in two places:
/etc/my.cnf
/usr/local/mysql/my.cnf
Then, I restart the server:
sudo /Lybrary/StartupItems/MySQLCOM restart
I also did two UPDATE, one INSERT, and one DELETE,
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL
Hugh Sasse [EMAIL PROTECTED] wrote on 10/13/2005 11:27:44 AM:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for
MySQL' would be a smash hit, but if you look up error 1064 you'll find
it is a naming error, two of which are visible in your error
report--column names enclosed in double quotes.
PB
http://www.artfulsoftware.com
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
MySQL does not normally use (double quotes) as name identifiers, it
uses ` `(backticks). Change all of your to ` to make your syntax
correct. That would mean that part of your original statement will look
like
Thank you.
In this case
On Thu, 13 Oct 2005, Peter Brawley wrote:
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for MySQL'
If I were familiar with the code base I'd happy send patches, but I
was hoping improve diagnostics might get nudged up somebody's
list by raising it.
would be a
Can anyone please help me with this? I'm just not getting it.
- Thanks
Ed Reed [EMAIL PROTECTED] 10/6/05 2:50:46 PM
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
Pooly [EMAIL PROTECTED] 10/6/05 1:51 AM
2005/10/6, Ed Reed [EMAIL PROTECTED] :
I'm trying to group some sub
(response bottom-posted)
Ed Reed [EMAIL PROTECTED] wrote on 10/13/2005 12:36:24 PM:
Can anyone please help me with this? I'm just not getting it.
- Thanks
Ed Reed [EMAIL PROTECTED] 10/6/05 2:50:46 PM
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
Pooly [EMAIL
[EMAIL PROTECTED] wrote:
speculating about that IMO.
What Oracle will do with Innobase is Oracle's matter, not much use in
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
how the
environment around Innobase / Innodb will change - and with it any
support
options and
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection solution to MySQL
SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid
FROM pmdata pmd, mnames pm, pmdata mypmd
WHERE mypmd.uid= ?
AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid
AND pmd.uid != mypmd.uid GROUP BY pmd.pmid, pmd.uid ORDER BY pmd.uid
What I would like also to return in this query is
Hi All,
I have a query which takes approximately 0.5 seconds to execute , it is as
follows
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN (1,2)
GROUP BY gamename;
EXPLAIN SELECT gives me this, also there is an
Gerald Taylor [EMAIL PROTECTED] wrote on 10/13/2005 12:20:53 PM:
SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid
FROM pmdata pmd, mnames pm, pmdata mypmd
WHERE mypmd.uid= ?
AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid
AND pmd.uid != mypmd.uid GROUP BY pmd.pmid,
Kishore Jalleda [EMAIL PROTECTED] wrote on 10/13/2005 02:25:52 PM:
Hi All,
I have a query which takes approximately 0.5 seconds to execute , it is
as
follows
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN
That was an excellent reply, I always see you helping so many people, keep
the great work going ..
Sincerely,
Kishore Jalleda
On 10/13/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Kishore Jalleda [EMAIL PROTECTED] wrote on 10/13/2005 02:25:52 PM:
Hi All,
I have a query which takes
Hi,
I have mysql 4.1.14 on solaris 9 and have just switched to using the
innodb_file_per_table option. Previously I was using MyISAM tables and
created about 700 tables.
The rlim_fd_cur and rlim_fd_max kernel paramteres are set to 256.
I'm getting an error from innodb that it is running out
Hi all,
I use MYSQL, it is good, I like it. But when comes to big tables, and
fulltext, it is really slow. I have in table up to 100millions rows,
and 1 querry fulltext (limit 5) last 5-200 seconds.
I use it on FreeBSD, I look for something better, thinking about
Firebird or Postgre. Could you
Bruno Cochofel wrote:
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC
Jonathan,
http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html
innodb_open_files
This option is relevant only if you use multiple tablespaces in InnoDB. It
specifies the maximum number of .ibd files that InnoDB can keep open at one
time. The minimum value is 10. The default is 300.
The
From http://www.mysqlusers.com/msg/37105.html we have:
Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql SET PASSWORD FOR 'some_user'@'some_host' =
Bruno Cochofel wrote:
From http://www.mysqlusers.com/msg/37105.html we have:
Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql SET PASSWORD FOR
Hi Doug,
Thanks for the reply.
That is more or less what I was thinking too. (especially the ANT rant ;-)
I would be looking forward to read the paper in case its published one day.
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
Quoting Douglas K. Fischer [EMAIL
The lists are managed using ezmlm-idx (http://www.ezmlm.org/). The
subscription lists are kept in a MySQL database, the message archives
are simply kept in the filesystem, the index of messages used by the
news server and web archive are kept in MySQL, and the search index is
kept in MySQL.
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control
Hi Listers,
Does anybody know if the MyISAM engine (apart from InnoDB) allows the
use of raw disk space rather than having cooked files? If not, is this
feature likely to be included in a future release? I had a quick scour
of the MySQL website but can't seem to find a page with upcoming
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written by perl what could replace the shell
Hi,
I've installed MySQL 4.1.10 and phpMyAdmin-2.6.4-rc1 on a RHEL4 box.
And I found that phpMyAdmin forces the character set of pages utf-8.
Though I knew that phpMyAdmin-2.5.7 can work well with gb2312, I want
to make phpMyAdmin work well too.
Anybody knows that how to make phpMyAdmin work
58 matches
Mail list logo