Hey all,
So there are a number of ways you can handle this - either take a 'cold
backup' of the database, ie just copy/tar/zip all the data files off
somewhere, mind you to do this you will need to either shutdown the
database or ensure no updates take place (lock the tables). Or you can
take the
Scott -
Throw in some error checking - it can't hurt. Also, do a check to see
if the MySQL database is online (you never know) before trying to back
up the database within. Here's an example:
/path/to/mysqladmin --user=$USER --password=$PASS ping | grep "mysqld
is alive" >/dev/null 2>&1
if [ $?
On 7/18/07 5:58 PM, "John Schubert" <[EMAIL PROTECTED]> wrote:
> Now to go back and do the
> tutorial on DB back up and do it myself, and then
> figure out how to automate pushing it to another place
> on an all Microsoft shop (on which I have no
> permissions anywhere).
I just had to figure this
Regarding #2, I have found that this works WONDERS for keeping people
from trying to use the UI while I do a little tinkering.
http://wiki.bestpractical.com/view/MaintenanceMode
John Schubert wrote:
> BINGO!! That's all it took. 2 weeks of down time to
> do about 5 minutes of work. You might as
John Schubert wrote:
So, for now all is well. Now to go back and do the
tutorial on DB back up and do it myself, and then
figure out how to automate pushing it to another place
on an all Microsoft shop (on which I have no
permissions anywhere).
Just a thought, can't you put it on your Windows h
18/2007 03:38
> <[EMAIL PROTECTED]>
> PM
> Subject
&
Subject
Re: [rt-users] Couldnt open File
'sessions.MYI' in
I went through the MySQL tutorials and created test
tables to delete, within test databases and got that
down. I also went ahead and practiced importing and
populating fields within a table, from a flat file.
I've gone through all the the RT documentation,
researched the archives, and even went t
Ole,
Thank you so much. I haven't used my skills with
computers in quite awhile and I never was really a
MySQL guru, so no, your idea isn't below my level. I
understood every word Drew said, but had no idea how
to do it.
I will go through and practice with the tutorial
before I mess with the rea
Drew's right, if it's only the sessions table that's gone you're in
luck, since that only tracks things related to who's currently logged
in.
And (since I well remember my first attempt to do something with
mysql administration that was not scripted by an RPM installer... :-)
before you do
Since it seems it is only the sessions table that is borked, you could
try dropping that table and recreating from the definitions in the RT
package you grab from BP's website.
John Schubert wrote:
> Are there any resources you've seen that were written
> well and described MySQL DB recovery? I'
Are there any resources you've seen that were written
well and described MySQL DB recovery? I've been
digging through the MySQL documentation and
Yahoo/Googled for "How-To" articles, but most seem to
assume a certain level of knowledge I don't possess.
I feel dumb. I can compile, run and maintai
John Schubert wrote:
Thanks Ole,
I checked and with the standard install my database is
indeed in /var. I'm playing with myisamchk to see if
there's a way to restore.
Just a thought, what else is in /var and can be moved, temporarily, to
another place so that you can start mysql and recover
Thanks Ole,
I checked and with the standard install my database is
indeed in /var. I'm playing with myisamchk to see if
there's a way to restore.
I asked the IT department to back this server up for
years, but they've ignored me. This is the only
machine I have permissions, otherwise I'd have
John -
If your mysql database is located on /var and /var filled up, you're
hosed. (If there's a database engine anywhere that can deal gracefully
with an inability to write to its backing filestore during normal
operations, it's definitely not MySQL.)
Your best hope is probably to restor
.MYI That is the index file for the sessions table? Might it be too
big?
http://wiki.bestpractical.com/view/CleanupSessions
John Schubert wrote:
> First post didn't get a single reply, so please let me
> know if I'm not posting correctly. I've read the FAQs
> and posted on this list before.
First post didn't get a single reply, so please let me
know if I'm not posting correctly. I've read the FAQs
and posted on this list before.
The system is a 3 year old RT (RT 3.0.4 I believe)
that has been running without problems. The /var
partition filled up at some point in time and this
erro
17 matches
Mail list logo