I save it as a CSV and stick it through phpmyadmin...it can be a bit
clumsy (getting the delimiters to agree, mostly, which isn't exactly a
monumental hurdle) but it works great unless your sheet is bloody
massive and it runs past the timeout. I guess it'd be equally simple to
do a LOAD DATA INFIL
"Nitin" <[EMAIL PROTECTED]> wrote:
>
> I have a project in hand, where I need to accept and show data in Hindi language,
> storage doesn't matter. Is that possible with MySQL, if yes, what do I need to
> configure? How do I do it, any help or ideas?
>
No, but from 4.1 you can use Unicode.
-
Is there a way to use a string concatenating function in connection with a
GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders
relation), to "catch" a structure like:
firm | stocholders
f_1 | s_1; s_2; s_3
f_2 | s_4; s_5
f_3 | s_6
instead of
firm |
If you're using MySQL 4.1, you have the GROUP_CONCAT(expr) function.
If not, then... i think someone has already done an UDF about this...
Search the archives..or see this:
http://www.cwts.nl/buter/misc/my-mysql.html
--
Diana Soares
On Wed, 2003-11-12 at 08:56, Ciprian Trofin wrote:
> Is there
Scott H <[EMAIL PROTECTED]> wrote:
> Repost - Haven't gotten any response on this and
> can't find an answer. If no one on the mysql
> list knows, where does a fellow turn? Help!
>
>> Can't seem to find this one in the manual or
>> archives - how do I control a db to maintain
>> its size to an a
Friday, November 07, 2003, 2:51:10 AM, Brian Keck wrote:
BK> On Thu, 06 Nov 2003 11:01:31 +0200, Victoria Reznichenko wrote:
>>Brian Keck <[EMAIL PROTECTED]> wrote:
>>...
>>>The replication is limited to a database called mipradius by a slave config
>>>'replicate-do-db=myradius', though the master
Is SPADE support TUFT or 1256 code page ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everybody
Pardon me for mistake writing
Is SPADB support TUFT or 1256 code page ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everyone
Currently I am using SAPDB as DB engine and I know that it is supported
Unicode , but for a project I `d like to use Farsi
and In presentation when I use Unicode DB , there is no problem ...but in
some functions of engine like Sorting there is
a problem and it does not sort some 4
On Wed, 12 Nov 2003 12:14:05 +0200, Victoria Reznichenko wrote:
>Yes, 'mipradius' is a current database and if you use option 'replicate-do-db=
>mipradius', 'insert into mipsessions ..' query should be replicated. But in the
>first post you said about database 'myradius', is this a typo?
How embar
The documentation for MyISAM states two features that I am trying to find
more information on.
1) Max Keys Per Table, according to the documentation, can be increased from
the default 32 / Table to 64 / Table without recompilation. However, I am
unable to find how to do this anywhere.
2) Max Key
That returns rows that have any of 'A01', 'B02'. I need the rows that have
all of them. E.g. logical OR vs. logical AND.
- Original Message -
From: "Shane Allen" <[EMAIL PROTECTED]>
To: "Jonathan Terhorst" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2003 8:26 PM
Sub
if you dont want to write program:
use MsAccess.
thx
öö
- Original Message -
From: "Lists - Dustin Krysak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 7:20 AM
Subject: Import from excel to MYSQL
> Is there an easy way to get an excel spread sheet impor
Hi all,
How can I change the directory of the databases?
I have tries the basedir switch in the my.cnf [mysqld] section, but it did not work.
How should I do it?
Thanks,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
in my.cnf:
[mysqld]
datadir=/var/lib/mysql
-Original Message-
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: Changing Data Directory
Hi all,
How can I change the directory of the databases?
I have tr
Just an FYI, but you can also specify at startup of mysqld by passing the
"--datadir" option. This will override what is in your option file, until
the next restart.
> -Original Message-
> From: Arunas Milašauskas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 8:26 AM
> To
Ok, I was confused about the password thing. It works now that I'm passing
root's password in the command:
/usr/local/mysql/bin/mysqldump --opt --all-databases -prootpassword >
/usr/local/mysql/data/mysqldump
> You're joking, right? (Perhaps you thought the original question was a
> joke, too, a
Why would you created separate fields for each quarter? Create a field
called quarter and store a number in it. You could also combine year,
month and day into a date field, which would make it easier to search
on ranges.
So, I think your table should look like this:
id
quarter
eventdate
week
O
Be aware that you password is visible (unix anyway with a "ps -ef"..) when you
pass the password like -ppassword. Usually you can enter the password later if
you use
usr/local/mysql/bin/mysqldump --opt --all-databases -p
which avoids the password being visible..
Cormac.
On 12-Nov-2003 Randall
Hello,
I have had some Error 127 on my system so I ran myisamchk -rf when mysqld was down.
Now I noticed my .MYI file is at 1024K:
-rw-rw1 mysqlmysql1024 Nov 11 16:33 table.MYI
My .MYD, .frm are still there:
-rw-rw1 mysqlmysql8802 Nov 6 07:04 table.frm
Dear friends
We have our application with data tier as mysql database in our office
running on windows platform which we need to synchronize with the same
database on a remote system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks & Regards,
Prashant A
--
MySQL Genera
Well, this command is running in a cron job -- so that's not an option.
>
> Be aware that you password is visible (unix anyway with a "ps -ef"..) when you
> pass the password like -ppassword. Usually you can enter the password later
> if
> you use
> usr/local/mysql/bin/mysqldump --opt --all-da
I get an error "Unable to access primary key" each time I attempt to
insert or update a record. But everything seems to be OK with my PK.
CHECK TABLE doesn't see any problem.
Any idea ?
Regards.
Stéphane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Using MySQL-4.0.15
For whatever reason I cannot use the following query in Cold Fusion or
Inside the control center for MYSQL or from the command line mysql.
Here is my query:
SELECT * FROM dbwebmaster d2
WHERE (menuid <> 0 AND website='CMS_INFORMATION' AND parentref = 4 AND
haschildren =1)
I think that I must be missing something, as I agree with all the suggestions that to
change the seperate date element columns to a single date field, but Meli's original
post had a date falling into multiple quarters. Now to my knowledge, a date can only
be in one quarter, from a calendar poin
I get an error "Unable to access primary key" each time I attempt to=20
insert or update a record. But everything seems to be OK with my PK.=20
CHECK TABLE doesn't see any problem.
Any idea ?
Regards.
Stéphane
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
you could put a shell script as the actual cron job, and make the file only read-able
by root, using an environment variable as the password passed (defined in shell script
file), so that way even if someone 'sniffs' the process via 'ps -ef' they don't see
the actual password (if they happen to
HI!
I'm trying to use spatial extensions.
I need to transfer a table like this,
++-+---+--+-+-+---+
| Field | Type| Collation | Null | Key | Default | Extra |
++-+---+--+-+-+---+
| x | int(11) | bin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan, et al --
...and then Dan Greene said...
%
% you could put a shell script as the actual cron job, and make the file only
read-able by root, using an environment variable as the password passed (defined in
shell script file), so that way even if
I am in the process of regenerating all the tables as per the
requirement
of custom designed JAVA and JSP codes for 'chemistry' application. It
requires lot of time to read, modify and write back to database.
The Total number of data points per table containing various types of
data (INT, VARCHAR,
Then put it in root's .my.cnf file.
Randall Perry wrote:
Well, this command is running in a cron job -- so that's not an option.
Be aware that you password is visible (unix anyway with a "ps -ef"..) when you
pass the password like -ppassword. Usually you can enter the password later
if
you u
[EMAIL PROTECTED] wrote:
>
> Using MySQL-4.0.15
>
> For whatever reason I cannot use the following query in Cold Fusion or
> Inside the control center for MYSQL or from the command line mysql.
>
> Here is my query:
>
> SELECT * FROM dbwebmaster d2
> WHERE (menuid <> 0 AND website='CMS_INFORMATI
Hi
I am attempting to install mysqlcc on a OSX 10.3 The configure process
seemed to work fine. However, the following dialogue then appeared:
"Creating Makefile with qmake
Failure to read QMAKESPEC conf file
/Developer/qt/mkspecs/darwin7.0.0/qmake.conf
Error processing project file: /usr/local
On 11/12/2003 02:58 AM Didier Godot wrote:
Hi everyone,
this is my first post, you will excuse me for my english cause french is
my fluent language.
So i'm also new to mysql, tonight my question is how to make a back up
of all the database on MySQL 4.0.12 running on netware server 6
i hava
Hi there!
I need to do a capacity planning for my MySQL database.
Can anyone help me finding information to do it? is there any methodology or at least
some information about it?
I think I have anything I need to do it, I used to do it for Oracle but we're working
with MySQL now, and I have no i
The simplest solution is to keep the password in the .my.cnf file in
your home directory. See http://www.mysql.com/doc/en/Option_files.html
in the manual.
In the case of root cron jobs then, you need a .my.cnf readable only by
root in root's home. It should include
[client]
password="mysql_root_p
--- Egor Egorov wrote:
> Scott H wrote:
>> Can't seem to find this one in the manual or
>> archives - how do I control a db to maintain
>> its size to an arbitrary value, say 20 GB? I
>> want to just rotate records, deleting those
>> that are oldest.
>
> You can't restrict size of the database on
I have a situation using InnoDB where I cannot create even the most
basic of tables with a given name.
mysql> create table card_batch ( a int );
ERROR 1005: Can't create table './test_gn/card_batch.frm' (errno: 121)
mysql> show tables like 'card%';
Empty set (0.01 sec)
mysql> show variables lik
Hello,
i've just installed the 3.23.57 version in my account and i don't have root
privileges. The problem is the if i try to create a database, like this
mysql> create database example;
i get the following message:
"Error 1045: Access denied for user : '@localhost'.
Is this because i'm not th
cronjob a sql script that runs a delete statement for old jobs daily
> -Original Message-
> From: Scott H [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 10:40 AM
> To: MySQL Mailing List
> Subject: Re: maintaining size of a db
>
>
> --- Egor Egorov wrote:
> > Scott H wr
Philip,
the problem is probably that the table already exists in the InnoDB internal
data dictionary. With 4.0.17, I get:
mysql> CREATE TABLE ids (id varchar(255)) TYPE=InnoDB;
ERROR 1005 (0): Can't create table './test/ids.frm' (errno: 121)
mysql>
Output to the .err log:
031112 17:48:3
In order to make sure of a multi-column index, you have to order the
WHERE clauses in the same order as the columns in the index. Since you
query Realm first, then AcctStartTime, then AcctStopTime, MySQL would
use an index on those columns in that order. You can either add a
differently ordered
Hi Fernando;
you are logged in as anonymous user. log into mysql like this
mysql -u root -p
Hit enter if no password is set yet.
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Thursday 13 November 2003 00:47, Fernando wrote:
> Hello,
> i've just installe
Hi Fernando;
you are logged in as anonymous user. log into mysql like this
mysql -u root -p
Hit enter if no password is set yet.
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Thursday 13 November 2003 00:47, Fernando wrote:
> Hello,
> i've just installe
Fernando <[EMAIL PROTECTED]> wrote:
> Hello,
> i've just installed the 3.23.57 version in my account and i don't have root
> privileges. The problem is the if i try to create a database, like this
>
> mysql> create database example;
>
> i get the following message:
>
> "Error 1045: Access denie
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael, et al --
...and then Michael Stassen said...
%
% The simplest solution is to keep the password in the .my.cnf file in
% your home directory. See http://www.mysql.com/doc/en/Option_files.html
% in the manual.
OK.
%
% In the case of root
Hello list:
Is it possible to create a table with a date column with current date as is
default value?, like curdate() or now() values?, any ideas.
- MySQL 3.23.58-Max-log
- RH. 7.3
Greetings and thanks in advanced
Mikel
_
Charla
Hi Patrick
How true ;-) hohohoho
Sorry for my really bad English, I just imagine that you might have had an
experience already from somebody taking it literally ??
I will try to avoid it.
Thanks for the warning ;-)
Best regards
Nils Valentin
On Thursday 13 November 2003 01:13, Patrick Dowd
Yes sir, exactly. It's just that's what I'm
looking for, and can't figure out. I can set up
a cron job, but what exactly would the SQL delete
statement be that would allow me to delete old
records in such a way that the db maintains an
approximately constant size on disk? (Failing
that perhaps a
"Prashant Akerkar" <[EMAIL PROTECTED]> wrote:
>
> We have our application with data tier as mysql database in our office
> running on windows platform which we need to synchronize with the same
> database on a remote system at data centre on Linux.
>
Look at the replication:
http://
I get your point Patrick.
I was customer support engineer myself. You cant always think about all
eventualities can you ;-), its really hard and needs a special way of
thinking.
Anyway that little "lesson" saved my day. ;-)
Thanks a lot.
Nils Valentin
On Thursday 13 November 2003 01:22, you
Dear all
A have a table mytable in which some records have the same value in
col1. I'd like to know how show up only once, how many twice, etc.
The following does what I want, but I think there should be a more
elegant way, possibly invlving subquires.
create table counts (n int);
insert into
I guess you could say that. The machine is Redhat 9 too. I logged in
locally and connected to the mysql server fine. Everything had appeared
as normal. I could see all the databases, and \u to them.
Is there a way I can turn on some extended logging to get more info on
the problem as it will proba
What does "show processlist" say when the connections are maxed out?
(You may have to leave a client logged in to reserve a slot so you can
submit this query.)
If it shows only a few connections, then there's something seriously
wrong. If it shows a ton of idle connections, it should tell you
whi
What I would do is a classical guesstimate
find the average size per record (data file size + index file(s) size / # records in
table)
using that, find the data used per day
using that, figure out how many days, on average it takes to hit 20GB
let's say it's 89 days.
right off the top, ta
Hi
In version 3.23.57 when i do a rollback i get this error message and the changes are
not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
mysql> SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.00 sec)
mysql> BEGIN;
Query OK, 0 rows affected (0
On Wednesday 12 November 2003 17.15, David T-G wrote:
> % [client]
> % password="mysql_root_password"
> What if one user connects to the database as different users (as I do, in
> fact; sometimes all-db-root, sometimes one-db-root, sometimes read-only
> user)? Let's back this out of "root" and g
Thanks to everybody for helping me.
I agree with the suggestion to change the quarter fields in to
one single field. The suggestion from Dan Greene to store the
quarters as binary values sounds good to me. So I will do it this way.
To explain you more about this table. The quarter fields
I'm mostly using mytop, and that's the way that I see that there are no
(are almost no) connections when the server claims that it is above the
connection limit... So I guess that there's something seriously wrong
then... Any ideas what?
-- Henrik
[EMAIL PROTECTED] (Pete Harlan) skrev:
> What do
At 09:24 PM 11/10/2003, Leo wrote:
notice the _and_ ?
*grin*
good point. I guess my reply (which I found out later was unnecessary since
the question had already been answered) would have been better stated had I
just pointed out the distinct keyword rather than constructing a sample
query. :)
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the "show
processlist" is returning only the "show processlist" process. the
results of netstat show absolut
OK, I *THINK* I follow you here. Couple of
questions. I'm reading an online tutorial trying
to figure this out, and I am led to believe mysql
can't do nested queries, aka sub-queries. But you
say it can? Is this recent? And I don't have a
timestamp field, I have an autoincrement field,
but what
Mikael Fridh wrote:
On Wednesday 12 November 2003 17.15, David T-G wrote:
% [client]
% password="mysql_root_password"
What if one user connects to the database as different users (as I do, in
fact; sometimes all-db-root, sometimes one-db-root, sometimes read-only
user)? Let's back this out
Joe Lewis said:
> We're experiencing the same issues, but not neccesarily after an
> upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
> getting max'd connections only on specific users, and the "show
> processlist" is returning only the "show processlist" process. the
> results o
Hi all
Curious as to what happens after data is repeatedly
selected from a mysql table overtime. Does it
accumulate as junk data, stored at some location and
eventually slow down the database/program/server?
Does any purging have to take place?
Thanks
J
__
Do y
>From the manual:
1.8.4.1 Subqueries
Subqueries are supported in MySQL version 4.1. See section 1.6.1 Features
Available in MySQL 4.1.
Hope that helps,
Mike
> -Original Message-
> From: Scott H [mailto:[EMAIL PROTECTED]
> Sent: 12 November 2003 17:45
> To: Dan Greene; MySQL Mailing L
William R. Mussatto skrev:
> Joe Lewis said:
>> We're experiencing the same issues, but not neccesarily after an
>> upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
>> getting max'd connections only on specific users, and the "show
>> processlist" is returning only the "show proce
You may find the SET column type of use here.
http://www.mysql.com/doc/en/SET.html
You could declare column Quarter as
Quarter SET ("one", "two", "three", "four") NOT NULL
or even
Quarter SET ("1", "2", "3", "4") NOT NULL
Then mysql will do some of the work for you.
Michael
Meli Meli wr
Dear DBA's
I'm setting up a database and altered several tables to BDB type in
order to enable transactions. Everything went fine until I restarted
mysqld.
Starting mysql now gets messages like
Didn't find any fields in table 'xxx'
for those tables altered to BDB type. Looking in the error lo
Yes let it finish. Never stop a repair in progress. Now myisamchk is
rebuilding the index file since youre the table is extremely corrupt.
Myisamchk can run faster if you set some buffer properties. Put this in
youre my.cnf file for next time.
[myisamchk]
key_buffer=256M
sort_buffer=256M
read_bu
Hi,
I wish to make a "pull" for mysql-5.0 from http://mysql.bkbits.net but always is
nothing to pull.
I try with :
bk pull http://mysql.bkbits.net/mysql-5.0
I wonder, what happens ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail a
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: joffrey leevy [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, November 12, 2003 9:58 AM
-->To: [EMAIL PROTECTED]
-->Subject: newbie questio
I'm sorry I didn't explain anything.
The problem is that it 's too slow and the result doesn't appear. I am going
to try to explain the query.
Fields from Table FASE: (300.000 records)
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
SQL_ID_PY char(6),
SQL_ID_CE char(6),
PR_flag INT,
PR_Date_Visita
Hello All,
Can a 64-bit MySQL client connect to a 32-bit server? Are there any
restrictions?
Thanks,
Dave Ritter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike --
...and then Michael Stassen said...
%
% Mikael Fridh wrote:
[And thank you to Mikael, too.]
%
% >On Wednesday 12 November 2003 17.15, David T-G wrote:
% >
% >>What if one user connects to the database as different users (as I do, in
...
%
Is there a way to abort a query after it's running?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanx so much! mysql_real_connect() certainly works.
Best,
hAj
on 2003.11.11 17:55, Nick Gaugler at [EMAIL PROTECTED] wrote:
> http://www.mysql.com/doc/en/mysql_connect.html
>
> This function is deprecated. It is preferable to use
> mysql_real_connect() instead.
>
>
>
> #include
> #include
>
Jonathan Terhorst wrote:
I can't figure out if this is actually challenging or if it's a stupid
question. Table1 is a normal old relation that describes a bunch of objects:
Table1 (id INT PRIMARY KEY NOT NULL, Name varchar(255), Size int) etc.
Associated with each Table1 record is a variable-lengt
On Wed, Nov 12, 2003 at 02:29:12PM -0500, Jeff McKeon wrote:
> Is there a way to abort a query after it's running?
You can use the KILL command from a separate connection.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQ
I would like to backup databases from a linux MySQL server to another
linux machine on the same private network but I don' see in the docs how
I can do this with mysqlhotcopy or mysqldump. Is there any way to do
this besides using ftp.
Any help would be appreicated.
Richard
--
MySQL General
Hi,
Repost - its happened again. Anyone any ideas PLEASE!
Hi,
Advice on the cause of the following table corruption would be much
appreciated.
Some background:
This customer has been running MySQL for 3 or more years, and, for back
up purposes, shuts MySQL down each night, takes a snapsh
Is is possible to do a select query with a left join from a real table
to a temporary table? I'm trying it but keep getting "unkown table
'tablename' in field list" error.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
mysqldump -uname -ppassword -BDatabase | mysql -uname -ppasswrod -Ddatabase
-hremotehost
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:54 PM
To: [EMAIL PROTECTED]
Subject: Backup question.
I would like to backup databases from a li
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1597257529, event_type: 49
ERROR: Could not read entry at offset 240378281 : Error in log format or
read error
On the master it's reporting this error. The data_len is 1.48 GB which
is an error. I know that this is not the
Create the column as a timestamp and the column will be updated on insert
and update.
-Original Message-
From: Mikel - [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: table creation
Hello list:
Is it possible to create a table with a
You should determine where your bottlenecks are first. Are the updates on
columns with keys? Can you disable the keys during the load? Are you using
extended inserts? Is there available memory? What is the cpu doing? etc...
-Original Message-
From: karthikeyan [mailto:[EMAIL PROTECTED]
Sen
Well, it sort of helps. But that section is
about future enhancements intended for mysql. I
need to set something up now, with the current
stable version. One thing I read (can't find it
now) indicated that the current version (I'm
actually running 4.0.15a) has "limited" support
for subqueries -
Hi,
Thanks - the tables were converted to MyISAM a while ago, and have run with no
problem. Because they have been repaired before, following a previous crash, I believe
that prior to the shut down last night all was well.
I have run in to the issue of trying to repair a 'live' table, with subs
you may be able to put both statements to a text file, let's call it deleteold.sql
then your cron job would be :
mysql (put your connect stuff here) < deleteold.sql
> -Original Message-
> From: Scott H [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 3:17 PM
> To: Michael
Would anyone be kind enough to provide an example of using MySQL 4 with it's
apparent built in SSL functionality to connect from a Win client to *Nix
box?
Am I correct in assuming that this new functionality means that I will not
have to use stunnel or ssh tunneling?
Thanks for any info!
--
Unless I am misinformed, subscription to the DIGEST format of this list
should cause all messages to come in one daily e-mail? Can someone else who
is subscribed this way please at least let me know that this is at least the
case for them?
I continue to get every single post as an individual e-mai
Hello,
My Load data command seems not to load data into my db:
mysql> load data local infile '/opt/week/ip.0311100440' into table logs.Nov03 ignore 2
lines;
Query OK, 1 row affected (0.66 sec)
Records: 48273 Deleted: 0 Skipped: 48272 Warnings: 48273
mysql>
I have plenty of space where my d
Can this be done?
No, I do not mean running multiple MySQL servers.
I need to have MySQL listen on two separate ports at the same time.
Reason being, the new port is needed for a routing issue, and the
default port 3306 needs to stay up to respond to normal traffic.
--
MySQL General Mailing List
Yes, you can do it like this:
Prompt> mysqldump --add-drop-table --host=source.IP.addr.spec -uuser
-ppassword databasename | mysql -uuser -ppassword
I've found that it helps things if you add --no-data to the source side on
the first pass, then remove that clause and run it again.
Dave
-
your best bet would be to do a port-forwarding methodology, at the os level, not in
mysql itself
I've used some for SOAP tracing, to intercept and view http traffic, but I'm sure
there are some out there that just forward traffic w/o a gui
> -Original Message-
> From: Misaochankun [mail
Cool idea, but I don't think you can really do
it. When I try, mysql just gives me back the
syntax stuff.I'm a bit perplexed - I
would have thought this would be a semi-common
issue in db maintenance, but no one seems to have
set this up. I'm still trying, please send any
other ideas/suggestio
* Elisenda
> The problem is that it 's too slow and the result doesn't appear.
> I am going to try to explain the query.
Please do that using the EXPLAIN SELECT statement:
http://www.mysql.com/doc/en/EXPLAIN.html >
This will show what index is beeing used on the different joins, and
approximatel
HI list
When installing mysql 4.16 on debian linux 2.4.20-20.8smp
I get the following errors...
---snip-
--
031112 16:05:08 mysqld started
031112 16:05:08 InnoDB: Started
031112 16:05:08 Fatal error: Can't open p
There is a C++ package called OTL (http://otl.sourceforge.net/home.htm).
It supports both MySQL through MyODBC, and Oracle. It works great with
Oracle applications, but we have not used it with MySQL.
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED]
713-944-1440 ex
Have you checked permissions - the files should be owned by mysql
Peter
-Original Message-
From: DePhillips, Michael P [mailto:[EMAIL PROTECTED]
Sent: 12 November 2003 21:38
To: [EMAIL PROTECTED]
Subject: new install failure
HI list
When installing mysql 4.16 on debian linux 2.4.20-2
1 - 100 of 133 matches
Mail list logo
