Hi
We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts
and updates on a P4 with 1GB of RAM. Performance is fine, and the table size
is 400MB, so you should not have any problems.
Peter
On 29/05/06, Chris W <[EMAIL PROTECTED]> wrote:
Harish TM wrote:
> hi...
> I n
SELECT DISTINCT Colour
FROM tablename
Peter
On 14/02/2008, Richard <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I don't know if it is possible to do this with mysql alone ...
> Here goes :
> I've got a database list which is like to following :
>
> Num | Name| Colour
> --
Hi
You probably cant make it 100% secure, because php is not a fully compiled
language, and as such an expert techie could probably add extra code to your
app that wouild allow access to the database, BUT you can get pretty close.
You will need to encrypt everything in the database using MySql e
Hi
try DEZIGN FOR DATABASES
http://www.datanamic.com/
hth
Peter
-Original Message-
From: Alaios [mailto:[EMAIL PROTECTED]
Sent: 30 November 2003 20:27
To: [EMAIL PROTECTED]
Subject: designer
Do u know any programme that can degin databases in order to design before i
implement them?
Hi
try running
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'pass';
where 'hostname' is the one in the error message
HTH
Peter
-Original Message-
From: Louis van der Merwe [mailto:[EMAIL PROT
Try
Insert INTO `table` ( `inc_field` ) values (10)
the auto inc field will then generate the next sequential numbers
HTH
Peter
-Original Message-
From: Graham Little [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:01
To: '[EMAIL PROTECTED]'
Subject: SEQUENCES
I was won
try adding an error report after the query
$result = mysql_query( "select * from domains" ) or die (mysql_error());
the rest looks OK
Peter
-Original Message-
From: Trevor Rhodes [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 22:26
To: [EMAIL PROTECTED]
Subject: Basic error
Hello f
Hi
We have been running MySql since 1998 and have never had any data corruption
We have servers running millions of queries a day and they are bullet proof.
>
> > Hi,
> >
> > I'm trying to get a software designer to write us some software using
> > MySQL as the database server (he currently requ
phpMyAdmin will do it.
http://www.phpmyadmin.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 January 2004 01:15
To: [EMAIL PROTECTED]
Subject: Looking for a tool
Importance: High
Several years ago, I used a cgi based tool that allowed me to upload a
SELECT *
>From articles
WHERE SectionID=1
ORDER BY EntryDate DESC
LIMIT 1,10
the where clause should be after the table name
HTH
Peter
-Original Message-
From: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Sent: 18 January 2004 11:22
To: [EMAIL PROTECTED]
Subject: SQL Query
Any idea what i
hi
it is very simple in php
$query = 'SELECT *
FROM table
WHERE somefield = "'.$somevalue.'"
ORDER BY somefield
';
$mysql_result = mysql_query($query, $mysql_link);
while($row = mysql_fetch_array($mysql_result))
{
$output .=
"\"$row["somefield"]\"\t\"$row["so
Hi
You can only connect as root from localhost for security I think.
If you want to connect from elsewhere create a new user and use that - look
for GRANT on www.mysql.com
Peter
-Original Message-
From: Duke, Brian [mailto:[EMAIL PROTECTED]
Sent: 08 February 2004 01:50
To: [EMAIL PROTEC
no .they really are out to get you :)
Security is always a challenge. You can build the most secure system in the
world but if the users are not educated in security you have wasted your
time.
The "no password" relies on a user knowing what to do. The question is this
OK default behaviour - t
Hi
var/lib/mysql/mysql.sock
is created when MySQl runs, it may be a permissions problem with the
directory - does MySql have write permission for this directory
Peter
-Original Message-
From: Vishal Thakur [mailto:[EMAIL PROTECTED]
Sent: 01 June 2003 10:37
To: ABHIJIT NAIK
Cc: MySQL; Su
Hi
This is a bug. You can fix it by adding a line to my.cnf. Can't remember
what but search the archives as it has appeared before.
Peter
-Original Message-
From: Nick Arnett [mailto:[EMAIL PROTECTED]
Sent: 01 June 2003 15:54
To: [EMAIL PROTECTED]
Subject: RE: MYSQL DB PROBLEM
> -O
';
?>
Peter
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 20:57
To: [EMAIL PROTECTED]
Subject: Re: Mysql / PHP image link problem.
FWIW, there is a PHP-DB mailing list that might prove more helpful to you.
I
know certain folk on both lists can g
Hi
I would echo that support is probably the most important aspect of your
choice.
Unless you have a particularly technically demanding application that needs
features only found in Postgres you would be best with MySql
You can get an answer to most support questions via this list, or MySql
them
Hi
can you post the form/php code
Peter
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 14:26
To: MySQL List
Subject: Column or Table issue
I am attempting to insert an article into a MySQL table on a remote server,
via a PHP Forms script.
I am able
smaller userbase and no commercial support *combined* mean fewer sources of
support. With MySql, support from this *superb* MySQL list :) and MySql AB
is likely to be better than Postgres support.
Open source support (free or paid for) in general seems to be better than
closed source equivalents
Hi
SELECT
COUNT(DISTINCT trEmail ) as clicks
, trEmail FROM table
GROUP BY trEmail
ORDER BY clicks DESC
will probably give what you are looking for
Peter
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]
Sent: 15 June 2003 00:14
To: [EMAIL PROTEC
Hi
You need nothing or backtics - ` - around the table name - you have quotes
INSERT INTO products VALUES (153328, 2, '181150', 'noimage.gif', '154.1000',
'2003-06-20 23:03:00', NULL, '-00-00 00:00:00', '0.00', 1, 1, 1, 0);
also better to state the field names - if you add or remove a field
Hi
If you log into MySQL on the command line and enter
mysql>SHOW PROCESSLIST ;
this should show you what is running. You may find a runaway query.
also check the temp disk space while the system is stalling - large joins
can use huge amounts of disk space. If MySql runs out of disk space it
t
Hi
I agree the SCO action sucks but Open source software should be just that -
open to all, let the courts decide, if it ever gets that far!.
Peter
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 01:18
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject:
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi
Hi
did you run mysql_install_db ? This sets up the mysql database and initial
privilages
Peter
-Original Message-
From: Blake Howe [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:27
To: [EMAIL PROTECTED]
Subject: mysql server wont start
OK i am having problems starting the mysql server
Hi
You could achive what you want using grant statements, but you still need a
user interface to send queries to the database and display the information
sent back in a way that is manageble for non techies.
There are many ways of building user interfaces, php ( http://www.php.net )
is probably a
search for
my.cnf
If it does not exist you can create it,
http://www.mysql.com/doc/en/Option_files.html
Peter
-Original Message-
From: Richard Sumilang [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 07:56
To: [EMAIL PROTECTED]
Subject: Setting max_connections
Where do I go to set t
2) Using the Opera browser, I open my pages and it sends variables through
"?var1=value1&var2=value2" perfectly until I tried using a form and
realised I am not getting anything back from $PHPSELF...
try $PHP_SELF
Peter
--
http://www.dragonstalon.co.uk/
Latest news at http://www.dra
Hi
when you log in to MySQL use
mysql -u root
you will then be asked to enter a password. On a new instalation the
password may be blank - nothing
After that you should be able to create databases.
You might find information about privilages and GRANT usefull
http://www.mysql.com/doc/en/User_A
SELECT * FROM TABLE
if( mysql_num_rows() == 0) table is empty
HTH
Peter
-Original Message-
From: D. K. [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 08:12
To: [EMAIL PROTECTED]
Subject:
Hello List;
I am developing a php-mysql application for my term project at school and
this is where
you need at least 3 fields
CategoryID
ParentID
Name
CategoryID is the key, and identifies the category
ParentID is the CategoryID of the parent category
Name is the category name
When you add a sub category you set its ParentID to the CategoryID
To show all sub categories of CategoryID 99
SEL
Hi
Firstly if your application is well designed then your data should not be accessible
by the wrong users - if you make sure that there is no way the wrong supplier id can
be allocated - put an extra 'are you sure this is correct' check, make it so that the
user id can only be allocated once t
HI
from the command line run
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'password';
(you may want to give more restrictive privileges)
that should fix it - you don't have privileges set for the user
hi
you might want to look at TIMESTAMP which does it all for you.
Peter
> -Original Message-
> From: Robert Adkins [mailto:[EMAIL PROTECTED]
> Sent: 15 October 2004 20:23
> To: MySQL General List
> Subject: Command that I believe should work...
>
>
> ...but doesn't.
>
> I am attempt
Hi
could it be that the - or a space is upsetting things?
111-111- might be calculated to give -
or if the user enters a space it is no longer an integer
unless you need it to be an integer, telephone numbers are usually stored
as a char type
HTH
Peter
> -Original Message-
Hi
sub selects are only supported from MySql 4.1 onwards, so it may be invalid
if you have an earlier version.
you may also cause a conflict by using the database alias (t1) as the name
of the result
Peter
> -Original Message-
> From: kalin mintchev [mailto:[EMAIL PROTECTED]
> Sent: 14
Virus!
Monty's address was probably spoofed
Peter
> -Original Message-
> From: Spenser [mailto:[EMAIL PROTECTED]
> Sent: 16 November 2004 08:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Returned mail: Data format error
>
>
> Did the system just reject Monty Wideni
Hi
What about encrypting the data using a password that is specific to the
user. That way only those that know the password for that row can access it.
Locking is really to stop two users editing the same record at the same
time, rather than controlling access.
HTH
Peter
> -Original Mess
> Sent: 18 November 2004 10:19
> To: 'Peter Lovatt'; 'Mysql (E-mail)'
> Subject: RE: Row level security requirements, can I still use MySQL?
>
>
> Yeah you are correct locking is something else I actually meant was
> restricted access.
>
> If I understa
t; access to
> the groups table and could easily se which password was allocated to each
> group and in that way bypass the security system? Or have I misunderstod
> your solution.
>
> In any case, thanks alot for wasting som "brain-time" on this ;)
>
> Regards
> /Jonas
&g
5001
Peter
> -Original Message-
> From: Robinson, Eric [mailto:[EMAIL PROTECTED]
> Sent: 18 November 2004 21:35
> To: [EMAIL PROTECTED]
> Subject: Auto-Increment Starting Point? (Multimaster Replication
> Question)
>
>
> When you set a field to auto-increment, can you tell it where to s
Hi
there a are a couple of things that I have found cause occasional lock ups.
running out of temp space - MySql builds temp files on bigger queries and if
it runs out of temp disk space it grinds to a halt, which causes all the
following queries to queue up until max_connections is exceeded.
th
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
> -Original Message-
> From: Christian Biggins [mailto:[EMAIL PROTECTED]
> Sent: 26 January 2005 12:27
> To: mysql@lists.mysql.com
> Subject: Access denied for user - I cant work this out
>
>
>
' . mysql_error() .
'');
}
}
HTH
Peter
> -Original Message-
> From: Christian Biggins [mailto:[EMAIL PROTECTED]
> Sent: 26 January 2005 13:30
> To: 'Peter Lovatt'; mysql@lists.mysql.com
> Subject: RE: Access denied f
Hi
There are two aspects to dates, and your questions include parts of both.
When MySql stores dates you have a choice of column types
http://dev.mysql.com/doc/mysql/en/DATETIME.html
has the details
If you just need to store dates then the DATE type will suit your needs. You
just specify it as
> Subject: RE: New to Dates - Plain English Please
>
>
> --- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > There are two aspects to dates, and your questions
> > include parts of both.
> >
> > When MySql stores dates you have a choice
hi
the error is because you have more or fewer items of data than fields or
columns to put it in
it is better practice to include fields in your query
INSERT INTO sometable
(
field1
, field2
, field3
)
VALUES
hi
the
/home/lark/public_html/connection.php on line 23
just refers to the file within the context of the whole file system and is
fine
the rest says that mysql cannot/does not execute the query so there is no
result to use.
the @ suppresses error messages so it may be best to remove it
try
HI
MD5 would be a good way of doing it. Just add a column to your user table
and
UPDATE users SET subscribed = 0 WHERE encryptedID = "md5 hash here"
HTH
Peter
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2004 03:37
> To: MySql
> Subject: Best
SELECT * FROM mytable ORDER BY alphabetical_field
hth
Peter
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 14 August 2004 08:57
> To: [EMAIL PROTECTED]
> Subject: MYSQL RECORDS AND ALPHABETICAL ORDER
>
>
> Dear Friends,
>
> I have mysql table which re
Hi
you try setting the column type to TIMESTAMP :)
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Peter
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 19 August 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Fairly lame question
>
>
> I think this c
Hi
the usual syntax is mysql -u root -p
if that does not work look into
skip grant tables option
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
HTH
Peter
> -Original Message-
> From: DBS [mailto:[EMAIL PROTECTED]
> Sent: 23 August 2004 03:50
> To: [EMAIL PROTECTED]
>
Hi
Just my two pence worth. Its not tested or scientific, and is based on gut
feeling and experience.
Connecting to mysql is resource intensive, particularly if you make a fresh
connection for each query. A query will almost certainly involve disk acces
which is slow. Sending the result of the qu
Hi
We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the
other. Both using port 3306
One instance listens on localhost, which maps to 127.0.0.1, and also on one
of the public IP addreses and the other listens to the other IP address.
I use the IP address in the connection s
try
INSERT INTO other_table
( field1, field2, etc)
SELECT SQL_CALC_FOUND_ROWS *
FROM wow.resume r
INNER JOIN wow.candidate c
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value)
AGAINST ('+BAAN' IN BOOLEAN MODE)
AND c.Candidate_ID = r.Candidate_ID
Peter
> -Original Message-
> From: Eve A
Hi
When you set up the mysql user use a GRANT statement that only gives SELECT
access. That is effectivly read only access for that user
Peter
-Original Message-
From: Mark Swanson [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 01:34
To: [EMAIL PROTECTED]
Subject: [q] can I start MySQ
Hi
Install MyODBC
Set it up for your mysql database
then from Paradox "copy table" to the mysql datasource.
You should get a correctly structured table. Depending on the fieldtypes you
may have to do a little manual tweaking.
You may also not be able to do memo fields.
MyODBC can be used as
Hi
We have a similar challenge. Offsite backups with huge amounts of data,
without spending a fortune.
We have a local Linux box and the remote server both running rsync.
http://samba.anu.edu.au/rsync/
Rsync is brilliant because it only updates file sectors that have changed.
We would only use
---
-Original Message-
From: Steve Vernon [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 14:19
To: Peter Lovatt; Mysql List
Subject: Re: Hardware Raid and 2 Gig Limit
Hiya!
Thanks for the help!!!
Do RSync like big files? Or does it prefer smaller
Have you checked permissions - the files should be owned by mysql
Peter
-Original Message-
From: DePhillips, Michael P [mailto:[EMAIL PROTECTED]
Sent: 12 November 2003 21:38
To: [EMAIL PROTECTED]
Subject: new install failure
HI list
When installing mysql 4.16 on debian linux 2.4.20-2
Hi
php
http://www.php.net
would be a good start.
Peter
-Original Message-
From: S Kusumo [mailto:[EMAIL PROTECTED]
Sent: 24 November 2003 12:09
To: [EMAIL PROTECTED]
Subject: programming language
Hello ..
I'm a CLIPPER programmer. I'm looking for programming language (like
Clipper)
Hi
To use phpMyAdmin you need a webserver and php installed - the code suggests
you either are not running through a webserver or that it is not configured
for php.
If you are not developing for php you might take a look at windows front
ends for mysql - search the list for recommendations
HTH
select
db1.table.field, db2.table.field
where
db1.table.someotherfield = db2.table.someotherfield
Peter
> -Original Message-
> From: Ed Reed [mailto:[EMAIL PROTECTED]
> Sent: 24 March 2004 23:45
> To: [EMAIL PROTECTED]
> Subject: Query across two databases on the same server
>
>
> Is
Big tables, a join and a LIKE on middleweight hardware - looks about right
to me.
Peter
> -Original Message-
> From: Kyle Renfro [mailto:[EMAIL PROTECTED]
> Sent: 27 March 2004 00:48
> To: [EMAIL PROTECTED]
> Subject: 6.5 seconds seems slow for the following search?
>
>
> I am testing MyS
Hi
Postgre might be a better bet, as it supports more of the features you are
looking for.
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-147
Hi
It means you are refering to/using a result id that does not exist. Maybe
the query changed or the database is down?
Try echoing the query and the error
echo mysql_error ( [resource link_identifier])
if not could you send more details to give us a little more to go on
Peter
---
hi
mysql_insert_id
http://www.php.net/manual/en/function.mysql-insert-id.php
should do it!
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1
You are missing a comma
update music
set cut = '' , mamended = '20021214013349' where mrecno = '1'
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
te
Hi
My first thought was that the docs on mysql.com should do the job, but,
although they answer most technical questions, often more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.
The other problem is that the documenta
unmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: 30 December 2002 01:35
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea
while Paul probably wouldnt say i
Hi
A faq without questions would be pretty empty!
While you have the questions why not keep a note (or send them to me) Once
we have some momentum we can put some answers and tutorials together.
I thought I would email MySql to see if they like the idea, if not then I
will build it.
Peter
---
Hi
Like the look of the way its taking shape.
I am not sure if there is existing faq software (I've checked sourceforge
and freshmeat without much luck) we could use, or if someone can do a better
job :) but I have a content management system written, together with a lot
of the search functionali
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---
-Original Message-
From: mnbv [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2003 00:23
To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users
Subjec
[mailto:[EMAIL PROTECTED]]
Sent: 02 January 2003 00:37
To: Peter Lovatt
Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users
Subject: Re: FAQ hosting site (was "Re: An Idea")
On Wed, Jan 01, 2003 at 11:08:58PM -0000, Peter Lovatt wrote:
>
> I am not sure if there is exist
$result=mysql_query("SELECT
items.*, city.City
FROM
items, city
WHERE
items.Category='$Category'
AND items.CityID='$CityName'
AND items.CityID=21
ORDER BY
City
");
while ($row=mysql_query($result)) {
hi
have you run mysql_install_db ?
this sets up the mysql database initially
Peter
-Original Message-
From: John Almberg [mailto:[EMAIL PROTECTED]
Sent: 01 March 2003 20:44
To: [EMAIL PROTECTED]
Subject: Can't start mysql
I'm trying to install MySQL 3.23 on a RedHat Linux Version 8.0
Hi
AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal?
not 100% sure but it looks like it
Peter
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: 24 March 2003 20:59
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib 3.23
HI
MySQL does not support sub selects/nested queries :(
Peter
-Original Message-
From: Eric Leupold [mailto:[EMAIL PROTECTED]
Sent: 29 March 2003 16:43
To: [EMAIL PROTECTED]
Subject: Nested SQL QUERY
I hope someone can help me with a syntax error I'm getting with a nested
query. I'm a
-Original Message-
From: Christian Calloway [mailto:[EMAIL PROTECTED]
Sent: 05 June 2003 18:32
To: [EMAIL PROTECTED]
Subject: RE: update statement, error free but no affected rows?
update students
set
counselor_id = 1 ,
school_attending='Univsity of Maryland'
where id = 1;
I think
Pet
Hi
One more suggestion that does work reasonably well.
Generate a basic HTML page with a table laid out to suit the labels, in php,
with addresses in place
Write the page to your webspace as labels.htm (you will need to set
permissions to allow this)
You then need a program that will open and pr
Hi
I am working on a search logging script to count the most popular word or
phrases searched for.
Table
I could add a line for each search, and aggregate the results for reports,
but I was wondering about the following which would keep table sizes down.
| search word | count |
=
---
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: 05 February 2002 17:58
> To: Peter Lovatt; [EMAIL PROTECTED]
> Subject: Re: Sql gurus
>
>
> Hi Peter,
>
> > I am working on a search logging script to count the most
> popu
Hi
Is there any reason to reboot MySql periodically?
My server has been up for just under 6 months without a reboot, and some of
the queries are noticeably slower. This may well be because the data has
grown, but I wondered if there is any memory leakage at all.
Anybody with more experience got
no!
about 150 messages today
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
>
Hi
Excuse the cross post
I am thinking about building a logging tool to do visit analysis using SQL,
rather than doing log file analysis.
The aim is to analyse requests for dynamic pages called via php as well as
static pages. Static pages will use an include for logging. Php calls may
have two
> -Original Message-
> From: BD [mailto:[EMAIL PROTECTED]]
> Sent: 18 February 2002 21:31
> To: [EMAIL PROTECTED]
> Subject: Security concerns on webserver with PHP & InnoDB
>
>
> I'm creating a web application with MySQL, PHP, InnoDB and I need to know
> whether I should split the one l
Hi
One of my servers was hit by a network DoS attack and was offline for an
hour on Thursday and I am looking at high availability solutions.
I can make sure the php site is always up by redundancy, but making sure the
database is ok is more difficult.
The situation I want to cater for is this
Hi
A few points
1. 1 (?)Spam, 40 people filling my in box with complaints about it. We get
very little Spam on this list, if you don't like it, bin it.
2. MySql users are diverse. We have php, perl, c++, Delphi, Access and VB
mentioned regularly. So why shouldn't we be interested in another
Hi
$query = 'SELECT *
FROM Table
WHERE
FirstName LIKE "%'.$firstname.'%"' ;
if($lastname)$query.= ', AND LastName LIKE "%'.$lastname.'%"';
if($region)$query.= ', AND Region LIKE "%'.$region.'%"';
if($loan_officer)$query.
Hi
php probably adds slashes to all the " and ' in the statement. Is it worth
trying backslashing all the variables individually?
$field1 = addslashes($field1);
$field2 = addslashes($field2);
etc
$query="INSERT ..
VALUES ('$field1','$field2',)';
If they come from form data php4+ adds
hi
hope this helps
Peter
';
$db = mysql_connect( "db", "**", "**");
mysql_select_db( "net3dual_reviews",$db);
$r = mysql_query("SELECT * FROM hwureviews ORDER BY num DESC LIMIT 7");
$max = mysql_query("select max(num) from hwureviews"
Hi
Installation packages for the Raq range can be found at
http://pkgmaster.com/packages/raq/
>From the main control panel go to 'Control Panel' and 'Install Software'
MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps
worth a try.
I installed it and it was almost 'hand
Hi
We are in the process of developing Ultra High Availability ecommerce sites
based on php and MySql.
1. The software itself is well tested
2. The site is duplicated on two or more servers in separate data centres,
with live replication.
3. Nameservers for the domain are on the s
Hi
Change your WHERE statement
to
WHERE stns.stns_id=1
AND table.ent_nws_id <> "3" '
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-2
Hi
I did some digging on this going back. From memory, the ODBC drivers vary a
little from version to version of Sage. I think they are also read only,
which may not be a problem if data is only being imported into mysql.
I contacted a local Sage reseller who was very helpful, and knew Sage over
this is for php, if you are not using php then try something similar
//use explode to create an array with one word in each item
$sql_array = explode(" ", $sql_text)
//loop thro the array
while(list($val) = each($sql_array))
{
$val = ucfirst ($val);
$new_sql_text .= $val ;
Hi
If you are developing for a Windows desktop, MyODBC with Access, Paradox or
Delphi all workm, from experience.
If you are developing for Linux desktop, then not sure, but perhaps others
have experience
Peter
---
Excellence in internet and open
Hi
If the databases are not too big, and are on the same machine, you could
just copy the directory with the databases in.
If you need to restore the database just copy it back.
I think this is OK, though you might want to stop mysql to "lock" the
database.
I have only done this a couple of ti
Jeremy at yahoo quoted one with 280 million rows, I think.
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
--
Hi
I have built and am testing a php module that is capable of this.
I have an ultra high availability project where it must survive a server or
network failure and switch seamlessly to the backup server.
All queries are executed through a db abstraction class. It basically does
the same as re
1 - 100 of 158 matches
Mail list logo
