In the last episode (Aug 20), hadi motamedi said:
> Can you please do me favor and let me know what is wrong with my MySql db
> installed on Linux server that causes to get the following error message :
> "Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)"
$ perror 145
MySQL e
Dear All
Can you please do me favor and let me know what is wrong with my MySql db
installed on Linux server that causes to get the following error message :
"Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)"
Your reply is highly appreciated
Regards
H.Motamedi
>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 11:39 AM
>To: Jerry Schwartz
>Subject: Re: How To Clean Old Table Data
>
>Thank you Jerry Schwartz and Blog Tieng Viet,
>
>To Viet: Mysql server is up alt lease 1 ye
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 9:59 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they login i
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 10:53 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they lo
I have an application that crates a users email info in MySQL every time
they login into the application. The only problem is once I remove their
account from the application/Linux, their user data remains in the MySQL
table and will eventually clutter the database. I don't know how I should or
can
I have an application that crates a users email info in MySQL every time
they login into the application. The only problem is once I remove their
account from the application/Linux, their user data remains in the MySQL
table and will eventually clutter the database. I don't know how I should or
can
Chris Spencer wrote:
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose "Edit table data" nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal han
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose "Edit table data" nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal handler:
domain: g-exec-e
; directory for InnoDB tables. It looks like InnoDB
> > table data belongs to his database are not kept
> under
> > his database directory. Am I right?
>
> Right. InnoDB uses big single (or multiple)
> tablespace for all data.
> But you can also use different
Sagara Wijetunga <[EMAIL PROTECTED]> wrote:
> I can see his MyISAM *.frm, *.MYD and *.MYI are kept
> under his database directory.
>
> But I can see only table.frm are in his database
> directory for InnoDB tables. It looks like InnoDB
> table data belongs to his dat
InnoDB data is kept in the ib* files. Did you explicitly create a directory
for your innoDB files?
-Original Message-
From: Sagara Wijetunga
To: [EMAIL PROTECTED]
Sent: 7/6/04 8:16 AM
Subject: InnoDB table data
Hi all
We allocate a limited amount of disk space for user's
home dire
nnoDB as well as MyISAM tables.
I can see his MyISAM *.frm, *.MYD and *.MYI are kept
under his database directory.
But I can see only table.frm are in his database
directory for InnoDB tables. It looks like InnoDB
table data belongs to his database are not kept under
his database directory. Am I
From: Michael B Allen [mailto:[EMAIL PROTECTED]
> I'd like to move some bookmarks in one database to another. The format
> of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly
> trucated):
>
> +--+--+--+-+-+
> ---+
> | Field
I'd like to move some bookmarks in one database to another. The format
of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly trucated):
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+---
Hold the phone - I've just realised that those tables 'missing' .ISM files are
actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM,
ISD) - how do I tell MySQL this is the case?
TIA (Again)
/Phil
On Sun, 02 Jun 2002 21:28:17 +0100
"Phillip Baker" <[EMAIL PROTE
Hi,
In haste to change some server hardware I copied the /var/lib/mysql directory directly
assuming this would suffice in order to carry the data over. I'm pretty certain I
stopped mysqld, but regardless I now seem to be missing nearly all the respective .ISM
files for my databases.
Now, I'm
Hello,
I am wondering if there is any way to determine the character set used for
data in a table.
For example, a single database has 10 tables, six with 'latin1' characters,
two with 'cp1251' characters, and two with 'greek' characters. The
character_set variable is set to 'latin1' on this dat
Hi!
We shall investigate your test case as soon as we find some time.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
>Description:
Hi all, I'm not exactly sure whether this is a bug or that I'm just the
following proper procedures for starting and stoping the database and
flushing logs.
But I do have repeatable test cases below.(terminal screen dumps)
I'm using version 3.23.36 with BDB tables:
Basically my da
uesday, 4 December 2001 7:49
> To: [EMAIL PROTECTED]
> Subject: RE: Viewing table data in a webpage using ASP
>
>
> Here is the connection code I use to view record information from a
> table. I'm using Dreamweaver Ultradev 4 to help with some of the ba
Nick Boldt [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: RE: Viewing table data in a webpage using ASP
Here is the connection code I use to view record information from a
table. I'm using Dreamweaver Ultradev 4 to help with some of the basi
Message-
From: Christopher R. Jones [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 3:07 PM
To: Nick Boldt
Subject: Re: Viewing table data in a webpage using ASP
If you have MyODBC installed and working you should be able to view the
records. I have a number of WEB pages that displa
Hi,
I'm trying to view the records of a table in on a webpage, but nothing
is showing up. I can add records to the table from the page but cannot
view, update or delete them.
I'm using Windows 2000 and IIS 5.0
I'm new to MySql and would greatly appreciate any help anyone can give
me.
Nick Bol
I posted a question a couple weeks back and received some half-dozen or so
responses, thankyou. I also bought a mysql/php book, which also has helped.
What I finally came up with (on my own no less) is the following -
printf("* %s
%s %s",
$row["bulletin_subject"], $row["bulletin_date"], $row
SELECT * FROM table_name;
This is explained in the manual, unless you want to use a GUI, then someone
else on the list may be able to help you.
- Original Message -
From: "Marc Bragg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 10:
what is the simplest command to view data from a table?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[
27 matches
Mail list logo
