MySQL Database Forum

What is the easiest way to import an XML Datafeed from a URL into a MYSQL Database? Possibly using PHP Regards Joe PS Please answer to group and joe@joesharman.co.uk

What is the easiest way to import an XML Datafeed from a URL into a MYSQL Database? Possibly using PHP Regards Joe PS Please answer to group and joe@joesharman.co.uk

------=_NextPart_000_005F_01C35137.8729F1B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way to restrict UPDATE without a WHERE clause? Mohammad Khan Software Engineer

Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even though we have a 4:1 ration of read/write the writes...

I'm basing some work on Joe Celko's excellent idea of using nested sets to represent an organizational structure as opposed to an adjacency list. By and large it's a great idea, but not without its pitfalls. I'm writing now to ask your collective opinion of the best practice. I've got my nested set table, and since the left bound is unique,...

Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be , not (mysqld2).

------=_NextPart_000_0266_01C35140.F8B40510 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I know this is not related to MySQL questions, but we are looking for a = savvy PHP/MySQL guru to fill a position at my organization. The job = description and requirements are below. Strong English...

I am running php 4.2.2 and mysql 3.23.54. This is my query: $sql = "SELECT MAX(esn) FROM address"; // line 37 $max_esn_result = mysql_query($sql) or print mysql_error(); // line 38 $max_esn = mysql_result($max_esn_result,$i,"esn"); // line 39 This is the error I get:

Jim, >> Does MySQL automatically handle deleted row cleanup, or is it necessary to >> periodically do this manually for tables with a lot of deletions? If it's >> manual, what are the SQL commands to do this? Depends on which storage engine you are using. If you are using InnoDB tables, there's no need to "vacuum" tables that way, as...

Greetings: Long time reader, first time poster. Here we go: ==Specific question: Does there exist in MySQL a privilege configuration which will allow an account to issue `SHOW MASTER STATUS` and `SHOW SLAVE STATUS`, but will disallow the running of any other commands (such as `KILL`)?

------=_NextPart_000_00C7_01C35146.AB4B3860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a MySQL master server; it has some tables from a database that = needed to be replicated once a day by some slave server, through a = dial-in connection. How do you think is the best way to do that?...

CREATE TABLE tbllayer ( LayerID int(11) NOT NULL default '0', LayerSize int(11) NOT NULL default '0', IceTypeID int(11) NOT NULL default '0', Fingerprint char(16) binary default NULL, PRIMARY KEY (LayerID), UNIQUE KEY Fingerprint (Fingerprint), KEY IceTypeID (IceTypeID) ) TYPE=MyISAM;

CREATE TABLE tbllayer ( LayerID int(11) NOT NULL default '0', LayerSize int(11) NOT NULL default '0', IceTypeID int(11) NOT NULL default '0', Fingerprint char(16) binary default NULL, PRIMARY KEY (LayerID), UNIQUE KEY Fingerprint (Fingerprint), KEY IceTypeID (IceTypeID) ) TYPE=MyISAM;

Will placing Apache::RequestRec & Apache::RequestIO & APR::Table in startup.pl to load them up for multiple handlers have any bad side effects? I noticed that when I load them via startup.pl the handlers that use them don't complain that they don't have the use statements within the module code and still work as normal. Jamie Krasnoo --

In the later part of June a new Linux Mysql server was installed. While mysqld was still running, the data folder was moved to a different volume and a soft link to the new location was put in it's place. I know, bad idea, but everything seemed to work fine, so I didn't think anything of it. Today, the server had to be rebooted for the...

--cmWTLedOjYLbGzFouNwjulwlHCR Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Situation: I just installed MySQL 4.0.14 on my Windows XP, the very = first time. The server daemon seems started running well. Now, I want to = create a new database. However, in the WinMySqlAdmin 1.4 tool, upon right...

--------------B23FB769A9677B05B30099D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am getting the following error: mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Dear folks: I was wondering how to query MySQL to display only a selection (1-20, 21-40) of a query in an HTML list. Can that be done in an SQL statement, or do you have to use PHP to dissect the returned array with for n elements to n+20 elements. How does Google achieve the returning of results in its search engine. I imagine that the...

Dear folks: I was wondering how to query MySQL to display only a selection (1-20, 21-40) of a query in an HTML list. Can that be done in an SQL statement, or do you have to use PHP to dissect the returned array with for n elements to n+20 elements. How does Google achieve the returning of results in its search engine. I imagine that the...

I have table one and table two I want to show all records from table one but also check if in table two is record that are in table one so if this is ture then bla=1 if false then bla=2 is it possible? query-"select tableone.user,tabletwo.user from tableone,tabletwo tableone.user=tabletwo.user" it will only show records if I have same...

I have table one and table two I want to show all records from table one but also check if in table two is record that are in table one so if this is ture then bla=1 if false then bla=2 is it possible? query-"select tableone.user,tabletwo.user from tableone,tabletwo tableone.user=tabletwo.user" it will only show records if I have same...

Hi I have been testing mysql's GIS support for quite some time now. I have one question. Suppose I execute this simple query: select * from node where MRBWithin(node.shape_geo, LINESTRING(0 0, 200 200)); This will select all node records that are bounded in in the ractangle (0,0), (0,200), (200,200) and (200,0).

Hi, I've a big problem!!! The replication start and work correctly but after 10 minutes slave don't update anymore. I must do "slave stop - slave start" for restarting replication. In the log there are not error.

------=_NextPart_000_000B_01C3510D.0BAE41A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Im writing a quick search in php. in this search user can enter = turkish,english and greek key words and i search them in mysql = table(MyIsam), in this table data are in unicode=20

Hi List Been trying to help out with this problem on a SunOS5.8 box running 3.23.56 It experiences periodic lockups of mysql. It does not seem that this server has a my.cnf file for mysql, and I'm not sure if that matters (what are the defaults mysql use when it cannot find the .cnf file?) Anyway, I have asked for any help in making a...