> Hi All!
> I am a newbie at mySQL. I need to implement a database which has the
> capability to store some *.dat files. hence i have already implemented
> a table using:
>
> create table table_name (field_name1 int unsigned auto_increment
> primary key not null, data_file longblob not null);
>
>
> > Disclaimer: SQL/database newbie here.
>
> Nothing wrong with being a newbie :-)
Thanks for the help.
> > Let's say I have a table of authors with columns for last name and first
> > name. Is there any general guideline re using a separate
> integer for the
> > primary key as opposed to a co
Using default port for MySql jdbc:mysql://127.0.0.1/db_name
Dirver org.gjt.mm.mysql.Driver
Ruel Elvambuena
Documentation Staff/Programmer
MOF Co., Inc. Manila, Philippines
Tel # (062) 551-69-48
Cell # 0917-342-69-07
- Original Message -
From: "Othmar Stehlik" <[EMAIL PROTECTED]>
To: <[E
Hi,
I'm looking for the wire protocol description document for the database. Can
someone forward it to me, I'd like to write a native provider for the .Net
platform.
Thanks,
Eddy
-
Before posting, please check:
http://
Jeff,
Let's do some math here first. Your table has 47 Million rows. You
have a primary key on an int, and indexes across 22 chars and 10 chars.
You have 512MB of key buffer.
Now, assuming the indexes just have information on relevant fields
(they're actually bigger than this since they have
I'm trying to figure out how to optimize a query on a fairly large table.
I've been reading the MySQL documentation and have tried a few of the
suggestions, but not seem to have much effect on the query.
The table contains three columns:
1) int unsigned
2) char(12)
3) char(10)
The table has 47,0
Any tips on what is causing this? System is as follows:
Red Hat 7.1
Dual-Athlon 1.2 Ghz
1 GB DDR RAM
15K RPM SCSI HDD
about 300,000 pageviews a day -- each with about 7-10 queries a page
Here is the processlist output: (warning, its BIG)
++---+---++-+--+
Any tips on what is causing this? System is as follows:
Red Hat 7.1
Dual-Athlon 1.2 Ghz
1 GB DDR RAM
15K RPM SCSI HDD
about 300,000 pageviews a day -- each with about 7-10 queries a page
Here is the processlist output: (warning, its BIG)
++---+---++-+--+
mweb wrote:
> Thanks for the shameless plug, I'll look into your code. However,
> shouldn't something like what I want be possible in PHP with ODBC?
Yes, you can install UnixODBC or similar and use the odbc_* calls in PHP on
both os's. I just do not know how reliable ODBC is on the *nix.
b.
my
Thanks for the shameless plug, I'll look into your code. However,
shouldn't something like what I want be possible in PHP with ODBC?
mweb
On Fri, Nov 09, 2001 15:22:11 at 03:22:11PM -0800, Bill Adams wrote:
> mweb wrote:
>
> > >mweb,
> > > To make sure I understand you correctl
mweb wrote:
> >mweb,
> > To make sure I understand you correctly, you want to create
> >and
> >test your PHP/MySQL database on your Linux/Apache box, then upload it
> >to
> >your ISP server that is running PHP/Access? I'm sorry but that's not
> >going
> >to work. You can't transparently s
i am having trouble running my databases. I have apache 1.3.22, mysql 3.23.44 on a
linux ppc 2000
Q4, kernel 2.2.18. I am trying to create a backup server for my main web server. as
far as i can
tell all the configuration is the same. could it be that php is not working
completely? it is
simple
>mweb,
> To make sure I understand you correctly, you want to create
>and
>test your PHP/MySQL database on your Linux/Apache box, then upload it
>to
>your ISP server that is running PHP/Access? I'm sorry but that's not
>going
>to work. You can't transparently switch a PHP application from
Thanks... I figured that out now. All is good and now I have access. I
just needed to create a new user with the proper host information.
Dan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
> Sent: Friday, November 09, 2001 3:59 PM
> To:
Dan Tappin wrote:
> Ok that worked... but now my SQL utility program returns a 'Host
> 192.168.0.74 (my local IP) is not allowed to connect to this MySQL server'
>
> I assume that I need to get into the grant tables. Is this just via
> mysqladmin -u root -p???
To get into the grant tables, as i
Hi All!
I am a newbie at mySQL. I need to implement a database which has the
capability to store some *.dat files. hence i have already implemented
a table using:
create table table_name (field_name1 int unsigned auto_increment
primary key not null, data_file longblob not null);
I then tried to
> "M. A. Alves" wrote:
>
> > I think the problem is in your query expression.
you're absolutely right here
> I have reformulated your
> > original query using my style and that consistently results in 4 rows
> > which I think is what you wanted.
> >
> > Original_Query : String :=
> >"se
"M. A. Alves" wrote:
> I think the problem is in your query expression. I have reformulated your
> original query using my style and that consistently results in 4 rows
> which I think is what you wanted.
>
> Original_Query : String :=
>"select distinct Exhibition.InternalNumber,Exhibiti
"M. A. Alves" wrote:
> My testing returns 16 rows in both ways (program using API vs. mysql
> monitor). I have copied verbatim the query string from your C code (it
> was the "query" constant right?)
>
> I think this contrasts with your results no?
>
yes
when I typed in the same query in mys
Actualy I did provide the things you mention. By stating that I've done
all that was suggested in the Readme and Install documentation. That
includes the compiler type and version etc and flags.
On Fri, 9 Nov 2001, Michael Stassen wrote:
> Keith,
>
> It's a little hard to help, since you didn'
At 7:45 PM + 11/9/01, Carl Troein wrote:
>Shankar Unni writes:
>
>> What are the rules about "bundling" now? If we distribute a (standalone)
>> copy of MySQL with our product, does that expose our product to the GPL? Or
>> is it just like distributing a copy of Emacs with your OS? (I.e. as
Ok that worked... but now my SQL utility program returns a 'Host
192.168.0.74 (my local IP) is not allowed to connect to this MySQL server'
I assume that I need to get into the grant tables. Is this just via
mysqladmin -u root -p???
Thanks,
Dan
> -Original Message-
> From: [EMAIL PROT
Dan Tappin writes:
> I tried that but it came back with a 'mysqld is running already' error.
/me silently curses the bad quoting habits that Lookout causes, but
knows what the thread was about, and so _please disregard_ this
sentence unless you know what I'm talking about.
Now where was I? Oh,
Hi,
- Original Message -
From: "DownloadFAST.com" <[EMAIL PROTECTED]>
To: "Ben Gollmer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
> Or does MySQL actively support, debug, fix, and go back and
> maintain older releases?
That is indeed the case.
The 3.23 and 4.0 branches co-exist, and
DOH! :^)
Thanks for the tips.
Dan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
> Sent: Friday, November 09, 2001 2:26 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbie MySQL Install Question
>
>
> Dan Tappin wr
I'm getting the sazme exact error, can anyone help us??
-Original Message-
From: Kelley Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 4:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Newbie MySQL Install Question
Make sure that the mysql server has be
Dan Tappin wrote:
> I tried that but it came back with a 'mysqld is running already' error.
Actually your command is wrong. If you never set the password before it should
be (without the -p):
mysqladmin -u root password your?new.password
note that 'password' IS the command.
> Side Question:
Port 3306 is open on the machine.
Dan
> -Original Message-
> From: Kelley Reynolds [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 09, 2001 2:07 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Newbie MySQL Install Question
>
>
> Make sure that the mysql server has been
Keith,
It's a little hard to help, since you didn't provide the details of your
attempt to install from source. (Compiler? command line for
configure? ...)
Searching Google groups on 'mysql solaris cross compiling', I found
numerous related threads. It appears that everyone who reported this
p
How do I double check? LSOF? I tried that but I can't get the option
right?
Side Question: How can I allow a SSH connection from a remote machine? My
linux box is in a locked server room and I would like to administer it from
my office via a terminal. I tried via SSH from my MacOS X laptop b
I tried that but it came back with a 'mysqld is running already' error.
Side Question: How can I allow a SSH connection from a remote machine? My
linux box is in a locked server room and I would like to administer it from
my office via a terminal. I tried via SSH from my MacOS X laptop but I g
%% Shankar Unni <[EMAIL PROTECTED]> writes:
su> Who can answer these questions?
Well, the obvious place to look is the MySQL web site, http://www.mysql.com
Click "Products", then click "MySQL Licensing Policy".
--
-
Dan Tappin wrote:
> I have some experience with MySQL on MacOS X but that was with a pretty GUI
> installer.
>
> I am now trying to get MySQL installed on Redhat 7.0. I download the client
> and server versions and followed the install procedures.
>
> The problem I am having is with mysqladmin.
Make sure that the mysql server has been started.
- Original Message -
From: "Dan Tappin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 4:07 PM
Subject: Newbie MySQL Install Question
> I have some experience with MySQL on MacOS X but that was with a pretty
I have some experience with MySQL on MacOS X but that was with a pretty GUI
installer.
I am now trying to get MySQL installed on Redhat 7.0. I download the client
and server versions and followed the install procedures.
The problem I am having is with mysqladmin. The docs state that you need t
Hi Shankar,
- Original Message -
From: "Shankar Unni" <[EMAIL PROTECTED]>
> What are the rules about "bundling" now? If we distribute a
(standalone)
> copy of MySQL with our product, does that expose our product to the
GPL? Or
> is it just like distributing a copy of Emacs with your OS?
> No kidding? Why don't you fork the PostGreSQL codebase and apply your
> special assembly talents to speed it up by "50% or even 60%"?
If you're willing to pay for quality, Oracle is an obvious choice.
It's fast, it has all the features, there are numerous advanced tools to
manage and develop y
http://www.mysql.com/doc/G/R/GRANT.html
You need to GRANT 'emdtest.ncr.com' permission to connect or a user from
any box to connect with a user name and password.
mysql> GRANT ALL PRIVILEGES ON *.* TO kenneth@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
means kenneth can connect f
Wells, Kenneth L writes:
> I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this
> MySQL database server'
First of all, I must ask you why you've posted this under a
thread about forking off MySQL. This makes little sense to me.
Secondly, since you just posted the same ques
I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this
MySQL database server'
How do I correct this???
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
hi.
regarding 'bundling' GPL products with commercial ones:
http://www.gnu.org/licenses/gpl-faq.html#GPLInProprietarySystem
to summarize, it's okay, if it's done properly.
hth.
-ravi.
-Original Message-
From: Shankar Unni [mailto:[EMAIL PROTECTED]]
Sent: November 9, 2001 2:24 PM
To:
"Brad Harriger" <[EMAIL PROTECTED]> wrote:
> How does MySQL handle duplicate column names?
Kind of open ended, but I'll give it a shot. MySQL doesn't allow duplicate
column names within a table, but if you are referring to a query accessing
multiple tables containing fields with the same name th
Shankar Unni writes:
> What are the rules about "bundling" now? If we distribute a (standalone)
> copy of MySQL with our product, does that expose our product to the GPL? Or
> is it just like distributing a copy of Emacs with your OS? (I.e. as long as
> you make the source available, it doesn
Hi.
I've just set up my prototype so I can benchmark comparatively tthe profmance
between PostgreSQL and MySQL.
There's good news, and there's bad news.
The good news is - MySQL is faster by about 2 times.
The bad news is - MySQL is ONLY faster by about 2 times.
Now, I DO understand that this
>How does MySQL handle duplicate column names?
You can't create two columns with the same name in one table.
If you have a query that combines multiple tables, you reference them with
the table name:
ie select a.id, b.id as otherid from a, b where
Chris
Check your grants table in the mysql db...make sure you have given yourself
permission to user said db from the specified host as that user...
"Wells, Kenneth L" wrote:
> How can I fix this?
>
> Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect
> to This mysql server F
DownloadFAST.com wrote:
>> [...] why don't you try PostgreSQL instead?
> My understanding is it is much slower.
No kidding? Why don't you fork the PostGreSQL codebase and apply your
special assembly talents to speed it up by "50% or even 60%"?
---
>Has anyone been able to get mysql-3.23.44 running on the Sparc platform
>Solaris 8? I've tried both binary and source distro's with no luck. I've
>made the recomended changes from the Readme's and Install files as well as
>searched google high and low. I still get the same failures.
>
>I went to
Steve Meyers wrote:
> The MySQL source is under the GPL. Any fork must also be under the
> GPL. You may sell your forked MySQL, but you must also provide the
> source code.
Is it really, now?
What are the rules about "bundling" now? If we distribute a (standalone)
copy of MySQL with our pro
How can I fix this?
Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect
to This mysql server Fatal Error, Quitting..
Snort: no process killed
-
Before posting, please check:
http://www.mysql.com/manua
Has anyone been able to get mysql-3.23.44 running on the Sparc platform
Solaris 8? I've tried both binary and source distro's with no luck. I've
made the recomended changes from the Readme's and Install files as well as
searched google high and low. I still get the same failures.
>From the sourc
Look at the 'grant' commands in the mysql manual. You have to setup
permissions if you want other hosts (other than localhost) to work, by
assigning permissions to all domains or a list of ips or something. Its
pretty complicated, but if you just want to give one user access from
anywhere its no
Can someone PLEASE explains how MySQL does authentication remotely
After installing MYSQL I created a user root with xyzxyz password. The
database allowed that.
When I connect Mysql, via java codes, from the same machine it works
perfectly.
When I connect Mysql, via java codes, from a rem
How does MySQL handle duplicate column names?
This e-mail and any files transmitted with it are confidential and are intended solely
for the use of the individual or entity to whom they are addressed. This communication
may contain material protected by legal privileges or statutory protections
> From: Demirchyan Oganes
>
> Hello everyone,
>
> I have a question with regards to the InnoDB data files.
> I have the following in my.ini file.
>
> innodb_data_file_path = ibdata1:200M
> innodb_data_home_dir = c:/innodb_data
>
> I just want to know the following. Does it mean that I have
> 200
I got it figured out, sort of. My machine was not loading the version of
MySQL I thought it was. Now it is, and I have BDB support. My rollbacks
now work.
Thanks for the help.
David
-Original Message-
From: David Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 10:25
Hi Shekar,
> -Original Message-
> From: ChandraShekarReddy Talakola [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 09, 2001 6:50 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: How to Create Tables ... and Clients using winmysqladmin
>
>
>
> Hi,
> Joseph Bueno wrote:
>
>Hi,
>
>If you run a single query, MySQL will use only one processor.
>MySQL multithreading allows you to run multiple queries in parallel,
>one query per thread.
Right, that I understand. Even while running up to 30 queries it pegs the
first CPU at max, and no other CPU
Hi All,
I tried to upgrade mysql database from mysql-server-3.23.36-1 to
mysql-3.23.43-1. However, when I downloaded and used
rpm -i MySQL-3.23.43-1.i386.rpm
I received the following error:
"error: failed dependencies:
MySQL conflicts with mysql-3.23.36-1
MySQL -server conflicts w
wk writes:
> Could anybody explain why index stops to work
> in the query
> SELECT SUM(...) WHERE ...
> with encreasing the size of range, but continue to work
> in the analog query
> SELECT COUNT(*) WHERE ... ?
Well, I can imagine that the optimizer chooses not to use the
index for SUM() a lot
Stuart Scamman wrote:
> How do I show processlist from a specific computer, not everything ?
> Thanks.
mysqladmin processlist |grep 'the.host.you.care.about'
--
Bill Adams
TriQuint Semiconductor
-
Before posting, please
Hello everyone,
I have a question with regards to the InnoDB data files.
I have the following in my.ini file.
innodb_data_file_path = ibdata1:200M
innodb_data_home_dir = c:/innodb_data
I just want to know the following. Does it mean that I have 200Mb allocated space to
store all the InnoDB da
I know, I know... this is not really an MySQL question but an ordinary SQL
question.. but I need help with it..
Lets say that I have a table called test that has 3 columns
test1,test2,test3 (what type they are are not interesting) columns test1 and
test2 makes the primary key
what I would like i
I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host
about 1000 very small sites on a fairly fast server with plenty of RAM and
space. However, it keeps shutting down frequently and every time it shuts
down, the binary log files rotate, and someone will probably try to access
How do I show processlist from a specific computer, not everything ?
Thanks.
Hello mysql list,
Could anybody explain why index stops to work
in the query
SELECT SUM(...) WHERE ...
with encreasing the size of range, but continue to work
in the analog query
SELECT COUNT(*) WHERE ... ?
See later:
In the table ip_summary_d: PRIMARY KEY = (date,):
mysql> explain select
Aaron Williams wrote:
> The tables run upwards of around 13-15 gigs each. The nature of the
> data forces me to search the entire contents (looking for unique
> values) around 3000 times a day. The server is running Solaris 2.8,
Do you have an index on the columns you are querying for unique val
Aaron Williams wrote:
>
> Hello again list. I sent this message yesterday and wasn't able to
> get an answer. Just curious to see if any of the gurus out there care
> to share some insight on a mid-level MySQL setup, and can offer some
> starting points for learning how to troubleshoot the same.
Rui Barreiros wrote:
> Hi,
>
> We have several mysql server in production evironment, and most of them
> when they have millions of rows, they all get MyIsam tables corrupted.
>
> One of the servers has ext2 filesystem with scsi harddrives, after the
> myisamchk -r it repairs the table, but after
Apache supports running cgi scripts as a designated user on a virtual
host basis (only key is the files can be writable by ONLY the USER not
his GROUP (toe badly stubbed making this mistake). However, why doesn't
the isp create a separate mysql user for each client's database and
restrict per
On Fri, 9 Nov 2001, Carl Troein wrote:
> Date: Fri, 09 Nov 2001 15:41:21 GMT
> From: Carl Troein <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Beginner question - getting last inserted ID
>
>
> Anna Åhnberg writes:
>
> > Thanks, I actually already found the chapters but now I also
Hi Othmar,
I'm sure its probably a typo in your message, but isn't the default port
3306 and not 3360?
Also, isn't there a : after mysql?
e.g.
jdbc:mysql://localhost:3306/
If its not this then let me know and I'll try and suggest a solution.
Best Regards,
Chris
-Original Message-
F
Hello again list. I sent this message yesterday and wasn't able to
get an answer. Just curious to see if any of the gurus out there care
to share some insight on a mid-level MySQL setup, and can offer some
starting points for learning how to troubleshoot the same.
| Begin message:
I have a
I'm sorry, but apparently I'm too green to be able to figure this out.
You are right, when I do the SHOW CREATE TABLE, it tells me my table is
MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it accepts the command but
does not change the table type.
I am using MySQLD-max-nt, which the manual sa
In the last episode (Nov 08), Mike Broxterman said:
> I'm looking for a programatic way to obtain the real FQDN of the
> myqld server, not the one used to connect to the server. Here's the
> scenario, several servers running mysqld are behind a virtual IP so
> when you connect to mysqld you do not
> Anna Åhnberg writes:
>
> > Thanks, I actually already found the chapters but now I also now how to
> > use the function too!
>
> Let me quote from the manual:
> "LAST_INSERT_ID([expr])
> Returns the last automatically generated value that was
> inserted into an AUTO_INCREMENT column.
Sure is:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
John Barton
[EMAIL PROTECTED]
http://jbarton.technicalworks.net
On Fri, 9 Nov 2001, Brad Harriger wrote:
> Is it legal to change a field name to the same name as in the following?
>
> ALTER TABLE t1 CHANGE a a INTEGER;
>
> Thanks,
>
> Brad
Hi,
3360? 3306?
Please try "jdbc:mysql//localhost:3306/..."
^^
Thanks.
Othmar Stehlik wrote:
>
> Hi
>
> I run mySQl on a Win98 machine,and cant get a connection.
> My sql runs fine, but I can$B%((Bt connect to the database.
> I use the path jdbc:my
Hi,
What is your Pooing Utility?
Generally, JDBC Connection is TCP/IP's Socket.
After the Socket has been disconnected, we can not detect it by JDBC
interface. So, we have to detect it before we return a Connection
to the client.
Please see a source of my util class for Pooling, below.
I am sending this mail in order to get things straight
about table corruption which I am experiencing with
4.0(as well as previous versions).
1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI,
AHA29160N SCSI controller
2) Database MyISam tables, BUT 21000 tables in the
database(this is fo
Is it legal to change a field name to the same name as in the following?
ALTER TABLE t1 CHANGE a a INTEGER;
Thanks,
Brad
This e-mail and any files transmitted with it are confidential and are intended solely
for the use of the individual or entity to whom they are addressed. This communica
Hi
I run mySQl on a Win98 machine,and cant get a connection.
My sql runs fine, but I can´t connect to the database.
I use the path jdbc:mysql//localhost:3360/...and so on.
On win2k everything worked fine.
Please give an advice!
Othmar
--
GMX - Die Kommunikationsplattform im Internet.
http://ww
I have a strange problem, when I run the following SQL query:
SELECT surname, Count(forename) FROM names GROUP BY surname;
If I run this in a mysql DOS box I get a correct result showing the surnames and the
appropriate number of people with that surname.
If I run this same query through ASP, ei
If you are using the Mark Matthews JDBC driver (MM.MySQL), there's another way to get
the last insert id: instead of using a generic Statement object to execute the INSERT
command, use an org.gjt.mm.mysql.Statement object. After executing an INSERT, the
method getLastInsertID() will return th
Glad to here it. I hadn't tried it myself, but I heard that it helped under
some circumstances. You'll take a small performance hit for the case where
you're dealing with lots of small files I've heard.
I haven't tried XFS.
I Just installed RH7.2 on a box last weekend using the ext3 filesystem.
Anna Åhnberg writes:
> Thanks, I actually already found the chapters but now I also now how to
> use the function too!
Let me quote from the manual:
"LAST_INSERT_ID([expr])
Returns the last automatically generated value that was
inserted into an AUTO_INCREMENT column.
mysql> select L
if you intend to use mysql you could send down for instance "select 1" to
the database..
but this is not database independent since not all databases might be albe
to handle this type of query
but it is application independent when using mysql.
if you plan to use an other database some other form
Hello,
I have to move a database from host with mysql 3.22.27 to a new host
with mysql 3.23.36.
After the install of mysql-3.23.36, I transfered the datadir that is
running with the 3.23.36 on the new system and I restart mysqld.
But the mysqld failed with error :
root@reserv4:/var/lib/mysql
IDE : JBuilder 4 prof
I am using pooling in order to optimize database access. When everybody
leaves the office for the weekend all my connection timeout. This is
expected except I would like my connection pool to be able to test
connections before passing them back to the requester. Whats the be
Hi,
I am just install the mysql database and i start the system at dos prompt
winmysqladmin i got the test tables with permissions and i have created my own
database but iam unable to create table for that how can i create table and also i
want create clients for my server and set the permis
> >> In fact, I already emailed the developers yesterday, and asked if I
> >> could
> >> pay to have the particular feature I wanted prioritized at this time.
> >
> >Strange how open source developers don't always answer to the almighty
> >dollar, eh?
>
>
>
> I asked kindly that you not turn
I would check the grant tables to see if host 127.0.0.1
has permission to access the DB. Even though they
are the same thing, I don't know if mysqld treats them
as the same thing.
Eugene
At 03:15 AM 11/09/2001 -0800, you wrote:
>Hello,
>
>Are there any obvious reasons why
>
>mysql -h localhost
> The guy passed this request to the hosting company (which he doesn't
> want to change) and the answer is:
>
> if you *really* need to use PHP instead of ASP OK, but as far as MySQL
> is concerned we only have one customer using it now, and if we gave it
> to you too, then the two databases would
I'm trying to set up a script for updating the tables on our production
machine with work done on the test machine.
The user that will be running the script, has SELECT privileges on the
source database. What privileges does the user need for the target
database? Can I get by with DELETE,INSERT?
Hi,
I am developing a application by using MySql database server. I have
requierment in my application, that i need to know/show all the tables
available in all the databases/catalogs of MySql. By using "show tables from
test" i can get tables from "test" database. But I need to know all the
tabl
Hello,
I have another question about the situation explained in my other message "Keeping SQL
DBs separated".
If it's not possible reconfigure SQL on the ISP server, then I
will have to test on Linux/Apache some PHP/MySQL pages that will
have to access via ODBC a MS Access database on an NT/IIS
Years ago I worked on an RDBMS that had a feature to allow execution of
'sections' of a command file, avoiding others. I am still ign scanning the
docs, but have not found anything similar in MySQL.
For example, in a database creation table one could enter (in MySQL format)
the following:
On Friday 09 Nov 2001 12:08, you wrote:
MySQL
> On Friday 09 Nov 2001 11:37, you wrote:
> > Note on what is going on here...
> >
> > The paragraph below was from a private email I sent to Gordon. And now
> > Gordon just responded to it on the public list.
> >
> > Gordon, I was strongly hinting to
Maciek,
At 12:20 PM 11/9/01 +0100, you wrote:
>> please show us the CREATE TABLE statements and what EXPLIN SELECT ... says
>> about both table types.
>
>CREATE TABLE `stats_InnoDB` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `ident` char(100) NOT NULL default '',
> `class` int(2) uns
Hello,
I have been asked by a guy to rewrite his web site presently written
by somebody else using ASP/NT/IIS/MS Access (by some other webmaster
who vanished). I said, yes, I could do it but with PHP/MySQL, because
that's what I know, and even more important I only have Linux/Apache
at home to t
1 - 100 of 121 matches
Mail list logo