(7¤ù¸Ë)¡Aµ´¹ï¶WÈ!(Á`ª÷ÃB: 1000¤¸)
Windows XP PRO SP-1 ¤¤¤å"±M·~"¥úºÐ¥¿¦¡ª©
Windows XP Service Pack 1¥]§t¤F±qWindows XP¥h¦~10¤ë30¤é¤W¥«¥H¨Óªº©Ò¦³×¥¿¡A
³o¨Ç×¥¿µ{¦¡¥]§t¤F¦b¦w¥þ©Êªº´£°ª¡A©Ê¯àªº¥[±j¤Î¿ù»~ªº×¥¿¡A
·íµM§ó¥[¤J¤F¥þ·sªºµwÅé³W®æ¤ä´©¡A¤×¨ä¬O USB 2.0ªº¤ä´©¡A
¦Ó¥þ·sªºWINDOWS XP°£¤F§ó·s¤F¨t²Î
Hello!
When I run this script the char-fields is converted to
varchar. Row-format is dynamic. I think it is because i have a text-field in
the
script. When I change the text field to somthing else I got the datatype
char in the char-columns. I have tried to alter the colums to char but it
doesn't
Hi..
Ok i have snort working and logging on my LINUX machine192.168.0.1. They are
alerts in /var/log/snort/alerts and portscan. I have it setup soo it is
suppose to log to my windows machine192.168.0.69 running MYSQL. I have been
using this as my reference:
http://www.sans.org/rr/intrusion/pra
I think you can't
If you want this why is this table structure? Details shold be as columns
nos as records in separate table - just to lose time ?
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell <[EMAIL PROTECTED]>
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form:
C
I have the follow MySQL queries for pulling out ans then inserting a
>record from
>a record set. Unfortunately I think I have missed something (vital) as the
>record being inserted is the value and not the name, for example 1 instead of
>blue... can someone kindly have a look and spot where I hav
Hi All,
I have mysql 3.23.41 on windows 2000
I have two questions I need to ask.
1) I want bigger value for the max_connections variable.
can I define the value in my.ini file? how can I define this variable?
2) I tried to insert into table a string with the char ' and mysql failed to
do thi
Rob,
This is a common problem in document management, where I have a reasonable
amount of experience.
Unfortunately, the short answer is, that to be completely generic, efficient
and elegant, it's a bit of an impossible problem.
What we have always done in this situation is to maintain an additi
I really am running it all again !
Obviously though I am going wrong somewhere...
I have killed it all and run it again 3 times now
and getting the same errors, I think it is
because I have done it so many times now...
I have copied and pasted everything that i have
typed (sorry that it is quite al
Thanks. Awesome idea. We'll probably use that :-)
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: Andy Eastham [mailto:[EM
Hi!
On Feb 11, [EMAIL PROTECTED] wrote:
> >Description:
> MAX fails to return the correct value in some MERGE table situations.
Fixed, thanks.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / //
Hello,
I'm using this command into a Java servlet
LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news";
It runs well with mysql-3.23.45 but not with mysql-3.23.55
The error message is :
java.sql.SQLException: General error: The used command is not allo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello List,
I am realy stucked. My Application (C++,OS9) needs to connect to a
MySQL-Database. But I can't find any informations how I can do that.
Maybe you can give me a hint?
Thats what i tried:
1. I found http://www.openlinksw.com/ (ODBC). Bu
Hi,
The approach I am suggesting is the one that you might use as a last resort.
I do not know much about C/C++ programming in OS9.
If you could find some ODBC Driver ( or any other API that can be used from
C++ on OS9 ) that could talk to JDBC drivers, then you may connect to MySQL
from JDBC, and
MySql,
I was trying to create a table named 'con' on version 3.23.52-max-nt and
found my request was ignored:
mysql>
create table if not exists con (
code integer unsigned not null auto_increment primary key,
...
...
) type=innodb;
Query OK, 0 rows affected (0.00 sec)
A 'show ta
* Ben Clewett
> I was trying to create a table named 'con' on version 3.23.52-max-nt and
> found my request was ignored:
>
> mysql>
>create table if not exists con (
> code integer unsigned not null auto_increment primary key,
> ...
> ...
>) type=innodb;
> Query OK, 0 rows af
To perform correct ORDER BY I need to use win1251 charset.
I know that this can be set from my.cfg or in the my.ini:
[mysqld]
default-character-set=win1251
The problem is that I cant use this because I have limited account on
my hosting provider's server (I can't restart the server and I even
do
Hi all,
please let me now if there is a solution to this.
I am facing the same problem.
Anis
>>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12,
>2003 3:48:16 PM >>>
Hello,
I'm using this command into a Java servlet
LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INT
hi all
i have established a two way replication setup
my problem is that my hard disk gets occupied by the log files;
i tried purging the files but after some time again my hard disk gets filled
with the log files
could any one please tell me how to manage the log files.
thanks
anirudh
mysql, q
Hi!
I have posted this message yerstaday, but apperantly
did not give enough information for reader to figure out
what's going on. So, i am reposting it with more information.
I have the following table:
create table law_words (
l_id int unsigned not null,
w_id int unsigned not null,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz said...
%
% MyISAM tables (the default table type in MySQL) become fragmented
...
%
% If you don't optimize fragmented MyISAM tables, they will become slow
% to scan because the operating system will need mor
I too would be interested in a good way of clearing the binary log files
(preferably non disruptive to the server ;-)
The only thing thats saving me so far is that the systems capacity is 320Gb.
danny
Anirudha Kukreti wrote:
hi all
i have established a two way replication setup
my problem is th
On Wed, 12 Feb 2003 15:50:29 +0300
Artem Koutchine <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I have posted this message yerstaday, but apperantly
> did not give enough information for reader to figure out
> what's going on. So, i am reposting it with more information.
>
> I have the following table:
Hello:
Because you have a variable length column type (text) in the row, mysql
changes char() types to varchar. This behavior is discussed in the
manual in Silent Column Change Specifications under CREATE TABLE.
If the stored length of these columns is an issue, you can move the
variable length
this is probably an issue already solved or at least treated on this list - so please
forgive.
nevertheless
I encountered the error 2013 when i tried to connect from another machine to the
machine holding the mysqlserver running with the standard mysql package resp. the
updated mysql package
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Hi all,
please let me now if there is a solution to this.
I am facing the same problem.
Anis
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, 2003 3:48:16 PM >>>
Hello,
I'm using this command into a Java se
MySql,
Version 3.23.52-max-nt
I cannot drop a table. My syntax is:
drop table if exists cust
I get:
MySql Error: Count not execute command [drop table if exists cust] on server
because: Unknown table 'cust'
This is true, it does not exist, although I still have a cust.frm file for
some reaso
But you're not using the word search engine, which would be the full
text index. I'm not sure what you mean by "morphology". MySQL 4 full
text searches support a lot of things, including using * as the
truncation operator.
Aside from that, perhaps it's the speed of your processor that
bottlene
Thanks Mark,
I tried to work with the latest driver. 3.0.4
Now it gave error shown below . Also see code snippet below at the
end
Error code is0
estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying
IOExcepti
on:
** BEGIN NESTED EXCEPTION **
java.io.FileNotFoundException
esto
Hi Edward,
Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports
structure, data, indexes, queries and relationships from MSAccess and it's
totally free.
[]s
Crercio
- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Thanks Mark,
I tried to work with the latest driver. 3.0.4
Now it gave error shown below . Also see code snippet below at the
end
Error code is0
estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying
IOExcepti
mysql:ÄúºÃ!
ÐÂÕ¾¿ªÕÅ,ÐÝÏкÃÈ¥´¦,ÇëÄúµãÆÀÒ»ÏÂ.
Ö÷Á¦Õ¾£º¡¡http://fenggwx.126.com
Á÷ÐиèÇúÒôÀÖÕ¾£º http://yinyuewx.126.com
FlashÕ¾£º http://flashwz.126.com
¼«Æ·Ð´ÕæÍ¼Æ¬Õ¾£º http://jpxzw.126.com
ÍøÖ·Õ¾£º http://webwz.126.com
ÖÂ
Àñ!
¡¡¡
Yes Mark it worked from the command line.
The Archived resides at the server side.
I ran Load data local infile 'sys:\\mail\\dump.txt" into table X
it worked.
The from a different machine i ran this java program. The Archived
file still exists at the DB server side.
So i guess local option
Ulla,
> When I run this script the char-fields is converted to
> varchar. Row-format is dynamic. I think it is because i have a text-field in
> the script.
This MySQL feature (silent column type change) is documented here:
http://www.mysql.com/doc/en/Silent_column_changes.html
Regards,
--
Ste
Viktor,
> I have a couple of tables in a MySQL database. In one of the tables,
> PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and
> ID 22. Any idea why?
Have a look at the table structure. You will find 'ID' is an
AUTO_INCREMENT column. When entries are deleted, they leave "gaps
MySql, magor problems!
Ver 3.23.52-max-nt
I find I cannot create a table (in my db 'rr'), which probably caused my
previous posted problem. Works perfectly with MyISAM, but not with InnoDB.
No SQL differnce. When executing I get:
MySql Error: Could not execute command [create table if not exi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Yes Mark it worked from the command line.
The Archived resides at the server side.
I ran Load data local infile 'sys:\\mail\\dump.txt" into table X
it worked.
The from a different machine i ran this java program. The Arch
* Ahmed S K Anis
[...]
> String filepath = "sys:\\restore\\data1.txt";
> String query = "load data local infile \'" + filepath + "\' into table
> x
>
> it takes as estoredata1.txt as file name not clear why ?
A double backslash will in many environments be reduced to a single
backslash. Your
I've recently learned that Oracle has the ability to partition table
data, Oracle9i's list partitioning feature.
http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
I'm trying to find out if MySQL or any open source database has
something equivalent to this.
---
No, I do not believe that MHZ is the bottle neck. Basically,
we can ignore that this is a dual box, because it is a
FREEBSD and only one CPU runs a whole process.
650Mhz is enough for doing a little web search engine and
I have seen a lot of applications which use the same technology
(vocabulary t
In the last episode (Feb 12), Jeff Bearer said:
> I've recently learned that Oracle has the ability to partition table
> data, Oracle9i's list partitioning feature.
>
> http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
>
> I'm trying to find out if MySQL or any open source databa
Hi
Is there a licence free way to Import (and Export) Access databases (mdb
files) into (out from) mySQL?
I've read the FAQs and looked at the converters available but it appears to
me that all of these require the Access program to work.
Is there any way of converting to/from MDB files without
Heinz
great hint - poor success
actually installed is 2.2.93
if i force it in maybe mysql functions - other thing will fail in bulk.
kr mr
>>> Stefan Hinz <[EMAIL PROTECTED]> 02/12/03 15:41 PM >>>
Markus,
If you're lucky, you might be able to use this RPM:
ftp://ftp.suse.com/pub/suse/i386/u
> On Wed, 12 Feb 2003 15:50:29 +0300
> Artem Koutchine <[EMAIL PROTECTED]> wrote:
>
> > Hi!
> >
> > I have posted this message yerstaday, but apperantly
> > did not give enough information for reader to figure out
> > what's going on. So, i am reposting it with more information.
> >
> > I have the
Hello,
I have two servers each one has mysql 4.1 running with seperate disks
Is there a way that the 2 mysqld have exactly the same data
(besides replication) ?
Is there a way that if one server crashes mysql will be avaliable?
Does mysql 4.1 have any extra culstering capabilities?
Thank you
Hi All,
Downloaded
mysql-standard-4mysql-standard-4.0.10-gamma-sun-solaris2.8-sparc.tar.gz.
If this is NOT installed in /usr/local/mysql and you try and start it using
support-files/mysql.server it fails with error:
$ ./support-files/mysql.server start
./support-files/mysql.server: /usr/local/my
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kissandrakis --
...and then Kissandrakis Giorgos said...
%
% Hello,
Hi!
%
...
% Does mysql 4.1 have any extra culstering capabilities?
I don't know about mysql directly, but I'm sure it would work just fine
as an application under an OS cluster.
> Is there a licence free way to Import (and Export) Access
> databases (mdb files) into (out from) mySQL?
>
> I've read the FAQs and looked at the converters available
> but it appears to me that all of these require the Access
> program to work. Is there any way of converting to/from MDB
> f
Any idea at all, anyone?
Cheers,
Andrew
-Original Message-
From: Andrew Braithwaite
Sent: 11 February 2003 17:52
To: [EMAIL PROTECTED]
Subject: mysql privs table level security
Hi all,
Can anyone help me please?
I have a database with hundreds of tables and I want to lock down certa
> I've recently learned that Oracle has the ability to partition table
> data, Oracle9i's list partitioning feature.
> http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html
> I'm trying to find out if MySQL or any open source database has
> something equivalent to this.
See the My
I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign
Keys to create.
The help files give this example:
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE SET NULL
) TYPE=INNODB
I have a configuration under MySQL 4.0.5a using many slaves and one master
under Linux 2.4.18.
The slaves always crash when using the command "load data infile" to
populate a table on the master (the table exists on the slaves).
Maybe this could help:
- The master and the slaves are bind on a spe
Write a script that generates all the GRANT SQL ?
Then pipe it into mysql.
I'd write a function that would go and get all the table name and a list of
the relevant users then generate the sql from there.
Jerry
-
Jeremy Hutchings
Apps R&D
Cable and Wireless
--
Does any one have a suggestion on running a daily / weekly e-mail
notification based on results from a MySQL query?
I have a table with date sensitive rows. The idea that as rows become
stale (they were created / updated more than a week or month ago) the
owner of the row is sent an e-mail wit
It seems like you are getting privileges systems mixed up. The MySQL server
has its own privileges system that is separate (sort of) from the filesystem
privileges system. All queries within MySQL will be handled by the MySQL
server privilege system. Within that system, you are able to control a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil --
...and then Neil Williams said...
%
% Hi
Hi!
%
% Is there a licence free way to Import (and Export) Access databases (mdb
% files) into (out from) mySQL?
I haven't seen one yet. It's quite possible that nobody has written a
file convert
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan --
...and then Dan Tappin said...
%
% Does any one have a suggestion on running a daily / weekly e-mail
% notification based on results from a MySQL query?
...
%
% I have a feeling that I will get a few 'buy a PERL book' suggestions
% which is
On Wed, 12 Feb 2003, Dan Tappin wrote:
> Does any one have a suggestion on running a daily / weekly e-mail
> notification based on results from a MySQL query?
>
> I have a table with date sensitive rows. The idea that as rows become
> stale (they were created / updated more than a week or month a
It won't work because MySQL doesn't count null values.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 8:18 AM
Subject: Re: Counting null values
Hi
Can I create my own my.cnf file if I am not the administrator of MySQL but I
just have a database?
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:
It seems like you are getting privileges systems mixed up.
No, I understand and have extensively read the below docs & more. Going
down to the filesystem level is a nasty work-around to the problem. I want
to know if there is any way to set certain tables to have SELECT only
privileges witho
At 9:41 +0200 2/12/03, Octavian Rasnita wrote:
It won't work because MySQL doesn't count null values.
It depends.
count(FieldName) will not count NULL values
count(*) will, because it counts rows, not values.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Origina
Thanks to all that responded to my questions about Full Text Searching.
Being caught up in that paradigm I overlooked the simpler answer :)
I am now experiencing a problem with pulling data from a Text (longvarchar)
field in MySql. The data is entered into a TEXTAREA field on a web page and
f
I use perl for this.
Something like this:
--
#!/usr/bin/perl
use MIME::Base64;
use Mail::Sendmail 0.77;
$email = '[EMAIL PROTECTED]';
$subject = 'some stuff here';
$entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here'
somedatabase`;
$ma
: Does any one have a suggestion on running a daily / weekly e-mail
: notification based on results from a MySQL query?
In your cron file do something like:
echo "select * from table" | mysql [options] db | mail
[EMAIL PROTECTED]
If it's a more complex query:
cat ~/quer
There's a relatively low-cost ODBC utility called DBScripter that does a
pretty good job creating scripts for exporting ddl and data from ODBC
datasources. It allows you to build dialects for server-based SQL
variations. I don't think that there's a current MySQL dialect, but looks
pretty simple
On Wednesday 12 February 2003 13:49, Mirko wrote:
> To perform correct ORDER BY I need to use win1251 charset.
> I know that this can be set from my.cfg or in the my.ini:
>
> [mysqld]
> default-character-set=win1251
>
> The problem is that I cant use this because I have limited account on
> my hos
On Wednesday 12 February 2003 11:30, Inbal Ovadia wrote:
> I have mysql 3.23.41 on windows 2000
> I have two questions I need to ask.
>
> 1) I want bigger value for the max_connections variable.
>can I define the value in my.ini file?
Yes.
> how can I define this variable?
set-variable=max_
On Wednesday 12 February 2003 10:21, Ulla Wensman wrote:
> When I run this script the char-fields is converted to
> varchar. Row-format is dynamic. I think it is because i have a text-field
> in the
> script. When I change the text field to somthing else I got the datatype
> char in the char-colum
has anyone managed to compile mysql control centre for freebsd (4.5 or
lower)? i am on the verge of giving up: my attempt to compile qt3 is
failing since qt seems to require the threads libraries even if i
configure with -no-thread, and without qt3 i cannot compile control
centre. of course if yo
I am interested as to why no one seems to be using the DBI/DBD-MySQL
perl modules?
Something like:
==
#!/usr/bin/perl
use strict;
use warnings;
use diagnostics;
use DBI;
my $dbname = 'DBI:$driver:database=database;host=dbserver.blah.com';
my $dbuser = 'dbusername';
my $
> Subject: RE: Recursion
>Date: Wed, 12 Feb 2003 09:36:11 -
>From: "Andy Eastham" <[EMAIL PROTECTED]>
> To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]>
>
> Rob,
>
> This is a common problem in document management, where I have a reasonable
> amount of experience.
>
> Unfortuna
I've used urSQL (http://www.urbanresearch.com/ursql) to accomplish this
for quite some time. You can click on an MS Access table and select
"Build Script as MySQL" to get a MySQL-like CREATE TABLE script...
On Wed, 12 Feb 2003, Christensen, Dave wrote:
> There's a relatively low-cost ODBC utili
I access a msyql server (apache/mysql/php) from my w2k workstation using
phpMyAdmin.
I do not have command line access.
When I use the link to load a local data file it responds that it is not
allowed. I read the
mysql docs and see it is now disabled by default. In 4.2.4 one paragraph
says "If y
Hello friends!
How do I create a new user on MySQL? I want to create the respective
password too.
Thanks,
e.
_
MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com
--
Amer,
It's still worth storing the parentId, because you can easily recreate the
fullpath if (when!) your code screws up a set of full paths. You can also
write a reliable sanity checker that checks the full path of all the nodes
in the table based on the parentids.
Also, to locate multiple chil
I'm running Redhat 8.0, and can't seem to get mysql-embedded to work.
After installing the current 4.0 RPMs, I get a lot of errors when trying
to compile the sample program as described here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example
[root@gw nwetter
RTM: http://www.mysql.com/doc/en/GRANT.html
Also see http://www.catb.org/~esr/faqs/smart-questions.html
-Original Message-
From: Elby Vaz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 10:39 AM
To: [EMAIL PROTECTED]
Subject: [ Creating a new user ]
Hello friends!
Ho
whichever way I try, I'm having no luck compiling on redhat 8.0. I've
tried with the latest 3.23 and 4.0 tarballs, the latest pull from
bitkeeper, and the redhat SRPMs.
some details here:
http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=84137
Has anyone else had similar problems?
The reaso
I am interested as to why no one seems to be using the DBI/DBD-MySQL
perl modules?
Because it's twice as much code to do the same job. Why format your data
when the -H option to mysql can do it too?
Cheers,
A
-Original Message-
From: Karl Dyson [mailto:[EMAIL PROTECTED]]
Sent: 12
Here are some commands to add a new user. Do this from the MySQL prompt:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.tablename
-> TO username@localhost
-> IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
->
Greetings:
If you use Dreamweaver MX and are looking for a very easy way to
Web-enable your MySQL databases, please check out today's
announcement of the immediate availability of the first beta release
of Lasso Studio 6 for Dreamweaver MX.
Details at:
http://www.blueworld.com/blueworld/news/
In the last episode (Feb 12), Nigel Wetters said:
> whichever way I try, I'm having no luck compiling on redhat 8.0. I've
> tried with the latest 3.23 and 4.0 tarballs, the latest pull from
> bitkeeper, and the redhat SRPMs.
>
> some details here:
> http://bugzilla.redhat.com/bugzilla/show_bug.c
>Description:
There is a missing element in the texi file.
>How-To-Repeat:
N/A
>Fix:
--- mysql-orig/Docs/manual.texi Wed Feb 27 23:45:07 2002
+++ mysql-patched/Docs/manual.texi Wed Feb 27 23:44:49 2002
@@ -56,6 +56,7 @@
@ifinfo
@fo
Danny Haworth wrote:
> I too would be interested in a good way of clearing the binary log files
> (preferably non disruptive to the server ;-)
> The only thing thats saving me so far is that the systems capacity is 320Gb.
>
> danny
>
> Anirudha Kukreti wrote:
>
> >hi all
> >i have established a tw
Version: Mysql 4.0.10-gamma
Description: Mysql client loses connection when doing a multi-table delete if one
table is innodb and the other is myISAM.
How to Repeat :
drop table parent;
drop table child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id))
TYPE=INNOD
Version: Mysql 4.0.10-gamma
Description: ERROR 1105: Unknown error after issuing a multi-table delete on
parent/child table.
if there's no foreign keys .. works ok.
How to Repeat :
drop table parent;
drop table child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id
Hello!!
when I do mysqldump of a big table, the process is killed, and it is not
posible make the dump. I read in the
list of somebody who did a dump of database with 4G size. Which variable
it
is necessary to modify for making a dump using mysqldump, or it is
necessary to move a better machi
How would you export your data from the mysql tables to a tab or coma
delimiter.
Thank you,
Stephen A. Lewis
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
> How would you export your data from the mysql tables to a tab or coma
> delimiter.
There are lots of ways, here are my favorite two:
mysqldump: http://www.mysql.com/doc/en/mysqldump.html
phpMyAdmin : http://phpmyadmin.sourceforge.net/
--
Greg Donald
http://destiney.com/
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave & J, et al --
[re DBScripter and urSQL]
Those are nice tools, but if I read you correctly they only work if one
has MS Access. The original poster, if I read *him* correctly, wants a
way to read Access DB files and turn them into MySQL files --
Yes, I think you misunderstood. You don't have to own MS Access or have it
on your PC to use DBScripter. You DO have to set up an ODBC data source
that points to the Access database though. That process can be accomplished
without owning Access.
-Original Message-
From: David T-G [mailt
Neil Williams wrote:
Hi
Is there a licence free way to Import (and Export) Access databases (mdb
files) into (out from) mySQL?
I've read the FAQs and looked at the converters available but it appears to
me that all of these require the Access program to work.
Is there any way of converting to/
Hello, list,
I'm having a weird issue with table locking. I'm running MySQL 3.23 on a
Win2k server, used for eCommerce applications.
All settings appear to be in order, that is, KeepAlive is 30, connection
pooling is on, with a timeout of 30.
The tables in any given database seem to remain loc
Hi,
My name is Eliran and I'm working at Rimed company in Israel.
We consider to use MySql as a database for our application.
I installed MySql 3.23 on window XP.
I want to know what I must do in order to be able to run the C++ example it
give me the following error: "Error: Unknown database 'mysql
94 matches
Mail list logo