On Wednesday, December 23, 2015, Jørn Dahl-Stamnes wrote:
> Hello
>
> I had to replace the datadisk where mysql had its innodb files.
>
> But after I had added a new disk I'm not able to initialize mysql files any
> more:
>
> # mysqld --initialize --user=mysql
&g
rship to the
directories to mysql:mysql
Any suggestions how to fix this?
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
noone is that stupid. I'm sure it cost the sender a lot to send fax/call
that number!
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
out what caused it:
https://www.percona.com/blog/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/
I suspect that this also apply to ext4, or?
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
verything that is happening. And the speed of the output tells me how fast
things goes. With 5.5
the speed was much higher right from the start (after a reboot and starting up
the test).
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
Fo
place. The test server is used for
testing this system
only. And in 99% of the time, only one client is using the SQL server.
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
: sleeping
Number of rows inserted 16718, updated 6422, deleted 12070, read 18051815
34.80 inserts/s, 21.00 updates/s, 31.40 deletes/s, 113447.76 reads/s
END OF INNODB MONITOR OUTPUT
====
1 row in set (0.01 sec)
--
Jørn Dahl-Stamnes
homep
O_DIRECT
innodb_lock_wait_timeout= 50
innodb_thread_concurrency = 16
innodb_fast_shutdown = 0
[mysql]
no-auto-rehash
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
to
resolve the issue.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.986100Z 0 [ERROR] Can't open
and lock privilege
tables: Table 'mysql.servers' doesn't exist
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.997527Z 0 [Note] Event
Scheduler: Loaded 0 events
May 15
On Tuesday, May 12, 2015, Jørn Dahl-Stamnes wrote:
> Hello,
>
> I'm trying to install mysl 5.6.24 from source on a Fedora Core 21 server,
> but it fails during 'make install':
>
> CMake Error at libmysqld/examples/cmake_install.cmake:74 (file):
> file INST
was able to start it but not to use 'mysql -u root -p' after I
started it. Got a
Segmentation fault - core dumped. :(
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
hours I could see that the performance was back to normal - 1800 -
2000 jobs per minute. There is no sign of drop in performace so far.
Please explain.
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Tuesday 14 January 2014 21:51, Jesper Wisborg Krogh wrote:
> Hi Jørn,
>
> On 15/01/2014 04:36, Jørn Dahl-Stamnes wrote:
> > 140114 18:20:08 InnoDB: Error: data file /data/mysql/data/ibdata3 uses
> > page size 1024,
> > 140114 18:20:08 InnoDB: but the only supporte
as a STORAGE ENGINE
failed.
140114 18:20:08 [ERROR] Unknown/unsupported storage engine: InnoDB
140114 18:20:08 [ERROR] Aborting
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
s read-only from the web application.
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
; (if i remember the
exact phrase). After witing 2 seconds, I restarted the server. It seemed
to work OK until the backup started.
Perhaps we should restore the database that I suspect cause this, in order to
rebuild the complete database.
--
Jørn Dahl-Stamnes
homepage: http://photo.
mysqld_safe: Number of processes running now: 0
Oct 12 11:53:33 cebycny mysqld_safe: mysqld restarted
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
--
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/
--
MySQL General Mailing List
For list archives: http://
t passing the date (without time) would get it but I keep
> getting an empty record set.
> So looking for something that works a bit better.
select * from your_table where convert(dateAdded, date)='2011-01-31';
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
M
On Monday 17 January 2011 09:53, Steve Meyers wrote:
> On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
> > mysql> select album_id, updated_at, created_at from album_stats group by
> > album_id order by updated_at desc limit 8;
>
> I believe that your problem is that the gro
270 | 2010-09-11 13:57:25 | 2010-09-11 13:57:25 |
+--+-+-+
8 rows in set (0.23 sec)
But the result is not what I expected. What have I missed?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For lis
was my fault (the missing join) but I still wonder why the
server processed the query. Would it not be more appropriate with an error
message saying that this query contain an error?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list ar
+
A join was missing. Strange that this passed the syntax check because the
select statment does not make sense (in the application).
It should containt a "AND images.ALBUM_ID=albums.ID'. When I fixed this, it
worked :)
Thanx anyway.
--
Jørn Dahl-Stamnes
homepage: http://
has only InnoDb tables and I'm using version
5.1.42-log.
The query is build using Propel (from a web-application made by Symfony
framework).
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
the browser is closed or not (or if the network
connection is losted). It will continue to execute the code until finnished.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
... or 50 ways to leave your Oracle...
... or 50 ways to save your money...
Choose mysql! :)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
previous used password the system remembered. The
program worked like this:
for (n = 0; no_of_stored_password > n; n++) {
set_password(random_generated_password);
do_a_short_sleep();
}
set_password(original_password);
... and the problem was solved :)
--
Jørn Dahl-Stamnes
homepage: http://www.da
alid
event in binary log', data_len: 100, event_type: 2
What is causing this? How can I fix this?
I'm using version mySQL 5.1.42.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
> (Correction, seel below)
>
> > Jørn Dahl-Stamnes :
> > > > I have checked the local DNS and 'r2-d2' and
> > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addres
cret-password';
I just found the cause of the problem... /etc/nsswitch.conf.
It said that files should be used before dns. After I changed the order, it
worked (so did the strange sendmail problem I had).
But still I wonder why it worked on the other host, since it also had the
order "files dns
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
> > Jørn Dahl-Stamnes :
> > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> > resovl to the same IP-addresse.
> > What's wrong?
>
> Reverse resolut
7; idenfified by
'secret-password';
grant all on *.* to 'root'@'jedi.dahl-stamnes.net' idenfified by
'secret-password';
> --Original Message--
> From: Jørn Dahl-Stamnes
> To: mysql@lists.mysql.com
> ReplyTo: sq...@dahl-stamnes.net
> Subject:
DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' resovl
to the same IP-addresse.
What's wrong?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Look at the message, 0 rows changed and 1 warning.
You cannot have ID=0 if ID is an index.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
be
important.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ql file like:
use foobar;
include some/dir/file1.sql
include some/dir/file2.sql
...
and so on.
Is it possible?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
privileges;
DBDesigner claim that the user/password is invalid.
Any idea what can be wrong?
I whish to do a reverse engineering on a big database in order to save time
making the visual design in DBDesigner.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General
On Saturday 01 March 2008 13:45, Jørn Dahl-Stamnes wrote:
> I have just installed MySQL 5. The server is running, but I'm not able to
> connect to the server as root.
>
> I have not set any root password, since I have not found any way to do this
> in version 5 (it was rathe
sword, but it does not work:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Can someone please explain who to set the root password?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
[EMAIL PROTECTED] ~]# uname -a
Linux jedi.dahl-stamnes.net 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:56:33 EDT 2005
x86_64 x86_64 x86_64 GNU/Linux
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PROTECTED]:.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
root -p and enter password and do a
> mysql>use dbname;
> mysql>source build.sql;
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near ')' at line 8.
f
rator does not include the last day, so my reports with
> > "<=" are done by adding one day but don't like to use it this way since
> > it could
> > be confusing and generate errors on reports.
> >
> > Thanks for any comment,
> > Mig
hich is exactly as described above.
Lesson learned: Get a good night sleep and then try to figure out how to do
things... ;-)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
this in a single operation.
Anyone that can give me a suggestion?
I'm using MySQL 4.1.8
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| | | 1 ||
+--+---+--+-+-++
The web-server is using PHP 4.3
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
is not to be trusted,
or? Any comments?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
info as l on
(l.user_id=u.id) inner join playershanddetails as h on (h.playername=u.id)
group by u.id;
Please note: I have not tried this... just a quick suggestion right out of my
brain... :-)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
15) to INT UNSIGNED and use INET_ATON
to convert a ip of the form a.b.c.d to unsinged int, and INET_NTOA to go back
to a.b.c.d
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set teams.created = select min(r.starttime)
from races as r on (r.id=p.race_id)
inner join participants as p on (p.rider_id=rt.rider_id)
inner join rider_team as rt where rt.team_id=$id
}
I guess that I have to do this in a perl script? But I would like to be able
to do this with a SQ
1.8-standard |
++
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
many times php must process that file.
If the image files are within the document path for the Apache web-server. But
they are not. In order to display an image, a PHP script must be used (a php
script can access files outside the document path).
But now we are moving away from the config question I h
d the
thumbnails are not stored in the database. The database contain image id,
image attributes (exposure++) and name of the image and thumbnail file.
I have looked into the docs about configuration, and there is parameter called
wait_timeout, which is set to 28800 (8 hours). I have not tested
.
Any settings in the config file for the sql-server I need to be aware of?
I'm using MyISAM tables .
mysql> select version();
++
| version() |
++
| 4.1.8-standard |
+----+
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
4-bit prosessor...
I also got some hints about using cpan (perl -MCPAN -eshell) but I felt like a
prisoner @ Guantamo who had to answer questions to CIA... At one point I had
no answer so I could not continue.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL Gene
, but without luck. I
have found a lot of references etc, but not a single link to the file...
Can some kind soul please guide me to this file? Or has it been lost for man
kind? ;-)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives:
e correct
value for the c.id.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e two COUNT's in one query or do I have to split the query into two
queries?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-+
| name | COUNT(b.id) |
+--+-+
| aa | 1 |
| bb | 1 |
+--+-----+
How can I get all records in x_type listet in one query?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archive
desc, sum_score
>
> if you're after 'asc' on "sum_score".
>
>
> - Rick
Hmmm.. Seems like I have missed something important here.
Thanks.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7 |1 | 1.0 | 1.000 |
| 143 |1 | 1.0 | 1.000 |
The order has changed from desc to asc!
Looks like a bug for me or am I blind? ;-)
select version();
++
| version() |
++
| 4.1.8-standard |
+--------+
--
Jørn Dahl-St
I dump my databases every night so if I
screw up, I can always go back without loosing more than 24 hours of updates.
But then, my databases are not that big.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
On Tuesday 22 August 2006 10:29, Peter Lauri wrote:
> Hi,
> I did something terrible similar to UPDATE table SET testdate=NOW()
> And I kind of forgot the WHERE lalalala, so now all my records are screwed.
> Is there any way of actually undoing this? :)
Backup?
--
Jørn Dahl-Stam
NER JOIN races AS r ON r.id = rs.race_id
> INNER JOIN participants AS p ON p.race_id = r.id
> WHERE s.receipt = 1
> AND p.rider_id = 236
> AND SUM(p.fee) > 0
> GROUP BY s.id
> ORDER BY s.f_date;
This gave the following error:
ERROR (HY000): Invalid use of g
+
Is this due to an old version of MySQL?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday 27 June 2006 13:43, Veerabhadra rao Narra wrote:
> Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
> www.venadsolutions.com
> its
> not spam
> -Rao
I consider this as spam. I would suggest that this person is removed from the
list.
--
Jø
tc, but without luck. All I get is an SQL
error.
The default value for some_field is null.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;t use. Here's the
> part of the manual that explains it and how to fix it:
>
> http://dev.mysql.com/doc/refman/4.1/en/old-client.html
Yes, I forgot to say that I was using PHP. However, using mysql does not work
eigher.
Thanks for the tip. I guess I just drop the passwor
even more strange, is that I have other pages on the same
server, which connect to a different sql-server (a different machine running
the same version of MySQL) without problems.
What can cause this problems?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mai
On Friday 23 June 2006 09:09, Veerabhadra rao Narra wrote:
> pls click this link www.venadsolutions.com and
> find new things
This is what I consider as SPAM...
So do not click the link...
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
Fo
On Thursday 22 June 2006 04:00, Daniel da Veiga wrote:
> On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote:
> > On Wednesday 21 June 2006 17:17, Barry wrote:
> > > Jørn Dahl-Stamnes schrieb:
> > > > Is it possible to get mysqldump to include rights that ha
On Wednesday 21 June 2006 17:17, Barry wrote:
> Jørn Dahl-Stamnes schrieb:
> > Is it possible to get mysqldump to include rights that has been GRANTED
> > to a database or to tables in the database that is being dumped?
>
> Dump the Grant tables?
I have though of it. Curre
Is it possible to get mysqldump to include rights that has been GRANTED to a
database or to tables in the database that is being dumped?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ht syntax to use
near 'Argentina Will win the match tonight against Holland' at line 1
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e2 left join table1 on table1.id=1 where table1.col1=3
and table2.id=1)
UNION
(SELECT col2 FROM table3 left join table1 on table1.id=1 where table1.col1<>3
and table3.id=1);
I have not tested it...
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing
o use
> near 'mysql
> dump --help' at line 1
Exit mysql and run mysqldump from the shell.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rrcode: 13)
> mysql>
A quick check with the perror command:
# perror 13
Error code 13: Permission denied
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e they help the spammers
by doing this. It's OK that they show the item in the list, but the e-mail
addresse should be masked...
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
cribe and a new subscribe.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Seems like someone has got their hand of my e-mail alias which I use for this
list only. It started last friday and I get about 10-15 messages every day.
Does someone else has this problem?
What's the procedure to change my subscribtion e-mail addresse?
--
Jørn Dahl-Stamnes
homepage:
something similar to:
> update dbB, dbA set dbB.foo=dbA.foo, dbB.bar=dbA.bar where
> dbB.id=dbA.id ;
>
> See:
> http://dev.mysql.com/doc/refman/5.0/en/update.html
Thanks a lot. That did the trick. I ended up with a command like this:
update newdb.table as T,olddb.table as
values, but the format is
different ('001234' vs 1234).
Is it possible to create a update query that copies the 'foo' and 'bar' from
table dbA.A to dbB.B for each record in dbB.B?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General
e?
> Furthermore, how should I do in order to load online the exported
> database?
> Many thanks in advance for the answer.
this is how I dump my database:
/usr/local/mysql/bin/mysqldump -u root -p imagedb
> /tmp/image_db.tmp
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes
d get a
output like "root > sub 1 > sub 1.1", if this is possible. Or do I have to do
this in a loop in my PHP code?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nes.net' (using
password: NO)
It seems like the host name given in the config file is ignored and that it
try to connect to the host where the web-server is running.
It should not be like this, should it?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL Ge
n why this happens? Should I be worried?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n't post attachments here?
>
> uploaded it:
>
> http://img394.imageshack.us/img394/4808/topgraphtoday9fp.jpg
> http://img394.imageshack.us/img394/3403/bottomgraphweeks2vf.jpg
Nice graphs. What tool do you use to make them?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamn
id;
Thanks. I'll try this. I found another way that seem to work:
SELECT @x:=category_id FROM category WHERE name='undefined';
UPDATE albums SET [EMAIL PROTECTED] WHERE category_id=0;
But your suggestions is a bit more elegant... :-)
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'some name';
UPDATE albums SET category_id='value found from above'
WHERE category_id='some value';
But I have not found any way to do this from a script.
Any hints from some kind souls out there?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
, but then I got the
following error:
mysqldump: Got error: 1: Can't create/write to file
'/home/dahls/Dump/albums.txt' (Errcode: 13) when executing 'SELECT INTO
OUTFILE'
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nst
> your DNS name (what's in the permissions tables).
I forgot to do a 'FLUSH PRIVILEGES;' after the GRANT command.
Thanks to "Sol Beach" for this solution.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list
a:
shell> mysql -h [EMAIL PROTECTED] -u snotface -p
Password: novice
ERROR 1045 (28000): Access denied for user
'snotface'@'otherhost.mydomain' (using password: YES)
I'm running MySQL version 4.1.8 on the server. and
Ver 14.7 Distrib 4.1.11, for redhat-linux-
S
('bob jones'),('larry smith'),('henry rogers');
BTW, I started to learn SQL two days ago...
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
93 matches
Mail list logo
