MysqlFront is thé best tool for me.
http://anse.de/mysqlfront/download.php
Works on remote databases to, nice and smooth interface, exporting tables in
various formats,
export/import from one active db to another ...
B.
-Original Message-
From: Correale, Ernest [mailto:[EMAIL PROTECTED]
Seems fairly impossible to me to really emulate transactions on a
non-transactional db.
Even if you develop a system where you :
a. collect all queries untill the end and then perform them in 1 block
b. keep your own logs of the queries and be able to roll them back in case
of error
even then it w
Yes there is:
perror.exe located in c:\yourmysqldir\bin\
:)
-Original Message-
From: Christopher A. Libby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:16
To: [EMAIL PROTECTED]
Subject: PERROR on Windows
Is there a command like perror for the Windows version of MySQL?
You can use the winmysqladmin tool located in the bin directory to install
it as a service.
(I'm not sure wether this also works on a '98SE machine)
CB
-Original Message-
From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:00
To: [EMAIL PROTECTED]
Subject
Are you sure that you are starting mysqld-max-nt.exe for the server ?
If so, try mysqld-max-nt --print-defaults to see what parameters are set,
maybe that will give you a clue ...
CB.
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 00:19
>From the manual :
Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though.
CB.
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Ju
2 23:14
To: [EMAIL PROTECTED]
Subject: Re: high level: enabling transactions in mysql-max with
WebLogic TX datasource?
>>>>> "Bert" == Bert VdB <[EMAIL PROTECTED]> writes:
Bert> Hi,
Bert> all you have to do use a transaction enabled data-source and use
Hi,
all you have to do use a transaction enabled data-source and use the
Mm-MysqlDriver
for your JDBC connections. (http://mmmysql.sourceforge.net/)
Best is to read the InnoDB documentation carefully (http://www.innodb.com),
as you cannot choose from a wide
variety of transaction-levels ... in m
Add this to your my.cnf file :
# The MySQL server
[mysqld]
# Default table type for new tables
default-table-type=InnoDB
CB.
-Original Message-
From: Pierre Baridon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 12:09
To: [EMAIL PROTECTED]
Subject: default table type
how c
Oops, forgot to send it to the list:
Use an index and offset in your queries.
You need 25 queries per page(=the offset), each page starting display from a
different record (=the index)
This would give something like this for page 1:
$result = mysql_query("SELECT * FROM your_table WHERE table_
Hi,
I'm sort of glad we're not the only one having this problem.
Yesterday we had kind of the same error message on an Solaris 8 machine with
512Mb of ram.
Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by
the orion-web-server.
Today I will perform crash-tests on another
I think u just have to create exactly the same table in another database,
and then copy
the .frm file to the one where you lost the original one.
CB
-Original Message-
From: Jonathan Stockley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 00:20
To: [EMAIL PROTECTED]
Subject: H
Just for those people who have the same problem:
-Original Message-
From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 11:13
To: Bert VdB
Subject: Re: Binary data mysqldump and restore.
That did it thanks!
MWP
> Hi,
>
> Have you tried making a
Hello everybody,
I have a small question regarding to the Mysql-InnoDB-tables :
"Is it possible to use an Oracle-like 're-do logging' feature with InnoDB" ?
This means more or less taking regular consistent backups of your database,
and then in case of corruption, you restore the latest consis
Hi,
I have 2 version installed on my win2k machinge (.49 , .50 and .51)
As long as you install in different directories , take care of config files
and
don't try to start 2 server simultaniously, I don't see why this should give
problems.
(At least, I haven't got any problems ;) )
CB.
-Orig
Remote access for mysql database can be done with this tool:
http://www.anse.de/mysqlfront/
Its free, reasonably reliable and pretty easy to use (also for making dumps)
my.ini is found under /WINNT directory
my.cnf is found under the root dir (prolly C:\ for you)
=> this file is not obligated to
16 matches
Mail list logo
