Please I need some help here, I don't think I understand the "rights"
architecture in MySQL.
I'm trying to connect like this:
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/homebrew?user=homebrew&password=maaler");
But I get the following error:
SQLException: Canno
Hi,
Could you please correct my doubt about Mysql-Max . I installed
mysql-max and worked
with java application works perfectly and could create InnoDB tables
with Foreign Key
references but I did't set anything in My.cnf, So, I need to know is it
installed perfectly and supports
transac
Dear Friends,
I am using MySql server in my application.
My application needs MySql server to be running for 24 hours and needs to make
connection with server at any time.
I have heared that by default MySql server will close the connection after 8 hours.
So, does it mean that after every 8 h
Hi,
This is a bug in myisamchk. The problem is already fixed in mysql-4.0.2 :
http://www.mysql.com/doc/N/e/News-4.0.2.html
"Fixed new bug in myisamchk where it didn't correctly update number of
``parts'' in the MyISAM index file. "
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Me
I had a typo I was trying to use myisamchk -r not -f to fix it which did
not fix it.
myisamchk -o seems to fix the problem.
The real question is why am i getting this when creating index(s).
Although I'm using the Alpha version, I don't get a warm fuzzy
Any responses on what could be causi
At 08:33 PM 2/16/2002 , you wrote:
>Hello
>
>I am new to the subject. I am experimenting in mysql via PHP with a nice
>book (PHP and MySQL
>Web development). My question is how many queries to mysql, made via PHP,
>should considered
>ok for efficiency. I know it has much to do with the size of d
Description:
After inserting 1062351 records into a table I create 2 index on the table.
It seems like after creating the indexs (test have shown that the error appears after
creating the first index) I get the following warning when i do a CHECK TABLES
mytablename or a mysisamchk -a myt
Hi,
I want to correct myself about Mysql-Max . I installed mysql-max and worked
with java application works perfectly and could create InnoDB tables with Foreign Key
references, but I need to know about is it installed perfectly and supports
transaction or any other settings have to be
Suggestions:
Good, Free Mac GUI to mySQL?
Please email directly to me at: [EMAIL PROTECTED]
Thanks,
Gary
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
> I am currently running mySQL with a slave...I just wondering if there's a
> way to replicate all data available in the master to be copied to the
slave
> in one single command...
>
> My master server is running ahead than my slave...so my slave is only
filled
> with user data...
>
> Is there a w
Hi,
I am currently running mySQL with a slave...I just wondering if there's a
way to replicate all data available in the master to be copied to the slave
in one single command...
My master server is running ahead than my slave...so my slave is only filled
with user data...
Is there a way to do
I have been working all night on something then Outlook Express crashed my
machine and now after restarting, MySQL service will not start. I am running
it on Win2K Pro and have had no probs until just now. I right click on it
and choose WinNT::Start the service. The dialog comes up asking if I wan
Hi Benjamin,
The perfect answer.
Thank you,
Anvar.
At 08:44 AM 16/02/2002 +0100, you wrote:
>Hi.
>
>On Fri, Feb 15, 2002 at 09:05:02PM -0800, [EMAIL PROTECTED] wrote:
> > In Re: Selecting records with the highest value no greater than x,
> <[EMAIL PROTECTED]> wrote:
> > >
> > >Hi Brent,
> > >
Oh. OK. Didn't know that. Thanks.
j- k-
On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote:
> On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
> > In that case, i would highly recommend using mysqldump to backup
> > your databases. Simply compressing the actual
In Re: Database synchronization, <[EMAIL PROTECTED]> wrote:
>
>On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
>
>> I'd like to connect a local sql server to a remote server and get 1
>> database synchronized between them. For various reasons, I need to
>> try to run this from within the s
> > MS SQL Server has this function built in...please let me know what the
best
> > method to do this using mySQL
>
> Wouldn't you agree that this is not really a task for an RDBMS server?
> Aren't these typically things that a client application should sort out
> for itself, in whichever way
Greetings,
I have spent a few hours trying to setup a replication server for
testing and I cannot get the slave to connect to the master server:
Here is the error:
020217 21:11:25 Slave thread: error connecting to master: Can't connect
to MySQL server on '192.168.1.2' (111) (107), retry in 60
> mysql_select_db("$DBName");
> mysql_query("SELECT Date,BuyerID,OrderNumber FROM Buyers")
>
> How do I assign the variable to both of those lines that make
> up the DB
> call???
Unless you're planning to use several databases, you only have to use
mysql_select_db($DBName); once, normally where
I just started going into some of the other files that will need updating
and I have run into another little prob dealing with the same thing
Here it is, maybe you can shed some light on it for me.
$result=mysql_db_query("$DBName","SELECT Date,BuyerID,OrderNumber FROM
Buyers");
The $Result v
> .. if mysql_db_query is what you're using.
Actually below is waht I am using...
mysql("$DBName","INSERT INTO Category VALUES('$Category','')");
After your response, I changed it to...
mysql_select_db("$DBName");
mysql_query("INSERT INTO Category VALUES('$Category','')");
Works like a charm
> > It means something is out of date...looks like you need an update of
> > something...
>
> This is the line 7 that it is talking about How do I know
> what is out of
> date and how to fix it? Are there any utilities out there for updating
> scripts or do I need to manually go into each .p
Hi,
> Warning: mysql is deprecated; use mysql_select_db() and mysql_query()
> instead in (rootPath here)\cart\admin\addcategoryresponse.php
> on line 7
[snip]
> What does depricated mean? I have searched the manual and the
> resources
> online but cannot find anything about it. Does it mean t
This is not a Mysql issue but an PHP one. The function you are using
(mysql_db_query ?) is deprecated and should therefore not be used. Try
modifying your PHP script to use
mysql_select_db("test");
mysql_query("select * from tablename");
.. instead of
mysql_db_query("test","select * from tablen
> It means something is out of date...looks like you need an update of
> something...
This is the line 7 that it is talking about How do I know what is out of
date and how to fix it? Are there any utilities out there for updating
scripts or do I need to manually go into each .php file and upd
> Hello everyone.
>
> I am new to MySQL and am trying to setup a shopping cart using MySQL and
> PHP.
> They are files that I found online for free from Rosenet Internet
Services.
>
> The problem is that when I try to add a category for a product I get this
in
> return:
>
>
> Warning: mysql is de
Hello everyone.
I am new to MySQL and am trying to setup a shopping cart using MySQL and
PHP.
They are files that I found online for free from Rosenet Internet Services.
The problem is that when I try to add a category for a product I get this in
return:
Warning: mysql is deprecated; use mysql
Hi,
On Mon, 2002-02-18 at 08:40, The Majestic Moined Mogul wrote:
> I am still looking for a method of reading XML documents into mySQL database
> and also to retrieve data from the mySQL database into an XML document
>
> I found something on how to do it with PERL but would like to stick wi
Hi,
On Mon, 2002-02-18 at 00:40, [EMAIL PROTECTED] wrote:
> I want to do substraction between tables in mysql,
> MINUS not yet implemented in mysql
>
> and this not work :
> select a.* from table_a a where a in (select * from table_b)
Please post the structure of both tables. Then we can post y
I am still looking for a method of reading XML documents into mySQL database
and also to retrieve data from the mySQL database into an XML document
I found something on how to do it with PERL but would like to stick with
just JAVA...
MS SQL Server has this function built in...please let me k
Please forgive the OT, but I am trying to integrate mysql db's with WIN32
clients on Linux servers. I need to use some programs (ONC RPC daemons) on
the Linux box from applications written in VC++ on a WIN32 box so RPC seems
the correct solution. Can anyone point me in the right direction for WI
Could someone please e-mail me to let me know how data can be retrieved in
XML format from my mySQL database?
Thank you in advance!
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
When I am logged in to my Linux system as root mysqladmin works
correctly. i.e. finds mysql.sock in the correct location.
When I am logged in as a normal user I get this error:
Can't connect to local MySQL server through socket
/var/lib/mysql/mysql.sock. blah blah... (This is *not* the cor
Hello,
according to the docs:
"For the moment, GRANT only supports host, table, database, and column names up to
60
characters long.
A user name can be up to 16 characters."
Is there a way to increase this limitation?
I want 32-64 character usernames.
Thanks
sql, query
--
Vincent Stoesse
> > I don't believe this is possible, but I couldn't find any posts and
wanted
> > to confirm. I realize that we may need to import through an SQL query.
>
> I believe itis, you can just copy the files over.
>
>
Thanks for the tips! I will let the list know how this turns out!
Alex Charlton
[EMA
In phpmyadmin
Choose the table from the list... Scroll down the main screen and you
will see this:
View Dump(schema) of table:
You will have options like Structure only, Structure and data, CSV for
MS Excel... Structure dumps the column names and all the field types...
Structure AND data
Since my first posting of this came out all screwed up,
I currently have a PHP script performing the following query:
mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1)
It works great except that the search is coming out case sensitive.
According to the MySQL Docs all search
mysqldump -hhostname -uuser -ppassword database table > table.sql
That will dump the structure and data of the table to the file table.sql
Tyler
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 17, 2002 10:02 AM
Subject: How to save the table
Hello,
I want to store my table in text file,
I've tried :
select * from news into outfile 'news1.txt'
but doesn't work
Can you help to do this with phpmyadmin or sql,
thanx
-
Before posting, please check:
http://www.mys
MySQL 3.23.49 fails to compile under RH Linux w/2.4.16 kernel. It was
configure w/InnoDB support.
Here's the output:
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\""
-DSHAREDIR="\"/usr/local/share/mysql\""
-DHAVE_CONFIG_H -I../innobase/include
-I./../inclu
Hi,
At first thanks for the answer. I was wondering if my mail was precise enough.
> Your results could have a lot to do with the fact that HEAP tables
> used hashed indexes rather than the B-Tree indexes of MyISAM. The set
No, I've really used queries that take advantage of the hash indexes
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
> I'd like to connect a local sql server to a remote server and get 1
> database synchronized between them. For various reasons, I need to
> try to run this from within the sql protocol (i.e. no ftp, etc.).
Okay.
> Replication is not the a
On Fri, Feb 15, 2002 at 10:08:08AM +0800, [EMAIL PROTECTED] wrote:
> Hi,
>
> I still got stuck on a query...so slow...it took a minute or more
>
> How can I improve my server...
Can you tell us what the mysterious query is? And send along the
output of EXPLAIN as well?
Thanks,
Jeremy
--
Je
On Fri, Feb 15, 2002 at 09:17:52PM +0300, Mikhail V.Soloviev wrote:
> Hello,
>
> I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2,
> pIII-800 512K RAM). It starts and works fine until some time is
> passed, then it starts eating my memory and CPU.
What does SHOW PROCESSLIST say at
On Fri, Feb 15, 2002 at 04:00:11PM +0100, Antoine wrote:
>
> Hello,
>
> Well, for my project at work, I've done some small benchmarking of
> different table types for relatively small sizes (some tens or
> hundreds of thousands rows - small enough so that key buffer size
> and other memory facto
On Fri, Feb 15, 2002 at 10:32:06AM +, Simon Windsor wrote:
>
> Currently, I maintain two mysql server, hosted by separate ISPs, and
> keep them synchronised using standard MySQL replication.
Great!
> Server A is master+slave to server B, and likewise server B is master
> +slave to server A.
On Fri, Feb 15, 2002 at 09:43:28AM +0100, Wolfgang Pichler wrote:
> I have to set up a HA-Linux Server with Apache and mysql running on
> two machines over load balancing. Apache isn't a problem. But mysql.
> AFAIK it is impossible to cluster mysql - it "only" supports
> replication. As I've said
On Sat, Feb 16, 2002 at 02:20:56PM -, Bjorn Swift wrote:
> > Have you optimized the settings in my.cnf and checked your slow
> > queries?
>
> No, I haven't optimized my.cnf - looking at it now. Thanks.
>
> Well, that was pretty much what I was hoping this "tool" could do;
> go though the tra
I'm trying to connect like this:
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/homebrew?user=homebrew&password=maaler");
But I get the following error:
SQLException: Cannot load connection class 'java.sql.SQLException: Server
configuration denies access to data so
Do you mean run a query that pulls all content in a table?
OR
Something thats saves all content of a table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 8:52 AM
To: [EMAIL PROTECTED]
Subject: How to save the table content into f
Note: I am temporarily unsubscribed from this list, so please Cc me at
[EMAIL PROTECTED] if you reply to this message.
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa M
Hello,
I am looking for how to save into file content of table,
Can you give an example of mysql query,
thanx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
If u can help,
I want to do substraction between tables in mysql,
MINUS not yet implemented in mysql
and this not work :
select a.* from table_a a where a in (select * from table_b)
thanx
-
Before posting, please che
Alex,
What I do is a DUMP on the table, either the schema or data or both.
This will create a .sql file you can run again against whatever platform
you are on
-Original Message-
From: Alex Charlton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 3:55 AM
To: mySQL
Subject: Fw:
Loretta,
please look in the manual http://www.innodb.com/ibman.html :
If InnoDB prints an operating system error in a file operation, look from
section 13.2 what that error code means. Usually the problem is one of the
following:
You did not create InnoDB data or log directories.
mysqld do
54 matches
Mail list logo
