You may be looking too far for your problem...
Your join_buffer and sort_buffer are probably a little large if you
have man concurrent users.
Must you use an old version of mysql?
You should analyize or post EXPLAIN of your query so that you/we
can see that it is properly indexed.. you should
Does anybody know of any commercial or opensource CRM systems that
run with MySQL on Linux (and/or FreeBSD)?
Mainly I need canned responses and ticket management and some other
standard features.
-
Before posting, please check
PID is stored in a file in the datadir named
.pid
[root@georgia data]# cat /usr/local/mysql/data/georgia.pid
19805
Teddy A Jasin wrote:
>
> Hi,
> wat command to type under linux to get the PID of the mysqld that is running?
> i tried : 'ps aux | grep mysqld' but this will list the mysqld info
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.
Richard Reina wrote:
>
> I posted t
---+
>
> However Chicago is the city of the first stop off (sequence 1) not the
> value that corresponds with a sequence of 2 which would be 'Boston'.
>
> The desired result is the following:
>
> +---+
> |flight_no |sequence|City
Original Message
From: "Matthew P. Marino" <[EMAIL PROTECTED]>
Subject: Re: So, what do you do with a "tarball" anyways.
To: Steve Ruby <[EMAIL PROTECTED]>
OK.
I'm trying to prove/disprove the viability of the MySQL/PHP/Apache triad
"Matthew P. Marino" wrote:
>
> So, what do you do with a "tarball" anyways. Since compiling the source is
> hopless( "sql_yacc.cc"), I'm looking for a binary.
>
then download the binary.. Or at least do a better job of describing your
problem...
---
"Matthew P. Marino" wrote:
>
> If you go to http://www.mysql.com/downloads/mysql-3.23.html, you will see the
> binary(tarball) distributions. They don't end in .tar.gz but I supposed that was
> a technical oversight. Of course I feel like a (_?_) (i.e dumb a**) not being
> able to track down the
Jack Dempsey wrote:
>
> Hi all,
>
> I'm wondering if it's possible to do something like that select line in
> the subject...often i want to select * but not one or two fields...i
> found something about this in the to do list for mysql4.0, but i'm
> guessing that's not exactly what i'm thinking.
His balance is a running balance...
Joseph, you will have to keep the running balance in some thing
that you write to get the query.. you can't do a running sum
in SQL directly. You can only use the examples people provided
to get the net per line.
Joseph Bueno wrote:
>
> [EMAIL PROTECTED] a
John Tsangaris wrote:
>
> If I turn on auto increment and let it do it's thing and then later on
> delete a few of the entries (let's say 1, 2, 3) and the current high entry
> has an id of 45.. why does mysql continue with 46 instead of using up 1, 2,
> and 3 first? Is there a way to bypass this
Depends on the situation.. Mysql will use only one index per table per query.
so if you very often query on all three you should put them in a multi-column
index.. If you also often search on only one of the three you should put
it first.. If you often search on another one of the three you shou
Dale Frohman wrote:
>
> Is there anyway to do a query and search for the most frequent
> word that appears in a particular field in a table?
>
> ie:
>
> ITEM DESCRIPTION
>
>
> Blue Dog
> Red Dog
> Yellow Cat
>
> I would want to spit out "Dog" as being the most reoccuring word
Cindy wrote:
>
>
> SELECT
>Foster_Dogs.dog_name,
>Foster_Dogs.dog_status,
>Foster_Dogs.date_resolved,
>Foster_Dogs.adopting_family,
>Foster_Dogs.foster_paperwork,
>Foster_Dogs.dog_id,
>Adoption_Applications.firstname,
>Adoption_App
Cindy wrote:
>
> SELECT
>Foster_Dogs.dog_name,
>Foster_Dogs.dog_status,
>Foster_Dogs.date_resolved,
>Foster_Dogs.adopting_family,
>Foster_Dogs.foster_paperwork,
>Foster_Dogs.dog_id,
>Adoption_Applications.firstname,
>Adoption_Applic
RTFM... Obviously you need to pass the correct usename and password
if need with the mysqldump command,, read the manual and/or mysqldump --help
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Go
"Todd A. Jacobs" wrote:
>
> I downloaded and compiled the latest version of MySQLGUI and am connecting
> to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
> following ssh tunnel:
>
> ssh -x -g -L 3306:localhost:3306 mysql
>
> I get this error message from the MySQL
It depends on your table type, check the manual, you will want
myisamchk or isamchk if you are using 3.23.x you can do SQL
REPAIR TABLE so long as your table is MyISAM.
Dave Loisel wrote:
>
> I have filled my hard drive by inserting data into a table (15 gigs).
>
> The table was then corrupte
Jonathan Dugan wrote:
> your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
> I am read ing here
> http://www.mysql.com/doc/D/e/Default_privileges.html
> and
> http://www.mysql.com/doc/A/d/Adding_users.html
>
> and I follow what is says:
> shell> mysql -u root m
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill "?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without taking down the server..
-
[EMAIL PROTECTED] wrote:
>
> Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
> that has a table that has a column with the name: FullText. Unfortunately,
> now with 3.23.33, any queries that explicitly refer to this column/field
> return an SQL error. So far this ha
Steve Ruby wrote:
>
> If I have a connection that executes a bad query shouldn't I
> ALWAYS be able to kill it with "kill "?
>
> I have a query that keeps getting stuck, (who knows what
> it is doing) but that State is "statistics"
>
> I
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
gt;
> -----Original Message-
> From: Steve Ruby [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 8 March 2001 5:19 a.m.
> To: [EMAIL PROTECTED]
> Subject: Re: kill bad query
>
> Steve Ruby wrote:
> >
> > If I have a connection that executes a bad query shouldn't I
Christian Hammers wrote:
>
> Hello list
>
> While browsing old sources by a former employee I realised that he always
> did comma seperated joins and then a "where"
> FROM
> tablea a, tableb b, tablec c
> WHERE
> a.id=b.id and b.nr=c.nr
> whereas I learned to
Steve Ruby wrote:
>
> Christian Hammers wrote:
> >
> > Hello list
> >
> > While browsing old sources by a former employee I realised that he always
> > did comma seperated joins and then a "where"
> > FROM
> > tablea
Tom Flanagan wrote:
>
> Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
> NT/2000 MYSql Database?
>
> Thanks,
>
> Tom Flanagan
>
If you are using MyISAM tables (3.23.x) you can simply copy them from
one computer to the other. If you are using ISAM tables like in
3.2
Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table
Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table
Andrew Staples wrote:
>
> New to list, and to mySQL. If there are archives available, please let me
> know--I'll search them.
>
> I have a client who is building a new win2k server, and wants to use
> ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
> will work with myOD
Roger Westin wrote:
>
> Hi,
> Have a problem with big tables,
> Cant get them over 2GB
> Using mysql 3.23.33
> and ReadHat Linux 6.0 Kernel: 2.2.5
>
> Need to biuld a table atleast 70Gb so Anyone?
>
switch to a file system that supports very large files
The problem should be with linux no mys
[EMAIL PROTECTED] wrote:
>
> On Fri, 9 Mar 2001, Jon Haworth wrote:
>
> > Not sure exactly what you're after... MySQL isn't an Apache module, it's a
> > separate program.
> > Where can I find Apache module for mySQL ??
>
> maybe "mysql module for apache"?
>
> regards
> --
You mean mod
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045:
> Access denied for user: 'accp@localhost' (Using pass word: NO) "
>
> can you help?
>
> with best regards,
> Keneth
Read the manual,
"Gupta, Sanjeev" wrote:
>
> Hi,
> I have tried to create a table with two fields. One is type CHAR and other
> is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
> i need to do some setting to work properly.
> I am working on WINNT machine.
>
http://www.mysql.com/doc/S/
Jordan Russell wrote:
>
> > Everything I've seen on this list indicates that using LEFT JOIN negates
> > using an index. (WARNING: This is 3rd hand info and as such should be
> viewed
> > skeptically!)
> >
> > Have you tried:
> >
> > SELECT files.id, dirs.name FROM files where files.dir_id=dirs.i
Randy Johnson wrote:
>
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
> example
>
> randy's is stored in the DB as randy\'s
>
> thanks
>
> Randy
If you just want to fix that one instance just do
update set = 'randy\'s' where
-
> gnanas wrote:
>
> Dear Sir,
>
> We are from Chennai, India.
> We are holding one site constructed using JSP pages. We couldn't connect to the
>mysql database using myodbc driver! The
> specified driver is not installed in the virtual server the hosting company!
> Do we have any otehr alternat
rozakdemir wrote:
>
> Hello,
>
> I am using MySQL on windows platform. How can I port mt datas from MySQL server on
>windows to MySQl server on Linux?
>
> Thanks for all.
You should search the sarchives and manual, this is a very FAQ...
tables extension is like .MY* you can just copy them, i
"Jeremy D. Zawodny" wrote:
>
> On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> > 2- I have to design a database for all universities of my country ,
> > Is it better to consider one database for each university or one
> > database for all universities . Note that a query
Pawan Kanda wrote:
>
> Hi , i have the following method:
>
> public Object getValueAt(int row, int column){
> // in here i want to construct a SQL query which gives the object at a
> certain
> row and column
> }
>
> Do you know how to do it?
>
> Thanks
> Pawan
>
Maybe make your sql statemen
Patrick Calkins wrote:
>
> Hello all;
> Are there any known problems with storing the database files on a NAS
> (network attached storage) device??
>
> also, can you run multiple MySQL daemons pointing to one common database, so
> you could have a "cluster" of database servers and one database??
"Alexey V. Litvinov" wrote:
>
> Hello JCampell,
>
> Friday, December 22, 2000, 11:25:51 AM, you wrote:
>
> RTFM about SELECT and about DISTINCT option
>
> J> I want to know if it is possible to build a MySQL query which will only
> J> return the unique values of a specific column. Ie if I had
How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without SPs
Luis wrote:
>
> Good morning all, last night I installed MyODBC on my laptop. What i dont
> understand is how do i connect threw access now?
>
> I'm a little confuse, can anyone help me understand how MyODBC works.
>
> luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to th
Probably should change that first line to
rpm -qa | grep -i mysql
Roel Vanhout wrote:
>
> rpm -qa | grep mysql
>
> if nothing found,
>
> rm -rf /usr/local/var
> rm -rf `find /usr/local/bin/ | grep mysql`
> rm -rf /etc/my.cnf
>
> This should catch about everything.
>
> cheers,
>
> roel
>
>
Kevin Pratt wrote:
>
> I have heard mysql is the access for unix... i would like to hear about
> comparisons with Mysql SqlServer and PostgresSQL
>
> Kevin
differences are in the archives for this list as well as on the mysql.com
list.
Mysql doesn't compare will to Access. access is simply a
Fabio Galarraga wrote:
>
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
>
> Best regards,
> Fabio Galarraga
> [EMAIL PROTECTED]
see
mysql --help
you probably want
mysql -e ""
-
Andrew Warner wrote:
>
> how do you query on a TIMESTAMP column to return all records of date today?
>
> I've been using "where date >= 20010418 AND date < 20010419" syntax
> and changing the dates as necessary, but I'd like to replace this
> with some kind of today() function.
>
> Andrew
Use
Istiaque Hussain wrote:
>
> Dear Friends ,
>
> One of our clients wants to port the Database which was originally in MS SQL , to
>MY SQL . he main problem we are facing is that how to make previous stored procedures
>run . There are a lot in the application . Front end was in VB .
> We are
Matthew Hafner wrote:
>
> does mySql support triggers or transactions
>
> Matthew Hafner
> Web Applications Engineer
> The Ohana Foundation
> 1099 Alakea st
> 22nd floor
> Honolulu, HI, 96813
> 1-877-61-ohana
> [EMAIL PROTECTED]
RTFM
www.mysql.com
-
> > Hi all,
> >
> > I'm looking for some pointers towards some good information on accessing
> and using MySQL with Java/Javascript.
> >
> > Can anyone point me towards a book you like, or some good web resources?
> >
> > Thanks much,
> > /Rob
> >
You'll need a servlet and/or JSP engine such as
Roger Karnouk wrote:
>
> Is it possible in a Select query to get values from the previously read row
> in order to do things like cumulative sums or other formulas which require
> the previous value in order to calculate the current value.
>
> ex.
> day current sales cumu_total
> - --
http://www.mysql.com/doc/c/o/configure_options.html
http://www.mysql.com/doc/A/d/Adding_character_set.html
Luis Hoeks wrote:
>
> I would be very pleased, if someone could tell me if MYSQL supports asian
> character sets like big5 or thai charctersets.
> If yes, what do I need to install to ge
For over a year the topic of mathematical operations on date values
has been disussed. It has never been possible to perform such math
on a date value without using DATE_ADD or converting the to days or
seconds first.
Why is this now all the sudden a reasonable bug?
Aurelian:
I suggest that yo
[EMAIL PROTECTED] wrote:
>
> Dear Friends ,
>
> The basic problem I face in the new project is to convert the previous Stored
>Procedures in MS SQL Database into My SQL . How to Replicate the same in My SQL .
> The Front End is VB 6.0 . The Back End previously was MS SQL . Now Client want it
Your Name wrote:
>
> dear sir/madam
> i'm currentlly doing a research on MYSQL and i would like to know more
> information about it :where does MYSQL come from who created it ...
www.mysql.com
-
Before posting, please check:
Alec Solway wrote:
>
> Hi,
>
> In various create table statements char columns are converted to varchar..
> I was wondering why this was happening. Here's an example:
>
> CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
> null, city VARCHAR(255) not null, state CHAR(2)
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> How can I have an UNIQUE key in MYSQL which
> differentiates between case sensitive strings.i.e If I
> want to store "XYZ","XYz" and "xyz"
> differently.Currently mySQl is not accepting this type
> of strings and treating them as the same.
>
> Reg
when a BDB table is being written to and another thread
issues a query I sometimes get this error code. Ideas?
The table is fresh it was created by the dumpfile that another
thread is loading in while I'm running the count query.
this is mysql-max 3.23.37
mysql> select count(*) from _data;
+-
green jon wrote:
>
> Hello,
>
> I have recently converted my Java Servlets to run against mySQL where previously I
>was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything
>works fine, more or less. However, I have one big problem which is as follows :-
http://w
InnoDB definately provides more features that BDB, and is probably
going to be faster, Gemini isn't available yet. BDB might be more
complete/stable.
So I'd say Gemini is out of the picture unless you are looking longer
term. I'd do some testing with both we found some bugs in the 3.23.37
distr
Don Pro wrote:
>
> Hi,
>
> I'm reading in my documentation (I have a book) that MySQL allows up to
> 101 simultaneous connections. Gadzooks! How can MySQL claim to be at
> the Enterprise level with this limit? Is there any way around this?
>
> Thanks,
> Don
http://www.mysql.com/doc/T/o/Too
Don Pro wrote:
>
> Hi,
>
> I'm reading in my documentation (I have a book) that MySQL allows up to
> 101 simultaneous connections. Gadzooks! How can MySQL claim to be at
> the Enterprise level with this limit? Is there any way around this?
>
> Thanks,
> Don
>
http://www.mysql.com/doc/T/o/
I've been doing some testing to determine tradeoffs with performance
for using the Innobase or BDB tables.
The testing application contains bulk inserts which must be processed
as quickly as possible. The results I'm getting look very bad for
innobase. Am I doing something wrong?
I'm inser
Heikki Tuuri wrote:
>
> Steve,
>
> you should set autocommit=0 and only call commit after the
> whole batch of inserts.
>
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
> If you use autocommit=1 and insert each row in a separate transact
Steve Ruby wrote:
>
> Steve Ruby wrote:
>
> > I'm inserting 49,990 rows via file containing individual inserts
> > (1 insert per sql statement). The table contains 7 columns and 6
> > indexes.
> >
> > Why is there so much difference on the time tak
Due to the fact that piping a table from mysqldump to an INNODB table
can be as much as 30X slower if the insert is not done with
transactions,
would it make sense to add some option to mysqldump to make every X
inserts a transaction.
for example
mysqldump --transactionrows=10 mydatabase |
Is there a plan to have any tablespace management tools for innobase?
I personaly dont' care if these are via a separate program or through
the mysql SQL interface but the following would be very handy.
move tables between tablespaces
list tables in a tablespace
shrink tablespace
It is very
There seem to be some operations that cannot be performed on the
server whie InnoDB is doing something.
For example I inserted about 200,000 rows in to a table from
a file (mysql database < file) the file starts with begin; and
contains many inserts, I cancelled (ctrl-c) in the middle of the
o
Heikki Tuuri wrote:
>
> Steve,
>
> on what operating system you are running?
>
linux, intel 2.2.12
> Was the rollback (and the table load) disk bound? Did you configure much
> memory to the InnoDB buffer pool?
>
I would say the rollback was processor bound, the machine was running
with almos
Chris Wilkinson wrote:
>
> I am attempting to upload an Access db to a remote mysql server - at
> dsvr in the UK.
>
> I get connected (I think) but receive the following error message:
> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
>
> Can you point me in the right di
by correct configuration.
>
> Hope you can follow what I am doing or doing wrong from this.
>
> CHRIS
>
> In message <[EMAIL PROTECTED]>, Steve Ruby
> <[EMAIL PROTECTED]> writes
> >Chris Wilkinson wrote:
> >>
> >> I am attempting to upload an A
< mytextfile_fromaccess
Chris Wilkinson wrote:
>
> Can you give me a sample command line please
>
> CHRIS
>
> In message <[EMAIL PROTECTED]>, Steve Ruby
> <[EMAIL PROTECTED]> writes
> >Chris Wilkinson wrote:
> >>
> >> I am attempting to up
Cyber Monkey wrote:
>
> I have found an isp that will leave port 3306 open for me to talk to the mysql
>server, my question is
>
> Is anything sent over this connection secure, if not is there some way of encrypting
>it such as ssl?
Yes.. you ssh like here
www.ssh.com
www.openssh.org
an
VVM Ravikumar Sarma Chengalvala wrote:
>
> Joshua,
>
> > Comparing Oracle vs. MySQL myisam tables, MySQL will
> > save disk space, and provide you with much faster
> queries, but you have to be aware of the table
> locking issues if you are doing
> updates/inserts/deletes mixed > with reads.
>
Look up link or something in the manual. There is a way to do
virtual symbolic links in NT with mysql without installing anything,
it has to do with adding paths to the my.cnf file, see the docs
for details.
"Tracy A. Mitchell" wrote:
>
> You can do this with NT Server as well. It is called
What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an en
Kenneth Kopelson wrote:
> So, how do we get support in MySQL so that multiple instances of the mysqld
> daemon running on separate machines can all access the same database files
> located on a central server? I can see how the file system of the central
> database server could be exported throu
There are really only two. mm.mysql (varisous version)
and the twz one.
I suggest the mm.mysql one. They are both type 4 I believe there
is no reason to choose the twz one over the mm one.
I would use the latest 2.0 version unless you have code that
would have a problem with it then you can u
Martin Thoma wrote:
> Hello !
>
> I'm a database-newbee. What I need is a column that makes the record
> unique. The content should be generated autoamtically and it should be
> able to get a lot of records (BIGINT would be nice). But I don't know if
> I should use PRIMERY KEY, KEY, INDEX or UNIQ
Asaf Maruf wrote:
>
> Dear all on list
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
>
> Is it possible that one column is tex
Mike Podlesny wrote:
>
> I want to select all the fields in from the mySQL database except I want my
> date field to be returned in the format of:
>
> January 16, 2001
>
> How can this be done without having to do the select in this manner:
>
> SELECT field1,field2,MONTHNAME(datefield),DA
GATOR-root wrote:
>
> >Description:
> We had an NFS incident and used CHMOD and CHOWN to repair it.
> Shortly there after, we noticed that our MySql under WebRT did not work.
> We presume that we corrupted the ownership and permissions of files and
> programs within MySQL.
>
> >How-To-Re
PHP handles persistent connections by leaving them open
for some other identical connection request. The next request
will check for a free connection.
see
http://www.php.net/manual/en/features.persistent-connections.php
In other words, you don't need to worry about when they are closed
php wil
Ann Ricchiazzi wrote:
>
> Dear mySQL Users,
>
> I am trying to choose between mySQL and Oracle for a Linux server. My
> specific questions are:
>
> 1) Will mySQL handle 3000 hits/day well?
> 2) Does mySQL handle multi-media file formats? For example, if I want to
> store audio clips, or Flash m
Nathan Cook wrote:
>
> Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
See... I know I've been spending too much time at the computer when
I get email in my dreams :)
what version are you talking about anyway, that number isn't even
a valid version number..
-
Paul DuBois wrote:
>
> In a table with no deleted rows, INSERTS happen by adding the row to
> the end of the table. An UPDATE won't necessarily be able to replace
> the row in-place (the new data may be longer than the old), so you won't
> be able to perform concurrent SELECTS along with the
I thought I should send this to the regular mysql list as there
are many mysql users who run DB on unix but must use windows
for a workstation and remote administration.
This is an excellent front-end.. It has the best UI of any of the
other windows front-ends I've seen, it is very fast, this is
Elekes Attila wrote:
>
> Hi!
>
> The mysql server (version 3.22.32-4) has hanged up, and the restarting
> causes a part of the
> *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> from these files :(
> Is there any method to recover the mysql tables from the remaining
> *.M
Elekes Attila wrote:
>
> Steve Ruby wrote:
>
> > Elekes Attila wrote:
> > >
> > > Hi!
> > >
> > > The mysql server (version 3.22.32-4) has hanged up, and the restarting
> > > causes a part of the
> > > *.ISM and *.ISD files ar
Chuck Barnett wrote:
>
> How do I copy the data from one table to another table with a time stamp
> every night?
>
> example: table A contains x,y,z.
>
> at midnight, I want to copy table A's contents to table B (B has same
> fields, just adds a date field) and reset x,y,z to zero.
>
what d
Chuck Barnett wrote:
>
> Thanks for replying.
> I know the SQL commands, I want to know how to automate the whole sequence.
>
> I've always written php pages that do the calls. I want to write a script
> to do it on the server as a cron job or something.
Ahhh, pardon my confusion, since this
Karen McAdams wrote:
> Is a space between characters considered a character
> in both column types or does one handle it
> differently?
Yes, it is a char.
>
> When I use a varchar I have to define its maximum
> length. I don't have to declare max length in
> tinytext. does this make a differen
Don wrote:
>
> Hi,
>
> I have a table called Ports that contains Port information and has
> several columns. I've designated the Portname column as Primary as it
> is unique (I did not specify it as unique). When I do a:
>
> SELECT * FROM Ports;
>
> It does NOT show the table contents in inde
"J.M. Roth" wrote:
>
> Hello,
>
> I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
> module) on an Apache 1.3.12 (Linux).
>
> Some SQL syntaxes that worked before don't anymore.
> E.g.:
>
> $query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
> doesn't wor
Leonardo Dias wrote:
>
> > I bet your webserver and database server are seperate machine.
> > Make sure the hostname of web and db are in the /etc/hosts on both machine,
> > it's very slow to use DNS to resolve everything
>
> That doesn't matter. We use IP to connect, not hostnames.
>
But if y
[EMAIL PROTECTED] wrote:
>
> I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
> searched the documentation on the site, but it doesn't seem to pertain to this
> version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
> figure out what it might bre
Don wrote:
>
> Hi list,
>
> I'm trying to backup up database in /etc/cron.daily. I've played with
> mysql dump with the following syntax:
>
> mysqldump --opt -p my_dbf.db > my_dbf.backup
> mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
> mysqldump --opt -p my_dbf.db > my_dbf.backup
James Ervin wrote:
>
> Can you restore from a backup of the mysql data directory or do you need to
> dump the database in order to be able to restore? I have seen some traffic
> on the list that suggests that a dump is the way to go. I backup the data
> directory each night, but I would hate to
Scott Baker wrote:
>
> That's the way that I do. I setup my server to shutdown the MySQL process
> at 3am, zip up my var directory, and then restart the process. Can you
> copy the data with the server running?
If you are shutting down the server, why don't you just copy the files
out to th
1 - 100 of 123 matches
Mail list logo
