Perhaps you could try "MySQL Migration Toolkit"
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
still beta though...
NB!
ATTENTION: Before installing the MySQL Migration Toolkit please download
and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from
http://java.sun.com
NOTI
Vlad Shalnev wrote:
Periodically I get error message "can't get stat of xxx.MYD" for tables
that are symbolic link to tables on different database on the same file
system. Error disappear after executing "flush tables".
Why are you doing this? You can access tables in other databases in your
Hi all
Problem description
OS: Solaris 9
Mysql: 4.1.8
Periodically I get error message "can't get stat of xxx.MYD" for tables that are
symbolic link to tables on different database on the same file system. Error
disappear after executing "flush tables".
If someone solve this problem let me
Craig Hoffman wrote:
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.
mdbtools: http://mdbtools.sourceforge.net/
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Au
For high volume discussion board type work InnoDB is faster. Our
"slow query" log droped 66% just by switching engine types.
Earlier comments about innoDB not supporting "full text" are actually
supposed to read InnoDB doesn't support full text indexes... This is
only important if you reall
There used to be a program called "AccessDump" that will dump access tables
into .sql files. Their website seems to be unresponsive at the moment,
though.
Here's a link:
www.AccessDump.com
They are from the south, so it's possible that the site was affected by the
hurricane.
Jenifer
-
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.
Best,
CH
___
Craig Hoffman
www.eclimb.net
[EMAIL PROTECTED]
iChat / AIM: m0untaind0g
___
--
MySQL General Mailing List
For
Hello.
If you want to have a complete understanding of how MySQL access
privilege system works, read this chapter of the manual:
http://dev.mysql.com/doc/mysql/en/privilege-system.html
James <[EMAIL PROTECTED]> wrote:
> I had set up the following
>
> I have a MYSQL server running
Hello.
As far as I see mysqldump doesn't support this feature. Here is the
thread where people discuss this issue, may be it will be interesting
for you. See:
http://lists.mysql.com/mysql/79914
Jacques Brignon <[EMAIL PROTECTED]> wrote:
> I have not identified which options to use
Hello.
See:
http://dev.mysql.com/doc/mysql/en/transaction.html
liofr <[EMAIL PROTECTED]> wrote:
> Hi
> i use a sofware to connect to mysql and it can connect with succes but
> wanted to share acces to mysql to many poeple and it popup
> [MUSQL][ODBC 3.51 Driver] Transaction are not
Anil wrote:
Michael,
Just I want to know if we grant privileges with '%' wild card character will
it accept connection from 127.0.0.1. when I tried it is showing connection
request is coming from [EMAIL PROTECTED] and connection is not establishing . to
my knowledge '%' means it should accept co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We have a production server that may be getting overworked, but I don't
know.
When I look at 'mysqladmin status' it consistently shows 107.#
queries/sec on average. That seems a bit high, it should be less, I
imagine, since the Id number in the proces
Hi!
Mayuran Yogarajah wrote:
Does anyone know if there are certified binaries for 4.0.x ? I think
I read somewhere that they will have it for 4.1 and later for 5 only.
I do not know where you read it, but to the best of my current knowledge
this is correct. I do not expect them ever to be don
You tripled the amount of memory assigned to the cache, but your
Qcache_lowmem_prunes value went up 10x and Qcache_not_cached went up
6x. I would say that you have enough queries that are unique, that
most of your queries are getting cached then flushed before the same
query comes up again.
Michael,
Just I want to know if we grant privileges with '%' wild card character will
it accept connection from 127.0.0.1. when I tried it is showing connection
request is coming from [EMAIL PROTECTED] and connection is not establishing . to
my knowledge '%' means it shouls accept connection from
Anil wrote:
HI,
I have granted all privileges to a user to connect from any host like below
grant all on *.* to [EMAIL PROTECTED] identified by 'password';
flush privileges;
Verify this worked with
SHOW GRANTS FOR [EMAIL PROTECTED];
By the way, giving all privilege
James wrote:
I had set up the following
I have a MYSQL server running on let's say 123.xx.xx.xx
User: user1
Host: 111.xx.xx.xx
and gave that user the appropriate priveleges.
How exactly? Did you use GRANT? Something like
GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY 'user1_pa
Eli wrote:
Gleb Paharenko wrote:
You may want to think about the MERGE storage ENGINE, however
it doesn't have a real spanned index. See:
http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html
MERGE is not the case here, since it is JOIN of tables which are
different in defintion. M
Hi All,
Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17,
I upgraded the slave a week ago and the replication was working perfectly,
once I upgraded and started mysql, it started fine without any errors but
the server was steadily creating mysql processes at the rate o
Symlinking works fine but keep in mind an important gotcha: if you ever do
a table rebuild, mysql completely ignores your symlink and overwrites it
with the file (which may even fill up your disk).
Have you noticed these table options (from
http://dev.mysql.com/doc/mysql/en/create-table.html)?
On Thursday 15 September 2005 10:02, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/4329a93daa95db74/jeff.nensha=gmail.com
>
> This confirmation ser
_
From: Anil [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:36 PM
To: 'mysql@lists.mysql.com'
Subject: QUERY CACHE TUNING QUESTION
Hi list,
We are using mysql 4.0.24 on RHEL 3.0 on dell 2650 machine with 2 gb RAM.
We tried to fine tune query cache . please
Hi list,
We are using mysql 4.0.24 on RHEL 3.0 on dell 2650 machine with 2 gb RAM.
We tried to fine tune query cache . please find below the analysis
PARAMETER old
modified
== ==
query_cache_
Does anyone know if there are certified binaries for 4.0.x ? I think
I read somewhere that they will have it for 4.1 and later for 5 only.
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
May be DATA DIRECTORY, INDEX DIRECTORY table options will
be helpful for you. See:
http://dev.mysql.com/doc/mysql/en/create-table.html
Ananda Kumar <[EMAIL PROTECTED]> wrote:
>i Friends,
>I am new starter in MYSQL, but have worked extensively in oracle. I wanted
>to know ho
Hello.
> i'm having a backup of the entire drive, but no dump.
In what way have you done the backup of the drive? Do you
have an archive with files from the corrupted drive or
a raw image (snapshot) of the file system?
If you have an archive you can just copy the data
directory to
Yes, you can use the same process. You will need to modify your existing
code so that you get the data from Oracle and write it to MySQL. You will
be able to reuse most, but not all, of your existing script. Those
portions that connect to your destination server and write data into the
databa
2005/9/15, Julien vander Straeten <[EMAIL PROTECTED]>:
> hi all,
>
> my machine crashed and i'd would like to restore my mysql databases
> on my new system.
> i'm having a backup of the entire drive, but no dump.
>
> my system is mac os x.3 server.
> is there a way to drag&drop some folders to my
HI,
I have granted all privileges to a user to connect from any host like below
grant all on *.* to [EMAIL PROTECTED] identified by 'password';
flush privileges;
when I tried to connect to database using ip address like below on the
server where databas
Hi Mark,
thanks for your answer. See comments.
>
> Stefan,
>
> Something is closing the network connection abrubtly between JDBC and
> your MySQL server. Things to check are:
>
> 1) Connections don't sit longer than 'wait_timeout' on the server.
I am actually using connection pooling (the torque sy
All,
Could you please tell us what are the differences between ORACLE SQL plus
and MYSQL SQL?
Thank you :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No. You will need to use an application external to the server to perform
the data collection process. This application can be one you write
yourselves or something you purchase. There are many ways to perform
things on a schedule:
a) you application continuously runs and performs certain actio
hi all,
my machine crashed and i'd would like to restore my mysql databases
on my new system.
i'm having a backup of the entire drive, but no dump.
my system is mac os x.3 server.
is there a way to drag&drop some folders to my new system?
thanks for your help :-)
julien
--
MySQL General
At 11:31 AM 9/13/2005, you wrote:
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version and 2.4
>Description:
The letter 'ö' (o umlaut) and Danish 'ø' are treated as equal causing
duplicate key problems. They are not !
Check also 'ä' and 'æ' which are not equal.
It was present in 4.1.8 and is present in 4.1.14.
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator
Hi Ananda,
I am not sure what do you mean by connecting MySQL to Oracle:
* Is it a permanent connection
* Do you want to transfer data from one to the other
* or ?
Mikhail Berman
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:33
Ananda Kumar <[EMAIL PROTECTED]> wrote on 09/15/2005 10:33:16 AM:
> Hi,
> How can i connect from MYSQL db to an oracle database. Do we need to
create
> any database link or use some ODBC.
> Please help
> regards
> anandkl
The only way to get one MySQL database server to directly manage data i
Hi,
How can i connect from MYSQL db to an oracle database. Do we need to create
any database link or use some ODBC.
Please help
regards
anandkl
Hi
i use a sofware to connect to mysql and it can connect with succes but
wanted to share acces to mysql to many poeple and it popup
[MUSQL][ODBC 3.51 Driver] Transaction are not enable
Is ot a mysql server message or not ( my application )
thank's
--
MySQL General Mailing List
For list archi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan Kuhn wrote:
> Hi all,
> I have a Java webapp using a mysql database. It all used to run well, but I
> now frequently get the following error:
>
> 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation -
> com.mysql.jdbc.CommunicationsException: C
Hi list,
I have noticed that the key buffer usage (defined in MySQL Administrator
as Key_blocks_used *key_cache_block_size) always stays the same, and
that I have a large amount of Key_blocks_unused, which seems to me
there's a potential performance gain somewhere:
> show variables like 'key%';
Hi Friends,
I am new starter in MYSQL, but have worked extensively in oracle. I wanted
to know how we can place indexes of tables on different disk in MYSQL.
Generally in oracle we have the option of specifying the tablespace on
different disk. Can we do the same in mysql to disk contention.
I a
Scott Haneda <[EMAIL PROTECTED]> wrote on 15/09/2005 10:31:48:
> I have moved my data from mysql 3 to 4, across various updates, over the
> past few years. I use phpmyadmin generally, and it defaults to making
tables
> myisam.
>
> I can not seem to find a really clear answer as to why I want to
Hi all,
I have a Java webapp using a mysql database. It all used to run well, but I
now frequently get the following error:
2005-09-15 11:33:32,115 [Thread-23] ERROR rotation -
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCE
I have moved my data from mysql 3 to 4, across various updates, over the
past few years. I use phpmyadmin generally, and it defaults to making tables
myisam.
I can not seem to find a really clear answer as to why I want to use one
over the other. Generally, I use myisam and change it only when I
I have not identified which options to use to have the current value of the
AUTO_INCREMNT included in the dump file.
Is this possible?
--
Jacques Brignon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UPDATE forums_members,members
SET forums_members.active=members.active
WHERE
forums_members.member_id = members.id
Oh, I see. I now feel a little foolish as I should have grasped that.
For some reason I assumed that by specifying where to get the data from,
it would be assumed that's what t
2005/9/15, Dave <[EMAIL PROTECTED]>:
> MySQL General List,
>
> Server specifications:
> MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
> My specifications:
> MySQL beginner, PHP intermediate, HTML and CSS advanced.
>
> The situation:
> I have two tables, one old, and one new. In bo
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have two tables, one old, and one new. In both tables I have a
column called "active", which is either
49 matches
Mail list logo
