Re: Archive Engine Question

2013-09-19 Thread Tim Callaghan
If you are looking for great compression another option is TokuDB. It supports quicklz, zlib, and lzma compression. On Wed, Sep 18, 2013 at 2:30 AM, Manuel Arostegui wrote: > 2013/9/17 Wayne Leutwyler > > > Hello List, > > > > I have a customer who is wanting to u

Re: Archive Engine Question

2013-09-17 Thread Manuel Arostegui
2013/9/17 Wayne Leutwyler > Hello List, > > I have a customer who is wanting to use the Archive Engine. I have no > experience with this engine, other than what I am been reading. Why would I > want to use Archive over InnoDB. They are only going to be placing audit > inform

Re: Archive Engine Question

2013-09-17 Thread Wayne Leutwyler
ere: > > http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html > > The ARCHIVE engine supports INSERT and SELECT, but not DELETE, REPLACE, or > UPDATE. It does support ORDER BY operations, BLOB columns, and basically all > but spatial data types (see Section 12.16.4.1

Re: Archive Engine Question

2013-09-17 Thread Keith Murphy
>From here: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html The ARCHIVE engine supports INSERT<http://dev.mysql.com/doc/refman/5.0/en/insert.html> and SELECT <http://dev.mysql.com/doc/refman/5.0/en/select.html>, but not DELETE <http://dev.mysql.com

Archive Engine Question

2013-09-17 Thread Wayne Leutwyler
Hello List, I have a customer who is wanting to use the Archive Engine. I have no experience with this engine, other than what I am been reading. Why would I want to use Archive over InnoDB. They are only going to be placing audit information in the table. Walter "Wayne" Leutwyle

Re: List archive?

2010-12-14 Thread Daniel P. Brown
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson wrote: > On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: >> >> I have a question that this list solved a year ago, and I can't remember >> what the solution was. Does this list have an archive? >> >>

Re: List archive?

2010-12-14 Thread Patrice Olivier-Wilson
On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) see

List archive?

2010-12-14 Thread Patrice Olivier-Wilson
I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL Gener

Re: ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-29 Thread Johan De Meersman
> > http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > > -- Bier met grenadyn

ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-29 Thread Daevid Vincent
I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Archive data from a single partition

2010-07-23 Thread Bryan Cantwell
I have a very large table (over 2 billion rows) which is partitioned by day. I'd like to archive all the data in the oldest partition to another table before I drop that partition. Is there some way other than a simple select statement that has parameters that match those of the partition

Re: Move records to "archive server"?

2009-10-18 Thread Johan De Meersman
e production on to an > "archive server"? I would like to this for two reasons: > > 1) To run data-mining queries on a copy of the live dataset without the > risk of overloading the production server. > 2) To maintain an addional set of "historical tables" that co

Move records to "archive server"?

2009-10-18 Thread Allen Fowler
Hello, I have a Python application that is using MySQL to store records of transactions about 3 tables with ~1k records each. How can I periodically copy the records off the production on to an "archive server"? I would like to this for two reasons: 1) To run data-mining qu

archive mysql data

2008-10-23 Thread Ujang Jaenudin
data is transferred to DB2 (my be with replication) but don't want transfer DELETE & DROP statement into it. I heard about mk-archiver, but it seem not good from the performance perspective. Is there a way to archive the data by utilizing replication with DML (DELETE) and DDL (DROP)

Re: archive engine potential bug

2007-09-11 Thread Rob
EATE TABLE `clog` ( `cID` int(20) NOT NULL auto_increment, `lID` > > int(10) default NULL, `ip` int(10) default NULL, `timestamp` int(11) > > NOT NULL, PRIMARY KEY (`clickID`) ) ENGINE=MYISAM; or i use ARCHIVE > > > > I have a bit of a problem that occurs only when i cha

archive engine potential bug

