Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell mysql -p -u root
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
jing,
Please modify your my.cnf file.
在 2009-7-16,下午2:56, TianJing 写道:
Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell mysql -p -u root
Enter password:
thanks,
my.cnf file is as follow:
[client]
#password = your_password
port= 3306
socket = /export/data1/apps/local/mysql/mysql.sock
# The MySQL server
[mysqld]
datadir=/export/data1/apps/local/mysql/data
socket = /export/data1/apps/local/mysql/mysql.sock
Hi all
*country*
IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2
Hi TianJing, all!
TianJing wrote:
Hi all,
i am trying to install mysql 5.1.35 in my linux platform, i do it from
source distribution, but there is a serious problem when i login it,
the error message is bellow:
*shell mysql -p -u root
Enter password:
Welcome to the MySQL monitor.
My table group_member looks like this:
+---+---+-+
| member_id | name | head_id |
+---+---+-+
| 1 | Elim |NULL |
| 2 | Ann | 1 |
| 3 | David |NULL |
| 4 | John | 3 |
| 5 | Jane | 3 |
On Wed, 15 Jul 2009 23:53:05 -0400 Darryle Steplight said:
Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
On Wed, Jul 15, 2009 at 6:44 PM, Tachu®tachu1+my...@gmail.com wrote:
I'm having random query slowness that i can only reproduce once. My main
question is that
I see such nice formated text output serving to illustrate people's
tables and I think it must be due to some code which is spitting
that out, rather than people typing so painstakingly. What is that
function/MySQL/code?
It's the default output format of the mysql command line client,
On 16 Jul 2009, at 15:02, Govinda wrote:
I see such nice formated text output serving to illustrate people's
tables and I think it must be due to some code which is spitting
that out, rather than people typing so painstakingly. What is that
function/MySQL/code?
It's the default output
when my.ini has query-cache-type = 1 setting
the query results are placed in cache on first read
second and consequent reads reference resultset from cache
http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm
Martin Gainty
Confucius say Big Dog in door
On 16 Jul 2009, at 15:26, Govinda wrote:
Meaning that on a shared hosting situation, without ssh, then I
cannot do that, right?
Not necessarily - you can run the client locally and connect to the
remote DB. It depends if your host allows remote access to mysql (they
might do on
Scott Haneda wrote:
On Jul 8, 2009, at 12:49 PM, Daevid Vincent wrote:
I know it comes a little too late, but as a preventive measure going
forward, I offer up my daily crontab backup script:
http://www.daevid.com/content/examples/daily_backup.php
FYI, this link does not work in
russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it
on a Windows ME system even though documents said you couldn't. Recent a
friend asked me to help him get it up and running on a Windows Vista
system.
I was looking for the system configuration
Hello everybody,
the MySQL application I'm building needs to be ported from my current site
to the hosting site - which is based on another nation.
The problem I'm having is that the login doesn't work as the password
doesn't match in the charset of the new hosting site.
To address this problem,
In the last episode (Jul 15), Tachu(R) said:
I'm having random query slowness that i can only reproduce once. My main
question is that the query runs faster the second time around but i dont
have query cache enabled here is some info from mysql profiler;
The time is spent mostly on the
As a followup, simply logging to stderr prints to the $host.err in the
mysql data directory, which is good enough for my purposes.
In case anyone else is curious, when experimenting I found I could use
my_printf_error to return errors to the console where I inserted the
bad data. But, that
I have a new slave I setup against a new master server. The master server has
4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be blank. This
slave is set to slave the master and act as a master for
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote:
I have a new slave I setup against a new master server. The master server
has 4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be
I'll have to look into that. We have a single cronjob that just does a
mysqldump daily but not during the time of the log file generation, but that's
all I can think of off the top of my head.
Gary
From: tly...@sitehelp.org [tly...@sitehelp.org] On
On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote:
I have backup all the database files(innodb engine).
Now I want to recover it as myisam engine offline.
Any suggestions?
Why can't you copy the InnoDb files to another machine and open the database
with another MySQL server? (You
20 matches
Mail list logo