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:htt
Bob | 4.0 |
| 2 | 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 wrote:
> Consider two rows with id m and n in a table tb with a column cl,
> what
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 | Defau
of issue is
> solved 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 wrote:
> > To populate table for a perl forum, I got the following
ands.com> 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 fo
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 n
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 that
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
mysql-bin.
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 wrote:
> I created (or activated) the root account and now I see
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 /usr/local/mysql/data
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 wrote:
> On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu wrote:
> > Thanks Larry and Darryle for your help
> >
> > Where the error log should be?
>
&g
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell wrote:
> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote:
> > Yes, there is an icon. I can open the preference but the start service
> > button cannot do the job
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
wrote:
> Do you see a MySql icon under System Preferences > Other ? That's how
> I start MySql on my Mac.
>
> **
>
>
>
>
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 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) s
*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.*
**
> How about:
>
> select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.pv+2 and
> t1.oid<100 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: http://lists.mysql
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 be
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.
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]>;
Sent: Friday, June 13, 2008 10:32 AM
Subject: RE: query counts of a database
If
." <[EMAIL PROTECTED]>
To: "Elim Qiu" <[EMAIL PROTECTED]>;
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@list
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 PROTECTE
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 ap
cpu 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: http://lists.mysql.com/mysql
To unsubscr
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
--
MySQ
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
#include
int main() {
printf("start backup ESite data\n");
system("tar
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,
e_contact_as
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,
t0.own
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 fo
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 inf
> 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]
I have, to make it clear, 2 many-to-many relationships for table person:
PersonPerson_Club ClubPerson_Creditcard
CreditCard
----- -
- -
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
Is there a way to ask mysql to return certain number of matches?
This is very useful for search functionality.
ut 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 Li
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 w
40 matches
Mail list logo