denied for user
'andy'@'frontend.internal'
(using password: YES)". Does it have something to do with the fact that
'andy' in the mysql user tables is only authorized to connect from
'localhost'? How do I fix this problem.
Thank you very much.
Andy
On Mo
the chapter titled "ABC" from e-book number XYZ
(or e-book titled "XYZ")). Can MySQL handle these types of queries well on
data of this size?
(4) What are the benefits/drawbacks of using MySQL compared to using XML
databases?
I look forward to help on this topic. Many thanks in advance.
Andy
mmunity, I will need to be able to provide fulltext (or chapter-wise)
search also to the users, among other things.
Please let me know if you have additional comments.
Andy
On Thu, Jun 10, 2010 at 9:05 PM, Peter Chacko wrote:
> Usually, you better use a NAS for such purpose. Database is des
not find any information
on doing this. Does MySQL not support parallel reads/writes?
Thanks in advance.
Andy
Shawn/Krishna,
Thank you. I will try this.
-Andy
On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Andy,
>
> I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30%
> faster than normal inserts.
>
> Kris
Hi all
Did anybody reply to this thread? If so I am interested in obtaining those
replies.
With kind regards
Andy
On Sat February 5 2005 09:43, Auyon Bhattacharya wrote:
> I am new to this. I have been trying to implement a hierarchial data
> structure in Mysql 5.0, on Windows NT wi
lling any package is as simple as typing
(example for mysql)
apt-get install mysql
it will download the packages and perform the installation (note: root
privileges required)
Andy
--
---
Registered Linux user number 379093
---
--
MySQL General Mailing List
For list archives: http://lists.
Dear [EMAIL PROTECTED]
Please configure your email client to stop sending auto reply messages in
reply to posts to the mysql mailing list.
Filters are your friends to achieve this.
Thank you in advance
With kind regards
Andy
--
---
Registered Linux user number 379093
---
--
MySQL
Hi all
I just wanted to know what would be the easiest way to retrieve simple data
from a MySQL database from a bash script.
With kind regards
Andy
--
---
Registered Linux user number 379093
---
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Thank you all for your replies.
I think that ShellSQL is really the thing I am looking for.
With kind regards
Andy
On Sun January 30 2005 23:50, Andy wrote:
> Hi all
>
> I just wanted to know what would be the easiest way to retrieve simple data
> from a MySQL database from a
un-solaris2.8 (sparc)
Thanks for any help!
-Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
When trying to execute a simple "Select" statement from the mysql command
prompt I'm getting the following Message:
ERROR 1016: Can't open file: 'wishes.MYD'. (errno: 144)
As far as I can see the database exists . Any ideas ?
Andy C
R2
hings I want faster?
I appreciate every help on that. Thanx in advance,
Andy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
) | YES | | NULL|
| tinyint(3) unsigned | | | 0 |
Maybe someone knows what I do wrong.
Thank you for any help on that mysql table.
Andy
-
Before posting, please check:
http://www.mysql.com
| country_code | 2 | u.country
|1 | |
| ct| eq_ref | PRIMARY | PRIMARY | 3 | u.city
|1 | |
does that help?
Andy
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]
m? I fear that the
performance would suffer. is there a better way to do this in one stmt?
Thanx for any help,
Andy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
smalltext columns as the info may vary between 1 and 1000 chars. A query for
LIKE 'test%' takes about 20 s right now.
Thanx for any help on that,
Andy
-
Before posting, please check:
http://www.mysql.com/manual.
anybody know what happened here? I hope I do not need to role out my
backup tapes :-(
Thanx for any help,
Andy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
|
6 | NULL | 32733 | Using index |
| c | eq_ref | PRIMARY,idx_cp | PRIMARY |
3 | t.city_id | 1 | where used |
Has anybody a good trick to solve boost it to a 0. time?
Thanx, Andy
-
Befo
data
and include the country code in the other table as well?
Andy
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "andy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 1:00 PM
Subject: Re: Join takes way too
repair the file system (suse72) and
tables. There was also a 130 MB tmp file I deleted.
So what did I do wrong, or does it just take that long? The table contains
about 40 MB of space.
Andy
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
* roger:
Try selecting FROM the cities table and JOIN with the recommendations
table.
* andy
SELECT count(DISTINCT user_recommending)
FROM geo.cities c
INNER JOIN recommendations AS t ON t.city_id = c.ID AND c.country_code
= 'gm'
same result. So do u think I would be
pe is tynyint(1) and contains 50 % "1" and 50% "2" values
explains says: using temporary on 38000 rows
So is there a way to do this faster. Choosing a different column type ore
similar stuff?
Thanx for any help,
andy
---
:
> SELECT w.website, c.comment
> FROM user_websites AS w
> LEFT JOIN user_comments AS c ON c.user_id = w.user_id
> WHERE w.user_id = '10'
But thats not what I want. I do want just to know if the user has a website,
or a signature and then pull them out if t
Hi there,
I am wondering if there is a software (free or shareware) which is
visualizing the shema (table strukture) of the mysql database.
thanx for any hint,
Andy
query
-
Before posting, please check:
http
running but how could
I tell php to connect to the right server?
Thanx for any help on that,
Andy
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
other db on the
other machine.
Is this possible?
Thank you for any help,
andy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
s possible to compile mysql with only a latin char
set.
Would this be helpful for me?
Thank you for any help on that,
Andy
query
http://www.globosapiens.net
Global Travelle
stamp june 1, 02
SELECT COUNT(*) AS c
FROM users_table
WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400'
Thanx for any help on that,
andy
query
-
Before posting, please check:
http://www.mysql.com/m
I have to change this db entries, and if how? How should they look like
and is there a good method to change all this thousands of records at once?
Thanx in advance,
Andy
query
-
Before posting, please check:
http://www.my
put:
INSERT INTO beaches VALUES ('','Carrabelle Beach','US','9');
does anybody know how to do this?
Thanx for any help, Andy
query
-
Before posting, please check:
http://www.mysql.com/
ck);
CREATE INDEX by_title ON tracks(title);
>Fix:
Postgre^H^H^H^H^H^H^HNone.
>Submitter-Id:
>Originator:Andy Dustman
>Organization:
>
>MySQL support: none
>Synopsis: FOREIGN KEYS don't work
>Severity: serious
>Priority: medium
>Categor
###
Maybe some of you guy has a good idea on that.
Thanx for any help,
Andy
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
show up on the
site. Is there a way to improve the performance, and why is this happening?
I thought the performance might even boost after storing them to blobs.
Thank you for any comments on that,
Andy
PS: I was planing to store all the other images (20 - 50 KB) to blobs as
well (thousands
advance,
Andy
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscr
see the error:
SELECT
ID,
rating_total / ratings_amount AS top10
FROM rating
ORDER BY top10 desc
LIMIT 10
Thanx for any help,
Andy
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
sort the other arrays with the same sorting algo? Or
a way to include a iff clause in the query?
currently I am doing:
SELECT
u_name,
id,
points
FROM user
WHERE
points > 0
ORDER by points desc
LIMIT 5
and the top10 reports extra.
Has anybody a good idea on that?
A
characters?
2. Is it possible with php to underline the keyword inside the search
results. This might be more tricky.
Thank you for any help on that,
Andy
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the
you could install MyODBC to write the tables directly from MS A. to MySQL
via ODBC.
Works ok and did a good job for me.
Andy
- Original Message -
From: "Mertens Bram" <[EMAIL PROTECTED]>
To: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Saturday,
ot;Down to Earth"
Note articleid 3076 is timestamped 02 in the afternoon. Article 3075 is
12:15 noon. Clearly article 3076 should come after 3075.
Can I set the select query to deal with the order by 24 hour clock or am I
missing something big time here !
Andy C
connection anyway? Is is persistant when the user is browsing all
the sites in my sytem? And when do I have to build the connection?
Thanx for any help on that,
Andy
query
-
Before posting, please check:
http://www.mysql.com
I was told that i need to create mysql-logon.sock so that mysql will start
running
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
My application is written in .asp and the database is mysql. do i need
myodbc to set the DSN/connection? (running in linux box)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
like many, many others pragmatically use MS
outlook), and invariably the only reason I even find this out is when the
person thanks me directly rather than through the list.
Come on, let's move into the nineties and sort this out.
Andy
> -Original Message-
> From: Jay Blanchar
eel better if someone
could actually tell me a reason why it is better this way?
Thanks,
Andy
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: 18 April 2006 13:44
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: RE: Reply / Return Addres
What would be the best approach to remote monitoring of numerous mySQL
databases remotely i.e. number of threads. number of open tables etc etc
Can I do it with DBD::Perl
Thanks
Andy
--
perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql
To unsubscrib
ther I will get
improved performance form these compared to mySQL.
Anyone have experience of large datasets within mySQL.
Thanks
Regards
Andy
This e-mail is private and may be confidential and is for the intended
recipient only. If misdirected, please notify us by telephone and confirm th
Thanks for the info Dan.
I'll check the resources you mentioned.
Regards
Andy
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Tue 8/22/2006 1:38 PM
To: Andy Ford
Cc: mysql@lists.mysql.com
Subject: Re: limitations of mySQL i.e. number of rows
ur multicolumn index wouldn't be used, as "id" is
the first column in the index, but "id" isn't in the where clause of your
query.
Sometimes you need to make lots of multicolumn indexes on a table to
optimise all of your queries. Sometimes this makes the indexes
installation in order to re-install and get my
blank user back ?
If I have to remove it what/where/how do I do that ?
Are there any decent documented sites that can help me to administer MySQL
under OSX ? So far I have found diddly squat of any real use...
Many thanks
Andy Hilton
l, or kill the process then reinstall ?
Thanks again
Andy
On 7/21/05 2:39 PM, "Brent Baisley" <[EMAIL PROTECTED]> wrote:
> MySQL is actually started using a little program called mysqld_safe,
> which monitor MySQL and restarts it if it "crashes". You first need
&
something I must not be deleting before reinstalling, or
maybe it is a simple matter to amend a user list somewhere ??
Baffled - trying to work out why it let me delete the blank user in the
first place if it is so importantbut that's another issue - for now I
just want to get it back
stalled it made no difference so I am assuming the 'users'
are stored elsewhere - I just have no clue where
Thanks for the continued assistance - I do appreciate it for sure
Andy
On 7/22/05 10:16 AM, "Brent Baisley" <[EMAIL PROTECTED]> wrote:
> Sounds like it coul
ther part of the original installation and it is now upset with
permissions on the re-install - cannot see where InnoDB lives but suspect
this to be a part of the issue now - obviously until I can get MySQL to
start then I am nowhere but I do feel I am only a single step away from
getting it going again
t' doesn't exist
050722 14:23:33 mysqld ended
Andy
On 7/22/05 2:09 PM, "Michael Stassen" <[EMAIL PROTECTED]> wrote:
>
> Don't assume. Mysql keeps its data, including ibdata1, in the data directory.
> In your case, that's the default location, /usr
Gentlemen
Thank you VERY much ! Am now back to working again
Then when Amazon delivery my MySQL books I should be a lot wiser too !
Very much appreciated all the assistance
Andy
On 7/22/05 3:12 PM, "Santino" <[EMAIL PROTECTED]> wrote:
> OK
>
> Now open the ter
guess I'm searching for some type of
functionality similar to SOUNDEX(), except for grouping not selecting.
Thanks,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql installer, it
does not behave properly. It keeps trying to connect to localhost.
I wouldn't care less, if not for the mysql icon, which seems to be embedded in
the shortcut and cannot be applied elsewhere.
With kind regards
Andy
--
Registered Linux User Number 379093
Now listeni
execute the mysql
binary from the command line, everything works like it should.
mysql being open source software, how about releasing the source for the mysql
icon? so that I can use my own shortcuts.
With kind regards
Andy
--
Registered Linux User Number 379093
Now listening to [silence
In my data structure I have many BLOBs which are not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
On 8/2/05 12:14 PM, "Octavian Rasnita" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I think that I have seen many times the advice not to store the
n tomcat write into this?
Andy
_
From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED]
Sent: 20 September 2005 12:00
To: 'Andy Eastham'
Subject: RE: Startup Error
[EMAIL PROTECTED] mysql]# ls -l /usr/local/mysql
lrwxrwxrwx1 root root 40 Sep 19
Nitzan,
In the unlikely event that you can recompile but not upgrade, you could add
your common words to the full text stopword list in myisam/ft_static.c and
rebuild mysql.
Otherwise, this might be helpful
http://lists.mysql.com/mysql/132649
Andy
> -Original Message-
> From:
jedem Feld in haben WHERE Klausel,
plus das Datumfeld. Ich vermute, daß dieses nicht der Fall ist, da die
Datenausgabe für eine mysqldatenbank ziemlich klein ist. Blick auf den
EXPLAIN SELECT, zu sehen, was Indizes für eine Frage verwendet werden.
Andy
> -Original Message-
> From
Hi list
I have a data set that is composed of many fields (30+). The final app will
allow the users to search records on each field.
What is the best thing to index in this situation? Make an index for *all*
fields?
With kind regards
Andy
--
Now listening to Phase - Morning Light on
Hi all
Is there any operator for mysql that behaves like "LIKE" but can act on
numbers.
Let's say I wanted to select all rows where column x has a value of ~ y
How should I do this?
With kind regards
Andy
--
Now listening to Trancelation - Intensensation on amaroK
Geek co
District and Sector.
Eg:
W1 2AA
MK6 3AB
SN25 1DD
This structure means you can easily give a central location for a partial
postcode, ie right truncated to the sector, district or just the city.
Hope this helps,
Andy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PR
James is right. I use this method on a table with a combined index on 50
million rows and it's almost instantaneous. Performance was vastly improved
after I did an
"alter table order by x"
Andy
> -Original Message-
> From: James Harvard [mailto:[EMAIL PROTECTE
group by vendor_id;
Andy
> -Original Message-
> From: Richard Reina [mailto:[EMAIL PROTECTED]
> Sent: 23 February 2006 16:48
> To: mysql@lists.mysql.com
> Subject: query help?
>
> I am a novice when it come to queries such as this and was hoping someone
> could he
brackets are the
issue here.
A colleague of mine has a similar issue with the ASP.NET designer - when
creating SQL statements in ASP.NET's front-end tools (e.g. data-grids)
it automatically encloses the table names in [...] instead of `...`
Whether the MySQL .NET Connector people have alre
ct, and it logs each SQL statement received from clients ..."
Regards,
Andy
Darvin Denmian wrote:
I wonder if there is the possibility of registering the users' access
to the server Mysql.
Something similar to the command "last" of Unix-like systems.
Thanks.
--
MySQL
possibly even the
newly-released 5.1.30, depending on how many applications you have that
are dependent on that box.
Regards,
Andy
Nishikant Kapoor wrote:
CREATE TABLE t ( id TINYINT, title VARCHAR(10) );
INSERT INTO t (id, title) VALUES (1, 'aaa'), (2, 'bbb'), (3, 'ccc
T 5;
Regards,
Andy
Morten wrote:
Hi, I'm retrieving the name of some records where either one of two
criteria are satisfied:
SELECT name
FROM foo
WHERE bar = 34
OR baz > 100
ORDER BY baz DESC
LIMIT 5;
I would like to sort that result set, such that the records matching
bar = 34 o
Hi Bryan,
My gut reaction would be to use a temporary table - create the temporary
table at the start of proc1, run multiple inserts into the temp table
for the results of proc2, then just before proc1 ends, select from the
temp table and drop it.
Andy
Cantwell, Bryan wrote:
I have a
system you
could even consider going to 5.1.30.
Andy
Nishikant Kapoor wrote:
Its been a while since I posted this. Would like to check again with the
folks on this list if they know why the results of query (b) are all
blank on MySQL 5.0.22. It works fine with 5.0.51a. If it is a bug in
5.0.22, c
use near 'end //
delimiter' at line 1
Query = end
//
delimiter
I'm guessing it's the first semi-colon in your IF statement. Does this
work...?
if @counted >= 1 then SET dummy = 'Cannot delete this record' end if;
Just a guess!
Andy.
--
MySQL General Mailing List
F
tual table in MSSQL.
Going back to the OP's problem - the original issue I believe was he was
using "old" instead of "OLD" (case-sensitive) - now that's sorted, MySQL
is complaining about a syntax error toward the end of the function
declaration.
Andy
--
My
Hello Hagen,
Hagen Finley wrote:
Should I be using a different datatype for these kind of numerical
values?
Yes. INT is by definition a whole number (0, 1, 2 etc.)
You will want to change the fmarg column to DOUBLE or DECIMAL.
Regards,
Andy
--
MySQL General Mailing List
For list
it[1]] = $value;
// Now you should be able to access the person's first name using
$result['person']['first_name']
}
}
This code may not be perfect as I've just typed it out from memory so it
may take a bit of tweaking.
Thanks,
Andy
Jason Pruim wrote:
O
Jerry Schwartz wrote:
-Original Message-
From: Andy Shellam [mailto:andy-li...@networkmail.eu]
Sent: Wednesday, December 17, 2008 3:29 PM
To: Lamp Lists
Cc: mysql@lists.mysql.com
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
Hi,
Hi Andy,
the reason I can't use this because fields (columns) in select
statement (p.first_name, p.last_name,...) are actually dynamically
created. In my project different client will select different fields
to be shown. 99% will select first_name, and last_name, but some don&#x
un mysql_upgrade to correct it, but
this requires an up-and-running system in the first place.)
Your second issue is that InnoDB does not have permissions to create
files in this directory. Check the owner/group MySQL is trying to run
as has access to /var/db/mysql.
Regards,
Andy
PJ wrote:
Or
log
and require highest performance, you should log to files and not to tables."
Hopefully this performance difference will be resolved in future
releases of 5.1.
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SELECT movies.*, average(ratings.rating) AS rating FROM movies
LEFT JOIN ratings ON movies.movie_id=ratings.movie_id
GROUP BY movies.movie_id
) result
Andy
Brent Baisley wrote:
The ratings field would be NULL. You could also add a count in your
query to tell how many ratings there were. If co
arger than a given threshold (e.g. 600 seconds.) We had an
issue last week where the slave's SQL thread died following a server
failure - Nagios caught it and let us know immediately.
www.nagios.org.
Regards,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
g you to set a threshold on how long is a warning, and how long
is a failure (error.)
I would hazard a guess that it uses the output of "show slave status;"
to gather its information.
Andy
xufeng wrote:
> Hi All
> On
> http://www.nagiosexchange.org/cgi-bin/search.cgi?d=1&
221.130.195.83." is not a valid IP address anyway, but MX records
must also be the hostname of an existing A record, not an IP address.
Regards,
Andy
Andy Shellam wrote:
> Hi Xu,
>
> The check_mysql plugin is part of the standard plugins package (see the
> downloads page a
and many Unixs and open source bits and pieces and Im usually quite
good at making them do what I need ;)
cheers Andy.
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list arch
erver B.
This could also help in replication situations - connect an application
to the MySQL Proxy which talks to all master and slave servers. If the
query is an UPDATE, INSERT or DELETE, direct it at the master only.
Andy
--
MySQL General Mailing List
For list archives: http://lists.mys
lly
MySQL.) Make sure this is done, then MySQL will start, then you can run
mysql_upgrade.
HTH,
Andy
JD wrote:
Hello List,
mysqld fails to start, and emits the following
error messages in /var/log/mysqld.log
090127 10:00:30 mysqld_safe Starting mysqld daemon with databases from
/var/lib/m
FROM Manufacturer... query, MySQL would delete the
associated records from all 3 tables automatically.
The only time you'd have to manually issue all 3 DELETE statements were
if your foreign keys didn't have the ON DELETE CASCADE option set.
Andy
Philip Pemberton wrote:
Hi,
First of all,
nless specified as
otherwise. Maybe the MySQL community has a differenet opinion :P
;)
cheers Andy.
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list archives: http://
l "network interface" hence I think this is badly
worded in the text.
thanks Andy.
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
pha.
Did anyone else receive an announcement for the release of 5.1.31? Was
it actually made?
Thanks,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
It could be that your my.cnf isn't being read (permissions or in the
wrong directory), or that you have multiple my.cnf files.
Quoting "csego...@gmail.com" :
That is intentional. I want to write the log to a non-standard location.
--
l.com/docs/refman-5.1-en.pdf
Tutorial (English): http://dev.mysql.com/doc/refman/5.1/en/tutorial.html
Substitute 5.1 with whatever version you're running.
HTH,
Andy
muzaffar hussain wrote:
hi all
where can i can download full mysql tutorial .
thanks
regards
muzaffar
What RAID level to use, whether to use SCSI or SATA etc are all pretty
much "how long is a piece of string?" questions. If you have a really
high end hardware array RAID 5 may be faster than RAID1+0 is on a
cheaper system.
Basically
RAID 5 = slower
SATA = slower
RAID 1+0 = faster
SCSI = fa
use, although I agree an example of a simple client/query
would have been useful.
Regards,
Andy
PJ wrote:
What is this supposed to mean from the manual:
The use of |mysql_num_rows()|
<http://dev.mysql.com/doc/refman/5.0/en/mysql-num-rows.html> depends on
whether you use |mysql_store_resul
t ball game and you're right - mysql_store_result
would do nothing for you (PHP wouldn't even recognise it as a function.)
If you are using PHP, you'd be better off looking at the PHP manual
instead - http://uk3.php.net/mysql.
Hope this helps,
Andy
PJ wrote:
Hi Andy,
I stil
py of
5.1 and run it alongside 4.0 (ie on different port numbers) then you can
migrate your databases/systems across one-by-one.
Andy
Matthew Stuart wrote:
Hi all, I am on... wait for it... version 4.0.25 and I want to upgrade
to MySQL 5.x
Is there anything special I should do in order to up
that might be. Post some
more info and someone on the list can probably help,
thanks Andy.
Quoting Bryan Irvine :
The information is there and the replica can connect on a reboot but
only if that information has not changed correct?
e.g. I reboot the slave, and on the master just run "re
1 - 100 of 617 matches
Mail list logo