2007-09-11 Thread WiNK / Rob
) default NULL, `timestamp` int(11) NOT NULL, PRIMARY KEY (`clickID`) ) ENGINE=MYISAM; or i use ARCHIVE I have a bit of a problem that occurs only when i change my really simple log table to the archive engine. The replication breaks. Any thoughts? The row number of the error is variable. When the

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-03 Thread Baron Schwartz
have to perform other task also. My task is to keep 3 monts data on the production server. archive the whole data and move it other computer. Reclaim the free space also. You mentioned many of the issues I wrote about here: http://www.xaprb.com/blog/2006/05/02/how-to-write-efficient-archiving-and

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-03 Thread krishna chandra prajapati
task is to keep 3 monts data on the production server. archive the whole data and move it other computer. Reclaim the free space also. Please give me the efficient way to do this job. Regards, Krishna On 8/3/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > > krishna chandra praja

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-03 Thread Sebastian Mendel
krishna chandra prajapati schrieb: > Hi Sebastain, > > On my production server there is two year data. So the hard disk is nearly > 60% full. It contains user data also. On the basis of data column, i have to > keep only 3 months user data on the production server. I have to also

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-03 Thread krishna chandra prajapati
Hi Sebastain, On my production server there is two year data. So the hard disk is nearly 60% full. It contains user data also. On the basis of data column, i have to keep only 3 months user data on the production server. I have to also archive whole data and move it to other system. Regards

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-02 Thread Sebastian Mendel
krishna chandra prajapati schrieb: > Hi All, > > I am working on the production server. I have been assigned the task of > keeping 3 months data on the production server and archive the whole data > also and move it to another system.(Innodb data) > > Experts, Please give me

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-02 Thread Baron Schwartz
krishna chandra prajapati wrote: Hi All, I am working on the production server. I have been assigned the task of keeping 3 months data on the production server and archive the whole data also and move it to another system.(Innodb data) Experts, Please give me the efficient way of do this task

KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

2007-08-02 Thread krishna chandra prajapati
Hi All, I am working on the production server. I have been assigned the task of keeping 3 months data on the production server and archive the whole data also and move it to another system.(Innodb data) Experts, Please give me the efficient way of do this task. -Regards, Krishna

a script to archive binary logs

2007-05-02 Thread Ofer Inbar
For disaster recovery, it's good to have copies of your database dumps that you can easily & conveniently access, that are outside the data center where the database lives. Since we do a weekly full dump and use binary logs for "incrementals", I also wanted copies of our binary logs in the same pl

Embedded server with the archive storage engine

2006-10-22 Thread imre
Hi, Is it possible to use the embedded server with the archive storage engine (version 5.0.24a)? I tried to build it on windows with VS2005, and encountered a few problems. After I managed to build it, I had an assertion failure in a file close operation. I built libmysqld in the following way

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Terry Burton
On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote: > >I require something along the lines of this: > > >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE > > CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log; > > PB Excellent. Exactly

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Peter Brawley
Terry I require something along the lines of this: CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log; PB - Terry Burton wrote: Hi, I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS s

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Terry Burton
On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote: > I dont think that it is possible to specify the engine when creating a table > this way, you could however create the table using the: > > CREATE TABLE old AS SELECT * FROM request_log > > and then issue an alter table command setting the e

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Pure Web Solution
es very simple. > > I require something along the lines of this: > > CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE > > If this cannot be done then I can always get equivalent functionality > by performing CREATE TABLE x (...) ENGINE=x followed by INSERT INTO x &g

CREATE TABLE x AS with ENGINE = ARCHIVE

2006-03-28 Thread Terry Burton
Hi, I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS syntax alongside the ENGINE = x pragma, since this would make archiving of tables very simple. I require something along the lines of this: CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE If this cannot be

RE: mysqld crash with archive engine > 2gb

2005-11-21 Thread Marc Rossi
h a 1GB archive table. Using a separate MyISAM table for each day of data (~ 132mb/3.2m rows) gives me the response time I need -- plus there are no scenarios in which I will be performing cross-day queries (I would guess I could use the merge table if necessary). Thanks again, Marc --- "Loga

Re: mysqld crash with archive engine > 2gb

2005-11-18 Thread Gleb Paharenko
ided RPMs on a RH ES3 box. > > Below is the tablestatus. > > mysql> show table status like 'trade' \G > *** 1. row > *** >Name: trade > Engine: ARCHIVE > Version: 10 >

RE: mysqld crash with archive engine > 2gb

