On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
Daniel da Veiga wrote:
> On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
>
>> what's event viewer? (searched google for error 1067, so opened .err
>> file, this is what is says (at the bottom, long file):
>>
>> 060607 22:37:33 [Note] mysqld: Shutdown complete
>>
>> InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760
>> bytes
>> InnoDB: than specified in the .cnf file 0 5242880 bytes!
>> 060607 22:47:57 [ERROR] Can't init databases
>> 060607 22:47:57 [ERROR] Aborting
>>
>> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
>>
>> (someone in a MySQL.com forum is also helping me, he suggested changing
>> this var in my.ini innodb_log_file_size to 20M, which I did, tried again
>> to restart, same error.. (maybe need to restart machine? you know,
>> this is all very weird, I never had MySQL server installed as a service
>> (I think), yet never had to turn it on, never had to do anything or
>> worry about it in any way, db's were always accessible to me with no
>> problems..)
>
>
> First of all, understand how MySQL works, at init, it searches for
> configs in files that can be in numerous location of your disk, mostly
> they're named "my.cnf" or "my.ini", that if your service does not
> point at it using "--defaults-file=<file>" on your "Services" windows
> at MySQL's service properties.
>
> Check if you find this file, it was probably ovewritten after you
> install/uninstall this other app you used, check if it has a
> configuration named "datadir" and see if it points at your "data"
> directory. It seems mysql was unable to locate its main database
> "mysql".
>
> Read the manual, the whole installation part, if you understand HOW
> mysql works you'll be all set. You really need the basis for this to
> work as we can't see or work with your system directly, only give you
> advice.
Daniel, thank you very much for your response.. this is what is says in
manual re .cnf/.ini files:
----
In MySQL installations prior to version 4.1.5 it was customary to name
the server configuration file 'my.cnf' or 'my.ini' and locate the file
either at 'c:\my.cnf' or 'c:\Windows\my.ini'.
The new MySQL Configuration Wizard places the 'my.ini' file in the
installation directory of the MySQL server. This helps associate
configuration files with particular server instances.
----
my.ini is there, but there's no .cnf file.. searched my entire C-drive
for a my.cnf file, it doesn't exist... (so don't understand why error
message mentions .cnf file..)
Ok, so, all you have to do is edit the MySQL service adding
"--defaults-file=<file>" and point it to a valid my.ini file with a
datadir variable set to your "data" directory, and you're set. Mysql
now is lost, it can't figure out WHERE to search for defaults.
error I'm getting is can't find my databases, but my databases are all
there, where they have always been.. ok, where do I go from here
But MySQL don't know where that is. Point it to a valid my.ini and it
will find them.
please... (would LOVE to know why no warning comes with XAMPP saying it
can damage existing MySQL installation.. I've never had any problems
Because bad written software installers tend to do stuff like this.
I'm impressed that an app is able to simply delete a service that do
not belong to it without even asking. Reminder to never use such
software.
whatsoever w/MySQL installation, now have spent two days dealing with
this.. this really sucks..) again, thank you for your help..
If you check the MySQL Manual at the Installation chapter, you'll find
all you need to start MySQL right. I REALLY recommend you read it and
post back later. To start, if you install MySQL by hand backin up your
current "data" dir, you'll learn a lot and probably will notice how
simple it was to solve this problem.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
