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]
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 M
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)
http://lists.my
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 Mess
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
SELEC
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.
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
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
>Description:
>How-To-Repeat:
>Fix:
>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:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
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 i
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
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
>
> I
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 you
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 pro
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
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, mySQL
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 hints of that work in version 4.1
--
Jeremy D. Zawodny, <[E
Does anyone know if Mysql supports geo-datatypes similiar to
PostgreSQL.. I want to use Mysql as the data source for Mapserver?
Kind Regards,
Ashley Joyce
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi all,
ROUND decimal value is the mis-understood between MySQL internal
function and another environment/programming. I found that MySQL-Round is
correct within the suitable of itself (you can say it correct in C library
or other word it correct in technical term), but it did not use
>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:
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
> combi
Check out the MySQL website for altering table structure:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
You could use MODIFY to change the columns definition in your tables. Note
that specifying NOT NULL on a column will not affect existing rows where
that field already contains a NULL value.
R
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 col
Hello,
I am running into a problem with MySQL. I just can't figure it out and I
have spent several days scouring the Internet for ideas. I have a query that
joins 3 tables and I just cannot stop it from using filesort.
The three tables are "prop_data2", "prop_data_int", and "prop_data_string".
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]>
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 processo
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 i
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 Host
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 Win
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
w
>Description:
*** against BK as of set 1.1144 ***
It appears that putting SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS
in the same SELECT statement is a really bad idea!
SELECT FOUND_ROWS() after SELECT SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS
either returns a h
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
cycles.
Server load gets close to 1.0, mysqld is active all the time,
although
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 thi
> - 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 th
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 an
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 selected
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 mh
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 mh
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 foll
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 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"..
* 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.
http:
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
-
* 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
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, please
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
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 e
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 Windows)? Any third party tools out there? For
* 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 po
On Sun, 3 Mar 2002 14:58:33 +0100, Roger Baklund wrote:
>* Roger Baklund
>> I came across what I think is a serious inconsistency.
>>
>> http://www.mysql.com/doc/N/u/Numeric_types.html >
>>
>> This page describes DECIMAL (and NUMERIC) as an exact precission type.
>>
>> http://www.mysql.com/doc/P/
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 thi
Starting about 2 weeks ago I started having problems with my databases
disappearing. mysqld is still running and can be shutdown via
mysqladmin and such. But "mysql -ppassword -u root mysql" will produce
a message similar to "Unable to find database 'mysql'", and this goes
for all of the databas
* 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 i
* Liivar Paas
> 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 thin
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 t
* Roger Baklund
> I came across what I think is a serious inconsistency.
>
> http://www.mysql.com/doc/N/u/Numeric_types.html >
>
> This page describes DECIMAL (and NUMERIC) as an exact precission type.
>
> http://www.mysql.com/doc/P/r/Problems_with_float.html >
>
> This page includes DECIMAL as on
* 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));
Que
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 th
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
au
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
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", a
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 tr
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 << > are
> > either "input" or "published">>> One suggestion would be to use the
> > MySQL client for investigations, then if you
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
th
-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 fi
66 matches
Mail list logo
