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
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:
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/
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
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
I'm trying to connect like this:
Connection conn =
DriverManager.getConnection(jdbc:mysql://localhost:3306/homebrew?user=homebrewpassword=maaler);
But I get the following error:
SQLException: Cannot load connection class 'java.sql.SQLException: Server
configuration denies access to data
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 trace log and
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 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 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 factors
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 that
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 query as well?
Thanks,
Jeremy
--
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
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 :
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./../include
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:
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 searches
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
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
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
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
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
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 you a
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 with
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
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;
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
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 tablename)
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 that
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
.. 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...
I
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
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 you
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
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 it
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 sql
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 DB's
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,
I cannot
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
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 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
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/
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
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
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
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
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
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
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
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=homebrewpassword=maaler);
But I get the following error:
SQLException: Cannot
50 matches
Mail list logo