select * from table1 insert into table2
both tables need the same structure
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
--
Hi
Generally root is only allowed access from local host for security.
Either use a GRANT statement to give access from the host you are using or
create another user with the appropriate permissions.
Not sure about the IP missmatch.
HTH
Peter
---
E
an indexed column cannot have null values, so it must be defined as 'not
null'
To fix alter the table so the two fields are not null
ALTER TABLE `message1` CHANGE `Title` `Title` varchar(64) NOT NULL
etc
then run your alter table
hth
Peter
---
Exc
Hi
Not sure if this is simpler or not but..
install MyODBC, set up a Paradox alias for your MySql database
Using Paradox, copy the paradox tables to the MySql database. This converts
all the field types and copies the data over. I am not sure if it will do
memo fields it may depend
Hi
Dont use the rpm, go for the package at
http://pkgmaster.com/packages/raq/4/
and install it from there, just point and click!
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.su
try logging in as follows
[william@localhost william] mysql - u root -p
it will then prompt you for your root password
you should have access as root after that
HTH
Peter
---
Excellence in internet and open source software
hi
Stop MySql on both servers to avoid changes to database during the move
Copy the whole directory to the new server
restart both Mysql servers
Grant permissions on new server
Done :)
HTH
Peter
---
Excellence in internet and open source software
Hi
If anybody from mysql is listening / watching, www.mysql.com is down, and
has been for a while.
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
te
Hi
Try
eregreplace(tab, 4 spaces)
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
I haven't seen the rest of the thread, but form data looses all formatting.
Line breaks will remain but HTML ignores them
look at nl2br() to convert them to
HTH
Peter
---
Excellence in internet and open source software
Hi
Just to throw another thought in
If you do change the password and send it to them, you have to allow for the
fact that their email could have changed - left work, service provider went
bust etc etc, or somebody could just enter their email for a joke 8*} and
get their password reset. I h
Hi
Not sure here, but you have logged in as 'admin' on the system. Unless you
su to root mysql will use the same user.
try either
[admin admin]$ su -l
to log in to the system as root and then 'mysql -p' to log into mysql
or stay as admin but log into mysql as root, under mysql
[admin admin]$
Hi
I am looking at a project using XML to import and export data into MySql
directly or using php. The datasets are quite large (40-50 million records)
I haven't used XML before.
Does it take long to work out how to use php/XML? Are there any problems
working with large datasets?
Thanks
Peter
Hi
A few thoughts. I am not an expert on this kind of use, so there may be
others with better suggestions :)
If every search is different then your search efficiency is critical. If you
fulltext index the field then it should help.
If not then what about indexing the text document words. You s
---
> -Original Message-
> From: va ku [mailto:[EMAIL PROTECTED]]
> Sent: 27 June 2002 14:19
> To: [EMAIL PROTECTED]; Peter Lovatt
> Subject: RE: How to change default mysql data-dir in Linux server ?
>
>
> Peter,
>
> Thanks for the reply.
Search for 'my.cnf' on mysql.com
This is the config file that you can use to set the data dr
You may need to create it if it doesn't already exist.
HTH
Peter
---
Excellence in internet and open source software
---
Not directly, MySql does not support sub selects yet.
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
--
Hi
If you open the directory where it is installed with a web browser what
happens?
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Hi
Not sure about sites but try searching for 'database normalisation tutorial'
I found
http://www.codelearn.com/rdb/rdbd_nt1_s.html
which looks to be a reasonable start.
Peter
---
Excellence in internet and open source software
---
if(ok)
{
include('zap.htm')
}
else
{
include('zip.htm')
}
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
No problem
I have a mysql server sited 150 miles from the php server (more by accident
than design, but it works day in day out)
Just set the connection parameter with the IP of the Mysql server and it
works. php doesn't know or care whether mysql is on the same machine or one
the other side of
is read a reserved word?
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original M
Hi
SELECT b.* //all fields from builder
FROM
builder b //define tables and aliases
, builder_category_link l
, category c
WHERE
(b.builderID = l.builderID) //linking builder to link table
AND (l.categoryID = c.categoryID)
insert into table (auto_inc_field) values (1000);
mysql will carry on from there
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
Hi
look into GRANT on MySql
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
>
Hi
How long is a piece of string..?
Hourly rate for independent work in the UK is £20-35 ish, roughly US$35-60.
I think US programmers are forbidden to discuss rates, as it is considered
price fixing!
You could access Access through ODBC, using php. This will not support a
busy site but
WHEN is a reserved word, so you need to choose another name for that field
hth
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
-
Hi
Seems to be offline, can't get it from here too - its giving 500 server
error
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
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
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
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
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
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
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
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
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
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
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
$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
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
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
> -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
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
no!
about 150 messages today
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
>
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
---
> -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
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 |
=
Anyway they need an SQL database to hold MY high scores
Peter
> -Original Message-
> From: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2002 10:03
> To: mySQL Mailing List
> Subject: Re: MySQL on the Playstation2? (OT? You betcha)
>
>
> From: "Colin Faber" <[EMAIL PRO
could you be subscribed under two (or more) email addresses?
Peter
> -Original Message-
> From: Yuxia Li [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2002 06:15
> To: [EMAIL PROTECTED]
> Subject: Re: Trouble in unsubscribing
>
>
>
> Hi:
>
> Does anyone know how to unsubcrib from
Hi
I am retrieving data from a mysql table and displaying the contents in a
text box for editing.
Some of the data contains double quotes eg '15" screen'. Using php4 the data
is backslashed and stores without any problem, but when it is displayed in
the text box it stops at the ", because that c
Hi
What about a table with logged in user ids and a timestamp (I use a sessions
table).
Update the timestamp when they access the system. Check when a user tries to
login. If that user id, but a different person, has accessed the system
within the last xx minutes or seconds then consider them lo
Hi
I have items in a table identified by a Part Number. The Part Number may be
selected by inputting into a php search box (perhaps from users memory).
Example
Original
71HF-9601-AB
Searched for
71HF 9601 AB
or
71HF9601AB
or
Original
36 44 A9
Searched for
36-44-A9
or
3644A9
or with other se
anx for that)
Peter
> -Original Message-
> From: Carl Troein [mailto:[EMAIL PROTECTED]]
> Sent: 11 November 2001 14:25
> To: [EMAIL PROTECTED]
> Subject: Re: OT: Securing username and password in script file
>
>
>
> Peter Lovatt writes:
>
> > I don't
I don't think there is a secure way of running php on a shared server.
I have a dedicated server which uses this 'property' to have a single shared
php codebase for about 20 domains and subdomains.
I looked at ways of securing it but, fundamentally, php under apache runs
the same user for everyo
Hi
should be
mysql_connect("fred.com", "fredsusername", "fredspassword")
or
mysql_connect($host, $username, $password)
Only needs quotes if you are using actual values
HTH
Peter
> -Original Message-
> From: Imran Aziz [mailto:[EMAIL PROTECTED]]
> Sent: 03 November 2000 19:49
> To:
Use MYODBC (see http://mysql.com ) to connect to the mysql database
Within Access database use 'link to external data' for mysql and use an
INSERT query to get the data into the Access table
HTH
Peter
> -Original Message-
> From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
> Sent: 03
I share most of these conventions, and I think the key is consistency.
Consistency makes the database usable, without guessing or having to refer
back to notes or other uses of the table or field.
My golden rules are
1. Key names are unique within the database this avoids any confusion when
101 - 158 of 158 matches
Mail list logo