470,619 Members | 2,003 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

subquery bug or compilation prob?

Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out.

The example is streight out from the ref manual:
http://www.doctaur.com/dtdocs/databa...anual_437.html
The following is what I get when I run that simple query:
$ cat test.sql
DROP DATABASE test;
CREATE DATABASE test;
connect test;
CREATE TABLE t1 (s1 INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (s1 INT);
INSERT INTO t2 VALUES (2);
SELECT * FROM t1;
SELECT * FROM t2;
SELECT (SELECT s1 FROM t2) FROM t1;

$ /usr/local/mysql/bin/mysql -t -u root -p < test.sql
Enter password:
+------+
| s1 |
+------+
| 1 |
+------+
+------+
| s1 |
+------+
| 2 |
+------+
ERROR 1064 at line 14: 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 'SELECT s1 FROM t2) FROM t1' at line 1

Now some details on my box:
mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.18, for pc-linux
(i686)

Connection id: 229
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.18-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 24 min 21 sec

Threads: 1 Questions: 5389 Slow queries: 0 Opens: 109 Flush
tables: 1 Open tables: 30 Queries per second avg: 0.061

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

PIII 900 Mhz / 512 RAM / Slack 9.1 / Kernel (vanilla) 2.6.4

How it mysql was compiled... if I can trust my notes:
# CFLAGS="-O3 -mcpu=pentiumpro " CXX=gcc CXXFLAGS="-O3
-mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti"
../configure --prefix=/usr/local/mysql --enable-assembler
--enable-safe-thread-client --with-mysql-user=mysql --with-openssl
--with-unix-socket-path=/tmp/mysql.sock

# make
# make install

Many thanks for your help
Ed.
Jul 20 '05 #1
28 2062
Edoardo Costa wrote:
I'm having a little problem with sub queries under mysql and I'd like Server version: 4.0.18-log


Subqueries are supported from version 4.1, you have 4.0, there's your
problem.
Jul 20 '05 #2
Edoardo Costa wrote:
I'm having a little problem with sub queries under mysql and I'd like Server version: 4.0.18-log


Subqueries are supported from version 4.1, you have 4.0, there's your
problem.
Jul 20 '05 #3
BTW, what I am ultimately after is something in the lines of:

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');

Thx :)
Ed.

ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out.

The example is streight out from the ref manual:
http://www.doctaur.com/dtdocs/databa...anual_437.html
The following is what I get when I run that simple query:
$ cat test.sql
DROP DATABASE test;
CREATE DATABASE test;
connect test;
CREATE TABLE t1 (s1 INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (s1 INT);
INSERT INTO t2 VALUES (2);
SELECT * FROM t1;
SELECT * FROM t2;
SELECT (SELECT s1 FROM t2) FROM t1;

$ /usr/local/mysql/bin/mysql -t -u root -p < test.sql
Enter password:
+------+
| s1 |
+------+
| 1 |
+------+
+------+
| s1 |
+------+
| 2 |
+------+
ERROR 1064 at line 14: 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 'SELECT s1 FROM t2) FROM t1' at line 1

Now some details on my box:
mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.18, for pc-linux
(i686)

Connection id: 229
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.18-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 24 min 21 sec

Threads: 1 Questions: 5389 Slow queries: 0 Opens: 109 Flush
tables: 1 Open tables: 30 Queries per second avg: 0.061

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

PIII 900 Mhz / 512 RAM / Slack 9.1 / Kernel (vanilla) 2.6.4

How it mysql was compiled... if I can trust my notes:
# CFLAGS="-O3 -mcpu=pentiumpro " CXX=gcc CXXFLAGS="-O3
-mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --enable-assembler
--enable-safe-thread-client --with-mysql-user=mysql --with-openssl
--with-unix-socket-path=/tmp/mysql.sock

# make
# make install

Many thanks for your help
Ed.

Jul 20 '05 #4
BTW, what I am ultimately after is something in the lines of:

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');

Thx :)
Ed.

ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out.

