Try using mysqldump.
BR,
Fbio 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
"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: "Fbio
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:
CREATE
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
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
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
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 on
- 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 wrote:
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
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,
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 = some_value, d = some_value, b =
some_value
The result tells me that MySQL is
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 take
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
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
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 Album, then get the
Hi,
I need help on compiling with the C APIs.
mysql v3.22.30
glibc-2.1.2-11
source code:
#include stdio.h
#include stdlib.h
#include mysql.h
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
void exiterr(int exitcode){
fprintf( stderr, "%s\n", mysql_error(mysql) );
exit( exitcode );
}
int
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
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
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:
Og nu da jeg s nrmere p din email adresse, er du selvflgelig velkommen
til at sprge p dansk... ;-)
Det er alltid hyggelig se p andre sprg p internettet, men hvis
du skriver p dansk, s skal de aller fleste taper sjansen lre om
ADO og MySQL.
Bob Hall
Know thyself? Absurd direction!
Bubbles
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
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
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 upgrade
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
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 -0700
On 28.02.2001 13:13:05 Bob Hall wrote:
Og nu da jeg s nrmere p din email adresse, er du selvflgelig velkommen
til at sprge p dansk... ;-)
Det er alltid hyggelig se p andre sprg p internettet, men hvis
du skriver p dansk, s skal de aller fleste taper sjansen lre om
ADO og MySQL.
Bitte
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 633913
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
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:
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
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
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 and not
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 manual.
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)
-
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
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 activo =
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 SQL
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 nu
[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 just fine.
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
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
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
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
[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 be set to
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 a hugh
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
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
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]; [EMAIL
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
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
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
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
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
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 thread,
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.
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
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
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
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
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
"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 MySQLGUI
Dear Sirs :
I'm attempting to install mysql 3.23.33 from source
distribution (I need source , not binary)
on my Digital Unix 4.0F , (I have a previous mysql 3.22.32
installed).
I follow the steps :
CC=gcc CXX=gcc ./configure
I can view on at config.log , that's all is fine, but when I
run
Hi.
On Mon, Feb 26, 2001 at 08:57:19PM +0100, you wrote
[...]
Yes, security info is to be sent to announcement list.
Well, the last two weren't sent to the announcement list, AFAIK. Well,
it's a question of its own, whether to send an announcement out due to
an buffer overflow in the client.
Hey everyone,
This may have already come up a couple of times in the mailling list, but I
I was wondering with mysql-3.22.32 if you can have two auto_increment's
in one table, e.g.:
+--+--+--+-+-++
| Field| Type | Null | Key |
Or use the no dependency flag or upgrade.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 23:36
Subject: Antwort: AW: version 3.23.29a-1
On 28.02.2001 14:28:14 Tobias Wolff wrote:
The binary may have a different name. If there
Just out of curiosity, why would adding a primary key make a difference to a
table being read-only or not? I thought it would be a DB permission
problem.
- Original Message -
From: "Miguel Angel Solrzano" [EMAIL PROTECTED]
To: "Produktberatung" [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent:
Hi,
We have installed Mysql on our server(UNIX) . When I am telnet into the
server and try to start Mysql by below procedure, I am getting problem.
Anyone can help me.
[/usr/home/tree/www/treebc.com] matis: {2} % cd mysql/bin
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {3} % ls
comp_err
Suggestion only: Try printing $sql on your web page and copy it to mysql
prompt and see what error you get, if any.
BTW: If you use single quotes, you don't need backslashes but personal
choice I suppose.
- Original Message -
From: "maxx" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
- Original Message -
From: "Nadim H Rabbani" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 22:50
Subject: MySql Support for Index Organizer tables
Hi--
Iam in the process of evaluating MySQL for research purposes .I would
like
to know if MySQL
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote:
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
Never heard of it. What is it?
- Original Message -
From: "Bill Herlehy" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 23:19
Subject: PSOSSYM
With MySQL software do you also receive PSOSSYM? If not where can I
receive this software.
--
Bill Herlehy
Try as suggested below then. Break up the file and feed each half into the
db and find where the problem lies. You may also need to change your dump
commands slightly so that import is ok in future. Because you upgraded, the
names of one of your tables or columns may now be a reserved
On Thu, 1 Mar 2001, nirmala wrote:
Hi,
We have installed Mysql on our server(UNIX) . When I am telnet into the
server and try to start Mysql by below procedure, I am getting problem.
Anyone can help me.
[/usr/home/tree/www/treebc.com] matis: {2} % cd mysql/bin
(second try, I had some magic words in this that set off the spam filter...)
Just as a general security note, make sure that you are not logging these SQL
commands somewhere... If you have entries like:
INSERT INTO my_table (blah, blah, blah) VALUES
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 4:08
Subject: Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there?
(LONG answer)
Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt hier
nur English bitte.
We've got our MySQL DB on comparable Linux Solaris hardware but Linux beats Solaris
by about 6 times.
Anyone have Solaris tuning tips ?
-
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
John
ALTER TABLE ADD [column] col_declaration
is what you are after I think - no need to go making another table
For example:-
ALTER TABLE example_table ADD example_column INT UNSIGNED NOT NULL
AUTO_INCREMENT
With the greatest regards to Paul DuBois whose marvellous book MySQL this is
Hi there,
I've got a site hosted at an ISP and everything was going well when they
decided to upgrade the software. Now my site is running under Win2K, IIS5,
MySQL 3.23.33 and MyODBC 2.50.36.
In order to get easier to explain what is going wrong, I've built the
following test:
CREATE TABLE
Turns out the Linux table_cache was 457 to Solaris 64.
Could that have been all the speed difference ?
- Sam.
Solaris
mysql show variables;
+-+-
--+
| Variable_name | Value
|
Has anyone installed MyODBC under Windows ME?
Did you use the Win95 or NT version?
I don't have the OS, still on Win95 and 98, but I have a client who wants to
install the driver.
Thanks in advance.
Greg Engel
-
Before
Hi =) Could you help me with creating a proper query? I have a table that
stores messages with a field for the message id, thread, and parent. The
goal is to create a query that gives me the total threads. I read in a
book and found the DISTINCT key allows me to run a query like this:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem
When I use C api to connet to mysql.
And I compile my program, I got an error:
Undefined first referenced
symbol in file
__udivdi3
/usr/mysql323/installdb/lib/libmysqlclient.s
o
__umoddi3
/usr/mysql323/installdb/lib/libmysqlclient.s
o
Thanks, Fred. The delete job has been running for 21 hours
at this point, and now rather simple queries on other tables hang
(e.g. SELECT COUNT(*) FROM other_table WHERE index=3Dsome_value).
I'll let it run overnight to see what happens, but I'm not hopeful.
Here's some addition
markr error messages show that lncurses, lcurses, ltermcap, could not be found.
markr We are running Debian Linux 2.2x, on SPARC. We are trying to install
markr 3.23.33. Any help would be useful thank you.
FYI, you can get 3.23.xx.deb from unstable in Debian.
Regards,
--Wen
[EMAIL PROTECTED]
From the 'user' table in the 'mysql' database:
mysql describe user;
+-+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---+--+-+-+---+
| Host|
When I use C api to connet to mysql.
And I compile my program, I got an error:
Undefined first referenced
symbol in file
__udivdi3
/usr/mysql323/installdb/lib/libmysqlclient.s
o
__umoddi3
/usr/mysql323/installdb/lib/libmysqlclient.s
o
99 matches
Mail list logo