Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
To unsubscribe:http://lists.mysql.com/mysql?unsub=
If you don't want people to follow this link, why are you including
it? To stop the 'suffering', stop including junk that doesn't belong
in outgoing email.
Jochem
Stern, stern, but fair ;)
Martijn Tonies
Database Workbench - tool
Hi,
Steffan A. Cline wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output the
results in a format like so:
MAIN
You didn't specify a user or password on your mysql command line when you
redirected your input to your .sql file, and for some reason the default is
[EMAIL PROTECTED]
You need to use the -p and -u options on the command line.
Regards,
Jerry Schwartz
The Infoshop by Global Information
On 7/8/07, Steffan A. Cline [EMAIL PROTECTED] wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output
the
results in a
Hi All,
Thanks a lot for your help. The thing is working now. Although I would like
to mention a couple of points:
1. mysql -u root -p test_dev db/create.sql -- simply works !!
2. Another way as people suggested to make it work was to give permissions
to user ODBC. I was not being able to do
Hello all
Ive scratched my head for a while on this one, so if someone
could shed some Light on it I would appreciate it very much
I have an account setup, and know about the password settings regarding
hosts. The account is named web19_u1, and has listed % and localhost as
posible
Héctor S. Mendoza O. wrote:
Hello all… I’ve scratched my head for a while on this one, so if someone
could shed some Light on it I would appreciate it very much
I have an account setup, and know about the password settings regarding
hosts. The account is named web19_u1, and has listed ‘%’
Dear everyone:
I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL
administrator. But it seems that I was only allowed to view the databases which
I have made up, but not allowed to edit them. Is it because I have to buy a
lisence or something which I didn't buy? Thanks
Are you sure the MySQL user you have defined in your GUI tool has the proper
table permissions?
Just a thought
-Chris
From: Weiqi Wang [mailto:[EMAIL PROTECTED]
Sent: Mon 7/9/2007 4:46 PM
To: mysql@lists.mysql.com
Subject: why can I not edit my database
The problem persists, with /usr/bin/mysql or with a php application, same
sympthoms
TIA
Hector
-Mensaje original-
De: Gerald L. Clark [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 09 de Julio de 2007 02:54 p.m.
Para: Héctor S. Mendoza O.
CC: mysql@lists.mysql.com
Asunto: Re: error in
Hola Hector, el problema son las 2 tuplas que mencionas, ya que debido a
su jerarquia pueden hacer un conflicto que te evita conectarte
correctamente, en tu caso si deseas que el usuario se conecte desde
donde sea (%) elimina la tupla de la tabla user donde aparezca el
localhost, esto puede
Gracias Carlos,
I've tried that already with no results, I've left only the [EMAIL PROTECTED]
and have
no luck logging in from the same machine the mysqld is running, I can log in
perfectly from anywhere.
TIA
Hector S. Mendoza O
-Mensaje original-
De: Carlos Proal [mailto:[EMAIL
On Mon, Jul 09, 2007 at 04:33:04PM -0500, Héctor S. Mendoza O. wrote:
The problem persists, with /usr/bin/mysql or with a php application, same
sympthoms
On the local host (where the mysqld resides) I do the same command and get
a
ERROR 1045 (28000): Access denied for user
MySQL administrator mainly focus on MySQL server status monitor/use
management/security/backup/restore etc.
If you want to edite database, you should use MySQL query browser, it's
included in MySQL GUI tools package.
Weiqi Wang [EMAIL PROTECTED] 写道：
Dear everyone:
I'm trying to
Hello there,
I have a problem, I wrote a stored procedure to retrieve some data
from various tables and then put it in a temporary table to use it
later, most of the procedure works just fine but there's something
that doesn't and I can not guess what the error can be.
Okay so, here's the
Hi
Am trying to access a web page in browser and get results from an old mysql
database.
The database has since been updated, but still see the original items. On 3
computers, the same problem, on 2, have deleted apache and mysql, no change
- uninstalled IE7 - reinstalled and eventually the
17 matches
Mail list logo