The example is streight out from the ref manual:
http://www.doctaur.com/dtdocs/databa...anual_437.html
The following is what I get when I run that simple query:
$ cat test.sql
DROP DATABASE test;
CREATE DATABASE test;
connect test;
CREATE TABLE t1 (s1 INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (s1 INT);
INSERT INTO t2 VALUES (2);
SELECT * FROM t1;
SELECT * FROM t2;
SELECT (SELECT s1 FROM t2) FROM t1;

$ /usr/local/mysql/bin/mysql -t -u root -p < test.sql
Enter password:
+------+
| s1 |
+------+
| 1 |
+------+
+------+
| s1 |
+------+
| 2 |
+------+
ERROR 1064 at line 14: 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 'SELECT s1 FROM t2) FROM t1' at line 1

Now some details on my box:
mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.18, for pc-linux
(i686)

Connection id: 229
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.18-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 24 min 21 sec

Threads: 1 Questions: 5389 Slow queries: 0 Opens: 109 Flush
tables: 1 Open tables: 30 Queries per second avg: 0.061

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

PIII 900 Mhz / 512 RAM / Slack 9.1 / Kernel (vanilla) 2.6.4

How it mysql was compiled... if I can trust my notes:
# CFLAGS="-O3 -mcpu=pentiumpro " CXX=gcc CXXFLAGS="-O3
-mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --enable-assembler
--enable-safe-thread-client --with-mysql-user=mysql --with-openssl
--with-unix-socket-path=/tmp/mysql.sock

# make
# make install

Many thanks for your help
Ed.

Jul 20 '05 #5
Also, the manual you've been using looks strange, because it says 4.0
would support subqueries. I haven't tried it personally, but at least
MySQL reference manual talks only about version 4.1.

http://dev.mysql.com/doc/mysql/en/AN...ubqueries.html
Jul 20 '05 #6
Also, the manual you've been using looks strange, because it says 4.0
would support subqueries. I haven't tried it personally, but at least
MySQL reference manual talks only about version 4.1.

http://dev.mysql.com/doc/mysql/en/AN...ubqueries.html
Jul 20 '05 #7
ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out. Server version: 4.0.18-log


Subqueries are only supported in version 5.0 (currently only available
as a development release).
Jul 20 '05 #8
ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out. Server version: 4.0.18-log


Subqueries are only supported in version 5.0 (currently only available
as a development release).
Jul 20 '05 #9
ch************@yahoo.com wrote:
Subqueries are only supported in version 5.0 (currently only available
as a development release).


Only in 5.0? Are you saying MySQL has error in their documentation?

http://dev.mysql.com/doc/mysql/en/AN...ubqueries.html
Jul 20 '05 #10
ch************@yahoo.com wrote:
Subqueries are only supported in version 5.0 (currently only available
as a development release).


Only in 5.0? Are you saying MySQL has error in their documentation?

http://dev.mysql.com/doc/mysql/en/AN...ubqueries.html
Jul 20 '05 #11
"Aggro" <sp**********@yahoo.com> wrote in message news:7jPkc.166
Subqueries are supported from version 4.1, you have 4.0, there's your
problem.


Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended,
and 5.0 as development.
Jul 20 '05 #12
"Aggro" <sp**********@yahoo.com> wrote in message news:7jPkc.166
Subqueries are supported from version 4.1, you have 4.0, there's your
problem.


Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended,
and 5.0 as development.
Jul 20 '05 #13
Siemel Naran wrote:
Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended,
and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html

List of versions 3.23,4.0,4.1 and 5.0 and download links to them all
with short description:

* MySQL database server & standard clients:
o MySQL 4.0 -- Production release (recommended)
o MySQL 4.1 -- Alpha release (use this for new development)
o MySQL 5.0 -- Development tree (use this for previewing and testing
new features)
o MySQL 3.23 -- Older production release
o Older releases -- older releases (only recommended for special needs)
o Snapshots -- source code snapshots of the development trees

http://dev.mysql.com/downloads/
Jul 20 '05 #14
Siemel Naran wrote:
Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended,
and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html

List of versions 3.23,4.0,4.1 and 5.0 and download links to them all
with short description:

* MySQL database server & standard clients:
o MySQL 4.0 -- Production release (recommended)
o MySQL 4.1 -- Alpha release (use this for new development)
o MySQL 5.0 -- Development tree (use this for previewing and testing
new features)
o MySQL 3.23 -- Older production release
o Older releases -- older releases (only recommended for special needs)
o Snapshots -- source code snapshots of the development trees

http://dev.mysql.com/downloads/
Jul 20 '05 #15
OK, so if I can resume what I have just been told:
MySQL 4.0.x will not run subqueries and the doc I found is wrong.
MySQL 4.1.x is thought to run subqueries.
and MySQL 5.0.x does run subqueries but is in a test phase

I'll give 4.1 a go after making sure it *can* run them.

BTW, is my sintax righ if I did get subqueries running? ;)

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');

