On Sun, 4 Sep 2005, Alexey Polyakov wrote:
Why do you choose to convert varchar to tinytext? Doesn't look like
good idea to me.
trailing spaces and mysql 4.x
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote:
> Now I have all the users in the new mysql.user table. But when I try
> to login, the same credentials do not work.
A bit more info on this. This interesting error happens with GRANT:
mysql> grant all on testing.* to testing@'%'
Hello everyone,
I'm working on migrating a number of users to a different database
server. mysqldump makes this quite easy, but I've run into a
surprising issue with the new server.
I imported things like this:
# mysqldump --skip-add-drop --all-databases | mysql -h newbox -u root -p
Somehow th
I read on Slashdot this morning that MySQL have 'teamed up' with SCO.
Slashdot article:
http://slashdot.org/article.pl?sid=05/09/04/1730225&tid=187&tid=126
CNet article:
http://news.com.com/MySQL+enters+Unix+pact+with+SCO/2110-7344_3-5847453.html
The CNet article is pretty light on details. Ca
hi Joe,
You might be more comfortable using a GUI admin tool - look for MySql
Administrator under Graphical Clients here
http://dev.mysql.com/downloads/
Also, I *believe* php no longer ships with mysql support enabled. Make
sure your php.ini file contains this line:
extension=php_mysql.dll
My questions are probably addressed in the MySQL documentation somewhere.
I've been reading the documentation on backup but I'm not sure if that is
the right tool for this situation. Perhaps there is a better place to be
reading?
Apparently my 4.0.23 database on my notebook is corrupted as one la
> However, I am trying to move my RH 9 system to Centos 4.1 and
> everything has gone well until I though I could just copy the mysql db
> into the new server.
You can. Just make sure you add old-passwords option to your my.cnf file.
--
Alexey Polyakov
--
MySQL General Mailing List
For list arc
Michael -
Thank you for your patience! I had forgotten about that part of the
install...been a long time I needed to do an install...nice part of
Linux. However, I am trying to move my RH 9 system to Centos 4.1 and
everything has gone well until I though I could just copy the mysql db
into
Bytes IIRC. Depending on actual content it can be 127-255 characters.
Why do you choose to convert varchar to tinytext? Doesn't look like
good idea to me.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Todd Cary wrote:
Unfortunately, I blew MySQL away by replacing the MySQL control tables
with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot reinstall
MySQL and create the mysql directory with the control tables (e.g. user,
db, host).
Unfortunately, I blew MySQL away by replacing the MySQL control tables
with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot reinstall
MySQL and create the mysql directory with the control tables (e.g. user,
db, host). I have run "yum re
Hello
GP> And MySQL uses a filesort algorithm.
How to make the filesort faster? May be I have to increase size of
some buffers?
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
--
The original message was received at Sun, 4 Sep 2005 17:39:59 +0900 from
[38.139.250.132]
- The following addresses had permanent fatal errors -
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
13 matches
Mail list logo
