| |
thread by: Jon Miller |
last post Jul 19 '05 by: Jon Miller
We've run out of disk space and would like to move either the entire MySQL =
system or if possible move the databases. Can this be done without any =
difficulties?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
|
thread by: blucados |
last post Jul 19 '05 by: blucados
Here are 3 questions about extended-status
and server parameters.
I have a server with 1G of Ram Dual Cpu running
mysql 3.23.41.
1/ to know if table_cache need to be increased,
what is the maximum rate of opened_table that
must be seen. I read somewhere that 1 or 2
|
thread by: Denis Labon |
last post Jul 20 '05 by: Denis Labon
I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused
I'm using...
|
thread by: Hoang Do |
last post Jul 20 '05 by: NDS Ltd
I have a yahoo web-php-mysql account and they place their mysql database
behind a firewall that can only be accessed via PHP code running on their
machine. Does anyone know of a proxy package that can allow you to access
mysql from a PHP script running on another machine, for example? This
scenario is becoming very common in today's webhosts...
|
thread by: Mike |
last post Jul 20 '05 by: Aggro
I am not a sql person and could use some help with a delete...here is
what I want:
I have the following tables/fields (only including necessary fields)
answers
result_id
results
result_id
|
thread by: Michael Russell |
last post Jul 19 '05 by: Michael Russell
I'm working on a Windows client program in C++, using Qt and OleDbPro (for
database access). Everything was working great until I had to use a query
for the first time in the code that pulled data from two tables. The query
executes, but returns 0 rows. I verified that the query should return rows
by running the query both through another...
|
thread by: Jay |
last post Jul 20 '05 by: Jay
Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?
TIA,
Jay
|
| |
thread by: Extraordinaire |
last post Jul 19 '05 by: Extraordinaire
Hi
I builded a little propert database. I added a search function to the site
but have the following problem:
I used "SELECT *
FROM table1 WHERE area ='province' and type like'%type_1%' and town
like'%town_1%' and descr like '%descr_1%' and suburb like '%sub_1%'"
But it do not do the like thing. If I search for 3 bed and the actual data...
|
thread by: Greg |
last post Jul 19 '05 by: Greg
I have just started my first big project and I am having trouble predicting
the system specs that will be required. At present during trials the site
has around 15 users, although this will go to 350 when it is launched.
Most of the pages execution time should not scale with the increase in users
but there are a few report pages which...
|
thread by: Info-maroz |
last post Jul 19 '05 by: Info-maroz
<html>
<head>
<title>cleanactpro</title>
</head>
<body>
<div style="text-align: center;"><span style="font-weight: bold;"><span
style="color: rgb(255, 0, 0);">Keep Your Job</span> - <span
style="color: rgb(0, 153, 0);">Keep Your Marriage</span> - <span
style="color: rgb(51, 51, 255);">Keep Out Of Trouble</span></span><br>
<br>
|
thread by: gondor |
last post Jul 20 '05 by: gondor
hi!
i have a problem with a update-query:
start-structur (column 1 index, 2 datetime, 3 time of measurement, 4-6 values):
1 | 0000-00-00 00:00:00 | 0 | 21 | 22 | 23
2 | 0000-00-00 00:00:00 | 1 | 21 | 22 | 23
3 | 0000-00-00 00:00:00 | 3 | 21 | 22 | 23
4 | 0000-00-00 00:00:00 | 5 | 21 | 22 | 23
|
thread by: Primaria Falticeni SDU |
last post Jul 19 '05 by: Primaria Falticeni SDU
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
|
thread by: krystoffff |
last post Jul 19 '05 by: krystoffff
For the following query, I have a little problem ...
First, I have to rewrite several times the same query because the
alias are not recognised in the same query ( I got an error when I try
to reuse the alias "nb_bogus_leads", for instance). Do you have a way
to avoid this ? Because If I do so, the same query is calculated twice
....
...
|
thread by: Bill |
last post Jul 19 '05 by: Bill
I was under the impression from the manual that if you added a field to a
table of type timestamp this would automatically be updated after each
insert/update of a new record, but all I get is 00000000.
Is there something else I should set?
Thanks.
|
thread by: a_rollins2 |
last post Jul 19 '05 by: a_rollins2
DID YOU KNOW A HACKER COULD BE READING YOUR EMAILS RIGHT NOW?
the next email you receive could contain a virus. are you protected?
All emails are scanned automatically with Norton Antivirus!
btw, you look great today.
Purchase a copy now and be safe.
http://9302fs@softwaresavings2you.biz/default.asp?id=3000
|
| |
thread by: krystoffff |
last post Jul 19 '05 by: krystoffff
Hi
It's probably a stupid question, but I can't find how to do that in
the MySQL documentation ...
I want to do the following query, or something like that:
SELECT id, "string"+id as text FROM ...
and the result should be:
|
thread by: Simon |
last post Jul 19 '05 by: Simon
Hi,
I'm trying to get a version of MySQL 4.1.0 installed on my (Gentoo Linux)
machine. I have a copy of MySQL 4.0.13 already installed, using Gentoo's
ebuilds, but am trying to install 4.1.0 in a side-by-side configuration.
(Into /usr/local/mysql_alpha, talking to port 3300) - So I can run 4.0 as my
"production" server, and muck about with...
|
thread by: Serious_Practitioner |
last post Jul 19 '05 by: Serious_Practitioner
Hello, all -
I would be interested in hearing opinions on how easy or difficult it it to
use MySQL as part of a Web page. I have no experience with MySQL, but I have
experience with MS Access and VB. The project that I'd like to put together
is an online ordering facility for videotapes, not too many concurrent users
and relatively low...
|
thread by: Ken Bass |
last post Jul 20 '05 by: Ken Bass
I am porting C code originally written to talk to a SQL Server engine
via ODBC. While many of the differences are mainly annoyances, and I
found work arounds, I have run across one big issue. The MySql driver
(3.51.06) doesn't support bookmarks.
The only time this is a real problem is when I need to get the value
of an auto-incremented...
|
thread by: krystoffff |
last post Jul 19 '05 by: krystoffff
Hi all
For speed reasons, I would like to rewrite the following query without
the subquery :
SELECT * FROM table1 WHERE field1 NOT IN (SELECT field1 FROM table2
where field2=X);
I thought something like this would work fine :
SELECT table1.* FROM table1 LEFT JOIN table2 ON
|
thread by: Chris Welsh |
last post Jul 19 '05 by: Chris Welsh
I have a large'ish mySQL table, very text heavy (although no fields
are larger than varchar 255). I do a bulk update once a day, which
probably removes a 1/4 of the records, replacing them with fresh
records. I find my table swiftly becomes massively inefficent, with
the reported overhead soon exceeding the actual size of the table.
So my...
|
thread by: pappatch |
last post Jul 20 '05 by: pappatch
Hi
I want to create the best index for thar query:
"select * from talkback where status=0 order by bject_type,vertical_id,event_id"
Which index i need to create for best performance.
10X
|
thread by: Ash Christopher |
last post Jul 19 '05 by: Ash Christopher
Is there a way to store images in a mySQL database? I was hoping to store
them in a table, then use php to call them from the database and display the
picture on a webpage.
Any help would be appreciated.
|
| |
thread by: Jerry Weinstein |
last post Jul 19 '05 by: Jerry Weinstein
Hi,
I know about stored procedures and that they can speed up data entry via the
SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record
to be inserted to the database before the procedure is executed.
I want to circumvent...
|
thread by: Braden Bowers |
last post Jul 19 '05 by: Braden Bowers
I have a web program where I want to connect to my database and
discover the tables within the database. Then select a table and
discover the column names, their types, and lengths.
Thanks in advance.
Braden Bowers
|