Thank you all for your info!
Ed.

ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out.

The example is streight out from the ref manual:
http://www.doctaur.com/dtdocs/databa...anual_437.html
The following is what I get when I run that simple query:
$ cat test.sql
DROP DATABASE test;
CREATE DATABASE test;
connect test;
CREATE TABLE t1 (s1 INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (s1 INT);
INSERT INTO t2 VALUES (2);
SELECT * FROM t1;
SELECT * FROM t2;
SELECT (SELECT s1 FROM t2) FROM t1;

$ /usr/local/mysql/bin/mysql -t -u root -p < test.sql
Enter password:
+------+
| s1 |
+------+
| 1 |
+------+
+------+
| s1 |
+------+
| 2 |
+------+
ERROR 1064 at line 14: 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 'SELECT s1 FROM t2) FROM t1' at line 1

Now some details on my box:
mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.18, for pc-linux
(i686)

Connection id: 229
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.18-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 24 min 21 sec

Threads: 1 Questions: 5389 Slow queries: 0 Opens: 109 Flush
tables: 1 Open tables: 30 Queries per second avg: 0.061

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

PIII 900 Mhz / 512 RAM / Slack 9.1 / Kernel (vanilla) 2.6.4

How it mysql was compiled... if I can trust my notes:
# CFLAGS="-O3 -mcpu=pentiumpro " CXX=gcc CXXFLAGS="-O3
-mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --enable-assembler
--enable-safe-thread-client --with-mysql-user=mysql --with-openssl
--with-unix-socket-path=/tmp/mysql.sock

# make
# make install

Many thanks for your help
Ed.

Jul 20 '05 #16
OK, so if I can resume what I have just been told:
MySQL 4.0.x will not run subqueries and the doc I found is wrong.
MySQL 4.1.x is thought to run subqueries.
and MySQL 5.0.x does run subqueries but is in a test phase

I'll give 4.1 a go after making sure it *can* run them.

BTW, is my sintax righ if I did get subqueries running? ;)

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');

Thank you all for your info!
Ed.

ed**********@yahoo.com (Edoardo Costa) wrote in message news:<b4*************************@posting.google.c om>...
Dear SQL wizards,
I'm having a little problem with sub queries under mysql and I'd like
to know if you can help me out.

The example is streight out from the ref manual:
http://www.doctaur.com/dtdocs/databa...anual_437.html
The following is what I get when I run that simple query:
$ cat test.sql
DROP DATABASE test;
CREATE DATABASE test;
connect test;
CREATE TABLE t1 (s1 INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 (s1 INT);
INSERT INTO t2 VALUES (2);
SELECT * FROM t1;
SELECT * FROM t2;
SELECT (SELECT s1 FROM t2) FROM t1;

$ /usr/local/mysql/bin/mysql -t -u root -p < test.sql
Enter password:
+------+
| s1 |
+------+
| 1 |
+------+
+------+
| s1 |
+------+
| 2 |
+------+
ERROR 1064 at line 14: 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 'SELECT s1 FROM t2) FROM t1' at line 1

Now some details on my box:
mysql> status
--------------
/usr/local/mysql/bin/mysql Ver 12.22 Distrib 4.0.18, for pc-linux
(i686)

Connection id: 229
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.18-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 24 min 21 sec

Threads: 1 Questions: 5389 Slow queries: 0 Opens: 109 Flush
tables: 1 Open tables: 30 Queries per second avg: 0.061

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not
allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the
command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

--------------

PIII 900 Mhz / 512 RAM / Slack 9.1 / Kernel (vanilla) 2.6.4

How it mysql was compiled... if I can trust my notes:
# CFLAGS="-O3 -mcpu=pentiumpro " CXX=gcc CXXFLAGS="-O3
-mcpu=pentiumpro -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --enable-assembler
--enable-safe-thread-client --with-mysql-user=mysql --with-openssl
--with-unix-socket-path=/tmp/mysql.sock

# make
# make install

Many thanks for your help
Ed.

Jul 20 '05 #17
"Aggro" <sp**********@yahoo.com> wrote in message
news:h7*************@read3.inet.fi...
Siemel Naran wrote:

Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended, and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html


Thanks.
Jul 20 '05 #18
"Aggro" <sp**********@yahoo.com> wrote in message
news:h7*************@read3.inet.fi...
Siemel Naran wrote:

Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended, and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html


Thanks.
Jul 20 '05 #19
"Edoardo Costa" <ed**********@yahoo.com> wrote in message
BTW, is my sintax righ if I did get subqueries running? ;)

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');