2005-11-17 Thread Logan, David (SST - Adelaide)
Hi Marc, I would be a bit suspicious of the version of zlib or something similar. If it has only been compiled with a 32bit compiler, this could be causing an artificial limit of 2Gb on a pointer. The ARCHIVE engine uses the zlib for its compression, that comes with mysql. I am presuming if it

Re: mysqld crash with archive engine > 2gb

2005-11-17 Thread Marc Rossi
estatus. mysql> show table status like 'trade' \G *** 1. row ******* Name: trade Engine: ARCHIVE Version: 10 Row_format: Compressed Rows: 0 Avg_row_length: 4137 Data_length: 21474836

RE: mysqld crash with archive engine > 2gb

2005-11-17 Thread Logan, David (SST - Adelaide)
: Marc Rossi [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 November 2005 3:16 PM To: mysql@lists.mysql.com Subject: mysqld crash with archive engine > 2gb I am trying to populate a table using the archive engine that I estimate will take up ~ 8gb of disk space when finished. Right now I am crash

Re: mysqld crash with archive engine > 2gb

2005-11-17 Thread sheeri kritzer
say? -Sheeri On 11/16/05, Marc Rossi <[EMAIL PROTECTED]> wrote: > I am trying to populate a table using the archive > engine that I estimate will take up ~ 8gb of disk > space when finished. Right now I am crashing the > server as soon as my file gets to the 2gb mark. OS is &g

mysqld crash with archive engine > 2gb

2005-11-16 Thread Marc Rossi
I am trying to populate a table using the archive engine that I estimate will take up ~ 8gb of disk space when finished. Right now I am crashing the server as soon as my file gets to the 2gb mark. OS is linux and there are other files on the same filesystem that are 30gb+ so I know the fs has

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-21 Thread Gleb Paharenko
or \g. Your MySQL connection id is 10 to server version: 5.0.13-rc-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table ar(a int) engine=archive; Query OK, 0 rows affected (0.02 sec) mysql> insert delayed into ar set

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-20 Thread Jeff Smelser
; blocks. > > Not sure why they say that ARCHIVE storage engine is a new feature in 5.0? I had to take a double take, as I thought it was.. That could be why its not working 100%, as its actually a feature of 5.0. However, I am guessing that this point.. Jeff pgpv8zNukrx9v.pgp Description: PGP signature

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
Jeff Smelser wrote: I would highly suspect this is a bug.. I would submit one.. unless someone else knows better.. Not real sure why you really need delayed, archive is suppose to be much faster on inserts then even myisam. Jeff Thanks Jeff! It's the way our code is written, and I

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
Jeff Smelser wrote: On Wednesday 19 October 2005 01:18 pm, Mihail Manolov wrote: Apparently ARCHIVE tables do not support INSERT DELAYED. Why? In documentation (http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it says that it should be possible. Example of the error that I

ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
Apparently ARCHIVE tables do not support INSERT DELAYED. Why? In documentation (http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it says that it should be possible. Example of the error that I am getting: INSERT DELAYED INTO audit_log VALUES ('db',

Re: Using MySQL to store/archive code/html etc?

2005-05-28 Thread zzapper
On Fri, 27 May 2005 15:39:36 -0400, wrote: >news <[EMAIL PROTECTED]> wrote on 05/27/2005 02:46:09 PM: > > >> > >It is possible to do just what you propose. You could even FT index your >code so that you could find certain key phrases (assuming that the >keyphrase you want is at least 4 (or 3)

Re: Using MySQL to store/archive code/html etc?

2005-05-27 Thread Frank Bax
At 02:46 PM 5/27/05, zzapper wrote: Today I designed a fairly cute error404.php page, which I'd like to reuse in future. Currently I rely on remembering that I created such a page for say ACME Carpets. Now and again my memory fails to remember which site I developed a piece of HTML,PHP,Perl,J

Re: Using MySQL to store/archive code/html etc?

2005-05-27 Thread SGreen
news <[EMAIL PROTECTED]> wrote on 05/27/2005 02:46:09 PM: > Hi, > Today I designed a fairly cute error404.php page, which I'd like to > reuse in future. > Currently I rely on remembering that I created such a page for say > ACME Carpets. > > Now and again my memory fails to remember which site

Using MySQL to store/archive code/html etc?

2005-05-27 Thread zzapper
Hi, Today I designed a fairly cute error404.php page, which I'd like to reuse in future. Currently I rely on remembering that I created such a page for say ACME Carpets. Now and again my memory fails to remember which site I developed a piece of HTML,PHP,Perl,Javascript for and I spend more time

Archive Mbox Files Needed

2005-04-27 Thread sksowe
Am analysing community participation in mailing lists. I have a python script that reads mbox files and parse the contents into Mysql database. Does anyone knows where i can get archived mbox files of the Mysql mailing lists? Thanks in advance -- Sulayman K. Sowe Aristotle University of Thessalo

Archive storage engine

2004-11-16 Thread Garrett Kajmowicz
When would a person want to use the archive storage engine? Would it suitable for output an audit log to? What happens if I insert into such a table in the middle of a transaction? Thanks for the info. - Garrett -- MySQL General Mailing List For list archives: http://lists.mysql.com

archive db daily- Rough Draft

2004-08-02 Thread Jacob, Raymond A Jr
-Original Message- From: Jacob, Raymond A Jr Sent: Monday, August 02, 2004 21:17 To: [EMAIL PROTECTED] Subject: archive db daily- Rough Draft I am new to Databases and would appreciate a second set of eyes looking over my sql script. The script takes the existing snort database and

RE: How do you archive db daily?

2004-08-02 Thread SGreen
created the > dbArchYesterday that > mysqld has the database in memory.Is there way to: > 1. write the database to disk, > 2. unload the database from memory, if it is in memory, > in order to file utilities such as tar and gzip to archive and > compress the > databas

RE: How do you archive db daily?

2004-07-30 Thread Jacob, Raymond A Jr
database to disk, 2. unload the database from memory, if it is in memory, in order to file utilities such as tar and gzip to archive and compress the database into to a tgz file? Thank you, raymond PS: Is there a document that describes how mysql loads and unloads tables and databases in

Re: How do you archive db daily?

2004-07-30 Thread SGreen
Why not keep your server running and just use scripted SQL to migrate the records from one DB to the other? CREATE DATABASE dbArchYesterday; USE dbArchYesterday; CREATE TABLE table1 like dbActive.table1; CREATE TABLE table2 like dbActive.table2; CREATE TABLE table3 like dbActive.table3; CREATE

How do you archive db daily?

2004-07-29 Thread Jacob, Raymond A Jr
I am running MySql 3.23.58-1 on a snort database containing IDS alerts. At 12:00am I would like move the previous day's alerts from four tables to a backup database named for the previous day. Has anyone implemented such a backup schedule? And if so can someone send me a script? I had the follow

Re: [OT] Email addresses shown in archive at lists.mysql.com

2004-07-12 Thread Jochem van Dieten
Ian Gibbons wrote: > > If someone else quotes your message in a reply ( which is considered best practice > in all mailing list I have ever been a member of ) email addresses are displayed. I quote you. Now where is an email address displayed? > I understand that my address could have ( and is

Re: [OT] Email addresses shown in archive at lists.mysql.com

2004-07-12 Thread Joseph A. Nagy, Jr.
On Mon, Jul 12, 2004 at 05:28:04PM +0300, Heikki Tuuri wrote the following: > Ian, > > note that the MySQL mailing list is also forwarded to the > mailing.database.myodbc Usenet group, as well as to several mailing list > archiving websites. Spam robots and viruses have plenty of places from which

Re: [OT] Email addresses shown in archive at lists.mysql.com

2004-07-12 Thread Heikki Tuuri
support from http://www.mysql.com/support/index.html . List: mysql Subject:[OT] Email addresses shown in archive at lists.mysql.com From: "Ian Gibbons" Date: 2004-07-12 14:18:49 Message-ID: <40F2ABD9.17993.2491A560 () localhost> [Download message RAW] D

[OT] Email addresses shown in archive at lists.mysql.com

2004-07-12 Thread Ian Gibbons
Dear list, After posting a question last week from an email address I only use for this list, I have already started to receive spam and virus reports. Looking at the archives at lists.mysql.com I notice that the from address is not shown, just the name. But... If someone else quotes your mes

Re: Your archive

2004-03-27 Thread jobs
Your file is attached. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

extracting .tgz archive for maxdb

2004-03-09 Thread Raza Ansari
l and it gives me the following error maxdb-all-linux-32bit-i386-7_5_0_8/ maxdb-all-linux-32bit-i386-7_5_0_8/SDBBAS.TGZ zcat: maxdb-all-linux-32bit-i386-7_5_0_8.tgz: invalid compressed data--format violated tar: Unexpected EOF in archive tar: Unexpected EOF in archive tar: Error is not recove

Re: archive data

2003-11-20 Thread Paride De Gasperis
diskspace of /var dir (it is about 1G), so, it was easily full loaded with data. now, i want to archive the data into another dir. how can i switch the dir such that, i can have a spacious diskspace to store my data. now, i am facing a problem that i cant write into the db because of the no diskspace

archive data

2003-11-19 Thread Hiu Yen Onn
hi, i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13 using rpm package. by default, the data file of mysql is alocated at /var/lib/mysql, but i have a limited of diskspace of /var dir (it is about 1G), so, it was easily full loaded with data. now, i want to archive the

Compiling:Not a valid library (invalid magic number).Possibly a 64-bit PA archive library (Mismatched ABI).

2003-06-05 Thread Derick Smith
). Possibly a 64-bit PA archive library (Mismatched ABI). *** Error exit code 1 Server/Version Information: HP-UX 11.00 Operating System mysql> status -- /software/grs/actr/mysql/bin/mysql Ver 12.18 Distrib 4.0.12, for hp-hpux11.11 (hppa2.0w) Connection id: 3 Current datab

re: Re: Rights required to archive a table

2003-03-07 Thread Victoria Reznichenko
<___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe

re: Rights required to archive a table

2003-03-07 Thread Victoria Reznichenko
On Friday 07 March 2003 13:30, Lakshminarayna U wrote: > I want to archive and restore a table in MySQL using SQL > statements. I have tried this by logging in as root user and could > do it fine. But when I created a new user and login as him, I am > not able to archive nor res

Rights required to archive a table

2003-03-07 Thread Lakshminarayna U
Hi, I want to archive and restore a table in MySQL using SQL statements. I have tried this by logging in as root user and could do it fine. But when I created a new user and login as him, I am not able to archive nor restore. I have granted him all the rights. Is there any specific rights

Re: Rights required to archive a table

2003-03-07 Thread Ahmed S K Anis
Yes you can. Try this query grant file on database.* to user@'. also remember grant file on database.table to user@'. does not work Anis >>> "Lakshminarayna U" <[EMAIL PROTECTED]> Friday, March 07, 2003 5:00:30 PM >>> Hi, I want t

Security Clipper Internet security mailing list archive is now online

2003-02-20 Thread m37
A new, free, Internet security mailing list archive is now online and searchable on the Security Clipper website at: http://www.securityclipper.com Over 50 security- and privacy-related email mailing lists, including MySQL-bugs, are available and all are freely searchable

RE: Archive on remote Machine.

2003-02-19 Thread Chris Faust
TECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; >> [EMAIL PROTECTED] >> Subject: Archive on remote Machine. >> >> >> Hi, >> I use Select * into outfile "filepath" from table to archive the >> database. >> Is there any way to archive this

Re: Archive on remote Machine.

2003-02-19 Thread Charles Lewis
n. Is there any way i can Archive data to remote machine where MySQL is not installed. Anis "KH Chiu" <[EMAIL PROTECTED]> Wednesday, February 19, 2003 8:46:46 AM >>> You may try the following command mysqldump -u -p samp_db | mysql -h remote host n

Re: Archive on remote Machine.

2003-02-19 Thread KH Chiu
fact, I have a project that has more complex remote backup requirement. I am working on it using C right now but not yet completed. Regards, > Thanx for the suggestion. > Is there any way i can Archive data to remote machine where MySQL is > not installed. > > Anis > > &g

Archive on remote Machine .

2003-02-18 Thread Ahmed S K Anis
I use Select * into outfile "filepath" from table to archive the database. Is there any way to archive this into a different machine. (Not current machine). Also Note the target machibe does not have MySQL installed. Yes Mapping to new machine and then giving path is an option.

Re: Archive on remote Machine.

2003-02-18 Thread KH Chiu
path" from table to archive the > database. > Is there any way to archive this into a different machine. (Not current > machine) > > Yes Mapping to new machine and then giving path is an option. Any other > opton.? > Anis > > ---

re: Archive on remote Machine.

2003-02-18 Thread Victoria Reznichenko
On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > I use Select * into outfile "filepath" from table to archive the > database. > Is there any way to archive this into a different machine. (Not current > machine) > > Yes Mapping to new machine and then g

Archive on remote Machine.

2003-02-18 Thread Ahmed S K Anis
Hi, I use Select * into outfile "filepath" from table to archive the database. Is there any way to archive this into a different machine. (Not current machine) Yes Mapping to new machine and then giving path is an option. Any other op

Re: How to Archive and restore the data in MySQL database.

2003-02-10 Thread Stefan Hinz
, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

RE: How to Archive and restore the data in MySQL database.

2003-02-10 Thread B. van Ouwerkerk
://www.mysql.com/doc/en/Backup.html Another relevant link for you: http://www.tuxedo.org/~esr/faqs/smart-questions.html B. -Oorspronkelijk bericht- Van: Prasad Budim Ram [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 7 februari 2003 7:31 Aan: [EMAIL PROTECTED] Onderwerp: How to Archive and

Re: How to Archive and restore the data in MySQL database.

2003-02-10 Thread olinux
/www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com

Re: How to Archive and restore the data in MySQL database.

2003-02-10 Thread Dan Nelson
PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL P

Re: How to Archive and restore the data in MySQL database.

2003-02-10 Thread mysql-list-bot
l * http://www.mysql.com/doc/en/CREATE_DATABASE.html * http://www.mysql.com/doc/en/DROP_DATABASE.html This was an automated response to your email 'How to Archive and restore the data in MySQL database.'. Final search keyword used to query the manual was 'How to Archiv

How to Archive and restore the data in MySQL database.

2003-02-08 Thread Prasad Budim Ram
manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Archive and retrieval in MySQL

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Ahmed, > 1. How can i trigger a database archive when a certain data base limit > is reached in a table. > Ex: when 1,00,000 records is reached, archive to file and clean table. You will have to wait for MySQL 5.0. This version will have SQL triggers. > 2. How can i restore multipl

Archive and retrieval in MySQL

2003-01-13 Thread Ahmed S K Anis
HI, I have a few questions related to DB archving / restore capability of MySQL. Most of them are design issues but have a lot to do with what MySQL provides. PLease share your view on them. 1. How can i trigger a database archive when a certain data base limit is reached in a table. Ex: when

RE: Archive of this mysql list

2002-10-03 Thread Sqlcoders.com Programming Dept
Ahem, have a look at the bottom of any post to the list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) :) HTH, William. > -Original Message- > From: Chris Becker [mailto:[EMAIL PROTECTED]]

RE: Archive of this mysql list

2002-10-03 Thread Andrew Braithwaite
Yep, It's here http://www.mysql.com/documentation/searchlists.html Cheers, Andrew Sql,query -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 00:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list >Is there an ar

Archive of this mysql list

2002-10-03 Thread Chris Becker
>Is there an archive of all posts to this mysql list that I can search >somewhere? > >Chris Becker >MCDBA MCSE >http://www.PrismSoftware.com >[EMAIL PROTECTED] sql - Before posting, please check:

web archive project

2002-07-11 Thread Matt Price
with a bunch of bibliographic-type data in other fields (keywords, author, date, etc). The html (and hopefully, accompanying images/css's/etc) are then grabbed using curl, and archived in a postgresql database. A web or other gui interface then provides fully-searchable access to the archive f

Re: doc archive?

2002-06-05 Thread Gary Delong
02, 6:05:08 PM, you wrote: > > GD> Is there an archive of the MySQL doc? The doc at mysql.com is > GD> for v 4.0 alpha and I'd like to get the doc for v 2.23.49 > GD> which I just downloaded. (As a new user I'd like to be able > GD> to RTFM before bugging the list

Re: doc archive?

2002-06-05 Thread Egor Egorov
Gary, Wednesday, June 05, 2002, 6:05:08 PM, you wrote: GD> Is there an archive of the MySQL doc? The doc at mysql.com is GD> for v 4.0 alpha and I'd like to get the doc for v 2.23.49 GD> which I just downloaded. (As a new user I'd like to be able GD> to RTFM before bugg

Re: doc archive?

2002-06-05 Thread Steve Edberg
least recent - versions of MySQL to be archived somewhere. Who knows, they might be somewhere on the mysql.com site - I haven't looked. -steve At 11:05 AM -0400 6/5/02, Gary Delong wrote: >Is there an archive of the MySQL doc? The doc at mysql.com is >for v 4.0 alpha and I&#x

doc archive?

2002-06-05 Thread Gary Delong
Is there an archive of the MySQL doc? The doc at mysql.com is for v 4.0 alpha and I'd like to get the doc for v 2.23.49 which I just downloaded. (As a new user I'd like to be able to RTFM before bugging the list with dumb questions. I'll still probably ask dumb questions, but at

Re: What is the best way to archive rows from one table to another? ##

2002-03-08 Thread George Whiffen
ve 2 tables, table1 and table1_archive. The archive table has identical > columns as table1 except it has a few extra columns like a log_date, > user_id. I would like to copy the corresponding columns from table1 to > table1_archive. Sounds simple, right? > > Example: > insert into table1_a

What is the best way to archive rows from one table to another? ##

2002-03-08 Thread BD
I have 2 tables, table1 and table1_archive. The archive table has identical columns as table1 except it has a few extra columns like a log_date, user_id. I would like to copy the corresponding columns from table1 to table1_archive. Sounds simple, right? Example: insert into table1_archive

archive logs

2002-01-09 Thread Chris Pesko
I'm new to MySQL. Does MySQL have archive logging and can you recover to the point in time of failure in the event of disk crashes? Also, Besides the manual and classes, what is the fastest way to get up and running on MySQL considering I am a seasoned Oracle DBA. Are there prac

Re: MySQL Searchable Mailing List Archive now up.

2001-12-17 Thread Robert Alexander
friends have accessed the archive from 95, 98, 2000, and XP that I know of. This is the first report that the 'Any Date' selection has not appeared checked by default. Wonder what could be causing it...? The archive has been tested with Netscape 4.0-4.78 on Solaris, Linux (RedHat 7

Re: MySQL Searchable Mailing List Archive now up.

2001-12-17 Thread Etienne Marcotte
th NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) Etienne Robert Alexa

Re: MySQL Searchable Mailing List Archive now up.

2001-12-17 Thread Robert Alexander
.. or emarcott at itl dot ca (like the >mysqldeveloper archive. > > >my 2 cents > >#2 is not a big thing, but #1 is pretty important against spam and spam >bots. > >Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me

Re: MySQL Searchable Mailing List Archive now up.

2001-12-17 Thread Robert Alexander
now, which gives me a >basic intro. The stuff on DevShed is generally quite good. It's a good resource. >Thanks a lot Rob, > >Peter Hope this helps, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting

Re: MySQL Searchable Mailing List Archive now up.

2001-12-17 Thread Etienne Marcotte
This is a very very good search engine for the mailing list!!! Great work Two things: 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. 2- Put the "Any Date" checked by default so we don'T

Re: MySQL Searchable Mailing List Archive now up.

2001-12-14 Thread Colin Faber
lt;[EMAIL PROTECTED]> > Sent: Friday, December 14, 2001 9:19 PM > Subject: MySQL Searchable Mailing List Archive now up. > > > So, being 'between contracts' right now, I decided finally to > > write one. I've actually been keeping an archive of the MySQL list >

Re: MySQL Searchable Mailing List Archive now up.

2001-12-14 Thread Tony Buckley
- Original Message - From: "Robert Alexander" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. > So, being 'between contracts' right now, I decided finally t

  1   2   >