-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 1:53 PM
To: Chetan Lavti
Subject: Re: RE: MySQL Backup and Recovery
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
Hi
You could handle this problem in a similar manner to the way we handle it
for the Sharp Zaurus PDA. We have a synch module which acts a mediator
between both the central db and the db on the PDA. In our case the PDA
stores info in a flat file system and the synch module maps data between
John,
I can see no explanation in the data stored in the table.
The important thing is what MySQL 'sees'!
You've already started testing your premise ASSUMING all records
are
either input or published One suggestion would be to use the
MySQL client for investigations, then if you
Hi
At 20:27 02/03/2002 +, [EMAIL PROTECTED] wrote:
Hi,
I am new to MySQL and to this list. I am currently going through Paul
Dubois' book, MySQL. I have set up MySQL on my Win 98 machine and am
able to access and create databases and tables.
The problem I am having is when I try to
Ron,
Ronnie wrote in message ...
--Boundary_(ID_3Wgj3oHvYWg449KlsCktkA)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
Hi everyone,
SQL
Iv'e been on innodb.com trying to find out the largest ibdata file size
acceptable to my system RH Linux 7.2, at one part it
Hi!
-Original Message-
From: j.random.programmer [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Saturday, March 02, 2002 5:21 AM
Subject: Re: Innodb tables lose foreign keys after creating an index...
--- Heikki Tuuri [EMAIL PROTECTED] wrote:
Heikki:
Is there a fix
Steve,
I added an item to the TODO list at http://www.innodb.com/todo.html
..
May, 2002:
Make a data file auto-extendible. You can specify the last data file in
innodb_data_file_path like this:
ibdata1:50Mautoextend
It will create a data file whose initial size is 50 MB, and InnoDB will
Greetings,
I brought new server and I'd like to copy old database to new server. MySQL
3.23.41 RH7.2 both machines.
I copyed /var/lib/mysql to new machine /var/lib/mysql and seems that MySQL
is working I can use databases and insert values into tables. But is just
copying right thing to do? Is
* Michael Widenius
The type of round(x,y) is double(max_double_digits,y) if y is a
constant and double(max_double_digits,4) if y isn't a constant. (The
4 is just a chosen value, as we didn't think of any better value)
mysql create table testme (number decimal (8,6),digits tinyint(3));
Query
I am novice in SQL so I may ask something very obvious, sorry.
If I have a table ordered by something, is it possible to select fields
from a record that appears on the table in a specific row number. And if yes, how can
I do it?
By row number, I mean that if the table has 10 records, I want
* Nikolas
If I have a table ordered by something, is it possible to select fields
from a record that appears on the table in a specific row number.
And if yes, how can I do it?
By row number, I mean that if the table has 10 records, I want to select
something from the record that is in the
The problem with LIMIT is that this table is not the same always, the
ordering
depends on data that changes.
I am ordering a table that contains webpages by the number of times they
have been visited. Then, for a specific page of them, I want to say in
which position
of popularity it is.
I
* Nikolas
The problem with LIMIT is that this table is not the same always, the
ordering depends on data that changes.
I am ordering a table that contains webpages by the number of times they
have been visited. Then, for a specific page of them, I want to say in
which position of
Hi Justin -
I have run into the same issues and have given up on using MySQL++ interface
for that reason, plus it doesn't have the ability to update tables
dynamically.
That is, if you need to update anything, you have to define the table to a
macro at compile time! Change a table, recompile
This round discussion has nothing to do with floating point
approximations.
Most round routines are statistically biased on the high side. The MySQL
round is statistically correct. The more accurate rounding rule is
If digit following the column you are rounding is a 5
I took a look at documentation and Paul's book at Safari and I couldn't fint
info about the various types of databases MySQL supports (Inno, default
MySQL ecc).
Where are they?
Thanks
Makis - no query
-
Before posting,
* Gordon
This round discussion has nothing to do with floating point
approximations.
well...
Most round routines are statistically biased on the high side. The MySQL
round is statistically correct. The more accurate rounding rule is
As far as I can tell, there is no MySQL round... as the
Hi all,
Have installed:
mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
I use a Win2K Pro, and downloaded it from http://www.myqsl.com
The problem is that a lot of commands are missing, like CREATE TABLE, or
even SHOW TABLE
Any help?
Regards
Steph
* savaidis
I took a look at documentation and Paul's book at Safari and I
couldn't fint info about the various types of databases MySQL supports
(Inno, default MySQL ecc).
Where are they?
They are called table types... you can combine tables of different types in
the same database.
URL:
* Stephane Collas
Have installed:
mysql Ver 11.16 Distrib 3.23.49, for Win95/Win98 (i32)
I use a Win2K Pro, and downloaded it from http://www.myqsl.com
The problem is that a lot of commands are missing, like CREATE TABLE, or
even SHOW TABLE
What do you mean commands are missing...? Do
Hi Roger,
It was may be a bad way to expressed.
I mean, I can't type the commands in DOS window, there are no .exe
Actually, would like to type my commands in text mod.
Regards
Steph
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: 'mysql' [EMAIL PROTECTED]
Cc:
Stephane...
What is the process you are trying to do?
In order to do commands in dos
Go to a command prompt:
C:\
Type this:
Cd \mysql\bin
Now type this:
Mysql
Now you should see this
Mysql
Type this:
\u name of your database;
Now type in the command:
Show tables;
Make sure you
Hi,
For those of you who are not aware of it, we run a searchable archive of this
list at the following location:
http://www.nextrieve.com/cgi-bin/mysql
We have added a bunch new features due to the release of a new version of our
search software. The search engine now interoperates with
Hi,
For those of you who are not aware of it, we run a searchable archive of this
list at the following location:
http://www.nextrieve.com/cgi-bin/mysql
We have added a bunch new features due to the release of a new version of our
search software. The search engine now interoperates with
Hi,
I was recently assigned to finish a project started by a previous employee.
The objective is to collect data from numerous geographic locations, and
then analyze the data at the central office. The goal is to look for
combined corporate trends and present statistical results and
On Sun, Mar 03, 2002 at 02:55:24PM +0200, Liivar Paas wrote:
Greetings,
I brought new server and I'd like to copy old database to new server. MySQL
3.23.41 RH7.2 both machines.
I copyed /var/lib/mysql to new machine /var/lib/mysql and seems that
MySQL is working I can use databases and
- Original Message -
From: Kim Hendrikse [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 03, 2002 7:04 PM
Subject: Searchable archives of this list
Hi,
For those of you who are not aware of it, we run a searchable archive of
this
list at the following location:
filter fodder: mysql, database, sql
whigh one is faster?
REGEXP or LIKE?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Is there any way in mysql to change a column that contains data
from null = yes to be not null.
I want to enforce users to enter some value in column_x that was
not a required field until now, by setting the column to not accept
any record where column_x is null, is there any way to do this
Craig,
At 10:02 AM 3/3/2002 , you wrote:
In an effort to encrypt private data in my database (national id numbers,
credit card numbers, passwords) I have had to resort to writing code in my
application using the Blowfish algorithm. Is there any facility for doing
this within MySQL (on
This is a definite newbie question. I downloaded
the Win32 version of MySQL to my personal pc
(windows 98), in order to become familiar with
the software. As directed by the section in the
online manual 2.6.2.3 Running MySQL on Windows,
I deleted the row in the mysql.user table that
holds
Hi,
On Tue, 2002-03-05 at 08:42, destr0 wrote:
whigh one is faster?
REGEXP or LIKE?
LIKE is an SQL language construct, REGEXP is a function.
LIKE only uses two simple wildcards (_ and *). Provided your LIKE
pattern does not start with a wildcard, the server will be able to use
an index for
On Sun, Mar 03, 2002 at 01:25:46PM -0800, Dreamtime.net Inc. wrote:
Hi,
We have mysql 3.23.43 running under FreeBSD 4.2, two-processors and
a Tyan LE S2510 motherboard with 1 gig of ram. After a few peak
loads of the server (load avg. gets higher than 20), mysql starts
eating processor
On Mon, Mar 04, 2002 at 02:42:46PM -0800, destr0 wrote:
filter fodder: mysql, database, sql
whigh one is faster?
REGEXP or LIKE?
LIKE is generally faster. But LIKE can't do everything that REGEXP
can, so that's probably no surprise.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
At 16:59 -0500 3/3/02, [EMAIL PROTECTED] wrote:
Is there any way in mysql to change a column that contains data
from null = yes to be not null.
Use the ALTER TABLE statement.
I want to enforce users to enter some value in column_x that was
not a required field until now, by setting the column
Hi Rebecca,
On Mon, 2002-03-04 at 05:19, Rebecca Hall wrote:
I was recently assigned to finish a project started by a previous employee.
The objective is to collect data from numerous geographic locations, and
then analyze the data at the central office. The goal is to look for
combined
Description:
Upon replacing mysql 3.23.21 with 3.23.49, all mysql functions
refuse to work. Apparently, it will not spawn /tmp/mysql.sock.
How-To-Repeat:
Replace mysql 3.23.21 with 3.23.49. Shut down all mysql
processes. Delete /tmp/mysql.sock. Attempt to restart.
Fix:
Dear all,
If my site has two users try to update the same piece of data in
mySQL at the same time.
* I wonder if I have to create a lock to handle the race condition in
my script or not?
* Or mySQL already provided a method, which is when the first user
update the data in mySQL,
Roger,
You can always write your own Round() function and have it
round exactly the way you want.
To round up on a decimal digit 5 use:
mysql select truncate(1.235+0.005,2) rounded;
+-+
| rounded |
+-+
|1.24 |
+-+
1 row in set (0.00 sec)
To round down
On Sun, Mar 03, 2002 at 07:51:36PM -0800, Son Nguyen wrote:
Dear all,
If my site has two users try to update the same piece of data in
mySQL at the same time.
* I wonder if I have to create a lock to handle the race condition in
my script or not?
* Or mySQL already provided a
hi,
I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
Now,for this database backup and recovery procedures are given as :
1. Taking 'binary' backup of the database.
2. Using the mysqldump utility
In the first method we do the following things :
ยท Shut down
On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote:
I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
Now,for this database backup and recovery procedures are given as :
1.Taking 'binary' backup of the database.
2.Using the mysqldump utility
In the
Thank you very much !!
I have a management screen, where I have two button namely BACKUP and
RECOVERY. I am not able to find out, how this will be done(both BACKUP
and RECOVERY)?, when I click on the corresponding buttons and while
doing this if error occurs, how I will handle them?. Moreover,
Please allow me to broaden this thread to include backup for mySQL
users who have accounts with ISPs.
In my case I have mySQL access on a Web server where I have NO access
to the server-level options. What is my best option of making a
backup of the database and tables that I use?
Also, what
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
On Sun, 2002-03-03 at 21:41, Jeremy Zawodny wrote:
On Mon, Mar 04, 2002 at 01:46:47PM +1100, Ashley Joyce wrote:
Does anyone know if Mysql supports geo-datatypes similiar to
PostgreSQL.. I want to use Mysql as the data source for
Mapserver?
It doesn't yet, no.
But I've seen
I am very new at using MySQL, so this may be a stupid
question. in my webpage front end, a user logs in,
and I pass his username to the form throught a hidden
form. The only problem is that the user name are all
FirstName LastName. It passes from the login page
to the php page fine, but once
Hi ,
I am working in mysql . with the help of password() function I insert the
data in some table .
for example :-
insert into a values (password('name'));
when I fire select query . It shows me this - 23e6065b74
I wants to decrypt the data again in same format as I insert with Select
query.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
Using the PASSWORD function is an irreversible process. Check the above
link.
A work around is you always deal with the encrypted password on the server
side.
E.g. When the user will login you encrypt the submitted password and do a
To examplify this:
When you add your user, do it like you do now:
insert into a values (password('name'));
When the user logs in at a later time, do this:
select * from a where pw = password('name');
If no row is selected, no user with that password was found.
- Carsten
- Original
Hello everyone!
I would like to use my mysql server via Perl.
Does anyone send me links or documents about it?
Thanks
Szabolcs
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I suppose I can't use InnoDB as I work remotly on a Internet Host.
But if I can, can you explain me - shortly- the benefits of InnoDB copmaring
with default MySQL?
I see has the transactions but new MySQL has them too.
Or if there is a comparison sheet somewhere.
Thanks
Makis
-Original
Is anyone using the conversion file (-e) feature in Maarten Boekholds dbf2mysql
software (contributed)?
Exactly what should this file contain (i.e plain characters, ascii/hex codes, mysql
char, ??)?
Is there an example anywhere?
Many thanks for any help on this.
Urban A.
[EMAIL PROTECTED]
54 matches
Mail list logo