We have the following problem: on the server (quite fast) we have the
Mysqld-nt daemon running ; and the data resides in it. When a user
access the server with a very long query and another try to do the
same , but with a very simple query ; the last one has to wait a very
long time because of the
All,
I've been having problems with a pretty simple series of SQL statements run
against some InnoDB tables returning the wrong results - temporarily!
Basically, I have one middle table that maps a role to an operation
(many-to-many), and I have separate role and operation tables that contain
Hi!
We are using mysql, version 4.0.4 beta on windows 2000 Server.
I packed a table with 100 million rows, using myisampack.
Now queries don't use the index of this table.
It's not possible for me, to work with table scan.
So, what can i do?
Kai
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Ben,
From the MySQL man online @
http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 :
PASSWORD() encryption is non-reversible.
To create a forgot your password page, the best method is to generate a net
password
Hello dear Mysql
http://gobrutal.com
dedicated to the beauty of Young Girls. Undoubtedly, this site is the best of its
kind.
We bring you only tasteful high quality fotos videos of young girls.
Every frame honors purity and innocence of youth involved in sexual acts...
Hi Ben,
As far as I know the algorithm used for the decrypting is a one-way hash function,
thus there is no way of decrypting it.
You may consider to reset the password and mail the user the new one instead of
mailing the old password.
The second solution is to store the password a second
Hi,
I'm having trouble writing dial-up user billing software in C using MySQL C
API.
Program suppose to send query to mysql server and retrieve records and
process those.
It sends query for each class_id for every day and get records from
ACCOUNTING table.
While retrieving records it adds user
Greets Folks,
I have been wanting to get into data driven sites for the longest time, and
I can do some immediate level work in them using perl, but my understanding
is still not comprehensive enough for whatever it is I want to do
(subconsciously).
I sense there is some need to pursue
If you know the primary keys of the two tables, it may be done as follows:
select count(distinct t1.pk1) + count(distinct t2.pk2) from t1,t2;
where - pk1 is the primary key column name of table t1 and
pk2 is the primary key column name of table t2.
SB
- Original Message -
From: Rick
Try using mysql_free_result each time after fetching the rows.
SB
- Original Message -
From: Ganbold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 4:27 PM
Subject: Help! problem using MySQL C API
Hi,
I'm having trouble writing dial-up user billing
Hello!
mysql Ver 11.18 Distrib 3.23.53, for portbld-freebsd4.7 (i386)
I have a problem with dumping data into databases.
I dump the database with mysqldump into a SQL-File.
So, i delete the database. Now i want to redump the SQL-File into database.
SQL tells me an error. The Problem is MySQL
When MYSQL is being heavily used on a windows cpu, In Task Manager does the
memory cpu load increase show the use for mysqld or another process like
Explorer?
-
Before posting, please check:
http://www.mysql.com/manual.php
* raj
However, I wish to use this as a security tool. I.e. one in which I (as
the mysql admin) can do a grant like:
all queries on a specific table from user apache must only return
1 record
This would be like forcing a limit of 1 (using the technique below).
I don't think GRANT can be
Having just walked into a job a few months back, one of the tasks I've
been asked to accomplish is to counting records inside a DB based on a
field. The database in questions holds realtor listings. There are fields
for Company Name and Agent Name on each listing. What I need to do is sort
On Tue, 12 Nov 2002, John Chang wrote:
Is there a good or bad reason to create the config file in the MySQL folder?
IMHO, usually no. But if you have several differently configured server
instances, it might make things more logical.
On production servers which logs do you turn on?
Error log
I need to move a whole bunch of web sites from one server to another.
This means moving cold fusion, MySQL, qmail, etc.. fun stuff.
What's the best way to move *ALL* of the MySQL databases on my system?
Do I basically just shut down the database, tar up the /var/lib/mysql
directory and move it
Description:
I use a little subset of mysql++ capabilities
- Connection
- Query ( only Query::store )
- Result
Memory leak I discovered is located somewhere in Result::operator= and is
available only after update;
Proof of concept code is supplied.
It leaks 1 Mb of
Background:
MySQL++ ( libsqlplus ) is a pretty nice official C++ styled mysql client
library wrapper of libmysqlclient. It offers STL-style C++ interface and is
designed with an effort of generic programming style. It should be a really
excellent choise if only it had not a MEMORY LEAK
* [EMAIL PROTECTED]
Having just walked into a job a few months back, one of the tasks I've
been asked to accomplish is to counting records inside a DB based on a
field. The database in questions holds realtor listings. There are fields
for Company Name and Agent Name on each listing. What I
I recently installed mysql 3.23.53 on Windows NT.
I'm no longer able to run 'winmysqladmin.exe'. The following message is
displayed:
winmysqladmin.exe - Entry Point Not Found
The procedure entry point CreateToolhelp32Snapshot could not be
located in the dynamic link library
Hi,
Is there a way to compare between a mysql process ID showed in top or ps
with a process ID from mysqladmin processlist ?
I'm asking this because we operate a mysql machine used for webhosting and
it has many users and many databases. If users do crazy stuff that result in
high usage of
I've been trying to work out a complicated query to select and
sum multiple columns in one select using a condition and multi column group by
What I expected to get was ONE row with the columns summed .
this query returns 5 rows
SELECT
Thank you for the response. It looks like that worked! I am going to try it
on the webpage now. I will let everybody know if this works.
Thanks
Rick
PS. to everyone else I want to say thanks. I have run the ones that you have
sent but always came up with an error. If you want me to send you the
Mike,
thank you very much for a repeatable bug report!
This revealed an embarrasing bug in InnoDB SELECTs: if you selected with the
full value of a primary key, and the row which matched to it was
delete-marked, then InnoDB could in some cases return the NEXT row.
Since purge cleans off
- Original Message -
From: William Martell [EMAIL PROTECTED]
To: MySQL Main List [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 2:02 PM
Subject: SCHEMA, ARCHITECTURE ???
Hello All,
How do I determine the best architecture for my MySQL database?
Do I create multiple databases or
* TimeWalker
I've been trying to work out a complicated query to select and
sum multiple columns in one select using a condition and multi
column group by
What I expected to get was ONE row with the columns summed .
this query returns 5 rows
SELECT
For speed multiple or single database makes no difference.
For SQL I would stick with one if all the data is related.
Index any thing you are going to select on. So if you have a user database
you would index name and password not there age and job title.
Simon
- Original Message -
From:
Search for aliases in manual.html.
PB
-
- Original Message -
From: Phillip Rhodes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 12, 2002 8:59 PM
Subject: support table synonyms?
I can not find anywhere that says that mysql supports table name synonyms.
For
what mysql version is recommended for running w/apache 1.3.26 php
4.2.2?
i'm having trouble getting mysql config'd w/these wonder if i should
avoid/lean to any particular versions?
-
Before posting, please check:
3.23.55 Production
4.2.2 is ALPHA
4.0.4 is BETA
So if you are runing a production server go for 3.*
If you can risk it go for 4.0.4 (should be ok)
and if you want to have some fun 4.2.2
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett;bard.edu]
Sent: 13 November 2002 16:05
To:
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't set root user passwd? simple syntax
error?
[root@a bin]# ./mysqladmin -u root -p password pp
Enter password: i enter p again
./mysqladmin: connect to server at 'localhost' failed
I want to code the following in one statement:
select min(field1) from table1;
$res=result of the query
select * from table1 where field1=$res;
does anyone know?
-
Before posting, please check:
pp
p
Look like you need a 'p' :-)
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett;bard.edu]
Sent: 13 November 2002 16:28
To: MySQL Mailinglist
Subject: setting passwd?
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't
Description:
mysqlhotcopy ignores --host -h option
How-To-Repeat:
call mysqlhotcopy with a host differs from localhost
Fix:
Add host|h=s to GetOptions
Submitter-Id: submitter ID
Originator:
Organization:
organization of PR author (multiple lines)
MySQL support: none
tx - i knew the diff between prod/ 'having fun' will stick
w/production. just wasn't sure if there were verion conflicts w/the php
apache, or it was just user (ie. me) error in config's
per below response - that would explain why mysql gets installed 1st.
i've heard/read? to stick w/all source,
Ben C. wrote:
I am using the MySQL password() function for the my passwords on the user
names. How do I decrypt the password in PHP to send it in an e-mail. I am
Short answer: You don't.
Long answer: search the archives for this mailing list; it was asked
about a week ago and I gave a
Hello All,
Using MySQL for sql...webpage forms:
I am trying to order the following:
1-03-0A0019-03-0D004;
this works fine using simple order by asc.
when I added 11-02-0B001, etc. it came after 1-03-
0D004, then continued to rest of order.
how do I fix this so that 11-xx-xxx comes after
The -p means you are going to enter the CURRENT password.
Since you don't have one yet, either leave off the -p, or
hit the enter key at the passowrd prompt.
P. Fawcett wrote:
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't set root user
The MySQL have SPOOL where can I stores query results in a file?
How can I do this?
How can I show my Indexes, Primary keys and Foreign Keys?
best regards,
Sil
-
Before posting, please check:
http://www.mysql.com/manual.php
Erwin Ulreich wrote:
I want to code the following in one statement:
select min(field1) from table1;
$res=result of the query
select * from table1 where field1=$res;
does anyone know?
select * from table1 order by field1 desc limit 1
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Hello All,
Using MySQL for sql...webpage forms:
I am trying to order the following:
1-03-0A0019-03-0D004;
...
when I added 11-02-0B001, etc. it came after 1-03-
0D004, then continued to rest of order.
Hi,
I currently have my replication setup with 3 machines
as such:
A B C
Machine A just died, so B is now my master. However, I
want to re-adjust my setup so it looks like this:
B A C
So what I did was stop C and copy everything over to
A. At this point, either A or C should be able to
Hi,
perhaps try :
ORDER BY SUBSTRING_INDEX(your_field, '-', 1) asc,SUBSTRING_INDEX(your_field,
'-', 2) asc,SUBSTRING_INDEX(your_field, '-', 3) asc;
Regards,
Jocelyn
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 4:38 PM
Subject:
Hi,
I am using Mysql version: 3.23.52 on Red Hat Linux. I tried to create a
table as below and got error. Could some one point me what I did wrong?
Or the DATA DIRECTORY defination does not really exist?
Thanks, Yuyi Guo
mysql create table testtable2 (col1 varchar(10) NOT NULL, col2
That's right, I should have checked before clicking on Send ;)
gerald_clark wrote:
That should not be DESC.
That will give the max value.
Joseph Bueno wrote:
Erwin Ulreich wrote:
I want to code the following in one statement:
select min(field1) from table1;
$res=result of
I am a little new to MySQL and PHP. How do I make the password a temporary password.
So when they login the first time they need to reset the password?
Thanks for you help in advance.
Ben
From: Merlin, The Mage [EMAIL PROTECTED]
Date: 2002/11/13 Wed AM 04:20:20 EST
To: Ben C. [EMAIL
At 11:21 -0600 11/13/02, Yuyi Guo wrote:
Hi,
I am using Mysql version: 3.23.52 on Red Hat Linux.
The option is DATA DIRECTORY, not DATA_DIRECTORY, but in any case it was
introduced in 4.0.0. Your version doesn't support it.
I tried to create a table as below and got error. Could some one
At 23:27 -0800 11/12/02, Ben C. wrote:
I am using the MySQL password() function for the my passwords on the user
names. How do I decrypt the password in PHP to send it in an e-mail. I am
making a forgot your password page and want to have the user enter their
e-mail and have the password sent
Ben,
create a column in the user table, that holds a flag called mustChangePassword (or
whatever you want to name it). Then write your PHP code that way, that a login of a
user who must change his password will be redirected to the change password page and
store the new password and reset the
Thanks for the reply.
I'm not clear on the solution?
--- Original Message ---
From: Cooke, Francis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Order issue with MySQL
--
From:[EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Hello All,
Using MySQL for sql...webpage
Daya,
Wednesday, November 13, 2002, 7:51:53 AM, you wrote:
DKD Can naybody tell me how do i ignore special character while insering in
DKD mysql database. For example while i m inserting string 'dk\bd\r' it takes \b
DKD and \r as diffenrent character, although i can ignore it with one more
DKD
Hello.
I have a problem with mysqld 3.23.49 .
My program consists of a father process and n children.
The children do a UPDATE at a certain time and the father might do a
SELECT at the 'same time'.
I suspect strongly that this is the problem. Any ways the father process
hangs at random
Hi all,
I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.
I could find only the module DBD::mysqlPP for pure Perl.
I don't understand what pure perl means but I've seen that this module
I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I
did it for both. I'm still getting this:
[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost'
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
At 11:45
I would like to upgrade MySQL to the latest production release
(3.23.53a) from my current 3.23.41
I have the following packages installed already:
mysql-devel-3.23.41-1
mysqlclient9-3.23.22-6
mysql-3.23.41-1
mysql-server-3.23.41-1
What do I need to do in order to upgrade to the newest version?
Hi,
Today I had a crash on my production server running Max-3.23.53a
It has the following specifications
MySQL-Max3.23.53a
RedHat 7.3
Kernel 2.4.18-SMP
Glibc-2.2.5-42
2GB of memory
When I resolv my stack_dump I get the following. Can anyone make something
useful out of this?
Hi,
You can make your own authentification system.A table which can have a
binary char/varchar field for encrypted password(effect similar like
password from mysql.user) and another char for ASCII password.
If you not use grant statement for adding new user, you can use the MySQL
authentification
On 13 Nov 2002 18:31:15 -
[EMAIL PROTECTED] wrote:
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please send an empty reply
to this address:
[EMAIL
It doesn't appear this part is valid sql, query
DATA_DIRECTORY=/tmp;
~K Black
-Original Message-
From: Yuyi Guo [mailto:yuyi;fnal.gov]
Sent: Wednesday, November 13, 2002 9:21 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: create table w/ data/index directory
Hi,
I am using
I'm working with MySQL-Innodb and I have one table with primary key composed
by the 5 first fields, and I want to change this removing the primary keys
attributes and add one new field in the first position as primary key and
auto_increment. How can I do this?
best regards,
Sil
Sorry I made a mistake as Paul pointed out.
I meant
GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
If you use the localhost substitution for the fully qualified domain name
then be sure your /etc/hosts file has a line at the top like
127.0.0.1 localdomain.localhost
Hi, we're using Innodb here and I just upped the number of datafiles
that innodb was using. When I did a show table status I noticed that I
didn't get all the space that I had added. When I looked at the error
log, I got recieved the following error.
InnoDB: Error: tablespace size stored in
On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote:
Can any of you point me to documentation or have a quick summary of
how beefy to make a mysql server. Basically we probably won't have
more than 50 connections at one time and we will be pushing packets
of 2Mb at times. I'm
It does except my hosts file has localhost.localdomain switched around
from what you specified. Mine is:
127.0.0.1 web01.nxtek.net web01 localhost.localdomain localhost
Any other ideas anyone? I wish the rpm did all this crap. heh
-Original Message-
From: Black, Kelly W [PCS]
[EMAIL PROTECTED] wrote:
Hi all, i'm planning on using servlets for an application I am
building What I need to know is if there are any thread safe JDBC
drivers?
MySQL Connector/J is thread-safe, but even though the JDBC spec states
that the driver itself must be thread-safe, most of
Hello.
I have a problem with mysqld 3.23.49 .
My program consists of a father process and n children.
The children do a UPDATE at a certain time and the father might do a
SELECT at the 'same time'.
I suspect strongly that this is the problem. Any ways the father process
hangs at random
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the
You might need to use rpm -e to uninstall previous version first.
Check the documentation.
~Kelly W. Black
-Original Message-
From: Rick Root [mailto:rroot;wakeinternet.com]
Sent: Wednesday, November 13, 2002 10:47 AM
To: mysql
Subject: Upgrading MySQL from 3.23.41 to 3.23.53a
I
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running
On Wed, Nov 13, 2002 at 05:03:38PM -0200, Silmara wrote:
I'm working with MySQL-Innodb and I have one table with primary key composed
by the 5 first fields, and I want to change this removing the primary keys
attributes and add one new field in the first position as primary key and
On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote:
Jeremy Zawodny wrote:
Well, it handles ISAM, MyISAM, and BDB (last I checked). So what
should it be called? mysql_isam_myisam_bdb_hotcopy?
Heheh, point taken. It seems simply unfortunate that the program in
I have a windows 2000 adv server that is running mysql and php in other to
interact with couple of other Microsoft Access database.
However, I have a challenge with the function odbc_fetch_array( ) which is
returning a endefined function error when used with the ODBC connection.
I have used
If you ran into any problems it would probably
be RAM. RAM is cheap so if you have trouble...just
pop a couple of 512MB chips in it.
~KB
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com]
Sent: Wednesday, November 13, 2002 11:12 AM
To: Devore, Jacob
Cc: '[EMAIL
At 13:47 2002-11-13 -0500, Rick Root wrote:
[root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.41-1
MySQL-server conflicts with mysql-server-3.23.41-1
[root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm
error:
Almost forgot to say,
I'm running mysql with the following command:
./safe_mysql --user=mysql --skip-networking --skip-locking --log-slow-queries
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello all,
I've been having some problems with MySQL crashing. I use a mixture of
MyISAM and InnoDB tables, but most of the data is under InnoDB tables. My
web applications all do relatively complex join queries. Almost all fields
in the WHERE clauses of queries are indexed.
I'm running
Where can I get a tuning guide for MySQL (MyISAM and InnoDB)...
memory-wise and son on?
At 11:11 13/11/02 -0800, you wrote:
On Tue, Nov 12, 2002 at 11:22:11PM -0800, Devore, Jacob wrote:
Can any of you point me to documentation or have a quick summary of
how beefy to make a mysql server.
Shakeel,
- Original Message -
From: Shakeel Sorathia [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:39 PM
Subject: InnoDB: Error: tablespace size stored in header
Hi, we're using Innodb here and I just upped the number of datafiles
that
Hi,
I am trying to comile a c++ program but I got an error message as below:
sqlplus.hh: No such file or directory
I have mysql server and client 3.23... on rh 7.2 and I have installed binary
RPM for SuSE 8.* built by gcc 3.2
../Downloads/mysql++/mysql++-1.7.9gcc3.2-2.i386.rpm
by: rpm -ivh
At 23:23 -0500 11/12/02, [EMAIL PROTECTED] wrote:
The MySQL documentation (4.6.1) says:
You can change the character set with the --default-character-set option
when you start the server. The character sets available depend on the
--with-charset=charset and --with-extra-charsets=
Hi
It's not a MySQL issue, it's a web server configuration problem. Check
you php.ini file and unquote in the section:
;Windows Extensions
the line accordingly with the DB connexion you're using. MySQL is set by
default.
Also try the function odbc_fetch_into()
-Mensaje
Hi,
I am newbie to MYSQL and ODBC
I have to update more than 2 tables simultanously
currently my application uses ADOBC connection object.
How can turn off the autocommit option and set manaul commit.
what places I need to change inorder to work manual commit
Thanks in Advance for your time
Hi Guys,
I am trying to comile a c++ program with mysql++ but I got an error message:
In file included from /usr/include/sqlplus/coldata1.hh:10,
from /usr/include/sqlplus/sqlplus.hh:12,
from createtable.cc:3,
/usr/include/sqlplus/null1.hh:4:19: ostream: No
MySQL folks,
I am having a problem with replication. When I create a new database on
the master, the CREATE DATABASE command is not shipped to the slave.
Subsequent table creation and table updates on the new database on the
master are replicated on the slave, but since the new database was not
if you can affect closure without artificial
constructs, then it probably belongs in a single
database. if closure can't be affected in the
logical design, then you probably need multiple
databases.
if you don't understand the concept of a
relational database closure, refer to
How do I LOAD a text file into a table that has a Primary Key defined?
I have the following table defined:
mysql describe phoneList;
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
I'd pick up the text file and search/replace all end of line character(s)
with a end of line00 comma combination so it reads
00,Abe,Lincoln,8347
on each line and try your first method. If that fails, I would drop the ID
field off the table, then do the import with original file, then atlter the
Chris Walcott wrote:
How do I LOAD a text file into a table that has a Primary Key defined?
Most stuff snipped. Sorry :)
I drop the Primary Key (and Timestamp) when I use 'load data infile'.
Below is my VB code which I use in Access to import stuff into MySQL.
Maybe someone will find it
Hi,
If this is a FAQ, I haven't been able to find it. I am a newbie to MySQL,
but I've followed the directions carefully and I get this whenever I start
mysqld:
# bin/safe_mysqld --user=mysql
[1] 24487
zaphod:/usr/local/mysql[15:02]# Starting mysqld daemon with databases from
At 23:23 -0500 11/12/02, [EMAIL PROTECTED] wrote:
The MySQL documentation (4.6.1) says:
You can change the character set with the --default-character-set option
when you start the server. The character sets available depend on the
--with-charset=charset and --with-extra-charsets=
Michael, Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:21 PM
Subject: Re: mysqlhotcopy point-in-time recovery
On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote:
Jeremy
--- Forwarded message follows ---
From: Mail Delivery System
To: Self
Subject:Mail Delivery Failure.
Date sent: Thu, 14 Nov 2002 06:50:33
Delivery has failed on the enclosed message for the following
reasons reported
I reconfigured and recompiled MySQL 3.23.53 that is supports now conversion
between Windows-1250 and ISO-8859-2 charsets.
If I do 'set character set cp1250_latin2' in a session, then everything goes
all right BUT only in insert/update/select statements.
If I do the same set and use LOAD DATA
Dear Sir:
i am a user of mysql gui,version
mysqlgui-win32-static-1.7.5-2. My pc is Petium 4 1.4G,
on which most program run very fast. but when i use
mysql gui, i find it run very slowly although i can
get the result.
I wonder how can i make it run faster. thank you for
your helping.
My OS:
Hello everyone
I was wondering if there are any tools that would allow me to port a
access database to mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
When you say port are you asking to export the access DB to mysql? If
so, Intelligent Converters makes one and you can also do it with EMS
MySQL manager.
If you wanting to view the mysql data in access; you can do this using
myodbc and open it using external data using the ODBC source.
Hi!
We are using mysql, version 4.0.4 beta on windows 2000 Server.
I tried to put data und index on different drives, usind the DATA and
INDEX directory option of the create table statement.
But both was created in the default data directory.
Is there anybody, who already used it successfully?
Hi
I'm using RedHat 8.0 and MySQL 3.23.52. I've also downloaded the MySQL Control Center
(latest). On the Linux mashine everything works just fine, but when I try to connect
to MySQLserver from Win2k using alpha version of MySQL Control Center I get ERROR
2013: Lost connection to MySQL server
1 - 100 of 101 matches
Mail list logo