Try using mysqldump.
BR,
Fábio Ottolini
-Original Message-
From: Keneth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 28, 2003 5:06 AM
To: [EMAIL PROTECTED]
Subject: how to backup mySQL database?
Anyone know how to backup mySQL database?
with best regards,
TOM
Hello,
I have searched for some information on single- and multi-colum indexes, but
often it is mentioned that the behaviour is implementation dependend. So I
post my questions on this list. If it's the wrong place, please redirect me
to the right one.
I am currently working with MySQL 3.22.32 o
"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
- Original Message -
From: "Fábio Ottolin
Hi:
Has anyone used MYSQL with StoreFront 2000? Thanks. Duane.
-
Hi
Lackó
mailto:[EMAIL PROTECTED]
- Original Message -
From: "Hanzsek Laszlo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 12:24 PM
Subject: Temporary merge table
> I want to create a temporary merge table:
>
>
Hi
i just installed the binay mysql on Solaris 8, i downloaded it from
www.sunfreeware.com
after the installation, i am running the mysqld the system returns with
this message
"ld.so.1: ./mysql: fatal: libstdc++.so.2.10.0: open failed: No such file
or directory"
any help?
thank you
Rodolph Aouad
I'm a new user and I bought a book PHP fast and easy web dev.
I'm trying to sign in. The book instructs me to c:\mysql\bin
then do mysqld --standalone I get a bad command error. What do I do?
_
Get your FREE download of MSN Explorer a
On 28.02.2001 04:57:04 ?iso-8859-1?q?Geetha=20Narayanan?= wrote:
> can i able to store images in database, not in
Yes sure, see below.
> binary format but directly as image and retrieve
An image is nothing but binary data, so I suppose you're just confused.
Okay, here's how I do that
On 28.02.2001 05:17:09 Rolf Hopkins wrote:
> But the way you are doing it now is perfectly ok. You may even find it a
Not always! There are setups where it is better to store the image in the
database instead of on the filesystem.
---
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
> Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine. But now the row will not have th
On 28.04.2003 10:55:50 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) "
You did not specify the username and password
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Geetha Narayanan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 17:01
Subject: Antwort: Re: storage and retrieval of images
>
>
> On 28.02.2001 05:17:09 Rolf Hopkins
> I'm a new user and I bought a book PHP fast and easy web dev.
> I'm trying to sign in. The book instructs me to c:\mysql\bin
> then do mysqld --standalone I get a bad command error. What do I do?
Install MySQL.
-
Before posti
Hi Jamie,
On Tue, 27 Feb 2001, Jamie Krasnoo wrote:
> Could anyone point me to any documents on creating a search engine using
> MySQL or search engine theory in general?
Try this one: http://info.webcrawler.com/mak/projects/robots/robots.html
I am writing a mySQL based search engine right now, a
Hello,
I'm slightly stunned seeing a result from the EXPLAIN statement.
I have a table "T" with columns "a", "b", "c", "d" and a multi-column index
on (a, b, c)
I perform a query:
EXPLAIN SELECT * FROM T WHERE a = , d = , b =
The result tells me that MySQL is taking index (a, b, c). Why?
Fur
On Tue, 27 Feb 2001, Markus H. Maussner wrote:
> does anybody know the limitations of mysql ? i am planing to make a
> big database. with big i mean something like 1,5TB ... the hardware
> seems not to be the problem (we get a big RAID for that, and our
> sysadmin sais that our linux system can ta
hello
i have mysql ver 3.22.29 installed.
My problem is that i m using mysql_ping at a lot of places (i.e before every
query) to check whether i have connection or not , in a program which is
running in deamon every 10 seconds i.e i dont close the connection anywhere,
just connect once and keep c
Hello. My name is Mayra.
I have an install problem when I try to install mysql in Solaris:
"checking return type of sprintf... configure: error: can not run test
program while cross compiling"
The matter is seemed to the commented problem in installation notes of
mysql manual. But this
>
>How do I do a single query to group a table by one column & then get
>the row of say the highest of each group ?
>
>Data is like so :
> Album, City, Plays, Date
>
>Britney, NYC, 103, 1-10
>
>Britney, SF, 101, 1-10
>
>Eminem, NYC, 100, 1-11
>
>Eminem, SF, 102, 1-11
>
>So I want to GROUP BY Alb
Hi,
I need help on compiling with the C APIs.
mysql v3.22.30
glibc-2.1.2-11
source code:
#include
#include
#include
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
void exiterr(int exitcode){
fprintf( stderr, "%s\n", mysql_error(&mysql) );
exit( exitcode );
}
int main(){
uint i = 0;
i
Hi
Two points:
- Any multi column index a,b,c also indexes a and a,b
- In using an index, efficiency is important, and if you have two indexes a,b,c and
a,d,b , when you hit data
from columns a+b+d, the database engine has to work out if accessing the data from
a+b is more efficient
than
Hi You,
I have some trouble with my MYsql installation. I imported several tables
from Foxpro that run/perform EXCELLENT! Great Tool! From any place I can use
all the tables only one table is read-only and I can't edit or delete any of
the rows. It gives both on mysql.exe and on Acc97 ODBC Error 1
Hi,
Since SuSE 7.1 I experience the following problem using MySQL:
andreaso@php4win:~ > mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
Looks like I don't get a connection...
andreaso@php4win:~ > su
Password:
ro
Hello,
I am using Poolman 1.4.1 , and trying to make 100
connections to mysql server.
ITs throwing an excepiton that cannot make connection
to mysql. We reached to a conclusion that mysql
supports 100 at a time connecdtions.
can u tell us how to configure mysql , to support more
connections.
>Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen
>til at spørge på dansk... ;-)
Det er alltid hyggelig å se på andre språg på internettet, men hvis
du skriver på dansk, så skal de aller fleste taper sjansen å lære om
ADO og MySQL.
Bob Hall
Know thyself? Absurd direc
well maybe I am just confused but I think that that function is in the libc
library, but then again I found it in the static library ie libc.a...
Why am I confused... I thought that it should have been included by default
or am I wrong, but I guess this is a question for a different NewsGroup...
Web robots are not search engines (just the things that fill the engines),
as far as I understand.
As I mailed to J. earlier, most searchengine algorithms aren't directly
compatible with (my)sql.
(Meaning that, for the best performance *you* have to do the searching, and
not mysql - once you have
Putting on my "Captain Obvious" costume here. Did you install MySQL first?
Cal
http://www.calevans.com
-Original Message-
From: matt sword [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 3:15 AM
To: [EMAIL PROTECTED]
Subject: help signing in
I'm a new user and I bought
I have problem
My server Linux RedHat 6.2 installed MySQL-3.23.33-1.i386.rpm
I want to connect to server for testing but I take an error message:
1130 - Host '192.168.0.42' is not allowed to connect to this MySQL Server
Please Help me...
HI!
Well patched 10.20 is an absolute minumum for MySQL.
Read our fine manual, chapter on HP-UX.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTEC
I have tried to install the rpm version of mysql 3.23.29a-1 on a Red Hat Linux 6.2.
It gives me an error asking for perl5 which I think I have it...
/*
[root@ghost2 mysql]# rpm -i MySQL-3.23.29a-1.i386.rpm
error: failed dependencies:
/usr/bin/perl5 is needed by MySQL-3.23.29a-1
[root@ghos
Try upgrading to gcc 2.95.2. That should fix the problem.
This cured my 'Installation of grant tables failed' error
condition.
Rgds, Bill Swanson
DNA Enterprises, Inc.
MIS Manager
972-671-1972
email: [EMAIL PROTECTED]
-- Original Message --
From: "
Sinisa Milivojevic wrote:
>
> As building process, nor system libs, may not be perfect, try using
> our binaries.
Thanks Sinisa, but this does not solve the problem - I've several
machines (RedHat|SUSE|SUN) (7) that all have near identical (with
different data and binary dirs so that I can upgra
Hello Mike,
Wednesday, February 28, 2001, 3:55:35 AM, you wrote:
You should know what you can't do direct comparasions between float
number and float const as the number really stored in a database can
be slightly different i.e
355.619
M
Hi Simon,
thanks for your response. So, would it be wise to replace the multi-column
index (a,d,b) with (a,d) to avoid the overhead you mentioned when accessing
data from a+b??
Thanks again,
Tobias.
-Ursprüngliche Nachricht-
Von: Simon Windsor [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwo
Well it isn't. I created a table with auto_increment, added 25 records,
deleted 5, did an insert, and the next auto number was 21.
>From: Steve Ruby <[EMAIL PROTECTED]>
>To: John Tsangaris <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: auto_increment
>Date: Mon, 26 Feb 2001 15:02:38
I've had the same issue. The problem, as I saw it, was that I inserted a
negatvie value into the ID field. For some reason, it "rolls" to the
highest possible positive numeric value if a negative number is used in the
ID field.
I made the field unsigned to address this issue in mySQL, but, t
The binary may have a different name. If there is only a /usr/bin/perl you
may have to create and symbolic link.
Tobias.
-Ursprüngliche Nachricht-
Von: acci [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 28. Februar 2001 13:53
An: [EMAIL PROTECTED]
Betreff: version 3.23.29a-1
I have tr
On 28.02.2001 13:13:05 Bob Hall wrote:
> >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen
> >til at spørge på dansk... ;-)
>
> Det er alltid hyggelig å se på andre språg på internettet, men hvis
> du skriver på dansk, så skal de aller fleste taper sjansen å lære om
> A
As building process, nor system libs, may not be perfect, try using
our binaries.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /
Hello,
I have compiled mysql-3.23.33 with Berkeley Db 3.2.9a
Iam not bale to startup the mysql deamon using safe_mysqld script.
Iam getting the following message in the error file under data dir
/usr/local/var
010228 19:06:09 mysqld started
010228 19:06:10 bdb: Recovery function for LSN 1 63
On Wed, 28 Feb 2001, Decasto David wrote:
> can u tell us how to configure mysql , to support more
> connections.
safe_mysqld --set-variable=max_connections=n
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
Hello.
I have installed from ports on FreeBSD 4.2 mysql323-server
It's working, but when I make mysql_query from php-file:
$sql="INSERT INTO guest (name,city,mail,text) VALUES
(\"$name\",\"$city\",\"$mail\",\"$text\")";
mysql_query($sql);
In brother window I have Warning from My
Hi,
On Wed, 28 Feb 2001, Sander Pilon wrote:
> Web robots are not search engines (just the things that fill the engines),
> as far as I understand.
Yes, you are right. I do know the difference between them too. I just
missred the letter. (Yes, I should first read and then write) Anyway, the
docs
The behavior differs between ISAM tables and MyISAM ones. Its all in the
manual.
> -Original Message-
> From: Bard dZen [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 1:23 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: auto_inc
Hello,
I´m having a problem running MySQL on a Windows 2000 Professional plattform.
There is no problem installing or uninstalling mysql, but you can´t start MySQL or the
MySQL service.
In the service list a MySQl entry exist, but when I´m tying to start it I get the erro
1067.
It is imppossi
Hi--
Iam in the process of evaluating MySQL for research purposes .I would like
to know if MySQL supports the following:
1-indexes,
2-cluster tables
3-index-organized tables
4-hashing
5- And any other support for embedded systems.
Thanks a lot for your help.
Yours
Nadi
I had the same problem.
Ensure that /var has these permissions: drwxr-xr-x
Ensure /lib is drwxr-xr-x
Ensure /mysql is drwxr-xr-x
That fixed it for me
rick
-Original Message-
From: andreas otto [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 6:11 AM
To: [EMAIL PROTECTED
I have had a similiar problem. Every morning I run a mysqlimport. The file I import
is about 500 meg. This ran fine for months but I upgraded to 3.23.33 and now the
import has hung three times.
>>> "Rolf Hopkins" <[EMAIL PROTECTED]> 02/27/01 11:04PM >>>
You really should reply to the list an
>Description:
When the shell script "mysql.server" is launched and/or stoped,
I receave an error message "mysql.server: @HOSTNAME@: command not found"
and the variable "pid_file" is not initialised
>How-To-Repeat:
Evry time when the script is launched with sart an
andreas otto wrote:
>
> Hi,
>
> Since SuSE 7.1 I experience the following problem using MySQL:
>
> andreaso@php4win:~ > mysql -u root -p
> Enter password:
> ERROR 2002: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (13)
>
> Looks like I don't get a connection
Nihat Tunalý wrote:
>
> I have problem
> My server Linux RedHat 6.2 installed MySQL-3.23.33-1.i386.rpm
> I want to connect to server for testing but I take an error message:
>
> 1130 - Host '192.168.0.42' is not allowed to connect to this MySQL Server
>
> Please Help me...
Lookup "grant" in the
Hello,
I'm working with version 3.22.32 of mysql on Linux Mandrake 7.
Here is my problem, mysql server gone away during process. I test all queries with
code error CR_SERVER_GONE_ERROR or CR_SERVER_LOST, and it is bad do mysql_ping() to
reconnect to the server but this return the error cr_serv
Hi Gerald,
> In order for andreaso to open mysql.sock, he needs search permission on
> /var/lib/mysql.
> chmod 775 /var/lib/mysql
That was it! Thanks for helping me out ;-)
Cheers,
Andreas
--
andreas otto
london (uk)
-
B
Micke
Can't really speak for Professional but I have it running fine on Server and
Advanced Server.
If my memory is right then 1067 is normally that the service cannot respond
to the control function effectively. Together with the fact that you cannot
remove the service after uninstall, this sug
Hello mysql,
Mysql 3.23.32 running on Linux.
I've got a table with auto_increment command stuck, well this is no
problem there is a record in this table with MAX_UINT value.
I'm not really shure if this is a bug or correct behavior, but still
it leads to toe problems in this case:
insert int
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
S A wrote:
>
> Can MySQL help with generation of ALPHANUMERIC unique identifiers ?
>
> ID's that use the full ASCII char range create more possible combinations with the
>same # of characters which can be important when squeezing into cookie storage space.
>
> 4 character numeric ID has 10,000
Angel Behar wrote:
>
> Hi !!!
>
> I'm running 3.23.28-gamma under windows NT, but I have the following
> problem.
> I need to query some data and gruop by some field (codigo in this case) so I
> run the following query :
>
> SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND a
Hi Phil,
>Looked at the Innobase web site - very exciting looking specs.
>SQL:
> -a small interpreter with stored procedure syntax like in
>Oracle, no SQL optimizer
>Does this mean that MySQL using Innobase tables, will this allow for stored
>procedures of
>multiple
Hi
Since the language of business here at MySQL is English it would be nice if
all messages to the list are written in English. This way you would have more
chance of receiving reply
On Wednesday 28 February 2001 12:54, [EMAIL PROTECTED] wrote:
> On 28.02.2001 13:13:05 Bob Hall wrote:
> > >Og
[EMAIL PROTECTED] wrote:
>
> On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
>
> > Try using mysqldump.
>
> This won't work always! For instance, I have a table that has a auto_increment
> INT column in it. Storing a row with this column set to 0 (zero), will add this
> row jus
On 28.02.2001 14:28:14 Tobias Wolff wrote:
> The binary may have a different name. If there is only a /usr/bin/perl you
> may have to create and symbolic link.
Which won't work, because RPM doesn't care at all about what the filesystem
really looks like. All it cares about is what it THINKS sh
With MySQL software do you also receive PSOSSYM? If not where can I
receive this software.
--
Bill Herlehy
Alcatel USA
Program Manager
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
On Wed, Feb 28, 2001 at 08:09:04AM -0600, Gerald L. Clark wrote:
> S A wrote:
> >
> > Can MySQL help with generation of ALPHANUMERIC unique identifiers ?
> >
> > ID's that use the full ASCII char range create more possible combinations with the
>same # of characters which can be important when
Thanks for the answer. but actually I'm not saying that mysql is doing
wrong, I just want to know HOW can I group by codigo and then get 10 random
rows of the grouped ones.
Hope I explain me.
Thanks again.
> Angel Behar wrote:
> >
> > Hi !!!
> >
> > I'm running 3.23.28-gamma under windows NT,
Hello,
I'm looking for MySQL tutorial with Visual C++.
could some one of you provide me an URL ?
big thanks,
zul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Laurent Oget wrote:
>
> On Wed, Feb 28, 2001 at 08:09:04AM -0600, Gerald L. Clark wrote:
> > S A wrote:
> > >
> > > Can MySQL help with generation of ALPHANUMERIC unique identifiers ?
> > >
> > > ID's that use the full ASCII char range create more possible combinations with
>the same # of charac
mysqldump "spits" not only table structures but data also. When you use
mysql to import data it will first attempt to create the table and then load
its values. If your table's got AUTO_INCREMENT set it will work fine after
recreating the database. Anyway... Give it a try! :)
BR,
Fabio Ottolini
On 28.02.2001 16:03:57 Gerald L. Clark wrote:
> But the dump who't have it set to zero, so it will reload with its
> proper value.
No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
(AutoCol) VALUES (0)" means that AutoCol should be set to the next available
value (if Au
On 28.02.2001 15:33:27 John Dean wrote:
> Hi
> Since the language of business here at MySQL is English it would be nice if
> all messages to the list are written in English. This way you would have more
> chance of receiving reply
Yeah, that's just what I was saying :]
--
I want to take a hash, in Perl w/ DBI, and store it in a column in one of my
MySQL tables. I tried writing it to a blob, but I can't read it back later.
How would I go about storing the hash and then reprocessing it later?
Thanks in advance,
Dunc.
---
>Description:
I can't make mysql from the provided sources. It looks like
get_hash_symbol() is not defined anywhere. Here's where the make
fails:
make[3]: Entering directory `/export/home/jhfrontz/src/mysql/mysql-3.23.33/sql'
c++ -DMYSQL_SERVER
> On 28.02.2001 15:33:27 John Dean wrote:
>
> > Hi
> > Since the language of business here at MySQL is English it would be nice
if
> > all messages to the list are written in English. This way you would have
more
> > chance of receiving reply
>
> Yeah, that's just what I was saying :]
>
But I'm s
Does anyone have any tips on writing programs with threads using the mysql c api? I
didn\'t want to have to learn it the hard way.
- Dan
Posted via Project Horizon
http://www.projecthorizon.com
-
Before posting, please che
[EMAIL PROTECTED] wrote:
>
> On 28.02.2001 16:03:57 Gerald L. Clark wrote:
>
> > But the dump who't have it set to zero, so it will reload with its
> > proper value.
>
> No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
> (AutoCol) VALUES (0)" means that AutoCol should
From: "Florian G. Pflug" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 1:31 AM
> I think XML support should not be just "sending the respone of an
> SQL-Queries written in a weird way as an XML Document as another weird XML
> Document to the client".
>
> It should make the DB-Server into
At 12:25 28/02/2001 +0100, Produktberatung wrote:
Hi!
The MySQL table has a primary key ?.
If the answer is no, add a primary key and try again.
Regards,
Miguel
>Hi You,
>I have some trouble with my MYsql installation. I imported several tables
>from Foxpro that run/perform EXCELLENT! Great Tool!
I have a rather large table (~130 million rows) running under MySQL
3.23.30 and have been very pleased with the performance of the
database. However, occasionally I have to delete millions of rows
from the table, and it appears that MySQL hangs on these jobs. To
be specific, I am running a delet
This is the way i do it:
- write a script that will run mysqldump on the database of choice and then pipe the
result though gzip (this is only to reduce the size)
- the script also copies the new backup over the old one where every you may be
backing it up
- run this script with cron every nigh
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :)
Good humor in this list, don't stop please
:) Philipp
- Original Message -
From: "Jason Landry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "John Dean" <[EMAIL PROTECTED]>
Cc: "Bob Hall" <[EMAIL PROTECTED]>; <[
Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt hier nur English
bitte. Kein Deutsch order Nederlander (ich glaube das ist Nederlander. Vieliecht
nicht).
-Original Message-
From: John Dean [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 8:33 AM
To: [E
Does anyone have any suggests on how to write thread safe programs with the mysql c
api? I\'ve heard a lot about it and know that i\'m going to do it i just don\'t want
to have to learn the hard way.
- Dan
Posted via Project Horizon
http://www.projecthorizon.com
--
Another tip is to store the backup on a separate physical disk and tape to
the actual database, because if they are on the same device, and that dies,
then there goes your back up too!
Quentin
-Original Message-
From: Dan Adams [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 March 2001 8:21
BUG: Telling me I "shouldn't have done" something, not even mentioned
in the manual, does not help me fix the problem.
BUG: Having to completely reinstall the operating system (Linux) in
order to repair problems with a mysql install. Or does someone
actually have any recommendations on this?
Dunc,
Check out either of these modules. You can insert their results into the
database and eval them later to restore the structure.
http://search.cpan.org/search?dist=Storable
http://search.cpan.org/search?module=Data::Dumper
For a simple hash, you are probably better off just using a two colu
>Description:
If Autoincrement can only work with positive numbers, then any
key that is auto_increment should automatically be made unsigned.
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
58k.com
>MySQL support: [none | licence | email support | extended email sup
Is there an archive for this mailing list?
-
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 PROTECT
I am interested in sourcing an accounting package in mysql. We are a vertical
developer in need to port our application to the web. Please respond with serious
solutions. We do not require services initially just product. Willing to negotiate
source code license if required.
Paul Hernandez-Cue
You shouldn't have to reinstall Linux, just uninstall the old RPM, or
delete the old version which was installed from source, and install the
new version if it be from RPM or whatever. There is no way that the
manual could cover every installation medium that exists (RPM, tar, DEB,
BSD Ports tree
kentj wrote:
>
> Is there an archive for this mailing list?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this
Well, except that the value of an auto-increment field CAN be set to a
specific value (perhaps negative) an INSERT or UPDATE statement.
> If Autoincrement can only work with positive numbers, then any
> key that is auto_increment should automatically be made unsigned.
>
---
Hi guys,
I am part of a team developing an interface from Microsoft Access on a
Windows environment to mySQL on a Cobalt RAQ server (LINUX).
When you say the software mySQLgui is in "beta testing", what level is
that? Is alpha a step higher than beta, as in the best and ready for
distribution. O
Hi,
I've got 350 mailing lists that have approx 32 fields. Each list will
have between
100k to 200k records. Should I create a database for each individual
list or create
one database with one table for each? If I take the latter approach I'll
end up with
35 - 70 million records in a single datab
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 MySQLGUI client:
Can't connect to loc
Hi,
I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to
decrypt them when I retrieve them.
I've tried:
mysql> insert into payment (payname1,ccaccount) values
("Kinney",encode('','Ilwfci');
ERROR 1064: You have an error in your SQL syntax near '' at line 1
mys
Thank you!
Sorry for my frustration, but I have been wrestling with this for a
week. In that time, I have neither seen meaningful suggestions, nor
have I seen help for a few others with similar problems.
I would still like to see a list of warnings that would alert me to
pitfalls and other dan
Your not closing off enough )'s
should look like this:
insert into payment (payname1,ccaccount) values
('Kinney',encode('','Ilwfci'));
Then, for decode, you do it like this:
SELECT DECODE(ccaccount,'Ilwfci') AS ccnumber FROM payment WHERE payname =
'Kinney';
- Original Messag
We run MySQL (3.22.32) on Windows 2000 servers, and have found that if we
issue the NET STOP MYSQL command from the DOS Prompt, it does in fact
shutdown the service ... it just takes much longer
than on the WinNT platform. Patience is the key. Same with removing the
installed service.
In every in
on 2/28/01 4:18 PM, Kinney Baughman at [EMAIL PROTECTED] wrote:
> Hi,
>
> I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to
> decrypt them when I retrieve them.
>
> I've tried:
>
> mysql> insert into payment (payname1,ccaccount) values
> ("Kinney",encode(''
1 - 100 of 137 matches
Mail list logo
