I fail to see how the submit button would be stopping the script. However,
you could use a
if ($REQUEST_METHOD=="POST") {
// script //
}
and then run the rest of the script. Unless the rest of the script relies
upon the submit bu
Hi Arawind,
> Could any one help how to cope up without transactons
> in mysql. The Help manual provided with the software
> doesn't help a great deal.
Oneway is to incorporte transaction processing functionalities in the
middle layer application. eg. before commiting persistent objects used f
Error 13 is permission denied - check the permissions of host.frm. The user
running mysqld must be able to read/write to it.
Quentin
-Original Message-
From: Mike Blain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 20 December 2001 4:02 p.m.
To: Cal Evans
Cc: Quentin Bennett; [EMAIL PROTECT
Hi,
I am using MySQL 3.23.40 on LINUX Redhat 7.1 version.
My application is an OLTP application and depends
heavily on transactions. Since MySQL doesn't support
transactions for the stable releases, is there any
work around to solve this problem.
Could any one help how to cope up without transacto
Michael Widenius wrote:
> Hi!
> Brent> Is there any way to detect the Operating System that a MySQL server is
> Brent> running on using SQL or DBI function calls only?
>
> Sorry no. But this is would be a good thing to have and we shall add
> this on our TODO.
Especially since MySQL has di
Hi!
> "Brent" == Brent Cowgill <[EMAIL PROTECTED]> writes:
Brent> Is there any way to detect the Operating System that a MySQL server is
Brent> running on
Brent> using SQL or DBI function calls only?
Sorry no. But this is would be a good thing to have and we shall add
this on our TODO.
Hello,
Can anybody provide input on commandline tool on solaris to connect to
mysql server running on linux. And possibly configuring procedure if any
involved.
Thanks,
Prabhu
---
Beauty is bought by judgement of the eye.
yup
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 6:05 PM
To: [EMAIL PROTECTED]
Cc: Quentin Bennett; [EMAIL PROTECTED]
Subject: RE: mysql.sock??
did you run install_db before trying to fire it up?
On Wed, 2001-12-19 at 21:52, Mike Blai
did you run install_db before trying to fire it up?
On Wed, 2001-12-19 at 21:52, Mike Blain wrote:
> error file says:
>
> 011219 18:24:58 mysqld started
> 011219 18:24:58 /usr/local/mysql/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 011219 18:24:58 mysqld ended
>
>
>
h. Well, I have a mysql directory and test directory in both of the
directories below. Why would it have created those in two places? (Sorry for
stupid questions here -- first-time install of MySQL and have been banging
my head on this stuff for several days now...)
Only the /usr/local/mysql/
error file says:
011219 18:24:58 mysqld started
011219 18:24:58 /usr/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
011219 18:24:58 mysqld ended
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:50 PM
To:
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of permissions
You should have an error file in /usr/local/mysql/var (or wherever your
database files are) called something like linuxdev1.err. I'd look in
there to see where your error is. Do you have a my.cnf file with startup
options? If not, maybe you should create this (see the documentation at
www.mysq
Check your error log. What does it say? There is a reason that it won't
start.
Cal
On Wed, 2001-12-19 at 21:19, Mike Blain wrote:
> I keep trying to start it and get this:
>
> [root@linuxdev1 mysql-3.23.46]#
> /usr/local/mysql/bin/safe_mysqld --user=mysql &
> [1] 1822
> [root@linuxdev1 mysql-3
Hi Mike.
Check if you data directory is in: /usr/local/mysql/var as specified in your
startup script, or in: /var/lib/mysql
On redhat using the binary distribution, the data dir is in /var/lib/mysql
--
On December 19, 2001 06:19 pm, Mike Blain wrote:
> I keep trying
I keep trying to start it and get this:
[root@linuxdev1 mysql-3.23.46]#
/usr/local/mysql/bin/safe_mysqld --user=mysql &
[1] 1822
[root@linuxdev1 mysql-3.23.46]# Starting mysqld daemon with databases from
/usr/local/mysql/var
011219 18:21:40 mysqld ended
It stats and immediately stops. Been comb
Greetings,
I'm running the latest stable release of MySql on RH 6 on a dual 1GH+
machine w/ 1GB of ram and I've set max_connections to 300. Once the
server reaches about 110 connections tho, even tho I have plenty of
memory left they're using 100% of my CPU. The majority are sleeping
because I'm
Hi,
mysqld will create it when it runs - have you started the server?
Quentin
-Original Message-
From: Mike Blain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 20 December 2001 2:07 p.m.
To: [EMAIL PROTECTED]
Subject: mysql.sock??
I just recently installed MySQL from source. Trying to s
I just recently installed MySQL from source. Trying to set the root password
and keep getting this error:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(111)'
Check that mysqld is running and
I have had to do this several times already using MS Access. MS Outlook (at
least 2000) can export to text, Excel, Access, etc.. I bring the data into
Access and create a relational setup and them duplicate it on MySQL through
ODBC or ODBC with MyAccess 1.4.
OR
Export to text and bring it in M
Dear List,
This is my first post, and I appreciate your input on this task:
MySQL is collecting CONTACT information of a membership organization.
MAIN FUNCTIONS:
1) PRINTING ENVELOPES for a USPS MAILING to all members
2) Maintaining an e-mail list for regular mails to all members
QUESTION:
**
On Thu, 20 Dec 2001, Duncan Crawford wrote:
> We are having the following error when installing mysql on open unix 8.
> We are installing from the open unix 8 skunkware 8 cd
Please try the binary on www.mysql.com. You have to have the libraries
and linker installed. Also there are a few patches
We are having the following error when installing mysql on open unix 8.
We are installing from the open unix 8 skunkware 8 cd
Description:
Killed
Installation of grant tables failed!
Examine the logs in /usr/local/var for more information.
You can also try to start the mysqld demon with:
/usr/l
>Description:
This problem pertains to the Sun Solaris distributions, I have
not tried others. Description follows:
mysqldump --tab runs up against user resource limits on the
number of open file descriptors when the number of tables in
the database being du
Roger Baklund wrote:
>>hi there.. no solution from me, but I'm also interested in this type of
>>query (although I only want 1 for each "lang")
>>
>
> If you only want one row for each "lang" you can do it using GROUP BY...
> SELECT * FROM table GROUP BY lang
Whoa. Watch out. You can omit co
> hi there.. no solution from me, but I'm also interested in this type of
> query (although I only want 1 for each "lang")
If you only want one row for each "lang" you can do it using GROUP BY...
SELECT * FROM table GROUP BY lang
Often you would want to use some GROUP BY functions: MIN(), MAX
* michael chang
> Does anyone know where I could get all of the source
> code to build the MySQL software?
http://www.mysql.com/downloads/index.html >
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.p
sherzodR writes:
>
> Hmm, I can't aggree with having two password columns, one raw password and
> another is encrypted. It just doesn't make any sence. Why do you need to
> encrypt the password in that case, don't you still have the original
> password in yoru database? It just defeats the whole
Is there any way that this number could be increased
by changing any of the variables in the configure file
or is this an internal limitation?
I've seen a similar behaviour on SQLServer but that
was on a prior version and is supposed to have been
fixed on later versions.
I'm using one table tha
Hmm, I can't aggree with having two password columns, one raw password and
another is encrypted. It just doesn't make any sence. Why do you need to
encrypt the password in that case, don't you still have the original
password in yoru database? It just defeats the whole purpose of
authentication.
If anyone wants PostgreSQL with support, but isn't interested in Red Hat's
thing, PostgreSQL Inc sells commercial support. There are actually some other
companies doing that too.
On Wednesday 19 December 2001 09:11 am, Christopher R. Jones wrote:
> And it comes with a nifty price tag: $2,300 US
On Wed, 19 Dec 2001, Matt Wagner wrote:
> Date: Wed, 19 Dec 2001 13:51:30 -0600 (CST)
> From: Matt Wagner <[EMAIL PROTECTED]>
> To: Zach Curtis <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Decrypting PASSWORD() from MySQL
>
> Zach Curtis writes:
> > I have a form for a user to requ
Well there is one easy sollution (if I understand your qestion correctly)
What I think you want is an history of old properties and values..
so what to do? well create a "history" table that hold all these old values
and then the normal table only contains 1 value for each property..
So wheneve
Hi All,
Is there a solaris version of Mysql++ API. I see some downloads under
the solaris section but no Mysql++. Is there a patch that I need to
install to make it work on Solaris?
Thanks for your responses.
Uday
-
Before pos
hi there.. no solution from me, but I'm also interested in this type of
query (although I only want 1 for each "lang")
I also wants it in 1 query, not multiple (it would be to many queries)
so any answer to this one please please reply to me to :-) although I do
read here also...
/Christian
Hi all,
Does anyone know where I could get all of the source
code to build the MySQL software? I wanted to make
edits to the SQL language that is embedded in the
MySQL software. Is there a way to do that? If not,
does anyone have any suggestions on how to do
something like that. I want to use
Hi There,
I got one question for you, so pls help me as i am struggling to solve this
problem for the past 2 days.
I am running the timetool.cgi file from browser. I am getting the Welcome
Screen where i it asks me to select a user. But the drop down list is empty.
And if i go to DOS prompt & run
Thanks for the suggestions.
I guess I can try to:
A) Store the password in plaintext if I need to retrieve the password.
B) Store the password using PASSWORD() and then generate a new random
password if needed, replacing the old password.
C) Look into mcrypt, ENCODE()/DECODE(), encipher/decipher
When I connect through odbc I get a succes with info, when I look at the
info I have a sql state of s1000, native error 0. If I try to query the
database I get an error and the sql state is s1000 with native error code of
1142. Everything I read on the internet says it's some kind of permissions
Greetings MySQL Users:
With MySQL embedded in Lasso Professional 5 (a commercial Web
application server), some of you may be interested in upcoming
opportunities to increase awareness of resources available to Lasso
and Lasso MySQL users.
And, more importantly, If you have add-ons to MySQL an
Hi,
Is there a way to prevent the 50% occurence threshold in mysql's
fulltext search logic that causes words that appear in more than 50% of
records to be considered stopwords? I have a table that has less than
1000 records and would like to do a fulltext search on two columns and
have them retur
Greetings,
I am trying to install (source distribution) mysql-3.23.46 on a DEC Alpha machine
running Digital UNIX V4.0D (Rev. 878).
When I run the configure command, I get the following error:
checking for ps... /sbin/ps
checking how to check if pid exists... configure: error: Could not find
* P.Agenbag
> So, how would the query string look that would only return ONE set of
> data for that specific property?
Use the LIMIT clause of the SELECT statement:
http://www.mysql.com/doc/S/E/SELECT.html >
In short: add "LIMIT 1" at the end of your query, and it will only return
one row.
>
Zach Curtis writes:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this using PHP and use mail()
> to send them their username and password. However, the password is stored in
> an encrypted PASSWORD('password') field i
Jinghua Tang wrote:
>
> It is a newbie question. I am wondering if there is a way to write
> out a table in plain text form. Thank you in advance!
select [select_options] select_list
[into outfile 'file_name' export_options]
[from tbl_list]
[where where_expr]
[g
zach: How can I retrieve the decrypted password in a SELECT statement?
You can't!
If you want them to deal with forgotten passwords, here is a standard way:
Whenever they submit their email addresses to retrieve their passwords,
just generate a random password, and send it to the user's emai
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
> an encrypted PASSWORD('password') field in the MySQL table. How can I
> retrieve the decrypted password in a SELECT statement?
MySQL's password() function is a one way hash. It does not have a
decryption function. Regardless
Hi everybody, I'm still new to Linux, and mySQL. I have a mySQL db on a
win32 box that I want replicated on my new Linux box. I have managed to do a
mySQLdump on the win32 box and have successfully relocated the db to the
Linux box, I could though, only do it if I was logged into mySQL as root
> Here's a conundrum I'm having with MySQL.
>
> The following code returns a bunch of records:
>
> SELECT sl_Year,
>sl_DayOfYear,
>sl_Query,
>SUM(sl_CountOfOccurrences) AS NumRequests
> FROM SearchLog
> GROUP BY sl_Year,
> sl_DayOfYear,
> sl_Query
>
> o
Try:
SELECT vgrupp, type, count(*) as recordcount FROM main GROUP BY vgrupp,
type
and pull the rs.fields("recordcout")
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 2:25 PM
To: Mattias Persson; [EMAIL PROTECTED]
Subject: RE: Problem with ASP
I have a form for a user to request their forgotten username and password by
entering their email address. I then process this using PHP and use mail()
to send them their username and password. However, the password is stored in
an encrypted PASSWORD('password') field in the MySQL table. How can I
Hi,
> -Original Message-
> From: Mattias Persson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 5:14 AM
> To: [EMAIL PROTECTED]
> Subject: Problem with ASP and GROUP BY queries
>
>
> My query:
>
> SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
>
> I ha
Hi,
> -Original Message-
> From: Jens Collin [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 3:05 AM
> To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: MyODBC leaking handles...
>
>
> Hi again,
>
> Some more information;
> OS: Windows 2000 Professional, SP2a + all
Can't I put an IF / CASE in the query to make it work ?
[ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]
> -Original Message-
> From: Brett Error [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 19, 2001 8:01 PM
> To: 'Jacob Friis Larsen'; Mysql maillist
> Subject: RE:
I concur. PHP is straightforward, powerful, and free! You can go to
http://www.php.net to download it.
Cheers,
Fred Woolsey
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:48 PM
To: 'Sven Hammann'; [EMAIL PROTECTED]
Subject: RE: New
Martin Oldfield writes:
>
> I'd quite like to have the whizzy new 4.x style full text searching
> features, but I'm scared of installing 4.x on a production system, so
> I'm seeking advice.
>
> I see two options:
>
> 1. Stop fussing and install 4.x;
>
> 2. Patch 3.23.x with 4.x's full text stu
You'll have to issue two separate queries:
"select * from table where lang=1 limit 10" and "select * from table where
lang=2 limit 10"
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 11:46 AM
To: Mysql maillist
Subject: select 10
Mysqldump will write out all the SQL needed to build the table (in plain
text form).
Connecting with the client and doing a select * from table will also "write
out the table in plain text form"
Finally doing a select into outfile (see manual for syntax details) will
also "write out the table in
Here's a conundrum I'm having with MySQL.
The following code returns a bunch of records:
SELECT sl_Year,
sl_DayOfYear,
sl_Query,
SUM(sl_CountOfOccurrences) AS NumRequests
FROM SearchLog
GROUP BY sl_Year,
sl_DayOfYear,
sl_Query
one of these records looks li
How do I select 10 rows with lang = 1 and 10 rows with lang = 2 from a MySQL
database ?
Please also reply to my E-Mail address.
:) Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Sinisa
Milivojevic To: [EMAIL PROTECTED]
It is a newbie question. I am wondering if there is a way to write
out a table in plain text form. Thank you in advance!
Jinghua
<<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><
Jinghua Tang, Ph.D. Phone: 858-784-8647(o)
Department of Molecular Bi
Hi all-
Using mySQL 3.23.44 and new to mySQL, can I assume that I can not add
comments on the columns (I see how add comments to a table).
Thanks-
Beth
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I'd quite like to have the whizzy new 4.x style full text searching
features, but I'm scared of installing 4.x on a production system, so
I'm seeking advice.
I see two options:
1. Stop fussing and install 4.x;
2. Patch 3.23.x with 4.x's full text stuff.
Has anyone tried option (2), and am I b
HI
This is possibly very easy, but I can't seem to get it right.
I have a table that hold some data about properties. The data gets
updated from time to time, but each time a new "update" is done, it
get's a new row. The only thing in some cases setting the different
entries appart is an "actio
Van writes:
>
> Sinisa:
>
> As in possibly the binutils problem? I've had to use:
> gcc version 2.95.4 20011006 (Debian prerelease)
> to do any builds of things that need glibc2.3.2, but had to revert to the potato
> compiler to compile the kernel.
>
> What's the recommended compiler/glibc for
Hello list
I've been working on Amazon clone for a client, except it doesn't sell
books, but helps them to advertise. You can take a look at it at:
http://www.ultracgis.com/UltraBooks
The client vanished into thin air, and now I am left with this program,
and don't konw what I can do with it.
[EMAIL PROTECTED] writes:
>
> But WHY, simply do tell me *why*! *Why* doesn't it know that?
> I put the path of /var/lib/mysql/mysql.sock in /etc/my.cnf, that should be
> already enough, isn't it?!
> Tell me a *plausible* reason why and I shut up. ;-)
>
>
> Greetings
> Andreas
Erase MySQL.opti
I like PHP.
Simon
-Original Message-
From: Sven Hammann [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2001 17:42
To: [EMAIL PROTECTED]
Subject: New world
Hello,
I'm new in the world of MySQL and have a question:
What Software can I use to programm MySQL clients for HTML(XML) or Ja
Hello,
I'm new in the world of MySQL and have a question:
What Software can I use to programm MySQL clients for HTML(XML) or Java
? Is there a
Software which is easy to use ?
Thanks a lot for answering,
Sven Hammann.
-
Before
Sinisa Milivojevic wrote:
>
> Van writes:
> > Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running.
> >
> > vanboers@tempe:~$ strace ./mysqlscan 1 2
> > execve("./mysqlscan", ["./mysqlscan", "1", "2"], [/* 17 vars */]) = 0
...
> > brk(0x1200ba000)
I'm trying to compile version 4.0.1 from the source tree on RedHat 6.1.
Configure runs fine, but make gives me the following error:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\"
-DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID
-DMYSQL_CLIENT -I./.
Please excuse me if this is not the correct place to post this question. I
am fairly new to working with MySQL. I have two machines that have the same
database, each for different development purposes.
There is a table in the database that I regularly query for product info.
The table is in set
Sinisa
Milivojevic To: [EMAIL PROTECTED]
Van writes:
> Greetings:
>
> Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running.
> Selects against the local database appear to work fine.
>
> I've got a couple userland applications that update data in remote 3.23.x
> servers that no longer work. I haven't seen any
Greetings:
Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running.
Selects against the local database appear to work fine.
I've got a couple userland applications that update data in remote 3.23.x
servers that no longer work. I haven't seen anything related to this in t
I am looking for some suggestions for MySQL log management. Just some
people to respond to this message with their log rotation, and archival
methods. I am just curious to see what others are doing, and to possibly
suggest a method for myself to use.
Thanks,
Shon Stephens
---
And it comes with a nifty price tag: $2,300 USD!
>"Deependra B. Tandukar" <[EMAIL PROTECTED]> writes:
>
> > What is RedHat Database?
>
>Postgresql.
>
> >Is anybody using it? How is it? Better than MySQL?
>
>It's postgresql w/support, so the answer would be the same as regular
>postgresql vs. MyS
[EMAIL PROTECTED] writes:
> Hi folks,
>
> I know I had got that working months ago, but now I had to set up another
> PC for a customer - this time it was a Linux machine.
> This cost me 2 (TWO) days to find out what was the error of MySQLGUI Error
> Number One...
>
Hi!
Our README is quite cle
adam nelson writes:
> Has anyone used a mysql gui that works securely over the internet
> (through ssh?). Currently I use ssh to do command line mysql, but I
> thought that a gui on my desktop might work well.
>
> I can't afford a vpn, so that isn't an option.
>
> -Adam
>
This is a least prob
Hi there, I'm back with yet some questions about group by/order by in
mysql..
My first question is how group by is beeing done if I have have columns in
the select query that is not in the "group by" statement.
Dring many test with 3.23-42 (Myisam tables) I found out that the content of
the colum
Hi folks,
I know I had got that working months ago, but now I had to set up another
PC for a customer - this time it was a Linux machine.
This cost me 2 (TWO) days to find out what was the error of MySQLGUI Error
Number One...
(***) "Can't connect to local MySQL server through socket (111)"
Th
I created a table with a buggy script. The name of the table is
"dbimport->import".
drop table `dbimport->import`; # note: inverted quotes
gmax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
phpmyadmin run on an secure apache server.. you leave the security up to
Apache and the MySQL admin is done with the phpmyadmin interface..
Apache: www.apache.org
phpMyAdmin: http://sourceforge.net/projects/phpmyadmin/
Have fun!
Ronald
-Original Message-
From: adam nelson [mailto:[EMAI
I have already looked here:
http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html
I would just like to know if anyone has had any problems with this upgrade.
The server is a Red Hat Linux release 6.1 (Cartman)
Kernel 2.2.13-0smp on a 2-processor i686.
Any help or advice would be very appreciate
Has anyone used a mysql gui that works securely over the internet
(through ssh?). Currently I use ssh to do command line mysql, but I
thought that a gui on my desktop might work well.
I can't afford a vpn, so that isn't an option.
-Adam
--
[EMAIL PROTECTED] writes:
> >Description:
> max() and possibly other builtins fail due to apparent rounding
> errors for any bigints larger than 53 bits or so. Caveats exist
> in the manual (section 6.2) about bigints larger than 63bit, but
> the actual useful limit (for t
Here is my dayly headbreaking problem to you all,
After hours of trieing and reading the manual regarding REPLACE INTO command and
INSERT INTO, looking for
a way to be able to achieve the following, was not very sucessfull ( can MySQL do
what I want in this case ? )
(running MySQL ver 3.23.
Lester Hightower writes:
> On Wed, 19 Dec 2001, Sinisa Milivojevic wrote:
>
> Sinisa,
>
> Thanks for the reply. You may have not seen it yet, but I sent a followup
> email stating that, after sending my first email, I had discovered mysqld
> user-defined-functions (which I did not know existed)
On Wed, 19 Dec 2001, Sinisa Milivojevic wrote:
> Lester Hightower writes:
> > Hi all,
> >
> > I would like to propose that mysql have compress_*()/decompress_*()
> > functions added that would be similar to des_encrypt()/des_decrypt().
> >
> > My idea would be to have functions available like:
Kemp Randy-W18971 writes:
> If I install mysql (latest stable version) on Windows 2000, service pack 1, I can
>type the command d:\mysql\bin mysqld-nt --standalone, and the server runs fine. I
>then invoke the mysqlgui, and can do anything with table creation, reading, etc. But
>if I do the s
My query:
SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
I have a problem with MySQL and a query. If I type the Query in a program with direct
db connect, in my case EMS Mysql manager, everything works OK but when I use it from
an ASP page it don't. I don't get any matches, it e
hy
Am 19 Dec 2001 13:06:30 + schrieb Matthew Darcy:
> Hi,
>
> I am not normally a fan of gui's but seeing as I am finding mysql a bit
> different from oracle I could use all the help I can get as my database may
> end up quite complicated.
>
> Are the gui's available for linux ??? are they
Dear Sir/Madam
I downloaded mysql3.23max version actaually i want to
use Innodb type for my tables in the properties its
showing Innodb is disabled to enable that i ve to give
some path in 'my.cnf' file according to Manual but im
not getting the my.cnf file any where in that folder i
searche all t
Dear Sir/Madam
I downloaded mysql3.23max version actaually i want to
use Innodb type for my tables in the properties its
showing Innodb is disabled to enable that i ve to give
some path in 'my.cnf' file according to Manual but im
not getting the my.cnf file any where in that folder i
searche all t
Try PHPmyadmin
Or mysql's own GUI
Simon
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2001 13:07
To: [EMAIL PROTECTED]
Subject: Gui's for linux
Hi,
I am not normally a fan of gui's but seeing as I am finding mysql a bit
different from oracle I co
Hi,
I am not normally a fan of gui's but seeing as I am finding mysql a bit
different from oracle I could use all the help I can get as my database may
end up quite complicated.
Are the gui's available for linux ??? are they any good.
Thanks,
Matt.
---
Lester Hightower writes:
> Hi all,
>
> I would like to propose that mysql have compress_*()/decompress_*()
> functions added that would be similar to des_encrypt()/des_decrypt().
>
> My idea would be to have functions available like:
>
> compress_gz()/decompress_gz()
> compress_bz()/decompress_
Ok the password problem is sorted
just to make sure i am right the command I used was
./mysqladmin -u root password $password
I have just ran mysql_install_db which didn't seem to do much except remind
me to change me password.
I have done a mysqladmin create test1
I then get the error that
>Perform a hot copy of the databases (using mysqlhotcopy). This also
>seems to take a while, but at least the database server does not have
to
>shutdown. The trouble with this is that it locks the table from writes
when
>it does the copy. Some of my tables take a while to copy (they are
hundr
1 - 100 of 119 matches
Mail list logo
