In the last episode (Jan 13), EP said:
> I am wondering:
>
> I can see the MySQL data files for my various databases.
>
> What technically prevents me from simply copying those files and using
> copies
> - to move my database to another file structure or server
> - to back-up my current db
Abso
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using copies
- to move my database to another file structure or server
- to back-up my current db
Yes, I did put my finger in the electrical socket as a kid.
* Matthew Stuart
> Right having just got to grips with the mysqldump command, I would like
> to be able to know how to import the database back in to MySQL should
> anything happen to my PC.
Good thinking. :)
> Does mysqlimport have to be done in the command line window like
> mysqldump, and if s
Here is how.
http://forums.devshed.com/archive/4/2001/3/3/12143
Regards,
-Martin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 13, 2004 8:15 PM
Subject: Looking for a tool
> Several years ago, I used a cgi based tool that allowed me to uplo
Hi Mat
mysqldump produces files containing SQL statements. mysqlimport allows
you to load data from comma-delimited (or other) text files.
For example, the following line will dump the contents of the table
'goat_painters' in the database 'the_goat_database' into a file called
'goat_painters.
phpMyAdmin will do it.
http://www.phpmyadmin.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 January 2004 01:15
To: [EMAIL PROTECTED]
Subject: Looking for a tool
Importance: High
Several years ago, I used a cgi based tool that allowed me to upload a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.10, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.10 is a bugfix/performance release for the STABLE tree.
It is now available in source and binary form from the Connector/J
downl
Matthew Stuart wrote:
Right having just got to grips with the mysqldump command, I would
like to be able to know how to import the database back in to MySQL
should anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just th
* Antonio De Luna
> I've a second look to de csv file and the format of the date is
> 09/14/1988, so I think it's easier to load it to the mysql date
> format, could it be done using mysqlimport, or LOAD DATA INFILE ??
You can read it into a varchar column and fix it later using something like
th
On Tue, 2004-01-13 at 01:58, Prasad Budim Ram wrote:
> Hi All,
>
> Is there any AS3AP benchmark suite readily available for MySQL?
Ram,
Yes but you're asking it in the wrong place :)
It is still not published to the public (we plan to publicly open our
Benchmark BitKeeper tree later this month)
Several years ago, I used a cgi based tool that allowed me to upload a csv file to a
server and load the data into either a new table or an existing table.
Anyone happen to know of one like it now. I can't seem to find it in my archives
anymore.
I know I can do it with load data infile, but I
I've a second look to de csv file and the format of the date is 09/14/1988,
so I think it's easier to load it to the mysql date format, could it be done
using mysqlimport, or LOAD DATA INFILE ??
Thanks
On Tuesday 13 January 2004 18:24, Antonio De Luna wrote:
> Hi, I've got a csv archive with
Mike Tuller wrote:
I have a shell script that is supposed to connect to a remote server running
MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES)"
The script looks like this:
/usr/local/mysql/bin/mysql --user=$username --passwo
Right having just got to grips with the mysqldump command, I would like
to be able to know how to import the database back in to MySQL should
anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just that I tried to import st
Matthew Stuart wrote:
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is called
the system command line to be the mysql client environment. The tutorial
book that I have been going through ins
Antonio De Luna wrote:
>
> Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a
> date field with the mysql date format (ISO ? ) 2003-02-15 ?
Well, if you're a Unix type, then you could pipe the input through a
small Perl script:
#!/usr/bin/perl -w
while (<>)
{
> Hi, I've got a csv archive with a date field 15/02/03, how can I load
> it to a date field with the mysql date format (ISO ? ) 2003-02-15 ?
>
> thank you
>
I wouldn't mind knowing this too, my work around is doing it in php using
fgetcsv to extract the csv data, finding the right rows and colu
These are completely different programs so you shouldn't have any problems. I've never
run into mention of any conflicts listed in the MySQL docs. You might check the docs
of the other applications. I know the MSSQL and MySQL can co-exist.
--
MySQL General Mailing List
For list archives: http:
Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a
date field with the mysql date format (ISO ? ) 2003-02-15 ?
thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are you logged on as Administrator?
Is there enough disk space free?
Does it generate the same error if you try re-installing?
Is there an existing installation with the server still running?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Dear Mike,
Thanx for the quick reply. I did what you specified on
your rely.
There is --with-mysql argument but is not set it is
just '--with-mysql'
does it mean I have to recompile it again?
cheers,
Bereket
--- Mike Johnson <[EMAIL PROTECTED]> wrote:
> From: Aron Bereket [mailto:[EMAIL PRO
Thanx for the quick reply peter.
That of one of the things I did when I had the
problem. It was not enabled. But when I enable it it
gave me mysql.so doesn't exits. I checked it on the
path there is not mysql.so.
cheers,
Bereket
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> check your php.ini to
From: Aron Bereket [mailto:[EMAIL PROTECTED]
> Hi there,
>
> I have recently installed mysql and php on my mechine
> and both work fine. But when i wrote an HTML/Php to
> access my databse I got the following error message:
>
> Fatal error: Call to undefined function:
> mysql_pconnect() in /var/
Hi there,
I have recently installed mysql and php on my mechine
and both work fine. But when i wrote an HTML/Php to
access my databse I got the following error message:
Fatal error: Call to undefined function:
mysql_pconnect() in /var/www/html/employee.php on line
48
I tried also with mysql_rea
Even though Napmarilu and localhost are resolving to the same machine, they are
different host names. MySQL security uses a combination of username and hostname in
the form of: [EMAIL PROTECTED]
That means that [EMAIL PROTECTED] is a different user than [EMAIL PROTECTED] Since you
have the Co
I get the following access denied error:
Warning: mysql_pconnect(): Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\Apache\Apache2\html\C2R\catalog\includes\functions\database.php on
line 17
Unable to connect to database server!
Why Is this happening and how can I fix it?
Steve,
This is on Server 2003 Enterprise Edition. TCP/IP is installed, so I have
not a clue. I know it should be using the IP address of the machine or the
Machine name instead. Well At least I need it to function that way
eventually, cause this is for a client.
Chris L. White
Network Administ
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing recurs
Hiya all!
I'm curious about if there's a simple way to manage user quotas in a MySQL
database? F.x. user one can have 10MB data in the database and user two can
have a maximum of 5MB?
Anders Norrbring
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On 13 Jan 2004, at 19:49, Chris L. White wrote:
Ok I was able to use mysqlcc and as long as I keep the host name
localhost
it will let me in. But the name of the host should be Napmarilu or
the IP
number right? When you change it to either one of those it will not
let you
in. So how would I
> > Based on a guess, or did you analyze the data file I sent?
>
> Based on your data.
.. ..
> And of course I tried this myself before writing to you :)
Cool. Thanks for the analysis.
> > And if so, may I suggest that the upgrade documentation REALLY needs to
> > be broke
Hi!
On Jan 13, Joe Rhett wrote:
> > Not a bug.
> > In the manual, section "Upgrading from Version 3.23 to 4.0", there is
> >
> >* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
> > you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
>
> Based on a guess
I have a shell script that is supposed to connect to a remote server running
MySql 3.23.53. It comes up with an error "ERROR 1045: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES)"
The script looks like this:
/usr/local/mysql/bin/mysql --user=$username --password=$password
cetech
Birju Shah wrote:
Hello,
Thankyou for your quick response.
When I start getting this error, the mysql crashes, any application which I
try to start which uses mysql backend, says mysql.sock error could not
connect .
-
DBI connect('database=search;host=localhost','web',...) failed:
On Tue, 13 Jan 2004, Priyanka Gupta wrote:
> Hi,
>
> I am trying to do some performance analysis by trying different indexing
> schemes and testing how long it takes. To get consistent results, I would
> like to use something like SQL_NO_CACHE. However, the mysqld version that I
> have installed d
I have somehow managed to create the datatype in COBOL matching
to C datatype and passed as argument to mysql_init and
mysql_real_connect.
My COBOL coding seems to working fine, but it could not able to
connect to MySQL and retrive Data. Instead it produce an error as;
Unknown MySQL S
I have been using adjacency lists to solve problems with hierarchical data.
The algorithm is described in a relatively database independent way here:
http://www.intelligententerprise.com/001020/celko1_1.shtml
And by the same author here: http://www.dbmsmag.com/9603d06.html
Includes a tiny bit more
Hi,
I am trying to do some performance analysis by trying different indexing
schemes and testing how long it takes. To get consistent results, I would
like to use something like SQL_NO_CACHE. However, the mysqld version that I
have installed does not seem to support it..its 4.0.16
Could anyone
> Not a bug.
> In the manual, section "Upgrading from Version 3.23 to 4.0", there is
>
>* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
> you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Based on a guess, or did you analyze the data file I sent?
And
>I want to have all the items into a recorset with only one query like
>Select id, reference, component from NOMS where reference = '4'
>but i want not only the primary relations, i want all relations.
>Could somebody help a newbie like me?
It can also help to change the way you look at the r
Birju,
Here's a little Linux/Unix info for you.
The "/tmp/mysql.sock" in question is used for ipc (Inter Process
Communication). This allows other applications to communicate with the mysql
server without using a "TCP/IP" connection. This eliminates the need to pass
everything through the netwo
> >mysql> select Notice_ID from Notices where match (Text) against
> >('+pollution +control' in boolean mode);
> >Empty set (0.00 sec)
> >
> >mysql> select Notice_ID from Notices where match (Text) against
> >('"pollution control"' in boolean mode);
> >Empty set (0.02 sec)
> >
> >mysql> select No
Hi!
On Jan 12, Holm Tiffe wrote:
> >Description:
> mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
> >How-To-Repeat:
> Any acces over IP (not domain socket) crashes mysqld:
> #/usr/local/bin/mysqladmin: connect to server at 'install' failed
> error: 'Lost connection to MySQL server during q
Keith Bussey wrote:
...
Also, I'm running MySQL 4.0.13-standard, STRAIGHT JOIN doesnt seem to exist
for me ;p
I think it is actually STRAIGHT_JOIN...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Victoria Reznichenko wrote:
Andrew DeFaria <[EMAIL PROTECTED]> wrote:
I created the following .sql file to demonstrate a problem I'm
having. According to the manual:
If |ON DELETE CASCADE| is specified, and a row in the parent table
is deleted, then InnoDB automatically deletes also all
Matthew,
http://www.innodb.com/ibman.php#InnoDB_Monitor
"
Starting from 3.23.44, there is innodb_table_monitor with which you can
print the contents of the internal data dictionary of InnoDB.
"
The output format is not beautiful, and you have to manually reconstruct the
MySQL CREATE TABLE stateme
Ok I was able to use mysqlcc and as long as I keep the host name localhost
it will let me in. But the name of the host should be Napmarilu or the IP
number right? When you change it to either one of those it will not let you
in. So how would I fix this problem. However on the other hand mysqlad
On Mon, 12 Jan 2004, Viktor wrote:
> Hello mysql,
>
> Table-level privileges do not work at all... (on Windows)
Works fine for me:
4.1.1a-alpha-max-nt:tmp >GRANT SELECT ON tmp.tmp TO [EMAIL PROTECTED]
IDENTIFIED BY 'aaa';
Query OK, 0 rows affected (0.18 sec)
4.1.1a-alpha-max-nt:tmp >\q
Bye
Steve Folly said:
>
> However, I suspect this isn't the full story. Do you also want to
> see what components make up C003 and D003 in the same query? I
> think you're after a feature not yet implemented in MySQL - the
> 'CONNECT BY PRIOR' SELECT statement, just the ticket for
> hierarchical que
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with "all relations". Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | a
OK I got the database created and stuff; When in the MySQLAdmin screen
under databases it doesn't show under databases. That is the first problem.
And for some reason the MYSQLadmin screen list the local user name as
Administrator and will not let me change it. But I can get into the mysql
shell
At 11:53 -0600 1/13/04, Steve Buehler wrote:
I am trying to allow someone to access our mysql server that is
behind our firewall. If I open the firewall ports 3306-65000/tcp
the person can get through. If I just try to open up the port
3306/tcp, they can not get through. Is there another port
Our server works with remote access just with 3306/tcp. Maybe it's
something to do with what you are using to access mysql.
At 12:53 pm 1/13/2004, you wrote:
I am trying to allow someone to access our mysql server that is behind our
firewall. If I open the firewall ports 3306-65000/tcp the pers
I am using 4.0.17 rpm on Red Hat 7.3 (fully updated). I have a server
colocated at my local ISP, and my workstation is on ADSL behind a Netsys
router (the ADSL ISP uses PPPoE, don't know if that's relevant or not).
The server has RAID 1, and has always been 100% reliable (up since
2000). I have bee
I tried a lot of things. Knowing now:
MySql is listening at... INET, TCP, Port 3306.
Direct connection is possible! The server answered with its version.
But what is with broadcast? Because I don't known were the servers!
That is what I like to find out!
Do any buddy know how to call a MySQL ser
min(Value + 0) works. It's not the most direct way I've run into but it
does the job. I wonder why they didn't do something more common like the
"C" cast syntax (double) Value?
At 11:35 am 1/13/2004, you wrote:
ok... you might have two options:
1- (don't know if this will work)
do a min(cast(Va
I am trying to allow someone to access our mysql server that is behind our
firewall. If I open the firewall ports 3306-65000/tcp the person can get
through. If I just try to open up the port 3306/tcp, they can not get
through. Is there another port that I need to open also? I have tried
330
Sorry, here are the EXPLAINS of a similar case, where what I did was switch
the first two tables in the join, and make it LEFT not INNER (note: the query
may look a little odd, as I took out some of the fields I was selecting,
etc...to make it shorter ;p)
mysql> EXPLAIN SELECT t.profile_alias F
I'm attempting to install version 4.0.16
When I try to install the software I get an error that reads:
"An error occurred during the data move process: 103"
Can anyone give me any guidance on how to resolve this.
Thanks,
Ken
This e-mail and any files transmitted with it may contain inf
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
<[EMAIL PROTECTED]> wrote:
Similarly.
SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE "c:/aaa/dump.sql" from
ytbl_development;
(dump.sql file must NOT already exist)
zzapper (vim & cygwin & zsh)
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-
To all the InnoDB gurus out there:
I have a similar problem to this person's predicament, except my situation
is that I have all the innodb data and log files, but have absolutely
no .FRM files.
Are there any general tools for data recovery from InnoDB databases? Any
companies that can do this f
In the last episode (Jan 13), [EMAIL PROTECTED] said:
>
> This may have been mentioned.. I have not been recieving message for 12+
> hours now.. And it appears:
>
> Jan 13 01:23:49 cyclone tcplog: smtp connection attempt from 213.136.52.31
> Jan 13 01:23:50 cyclone sendmail[10674]: ruleset=check_
ok... you might have two options:
1- (don't know if this will work)
do a min(cast(Value * 100 as signed integer) / 100
2- or min(Value + 0.0)
and see what happens.
> -Original Message-
> From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 13, 2004 11:24 AM
> T
From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED]
> Hello.
> Table 1:
> Items
> id, Name
>
> Table 2:
> Properties
> id, Item, Name, Value
>
> I want select Items _and_ all thier props only if Item have specified
> property.
>
>
> Example:
> Table Item:
> 1, Mouse
> 2, Monitor
>
DOUBLE doesn't seem to be an option with CAST
At 10:31 am 1/13/2004, you wrote:
Could you CAST them first, then apply MIN?
> -Original Message-
> From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 13, 2004 9:56 AM
> To: [EMAIL PROTECTED]
> Subject: MIN with negative nu
From: Eve Atley [mailto:[EMAIL PROTECTED]
> I am attempting to construct a select statement in which I
> can find values between two fields: start, and end. I have
> tried using "BETWEEN" and comparing with <= and >=, but
> neither meet success. Can someone please set me straight?
> This is me
From: Michael B Allen [mailto:[EMAIL PROTECTED]
> I'd like to move some bookmarks in one database to another. The format
> of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly
> trucated):
>
> +--+--+--+-+-+
> ---+
> | Field
Couldn't it be something like:
WHERE ('a' IN ('a','b','c','d')
OR 'f' IN ('a','b','c','d')
OR 'g' IN ('a','b','c','d')
)
On Tue, 2004-01-13 at 15:34, Eli Hen wrote:
> Hello All,
>
> In MySQL it is possible to check if an element is existing in a group, like:
>
> ... WHERE 'a' IN ('a',
Hi everyone,
Excuse me for asking this question but I would like to know if I
can install and use other DBMSes like: PostgreSQL, Oracle, and Sybase.
I'm using Mac OS X v10.3.2, and MySQL v4.0.14
I like MySQL and haven't found a need for other DBMSes except that most
Job listings I come across requi
Could you CAST them first, then apply MIN?
> -Original Message-
> From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 13, 2004 9:56 AM
> To: [EMAIL PROTECTED]
> Subject: MIN with negative numbers in VARCHAR
>
>
> We have a table with floating point measurement values s
Hello All,
In MySQL it is possible to check if an element is existing in a group, like:
... WHERE 'a' IN ('a','b','c','d') ...
but that checks one element only.
I want to check if any element from a group exists in another group, like:
... WHERE ('a','f','g') IN ('a','b','c','d') ...
'a' in th
We have a table with floating point measurement values stored in VARCHAR's.
How can I get MIN in SELECT to evaluate these as numbers instead of strings
so negative value sort correctly? Right now I've kludged it as
MIN(SIGN(Value) * ABS(Value)). Is there a more straight forward way?
--
MySQL Ge
"Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sergei Golubchik wrote:
>
> >Hi!
> >
> >On Jan 13, Kurt Haegeman wrote:
> >
> >
> >>Hi,
> >>
> >>When trying to create a fulltext index on my large table, I get the
> >>following error:
> >>
> >>ERROR 1034 (HY000): 121 wh
I am attempting to construct a select statement in which I can find values
between two fields: start, and end. I have tried using "BETWEEN" and
comparing with <= and >=, but neither meet success. Can someone please set
me straight? This is meant to be in a PHP page, but I'm assuming the syntax
is
ouch
To Jimmy and Chris and the list in general. This list is particualiarly kind to
question of this nature. I for one appricate it. In this case it is amazing how
many wrong things I came up with.
On Tue, 13 Jan 2004, Chris Elsworth wrote:
> On Tue, Jan 13, 2004 at 02:03:26AM -0500, [EMAIL
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is
called the system command line to be the mysql client environment. The
tutorial book that I have been going through instructs me to issue this
Viktor <[EMAIL PROTECTED]> wrote:
>
> subj.
> It's inconvenient, because one should get source distribution and
> compile this tool.
>
You can use comp-err.exe from older packages.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita
Birju,
What messages do you get in the mysql log file? The message you're
getting from perl just says that the database is not available. Before
you try to restart mysql, have you checked to see if there are still
mysql processes running (ps -eax |grep -i mysql). Have you run myisamchk
on the table
At 03:52 AM 1/13/2004, Harald Fuchs wrote:
SELECT *
FROM tbl
WHERE user = 'jones'
AND '/data1/index.php' LIKE concat(path, '%');
Thanks for the tip.
Bob
==
Bob Ramsey Applications Development & Suppo
Matthew Stuart wrote:
I am really struggling with a mysqldump. I am trying to create a dump of
a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes af
Xavier Fernández i Marín wrote:
>
> Hi,
>
> I've been inserting a csv file of about 150Mb into a mysql database. The
> problem is that there is no enough free space on the hard disk, and the
> process have been collapsed.
>
> Now I've been trying to access to the database to drop the table and c
Scenario:
Client gets a connection from MySQL. The client process is killed i.e.
client does not close the connection to MySQL.
Observation:
When I use "Show ProcessList" command to look at all the open connections,
the connection with the client (terminated abnormally) doesn't show up in
the l
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
<[EMAIL PROTECTED]> wrote:
>I am really struggling with a mysqldump. I am trying to create a dump
>of a complete database called csi_db01 and I am trying to save the dump
>file to My Documents on the C drive.
>
>I am sure I am doing right, but c
Victoria, sorry for waste your time with this =(
Just is a EMS MySQL Manager 2.0.1.4's error, from command line (mysql) works fine; the typo was writing the mail.
Alejandro.
---Mensaje original---
De: Victoria Reznichenko
Fecha: 01/13/04 11:04:50
Para: [EMAIL PROTECTED]
Asunt
>I am really struggling with a mysqldump. I am trying to create a dump
>of a complete database called csi_db01 and I am trying to save the dump
>file to My Documents on the C drive.
>I am sure I am doing right, but could somebody email me the full syntax
>to use which comes after the mysql>
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes after the mysql>
If I ca
On Tue, Jan 13, 2004 at 09:41:57AM -0400, Vernon Webb wrote:
> I've been asking around for awhile without a solution to this
> problem and thought I'd post it here perhaps some one will know of a
> script that will help.
>
> I need to have emails sunmitted to a database field but more to the
> poi
Andrew DeFaria <[EMAIL PROTECTED]> wrote:
> I created the following .sql file to demonstrate a problem I'm having.
> According to the manual:
>
>If |ON DELETE CASCADE| is specified, and a row in the parent table
>is deleted, then InnoDB automatically deletes also all those rows in
>t
I've been asking around for awhile without a solution to this problem and thought I'd
post it here perhaps some one will know of a script that will help.
I need to have emails sunmitted to a database field but more to the point I need to
have the attachment stripped and added to MySQL. People wi
"adburne" <[EMAIL PROTECTED]> wrote:
> I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
> mysql's page example to test but makes an error:
>
> mysql> delimeter |
You made a typo. You should write 'delimiter'.
>-> create function hello (s char(20
hi - ive been playing with the OGC support for WKT but cant find data type size
constraints for GEOMETRY types. does anybody know what they are? Ive a polygon with >
140,000 bytes as WKT but inserts all produce a NULL geometry...
any ideas?
regards
"Programming today is a race between softw
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
version with the --with-rai
On Sat, 2004-01-10 at 12:04, Bernard Clement wrote:
> Hello Aman,
>
> For instructions on taking the exam in India goto the URL:
> http://www.vue.com/mysql/ and click on "test center" of "To register for exams
> in India, please contact the test center directly. This will bring you a
> window
Hi!
On Jan 13, Kurt Haegeman wrote:
> Hi,
>
> When trying to create a fulltext index on my large table, I get the
> following error:
>
> ERROR 1034 (HY000): 121 when fixing table
>
> I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
> version with the --with-raid option.
I have tried two ways of dumping data but it doesn't seem to be working.
One using the admin window with mysqldump dbname > dumptest.sql but I
don't know if it has done anything because all it did was return to a
new blank line. I can't find anywhere a file named dumptest.sql
The other way was
Hi,
I've been inserting a csv file of about 150Mb into a mysql database. The
problem is that there is no enough free space on the hard disk, and the
process have been collapsed.
Now I've been trying to access to the database to drop the table and change
the directory where mysql stores the inf
Hello,
Many thanks for your reply!
I am currently syncronizing two MySQL servers (version 3.23.49) on a
very high traffic website.
There are, at peak times upwards of 600 updates a second (and many many
more selects)
During these times the slave database will fall out of sync, sometimes
by s
Hi Ya
I believe the Dos Mysql Client has limited table name completion, but
do any of the GUI Clients have this feature??
zzapper (vim & cygwin & zsh)
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
--
MyS
I'd like to move some bookmarks in one database to another. The format
of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly trucated):
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+---
Hi All,
Is there any AS3AP benchmark suite readily available for MySQL?
Thanks in advance,
Ram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 109 matches
Mail list logo
