Start mysqld 5.7.7 with new disk

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

Re: Start mysqld 5.7.7 with new disk

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 > 20

Re: Sending a fax

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

Re: MySQL 5.7 Innodb performans issue

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

MySQL 5.7 Innodb performans issue

= 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

Re: MySQL 5.7 Innodb performans issue

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 homepage: http://photo.dahl-stamnes.net

Re: MySQL 5.7 Innodb performans issue

% 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

Re: MySQL 5.7 Innodb performans issue

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 For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Starting mysql 5.7.7

09:42:57 anakin mysqld: Version: '5.7.7-rc' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) -- 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

Cannot install mysql 5.6.24 from source

-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

Re: Cannot install mysql 5.6.24 from source

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 INSTALL cannot copy file /var/local/src/mysql

Re: Crash after shutdown/restart

- 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

Re: Crash after shutdown/restart

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 supported page size in this release is=16384

Crash after shutdown/restart

/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

Lost connection to MySQL server - need help.

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://lists.mysql.com/mysql To unsubscribe:http

Re: Lost connection to MySQL server - need help.

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

Re: Lost connection to MySQL server - need help.

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.dahl-stamnes.net/ -- MySQL

Re: Lost connection to MySQL server - need help.

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

Re: Help with Date in Where Clause

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/ -- MySQL General Mailing List For list archives

Re: Group by question

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 group by happens before the order

Group by question

: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 list archives: http

Incorrect key file for table

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 unsubscribe:http

Re: Incorrect key file for table

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://www.dahl-stamnes.net/dahls

Re: Incorrect key file for table

(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 archives: http

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

). 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

Re: 50 things to know before migrating from Oracle to MySQL

... 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

Re: Record old passwords ?

(); } set_password(original_password); ... and the problem was solved :) -- 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

Re: Problem with mysql

On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: Jørn Dahl-Stamnes sq...@dahl-stamnes.net : 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 resolution? I have checked that, and reverse DNS is OK

Re: Problem with mysql

. 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 in it's nsswitch.conf file... Thanks for your support. -- Jørn Dahl-Stamnes

Re: Problem with mysql

On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote: (Correction, seel below) Jørn Dahl-Stamnes sq...@dahl-stamnes.net : 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 resolution? I

Binary log problems

', 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 unsubscribe:http://lists.mysql.com/mysql

Problem with mysql

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

Re: Problem with mysql

by 'secret-password'; --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq...@dahl-stamnes.net Subject: Problem with mysql Sent: Jan 10, 2010 3:20 PM Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some

Re: Update Doesn't Update!

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

Include SQL files

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.com/mysql?unsub=arch

Re: Include SQL files

On Wednesday 01 April 2009 16:49, Eugene Kosov wrote: What about source? use foobar; source some/dir/file1.sql; source some/dir/file2.sql; ... Gee... why did I not find that on google? :D Thanks... this give me control of the order of the files, which can be important. -- Jørn Dahl

DBDesigner 4 and MySQL

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 Mailing List For list archives

Sql 5 new installation and root password?

, 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/mysql

Re: Sql 5 new installation and root password?

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 rather good documented in version

Re: Mysql and Perl

/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]

Re: backup InnoDB db to another server

]:. -- 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]

Re: Debugging batch sql statements

(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. foreach source do source file fix any error until no errors -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls

Re: Selecting rows by DATE ranges

for viruses and dangerous content by MailScanner, and is believed to be clean. -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- Jørn Dahl-Stamnes homepage: http

Re: Update question

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://lists.mysql.com/[EMAIL

Update question

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]

SQL and PHP: Incorrect errorcode

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]

Re: need a help in Query

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]

Re: need a help in Query

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 For list archives: http://lists.mysql.com/mysql

Re: Table update

(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 SQL line. -- Jørn Dahl-Stamnes homepage: http

Table update

-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]

Mysql, PHP and Persistent mode

before I changed to persistent mode. 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

Re: Mysql, PHP and Persistent mode

configuration, and there is parameter called wait_timeout, which is set to 28800 (8 hours). I have not tested it yet, but perhaps this should be set to something much lower? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http

Re: Mysql, PHP and Persistent mode

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 had about configurating the mysqld server. -- Jørn Dahl-Stamnes homepage: http://www.dahl

Re: Mysql and Perl

) 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Mysql and Perl

, 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: http

COUNT question

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]

Re: COUNT question

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]

Question about COUNT()

| 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

SQL order by BUG?

| ++ -- 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]

Re: SQL order by BUG?

. - 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]

Re: HELP!

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-Stamnes homepage: http

Re: HELP!

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/mysql To unsubscribe

Problems with WHERE clause

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]

Re: Problems with WHERE clause

= 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 group function -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list

Re: for queries and enquiries

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ørn Dahl-Stamnes homepage

SELECT and NULL

. 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]

Dont click this link

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 For list

PHP mysql_connect

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 Mailing List For list archives: http

Re: PHP mysql_connect

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 password... -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls

Re: About mysqldump

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 has been GRANTED to a database or to tables

Re: if else statement

on table1.id=1 where table1.col13 and table3.id=1); I have not tested it... -- 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]

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

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]

About mysqldump

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

Re: About mysqldump

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. Currently I am dumping the mysql

Re: Copy database to a file

' 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]

Re: MySQL

'\c' to clear the buffer. mysql use mysql; Can't read dir of './mysql/' (Errcode: 13) Database changed mysql show tables; ERROR 12: Can't read dir of './mysql/' (Errcode: 13) mysql A quick check with the perror command: # perror 13 Error code 13: Permission denied -- Jørn Dahl-Stamnes

SPAMs

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: http

Re: SPAMs

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]

Re: SPAMs

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:http://lists.mysql.com/[EMAIL

Update query

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 Mailing List For list archives

Re: Update query

://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 S set T.foo=S.foo,T.bar=S.bar,...(more fields that should be copied) where T.id=S.id; -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net

Re: mysqldump

in advance for the answer. this is how I dump my database: /usr/local/mysql/bin/mysqldump -u root -psomepassword imagedb /tmp/image_db.tmp -- 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

query question.

, 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]

myPhpAdmin

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 General Mailing List For list archives: http://lists.mysql.com

MySQL server has gone away ??

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]

Question on table udate

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/ -- MySQL General Mailing List

Re: Question on table udate

a.category_id=c.category_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

Re: proper way to export with the --tab function

: 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]

Network login

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-gnu (i386) on the client. Why? -- Jørn Dahl-Stamnes homepage: http://www.dahl

Re: Network login

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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: sequential id

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]