| results |
| users |
| website_internalurl |
+-+
12 rows in set (0.00 sec)
mysql> show create table metadata;
ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
|
| page_content|
| projects|
| results |
| users |
| website_internalurl |
+-+
12 rows in set (0.00 sec)
mysql> show create table metadata;
ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
I backup my all rema
|
> | groups |
> | metadata |
> | page_content |
> | projects |
> | results |
> | users |
> | website_internalurl |
> +-+
> 12 rows in set (0.00 sec)
>
> mysql> show create ta
cos |
| categories |
| groups |
| metadata|
| page_content|
| projects|
| results |
| users |
| website_internalurl |
+-+
12 rows in set (0.00 sec)
mysql> show create table metadata;
ERROR 1146
- Original Message -
> From: "Adarsh Sharma"
>
> 1. Go to data dir : cd /hdd2-1/mysql_data/
> 2. mv abc abc1
Whatever gave you the idea that it's a good plan to start messing with the
files of a service whose inner workings you have no clue about?
> E
Dear all,
Today I changed my database name from abc to abc1 by the below commands :-
1. Go to data dir : cd /hdd2-1/mysql_data/
2. mv abc abc1
But when I go to the mysql prompt & try to use the tables in abc
database , below error occurs:
ERROR 1146 (42S02): Table 'abc1.job_queue
Hello.
MySQL CC is not supported now, and could have some problems with a fresh
versions of MySQL. If error doesn't appear in latest MySQL Administrator
then everything is ok.
> [local] ERROR 1146: Table 'llcopy.1' doesn't exist
Have a look here:
http://dev.mysql.com/d
February 2006 10:05
To: mysql@lists.mysql.com
Subject: error 1146 X.1 does not exist
Can someone point me in the right direction.
I had 4.1 running and all was well with my little program. I decided to test
the code with the newer 5.0.18. I updated my DB and then tried to access it
using the
me to view table structure but not to add any
numerical columns.
Using the Control centre, If I double click on the table I wish to view data
I get two lines in the message area
Empty set (0.00) sec
[local] ERROR 1146: Table 'llcopy.1' doesn't exist
llcopy being my test datab
>Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 =
'5') ORDER BY link_lastmod DESC
mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn&#
w_links WHERE (link_app1 =
> 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 =
> '5') ORDER BY link_lastmod DESC
> mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist)
This is nothing to do with MySQL - yo
; AND link_id2 =
'5') ORDER BY link_lastmod DESC
mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist)
File: /var/www/html/egroupware/infolog/inc/class.solink.inc.php
Line: 132
Function: calendar.uicalendar.view 3.23.58
I am using php 4.2.2 and MySQL
D]>
rs.com> cc:
Fax to:
I am trying to do an INSERT ... SELECT statement. When using MySQLcc
everything is fine. However when I try to execute the command using PHP I
get error 1146: Table 'caldata.resource' doesn't exist. Following is my
query statement. I am trying to combine a bunch of tables toget
On Tue, 1 Jun 2004 14:50:11 +0200
"Bungarz, Kai" <[EMAIL PROTECTED]> wrote:
> Hi!
> I'm using mysql-max-nt, Version 5, running on Windows 2000.
> While inserting rows into a table from a perl script, i get error
> 1146:"table mysql.proc doesn't exis
Hi!
I'm using mysql-max-nt, Version 5, running on Windows 2000.
While inserting rows into a table from a perl script, i get error 1146:
"table mysql.proc doesn't exist".
The application ran without any error with mysql, version 4.
Any ideas?
best regards,
Kai Bungarz
Hi,
When I enter this query "select * from books", it gives me this error message: "Error
1146: Table "test.1" doesn't exist". What does that mean? This is MySQL 5.0 and I just
installed today. How can I solve this pr
Well I will test that on my win2k server machine is now down
running instead Suse 9.0.
Thanks,
If I know that it runs satisfactorily under suse, I'm satisfied,
I have suse 8.2, but I can go for suse 9.0 If necessary.
Anyway you have the option for to download the package without
installer,
At 20:02 8/1/2004 +0100, Morten Gulbrandsen wrote:
hi,
Well I will test that on my win2k server machine is now down
running instead Suse 9.0.
Anyway you have the option for to download the package without
installer, then is just an issue to unzip the files in the
right place. You should this option
th nothing, before I installed again.
ERROR 1146 at line 24: Table 'mysql.proc' doesn't exist
the same error again,
I did the following,
C:\Documents and Settings\Administrator>net stop mysql
The MySql service is stopping..
The MySql service was stopped successfully.
then I renamed t
At 14:40 8/1/2004 +0100, Morten Gulbrandsen wrote:
Hi,
Thank you,
I am comparing the two \mysql\data\mysql directories,
finding that many files are simply missing in my installation.
I had another mysql version previously, which I removed,
I also have a different operating system. win2k
MySQL 5.
- Original Message -
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: "Morten Gulbrandsen" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 6:42 AM
Subject: Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn'
16.960 bytes
MySQL 5.0.0-alpha-max-nt under win2k
a small problem:
If I have a foreign key with reference to the same table,
I get an error,
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
what can I do ?
Yours Sincerely
Morten Gulbrandsen
=
MySQL 5.0.0-alpha-max-nt under win2k
a small problem:
If I have a foreign key with reference to the same table,
I get an error,
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
what can I do ?
Yours Sincerely
Morten Gulbrandsen
tup with -A
hs> Database changed
hs> mysql> INSERT INTO mysql VALUES(localhost, sample_db,
hs> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
hs> ERROR 1146: Table 'mysql.mysql'
n/GRANT.html for details...
Cheers,
Andrew
-Original Message-
From: hans schneidhofer [mailto:[EMAIL PROTECTED]]
Sent: Mon 23 September 2002 07:44
To: [EMAIL PROTECTED]
Subject: ERROR 1146
hi list,
trying to do my first steps with mysql, i have done the following :
mysql> USE mysql;
R
nged
>mysql> INSERT INTO mysql VALUES(localhost, sample_db,
>'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>ERROR 1146: Table 'mysql.
ple_db,
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1146: Table 'mysql.mysql' doesn't exist
hmm - what I have done wrong here ? or do I have to do someth
ple_db,
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
ERROR 1146: Table 'mysql.mysql' doesn't exist
hmm - what I have done wrong here ? or do I have to do someth
>From: david [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 10, 2002 1:42 PM
>Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding
a postfix to my USE request?
>
>Why is mysql adding a postfix to my USE request? I know that test.test
>
l Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 8:42 PM
Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding a
postfix to my USE request?
> Why is mysql adding a postfix to my
|
+--+
2 rows in set (0.00 sec)
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from test;
ERROR 1146: Table 'test.test' doesn't exist
mys
When I try to dump a file with
Create table
and
insert into
when i try to dump it into the DB I get this error
error 1146 at line 1: table 'dbname.tablename' doesn't exist
I tried it on a different server and
33 matches
Mail list logo
