saraswathy saras wrote:
Hi everybody,
Can anybody help me?
I'll give it a shot.
is there any other specific command instead order by ID DESC to select
all the record from table where the ID is the last ID.The ID is
autoincrement.
Try this:
select last_insert_id() as ID from TABLE
Patrick,
Try this from your shell:
You want to flush the tables (I'm assuming you want to keep the database
up and running), do a recover, safe recover, and check to make sure you
don't get the error messages when everything is finished.
$ mysqladmin flush-tables
$ myisamchk -r -o
with only 1 processor.
Do you have any idea as to what may be causing this problem and if so,
do you have a suggested solution?
Any help you may be able to give will certainly be appreciated.
Thanks,
Ozette Brown
have any idea as to what may be causing this problem and if so,
do you have a suggested solution?
Any help you may be able to give will certainly be appreciated.
Thanks,
Ozette Brown
-
Before posting
Dan Nelson wrote:
In the last episode (Mar 22), Ozette Brown said:
Andrey,
Thank you for the reply.
I read somewhere that when checking your maximum file descriptors your
kern.maxfiles
should be greater than kern.maxfilesperproc. My settings are:
kern.maxfiles = 8232
MySQL Error: 1049 (Unknown database 'databasename')
I having a very weird unpredictable problem. I have a webserver which
makes database connections via Perl and DBI. For the most part it works
pretty much all the time but sometimes (2 or 4 times per month) it gives
an error: Unknown database
I'm in the process of converting all of my database tables from ISAM to
MYISAM table format. I'll run the mysql_convert_table_format script
which basically does an Alter table. If during this conversion
someone accessed a web page which writes to the database (insert or
update), what will
From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it: