I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
confused on how to relocate the datadir.
my basedir was F:/MySQL and datadir was F:/MySQL/data
It works fine and I'm trying to relocate the datadir:
(0) stop mysql service
(1) copy F:/MySQL/data to F:/DBData/MySQL/data
(2)
I downloaded mysql-5.1.67-osx10.6-x86_64.dmg, installed it to my snow
leopard book. it works but from the preference pane I see
MySQL(32-bit)
What I should believe, how do I make sure it's 64bit?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Consider two rows with id m and n in a table tb with a column cl,
what's the sql command to set the value of cl in row n the same as
that in row m?
Below is my testing
mysql desc student;
+---+--+--+-+-++
| Field | Type | Null | Key |
| Ming | 3.8 |
| 3 | Ann| 3.8 |
| 4 | Howe | 3.8 |
| 5 | nobody | 4.0 |
+++--+
5 rows in set (0.00 sec)
mysql
On Thu, Aug 23, 2012 at 2:47 PM, Elim Qiu elim@gmail.com wrote:
Consider two rows with id m and n in a table tb with a column cl,
what's the sql
by reinstalling DBD::mysql in the same way that you previously
installed it, so it can build against your current libraries.
- Perrin
On Mon, Aug 6, 2012 at 5:42 PM, Elim Qiu elim@gmail.com wrote:
To populate table for a perl forum, I got the following error:
aMac:mwf elim$ perl install.pl
wrote:
http://bixsolutions.net/forum/thread-18.html
-Original Message-
From: Elim Qiu [mailto:elim@gmail.com]
Sent: Monday, August 06, 2012 5:42 PM
To: mysql@lists.mysql.com
Subject: trouble with perl
To populate table for a perl forum, I got the following error:
aMac:mwf elim
To populate table for a perl forum, I got the following error:
aMac:mwf elim$ perl install.pl
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Expected in: flat namespace
dyld: Symbol
I don't really know how to use those files and so like to know how to
stop populating them. or at least control the number and size of them.
I'm running os x 10.6.8, mysql Server version: 5.1.61-log MySQL
Community Server (GPL)
I tried comment out the line log-bin=mysql-bin and those
Thanks a lot to all helped me out. Really appreciated.
Rik Wasmus,
Thanks for the Binary Log Documentation
http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#sysvar_max_binlog_size
Rick James,
I'll try this: expire_logs_days=7
Vikas Shukla,
My server-id is 1 (thought
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache.
The installation went smoothly but the service just cannot be started.*
**
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed
to my pretty clean os x 10.6.8 (snow leopard) after (1st time
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com
wrote:
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
**
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
directory, but I cannot even cd to that
directory (sudo is not good enough!)
On Wed, Feb 29, 2012 at 10:33 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote:
Thanks Larry and Darryle for your help
Where the error log should
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file
system for
Looks like 5.1.61 mac installer messed up the privilege setting...
But how to fix it? I remember the server account is mysql, not _mysql
What do you got? And how to fix it? Thanks
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote:
I created (or activated) the root account
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
| .|
+-+--+-+
what the query will
How about:
select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
t1.oid100 order by t2.pv
Mike
Very nice and simple. Thanks Mike!
Also Thanks Singer X.J. Wang and shawn wilson.
best regards,
Elim
--
MySQL General Mailing List
For list archives:
I'm still using win2k mysql 5.1
With default databas encoding, I can do querys with bh English and Chinese GB.
But when database encoding is uft8, all the Chinese become question maks.
Any idea about how to mysql work unicode databa? Thanks a lot.
I'm looking for a query that reports the count of each table in the
database.
the query should not assume the table list of the database.
Thanks for any inputs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 13, 2008 10:02 AM
Subject: RE: query counts of a database
-Original Message-
From: Elim Qiu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:56 AM
To: mysql@lists.mysql.com
Subject: query counts
Thanks a lot Edwards!
I'm using MySQL 5.1. Your query works great!
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 13, 2008 10:32 AM
Subject: RE: query counts of a database
If you are using MySQL 5.0
Dear list,
I never tried any timezone features(options) of mysql and like
to learn from you.
(1) In what situation one need to set mysql timezone?
(I know there are application level timezone solutions)
(2) What the effect if a custome timezone is settled with mysql?
I use mysql for web
Anyone successfully make MySQL 5.02 working on windows2000?
I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005
--
and the whole system hardly response any commands.
Maybe i need to uninstall the service and reinstall the new one?
- Original Message -
From: Whil Hentzen [EMAIL PROTECTED]
To: Elim Qiu [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, February 03, 2005 12:21 PM
Subject: Re: MySQL 5.02
This is on windows 2000.
I did the following as a temp solution for the full back up of a database. I
know this is not safe and possibly
not complete. Any suggestions (how to lock/unlock a db for read here)?
Thanks
#include stdio.h
#include stdlib.h
int main() {
printf(start backup ESite
when switch from 5.0.1 to 5.0.2 (without any config /my.ini change)
it used 100% cpu for a single command show tables (i've 42 tables)
and running forever (ate more and more memory)
So get back to 5.0.1 and things are fine.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Dear list,
i have some small tables but for some reason the mysql took very long to
find the results. my query looks
like below and mysql'e explain is attached for better format. Thanks for
your help!
select teu.name, eca.owner_id, ece.value
fromtyped_enterprise_unit teu,
I'm trying to create a view from two tables address and address_association.
So I did the following and expect they are the same:
CREATE VIEW associated_address AS
select t0.association_id AS association_id,
t0.property_dict AS property_dict,
t0.type_id AS type_id,
t0.owner_id AS owner_id,
I want to see the warnings when load data from text file using command
mysal load data local infile 'mydata.txt' into table my_table;
When I got
Query OK, 1431 rows affected, 1506 warnings (0.27 sec)
Records:1431 Deleted: 0 Skipped:0 Warnings:1506
I have to find out what cause the warnings. I
you can use MySQL-4.1.6 and the UTF-8 character set for both Chinese and
European languages.
What's the default character set for MySQL 5.0.1?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cool! Thanks a lot Shawn.
No, but you can. Modify your scripts so that the word EXPLAIN is the first
thing in each one then re-execute them. This will product the optimizer's
execution plan for each query. The results of all of those EXPLAIN
SELECT statements will give us the most
I have, to make it clear, 2 many-to-many relationships for table person:
PersonPerson_Club ClubPerson_Creditcard
CreditCard
----- -
-
Is there a way to ask mysql to return certain number of matches?
This is very useful for search functionality.
and cpu usage to do so.
- Original Message -
From: [EMAIL PROTECTED]
To: Elim Qiu
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 2:18 PM
Subject: Re: fetch certain number of matches
Could you possibly describe what you would like to find? Table
definitions
of curiosity, can oracle do such things? I'm kind of far away from
oracle but
not too long ago I learned there is no way that I can store long text and using sql
query
the text in oracle tables.
- Original Message -
From: [EMAIL PROTECTED]
To: Elim Qiu
Cc: MySQL mailing List
Sent
Hi, instead of xml, i stored arbitrary data of the form
(the actual usage of such mechanism is for more fancy stuff,
say, dynamic configuration, otherwise this is really not necessary)
{
name = Fn, Ln; // string value
gender = F;
Hi, instead of xml, i stored arbitrary data of the form
(the actual usage of such mechanism is for more fancy stuff,
say, dynamic configuration, otherwise this is really not necessary)
{
name = Fn, Ln; // string value
gender = F;
Is there any tools or built-in functions for querying contents of a column that holds
a xml file?
Hi, I'm looking for help on timezone issues.
I'm using mysql for a web application about time related events.
I've two servers in different locations with different timezones.
How to setup the database server so that the datetime value will not
depend on the server machine's timezone? In other
40 matches
Mail list logo