My gut feeling is it should be be

INSERT INTO table2 (Donetime,Tid)
SELECT NOW(), Tid FROM table1
WHERE Tasks='foobar'
;

I'm busy downloading 4.1, but it's going to take a while on dialup modem.

See the threads "find all products with maximum version", "delimiter |",
"Having problems with subqueries" -- and I think 4.1 should fix all of
these. Will let the group know.
Jul 20 '05 #20
"Edoardo Costa" <ed**********@yahoo.com> wrote in message
BTW, is my sintax righ if I did get subqueries running? ;)

INSERT INTO table2 (Donetime,Tid) VALUES (NOW(),SELECT Tid FROM table1
WHERE Tasks='foobar');


My gut feeling is it should be be

INSERT INTO table2 (Donetime,Tid)
SELECT NOW(), Tid FROM table1
WHERE Tasks='foobar'
;

I'm busy downloading 4.1, but it's going to take a while on dialup modem.

See the threads "find all products with maximum version", "delimiter |",
"Having problems with subqueries" -- and I think 4.1 should fix all of
these. Will let the group know.
Jul 20 '05 #21
"Aggro" <sp**********@yahoo.com> wrote in message
news:h7*************@read3.inet.fi...
Siemel Naran wrote:

Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended, and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html


OK, I have 4.1 now. Unfortunately it does not have an automatic installer.
So how to do the upgrade? Is it as simple as copying the directories and
files from the downloaded version to overwrite what I already have?
Jul 20 '05 #22
"Aggro" <sp**********@yahoo.com> wrote in message
news:h7*************@read3.inet.fi...
Siemel Naran wrote:

Where to get 4.1? The www.mysql.com website only has 4.0.18 as recommended, and 5.0 as development.


Direct link:
http://dev.mysql.com/downloads/mysql/4.1.html


OK, I have 4.1 now. Unfortunately it does not have an automatic installer.
So how to do the upgrade? Is it as simple as copying the directories and
files from the downloaded version to overwrite what I already have?
Jul 20 '05 #23
Siemel Naran wrote:
OK, I have 4.1 now. Unfortunately it does not have an automatic installer.
So how to do the upgrade? Is it as simple as copying the directories and
files from the downloaded version to overwrite what I already have?


I don't know, but instructions can be founf from here:

http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html
Jul 20 '05 #24
"Aggro" <sp**********@yahoo.com> wrote in message
news:LC************@read3.inet.fi...
Siemel Naran wrote:

OK, I have 4.1 now. Unfortunately it does not have an automatic installer. So how to do the upgrade? Is it as simple as copying the directories and files from the downloaded version to overwrite what I already have?


I don't know, but instructions can be founf from here:

http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html


Thanks. Anyway I just copied the 4.1 files into my 4.0 location, and
whoops, all the users I created were deleted because the copy overwrote the
data\mysql sub-directory.
Jul 20 '05 #25
Siemel Naran wrote:
OK, I have 4.1 now. Unfortunately it does not have an automatic installer.
So how to do the upgrade? Is it as simple as copying the directories and
files from the downloaded version to overwrite what I already have?


I don't know, but instructions can be founf from here:

http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html
Jul 20 '05 #26
"Aggro" <sp**********@yahoo.com> wrote in message
news:LC************@read3.inet.fi...
Siemel Naran wrote:

OK, I have 4.1 now. Unfortunately it does not have an automatic installer. So how to do the upgrade? Is it as simple as copying the directories and files from the downloaded version to overwrite what I already have?


I don't know, but instructions can be founf from here:

http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html


Thanks. Anyway I just copied the 4.1 files into my 4.0 location, and
whoops, all the users I created were deleted because the copy overwrote the
data\mysql sub-directory.
Jul 20 '05 #27
Siemel Naran wrote:
Thanks. Anyway I just copied the 4.1 files into my 4.0 location, and
whoops, all the users I created were deleted because the copy overwrote the
data\mysql sub-directory.


I hope you had a backup ;)
Jul 20 '05 #28
Siemel Naran wrote:
Thanks. Anyway I just copied the 4.1 files into my 4.0 location, and
whoops, all the users I created were deleted because the copy overwrote the
data\mysql sub-directory.


I hope you had a backup ;)
Jul 20 '05 #29

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by lev | last post: by
22 posts views Thread by Kevin Murphy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.