Hi!
By typing your error message into Google, I was lead to the following result
(two of them)
"Solution
This only works if you don't care about your innodb transaction backups!
Although to get this error, InnoDB probably wasn't working in the first
place.
Just move those log files to ib_logfile0.bak, ib_logfile1.bak, etc. and
start mysql again.
Consequences
This solution is not elegant but it works. At least it worked for me because
I didn't have any real data in the innodb tables anyways. INNODB stores all
transactions in it's log files so by moving those, I probably erased all the
backups of my transactions. If you have data you need to save, you'll have
to get help from someone wiser than me. ;) "
2nd result:
"Yes, do you have already the InnoDB data and log files and you are
specifying a different size for them.
You should do:
1- if the older InnoDB files doesn't has important data for you, just delete
them.
2- if you need to preserve theses files them specify the correct size in
your my.cnf/my.ini.
3- If you don't use InnoDB, then specify skip-innodb in the configuration
file."
I just want to tell you this if you have to do forensics on your database,
do this:
1. Back-up ALL your folder /var/lib/mysql, by copying it on your home
directory, for instance (use mc to do this), also copy /etc/my.cnf
2. rpm -ev mysql
3. DELETE all the directory you backed up
4. reinstall mysql, execute the online update (by running the comand you)
and start modifying /etc/my.cnf then rcmysql restart after EVERY line of
modifications you do into it
5. be sure that you don't have /homedir/.my.cnf and/or /root/.my.cnf
P.S. Please send me a copy of your mysql manual (the one you are using for
innodb and to learn mysql)
Thanks,
Radu
----- Original Message -----
From: "Mark Seven Smith"
On Tuesday 13 April 2004 22:09, Jon Clausen typed:
On Tue, Apr 13, 2004 at 09:55:53PM -0700, Mark Seven Smith wrote:
<snip>
Here's what my directory looks like now: (I showed what it looked like with this command before, in the previous Email):
linux:/home/markvii # ls -lia /var/lib/mysql total 20558 234907 drwxr-xr-x 4 mysql daemon 488 2004-04-13 21:41 . 23 drwxr-xr-x 41 root root 1072 2004-04-13 04:31 ..
jon@a13:~> ll -d /var/lib/mysql/ drwxr-xr-x 6 mysql daemon 5280 2004-04-14 06:01 /var/lib/mysql/
Maybe?
OK, here's what mine says (it's the same, except for the 6, mine's a 4):