Hi All,
Am using mySQLDump to backup db as follows
mysqldump --databases OURDB -uroot -pROOTPASSWRD dump.sql
How can I restore OURDB from dump.sql?
Thanks
Jim
Tom Lobato wrote:
Hi!
UPDATE command is not working for only the record that I want, but for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r',
Hello Jim,
mysql -u root -p ROOTPASSWD dump.sql
Thanks,
Abdul.
On Fri, 2006-04-21 at 17:02 +1000, Jim wrote:
Hi All,
Am using mySQLDump to backup db as follows
mysqldump --databases OURDB -uroot -pROOTPASSWRD dump.sql
How can I restore OURDB from dump.sql?
Thanks
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
values('Whatchamacallit',
Vincente Aggrippino wrote:
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
Hi all,
I am trying to find a list that shows what wildcards I can use in fulltext
searches, I searched the docs but no luck, does anyone happen to have a link
to a list?
thanks in advance.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox
Try: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
--
Gabriel PREDA
Senior Web Developer
thank you.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au/ http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994 .
*
Web Design and Development
*
SMS
Hi,
I have a strange and annoying problem with Mysql 4.0.26 that I hope
someone will help me to fix:
the more databases a user has the less time it takes to execute show
databases and vice versa:
show databases;
+--+
5 rows in set (7.97 sec)
Hi all,
I was wondering if someone could tell me whether the following SQL would
have to perform two searches,
One to get the score in the SELECT clause and one in the WHERE clause to
only return matches?
If it does perform two searches, would it be best to put WHERE score != 0 in
the WHERE
Or use mysqlimport...
Typ 'mysqlimport --help' for further assistance. There are more usefull
tools in the bin directory of your mysql installation.
HTH,
Arjan.
-Original Message-
From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 09:03 AM
To: Jim
Cc:
Nicolas Verhaeghe [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
RedRed!com IT Department [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Jay Blanchard wrote:
[snip]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
--
Regards
Abhishek Jain
On 4/20/06, abhishek jain
WEBBEE . BIZ wrote:
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
Hmm should work with PROCEDURE
On 4/21/06, Nico Sabbi [EMAIL PROTECTED] wrote:
Is this behaviour due to a bug or maybe my mysql tables are messed up?
I'm not sure if we can call it a bug. But spending 8 seconds (and
using 100% CPU) for a simple SHOW DATABASES query is a bit too much,
and should be fixed.
mysqld first reads
On 4/21/06, Nico Sabbi [EMAIL PROTECTED] wrote:
the more databases a user has the less time it takes to execute show
databases and vice versa:
If no rows in `show databases` output appear because some user has
some table/columns privs but no db privs for a database in question,
then I think
Hi,
I have a problem with 'commit'. My database contain non transaction tables.
When ever i do something wrong on DB, i am unable to rollback. I am setting
set sutocommit off, but the result is same, no rollback is happening. Please
help me!
regards,
bala
Hello
Trying to CONCAT several fields into one with carriage in a Dreamweaver/php
recordset
I found an example for MS SQL
SELECT recid, CoName, Drive, Del_Proj,
'Co: ' +CoName + CHAR(13) + 'Acct: ' + Acct + CHAR(13) +'Drive: ', Drive) AS
Info
FROM data
ORDER BY recid ASC
Desired Result:
'\n' works for me in the command line client
select concat('Co: ABC','\n','Acct: 123','\n','Drive: Summer Special');
+-+
| concat('Co: ABC','\n','Acct: 123','\n','Drive: Summer Special') |
boll schrieb:
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create
I am trying to formulate a query that will increment if a condition is true.
For example, if I do a select (just let me know if there was data on
this day, if so increment count by 1 and check the next day) where
timestamp between jan and feb.
Thanks.
--
MySQL General Mailing List
For list
Shaun wrote:
I have stored the dimensions as decimal(4,2), does this make a difference?
not a very good way to do it if you ask me but here is how to do the
calculation.
SELECT ((FLOOR(X) + ((X - FLOOR(X))/0.12)) * (FLOOR(Y) + ((Y -
FLOOR(Y))/0.12))) as SqFt.
FLOOR(X) gives you 6
In the last episode (Apr 21), Vincente Aggrippino said:
The following query runs fine on my test server at home, running
MySQL 5.0.15, but on my hosting provider's server, running MySQL
4.0.24, it gets a syntax error. Can anyone help me figure out why?
...
insert into product (name, url,
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev/[yourdevicename]
After the JS2E 5.0 Release 4 update on Mac OS 10.4.6 on the 19th,
MySQL 4.1.18 64-bit hasn't started. It begins to start up, before
ending with ERROR!. Any possible reasons/solutions?
- Geoffrey Sneddon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi all,
This query works fine on a 4.1 server, but not a 5.0 server:
Select *
from
agentrelationships, agents as a2
left outer join agents
on
agentrelationships.agentidparent = agents.agentid
where
agentrelationships.agentidchild = a2.agentid
On a 5.0 server, I receive 'unknown
Writing echo
p-.mysql_error().-P-.mysql_info().-p;
below
$result = mysql_query($command);
gives the output:
--
-Rows matched: 2 Changed: 0 Warnings: 0-
So, it seems mysql doesnt get error. It simply ignores the WHERE.
From: George Law [EMAIL PROTECTED]
echo
From: Barry [EMAIL PROTECTED]
Tried: WHERE id = 5 ?
Yes, same trouble 8-(
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: George Law [EMAIL PROTECTED]
How many rows are in the table, just 2? (ie - is it updating ALL the
rows?)
In the instant of this test, just 2, but as I have tested several times,
with any number it behaves so, 2, 10, 15.
As someone else on the list mentioned, maybe you need to
Maybe it a bug of the php's mysql API?
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
Maybe it a bug of the php's mysql API?
[/snip]
Nope, I do this all of the time. Head on over to the PHP list and post
your code and see what they say.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
From: Jay Blanchard [EMAIL PROTECTED]
Nope, I do this all of the time.
me too =)
Head on over to the PHP list and post
your code and see what they say.
ok, I'll post there.
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I was looking around the list search and didn't find much on this subject
(maybe didn't look back far enough), but I was discussing with a coworker
about a reasonable application of subselects vs. a WHERE clause or table
join.
Thank you in advance.
--
Chris White
Interfuel
--
MySQL
Thanks for the pointer, Keith. I had not seen that tool before.
However, while it looks useful, it doesn't seem to address the problem
that I need to solve.
Any other thoughts?
Thanks again,
- Sam
On Wed, 2006-04-19 at 23:48 +0100, [EMAIL PROTECTED] wrote:
Have you taken a look at this
On Fri, 2006-04-21 at 11:42 -0500, Duzenbury, Rich wrote:
Is there some known bug about combining theta and ansi style joins in
the same query? As I say, this works on a 4.1 server, and it will be
troublesome to convert all of the old queries in order to upgrade.
In MySQL 5.0.12 they changed
On Wednesday 19 April 2006 11:10, Lucas Vendramin wrote:
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father) references t1(id) on
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
Yes, but this output indeed was generated when I made no changes in the
loaded fields of the web form. When I change something it outputs Changed:
2, for the case of 2 records in the table.
From: Nicolas Verhaeghe [EMAIL PROTECTED]
Normal. MySQL returns 0 changes when the data before and
On 21 Apr 2006, at 17:18, Geoffrey Sneddon wrote:
After the JS2E 5.0 Release 4 update on Mac OS 10.4.6 on the 19th,
MySQL 4.1.18 64-bit hasn't started. It begins to start up, before
ending with ERROR!. Any possible reasons/solutions?
Managed to fix it: /tmp was broken.
/tmp should be a
Ok but what is the problem then?
In the case of a group, you need to use HAVING for a condition on a listed
field, and if you id is an integer, then you may want to drop the '
Also are you taking care of converting the single quotes or do you have
magic quotes set to on?
-Original
Ok but what is the problem then?
In the case of a group, you need to use HAVING for a condition on a listed
field, and if you id is an integer, then you may want to drop the '
Also are you taking care of converting the single quotes or do you have
magic quotes set to on?
-Original
From: Nicolas Verhaeghe [EMAIL PROTECTED]
Ok but what is the problem then?
WHERE doesn't work. Iwrite WHERE in the command for UPDATE exactily one
record, defined by id = $id, and mysql server UPDATE all the records in the
table.
Also are you taking care of converting the single
Magic quotes replaces the ' with '' so that when you execute an SQL query,
it is encoded properly.
Or else someone could put a single quote in a form field and screw up your
database.
I do not like magic quote myself.
But we're going OT.
Echo the UPDATE query itself and then copy/paste it here
Hello,
I am attempting to upgrade one of our older servers running RH 7.3
w/glibc-2.2.5-44
it's currently using 3.23.58 and tried installing 4.0.26 rpm's for linux, but
won't install due to the following error:
libc.so.6(GLIBC_2.3) is needed by MySQL-shared-4.0.26-0
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to
You might like to take a look at smart package manager.
It's a wizz at dealing with dependancy conflicts.
http://labix.org/smart
http://wiki.suselinuxsupport.de/wikka.php?wakka=HowtoSmartPackageManager
http://forums.suselinuxsupport.de/index.php?showtopic=21121
HTH
Keith
In theory, theory
we where hoping to avoid all that, if possible :) it's not much of a product
server anymore, just for some small developement.
I guess we'll stick with what's installed.
Mike
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, April 21, 2006 5:38 PM
hi,
i am running a join query between the german_english table and the
user_todo_german_english tables, to figure out which words a user is
studying.
the key i am using is a combination of wordid + pos + posn (that is part
of speech == pos)
however, i am not able to correctly do the join because
Hi,
mysql select * from user_todo_german_english where wordid = '86851' and
posn = '1' and pos = 'm' AND mb_id='curious';
+-++--+--+-+
| mb_id | wordid | posn | pos | date_col|
+-++--+--+-+
2006-04-22 (토), 08:43 +0900, kmh496 쓰시길:
hi,
i am running a join query between the german_english table and the
user_todo_german_english tables, to figure out which words a user is
studying.
the key i am using is a combination of wordid + pos + posn (that is part
of speech == pos)
however,
2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길:
Hi,
mysql select * from user_todo_german_english where wordid = '86851' and
posn = '1' and pos = 'm' AND mb_id='curious';
+-++--+--+-+
| mb_id | wordid | posn | pos | date_col
From: Nicolas Verhaeghe [EMAIL PROTECTED]
Echo the UPDATE query itself and then copy/paste it here that way we'll see
what is wrong.
I already tried it. See some msgs before this. No sucess. When I paste
the exactily same command to the mysql client, all works fine (only the
right record
Tom Lobato wrote:
From: Nicolas Verhaeghe [EMAIL PROTECTED]
Echo the UPDATE query itself and then copy/paste it here that way
we'll see
what is wrong.
I already tried it. See some msgs before this. No sucess. When I
paste the exactily same command to the mysql client, all works fine
I'm using PHP, and I sometimes INSERT new records in a table. MySQL assigns
a new autoincrement int field on each INSERT ... nothing surprising there.
It goes 1, 2, 3, etc.
What query can I use to find out what value this int autoincrement assigned
field was? I could of course SELECT based on
David T. Ashley wrote:
I'm using PHP, and I sometimes INSERT new records in a table. MySQL assigns
a new autoincrement int field on each INSERT ... nothing surprising there.
It goes 1, 2, 3, etc.
What query can I use to find out what value this int autoincrement assigned
field was? I could of
kmh496 wrote:
hi,
i am running a join query between the german_english table and the
user_todo_german_english tables, to figure out which words a user is
studying.
the key i am using is a combination of wordid + pos + posn (that is part
of speech == pos)
however, i am not able to correctly do
Geoffrey Sneddon wrote:
On 21 Apr 2006, at 17:18, Geoffrey Sneddon wrote:
After the JS2E 5.0 Release 4 update on Mac OS 10.4.6 on the 19th,
MySQL 4.1.18 64-bit hasn't started. It begins to start up, before
ending with ERROR!. Any possible reasons/solutions?
Did you check mysql's error log
Thank you Prassad, and Dilip for your reply.
Prasad, i wiil be pleased if u answer to my query, how i can convert my
tables to Innodb?
Thank You,
regards,
bala
[EMAIL PROTECTED] wrote:
Thankyou Gabriel.
So how does one set a column comment then?
Regards
Keith
As part of the column definition, as documented in the manual
http://dev.mysql.com/doc/refman/5.0/en/create-table.html.
column_definition:
col_name type [NOT NULL | NULL] [DEFAULT
60 matches
Mail list logo