| |
thread by: 21novembre |
last post Jul 23 '05 by: 21novembre
Hi all,
I made a question several days before to describe my strange trouble of
mysqldump. But I still can't figour it out. Well, I just want to ask
another question whether I could just backup my databases by copying
the data folder to some place? Then if I meet some disaster, could I
just copy the backup folder back to recover my...
|
thread by: chuy |
last post Jul 23 '05 by: chuy
I currently am using FreeBSD 5.3 with Mysql 4.1 for some testing and learing
of both Unix and the Mysql Database. I am having a problem with creating a
new user in Mysql. When I created a new user in mysql the command is
accepted and I can see the user is there through PHPMyAdmin. If I execute
the command mysql -u chuy -p I am prompted for...
|
thread by: Peter King |
last post Jul 23 '05 by: Peter King
I am in the process at looking into load balancing 2 web servers.
I will need both servers to have MySQL server installed and then a load
balancer to split the traffic to both servers.
The servers will be running apache with PHP web sites.
Has any one set this up and do you have any notes for me, i.e. what version
of MySQL do I need,...
|
thread by: Geoff Jones |
last post Jul 23 '05 by: Geoff Jones
Hi
Can anybody show me if there is an alternative syntax to the following psudo
code in SQL:
SELECT tblA.first, tblA.second FROM tblA WHERE (((tblA.third)= 23) OR
(tblA.third)=42) OR (tblA.third)=56)));
i.e. is there a way of writing something like:
|
thread by: steve |
last post Jul 23 '05 by: steve
I am thinking about implementing replication. Basic question is what
kind of delay there would be to have the data replicated. Not a
massive table, and all on the same net.
Furthere, can you specify priority for replication?
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for...
|
thread by: Bill Michaelson |
last post Jul 23 '05 by: Bill Michaelson
I'm running 5.0.4-beta with replication, and it works OK. Except...
When I use "create function" in the master, it does not get propagated
to the slave. Is this reasonable behavior? I don't think so. I'm
supposing it is a bug.
Any comments?
|
thread by: Marek Kotowski |
last post Jul 23 '05 by: Bill Michaelson
Hi,
What is the real difference between LEFT JOIN and RIGHT JOIN?
Are there situations where a query with RIGHT JOIN cannot
be rewritten with LEFT JOIN and tables reversed? (and vice versa).
In MySQL documentation there is stated explicitly:
"RIGHT JOIN is implemented analogously to LEFT JOIN, with the roles of
the tables reversed."
|
| |
thread by: Jonathan |
last post Jul 23 '05 by: Jonathan
Some one suggested me to alter my tables to InnoDB instead of myISAM
type to improve speed for select queries. Is this really true. I read
some article that stated that myISAM was optimized for select queries
over update/insert because of most of the queries for web based
applications are select queries.
Can anyone tell me what the...
|
thread by: John |
last post Jul 23 '05 by: John
Hi
I'm using mysql 3.23.54 over Red Hat Linux 9. I'm having problems with
the error logs.
I've run mysqld start --l, mysqld start --log, mysqld start
--log-error, and mysqld start --log=MyErrors.log and not once managed
to find a log file.
I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1;
|
thread by: Bruce D |
last post Jul 23 '05 by: cainlevy
I'm trying to figure out a way to get this to work:
INSERT INTO Donations( finderid, cardused )
(SELECT finderid, 1
FROM Donations
WHERE assignmentid = 1)
Basically, there are a lot of records in Donations. The Donations table has
a unique, auto-increment id field (not displayed). Here's what I have...
ID, FinderID, CardUsed,...
|
thread by: Phillip Parr |
last post Jul 23 '05 by: Phillip Parr
hah well I'm here again, guess I need more practice to do this all properly!
I have a table, such as this:
friends
+--------+----------+
| userid | friendid |
+--------+----------+
| 2 | 7 |
|
thread by: Diane Blevins |
last post Jul 23 '05 by: Diane Blevins
sFt
----HUISORc8AeipkQw2ckY
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style type=3D"text/css">.eyebrow { FONT-WEIGHT: bold; FONT-SIZE: 10px; TE=
|
thread by: Diane Blevins |
last post Jul 23 '05 by: Diane Blevins
sFt
----HUISORc8AeipkQw2ckY
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style type=3D"text/css">.eyebrow { FONT-WEIGHT: bold; FONT-SIZE: 10px; TE=
|
thread by: cainlevy |
last post Jul 23 '05 by: cainlevy
I'm wondering if there's any way to speed up create table queries?
Besides upgrading hardware, that is. The very simplest table creation
query, "create table table1 ( field1 INT(10))" is taking about .03
seconds, which compared to other queries (large inserts at .01 seconds)
and previous experience appears inordinately long. Further, it...
|
thread by: Craig Stadler |
last post Jul 23 '05 by: Benoit St-Jean
mysql 4.0.22 (win32)
Can anyone recommend best practices for the fastest way to remove large
numbers of rows at once?
I am diving my deletes into chunks (1000 rows at a time) but this still is
very slow.
-Craig
|
| |
thread by: Frank Natoli |
last post Jul 23 '05 by: Bill Karwin
Does START TRANSACTION and COMMIT apply only to the Connection for which the
START TRANSACTION statement was performed? So if a second Connection is
created, and used to access different tables in the same database, are the
tables affected by the second connection visible to other processes as the
changes are made, not masked by the START...
|
thread by: Frank Natoli |
last post Jul 23 '05 by: Bill Karwin
After START TRANSACTION but before COMMIT, are intervening SQL transactions
visible to other threads or processes? I understand that failing to perform
a COMMIT, or explicitly performing a ROLLBACK, results in the transactions
occurring after START TRANSACTION being undone. But until and if the
transactions are undone, would queries to the...
|
thread by: Phillip Parr |
last post Jul 23 '05 by: Phillip Parr
Hey all, I'm probably just having a lax moment but I can't quite figure this
out. Say I have a table such as this:
friends
user friend
1 2
1 3
2 4
2 1
|
thread by: pingo |
last post Jul 23 '05 by: Bill Karwin
Hello,
I am trying to join together the following table in an attempt to find
the shortest route between all the coordinates.
+-----+-----+-------+
| frm | nxt | total |
+-----+-----+-------+
| 1-3 | 7-3 | 10 |
| 1-3 | 4-6 | 10 |
|
thread by: steve |
last post Jul 23 '05 by: steve
I am researching mysql performance optimization. Does anyone who
good books, or good url’s for this. I have seen a couple of good
books on Amazon, but if you have read anything good, let me know.
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards...
|
thread by: Colin Finck |
last post Jul 23 '05 by: steve
Hello!
I need to backup a MySQL database (MySQL 4.0). But it is on a
shared-hosting web server and so I don't have direct server access. I
also have no phpMyAdmin installed.
How can I backup the database? I think it is possible with PHP
(version 5.0.2 is installed on the web server) to create a file with
SQL commands which restore the data,...
|
thread by: Gregory.Spencer |
last post Jul 23 '05 by: Bill Karwin
Hi There,
Been working in a PHP / MySQL project I took over code development for.
Today when testing new changes suddenly started getting "Failed to
connect to the database" errors.
When logged into phpmyadmin it said:
Error
|
thread by: Programas de email |
last post Jul 23 '05 by: Programas de email
Convidamos você a experimentar o Magic Seven,
o melhor programa de envio de emails para listas
de contatos.
Com o Magic Seven você pode enviar emails personalizados
e com recursos multimídia, além de ser o programa mais
rápido e confiável do mercado.
O Magic Seven está no mercado há mais de 5 anos,
já estando na sua versão 5. É um...
|
| |
thread by: Andrew |
last post Jul 23 '05 by: Andrew
Hi,
I have a form set up which collects details and then when submitted it
creates a new record in a table called rbh_vacancies
Most of the time it adds the records perfectly, but there seems to be a very
low number of characters it will accept in each field-
The following code updates the database-
|
thread by: Fast Eddie |
last post Jul 23 '05 by: Fast Eddie
Hi,
I'm writing a program (using mysql++) where I want users to be able to
lock a row while they are editing it. My problem is I don't know how
the 2nd user can detect the lock vs it looking like a failed query.
I have innodb_lock_wait_timeout set to 1 second, which works fine, but
mysql returns two errors when I try to update:
ERROR...
|