Thanks for coming to the rescue, Mark and Bruce.
Mark Leith wrote:
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
not sure, but it may be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL. pr
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Hi all,
My Windows-based database server crashed (no fault of MySQL. probably OS
or hardware), and I managed to copy out the data files. I am using
version 5.0 of the Essentials package.
I tried to install a similar setup on another server, then copy the
data\ folder over. The MySQL service
>From MySQL Manual:
"If you want to change the number or the size of your InnoDB log files,
you have to shut down MySQL and make sure that it shuts down without
errors. Then copy the old log files into a safe place just in case
something went wrong in the shutdown and you will need them to recover
Using a backup I recreated the /var/lib/mysql directory and when I
restart mysqld I am getting the following error:
InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of a different
size 0 5238827 byes
InnoDB: than specified in the .cnf file 0 5242880
Of course, the database never starts bec
