RE: MySQL Manager Connection Config Problem

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 ---

RE: FULLTEXT search questions

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 ---

RE: Utility for importing Paradox tables to MYSQL

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

RE: MySQL on a Cobalt RAQ4

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

RE: A beginners proplems.

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

RE: Moving a DB from one Server to another

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

RE: fulltext searching

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]

RE: Root pass

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

RE: Soliciting best approach for storing passwords . . .

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

RE: text formatting

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 br HTH Peter --- Excellence in internet and open source software

RE: text formatting

Hi Try eregreplace(tab, 4 spaces) Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

RE: How to change default mysql data-dir in Linux server ?

--- -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... Infact my.cnf wasn't there when I

RE: Hardware Planning

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

XML

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

RE: phpmyadmin .... ?????

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

RE: How can this Oracle Query converted to MySQL

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

RE: How to change default mysql data-dir in Linux server ?

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

RE: Referring Page in PHP/SQL

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

RE: Understanding relational database setup/construction

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

RE: Creation query problem!!

is read a reserved word? --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original

RE: Can I be an ASP with PHP?

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

RE: Help needed with JOIN on 3 tables

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)

RE: query

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

RE: password for databases

Hi look into GRANT on MySql Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

RE: job payment.

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

RE: Project Time

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

RE: Problem with DDL

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

RE: Distributed MySQL : How to synchronize ?

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: Maximum number of rows in the table

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

RE: Newbie Question

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

RE: Two database servers, same physical server

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

RE: Uppercase first letter of each word

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 ;

RE: MySQL on Cobalt Raq2

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

RE: -- e-shop

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

RE: Help w/Query

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.

RE: Sage Line 50 and importing into MySQL with ODBC

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

RE: SQL query question - using LIKE

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.= ',

RE: [ANN] Blue World ...

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

RE: Security concerns on webserver with PHP InnoDB

-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 large

Rebooting MySql

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

RE: Is The MySQL Mailing List On Crack?

no! about 150 messages today Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ---

Logging visits using a database

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

Sql gurus

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 |

RE: Sql gurus

--- -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 popular word or phrases searched for. Table

RE: MySQL on the Playstation2? (OT? You betcha)

Anyway they need an SQL database to hold MY high scores grin 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

RE: Trouble in unsubscribing

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 sql

quote marks

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

RE: locking specific rows

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

RE: stripping characters

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

RE: Securing username and password in script file

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

RE: OT: Securing username and password in script file

-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 think there is a secure way of running php on a shared server

RE: MySQL to MS' Access '97

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

RE: Can't access MySQL via PHP

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: [EMAIL

RE: Field Naming Standards

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

<    1   2