[Problem solved]cannot start mysql during upgrade

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[Problem solved]cannot start mysql during upgrade

Postby danielc » 30. December 2008 07:45

Hello i am trying to upgrading my xampp from 1.6.8 to 1.7.0, I downloaded the upgrade package, extracrt it and overwrite the xampp.
Then i followed the "How to", but when i tried to do the database, i found that the mysql cannot be started, and :


C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql_upgrade
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
C:\xampp\mysql\bin\mysqlcheck.exe: Got error: 2003: Can't connect to MySQL serve
r on 'localhost' (10061) when trying to connect
FATAL ERROR: Upgrade failed

C:\xampp\mysql\bin>mysql -u root -h localhost
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

what can i do now?
Last edited by danielc on 02. January 2009 03:27, edited 1 time in total.
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby Sharley » 30. December 2008 09:30

Did you edit the my.cnf file correctly - check again.

The error is usually because MySQL is not started.

Check the Application event viewer.

Make sure that the service is not installed:
Run xampp\mysql\mysql_uninstallservice.bat

Try starting with the mysql_start.bat file in the xampp folder or use the XAMPP Control Panel.

This is an upgrade and if you had a MySQL password for root before the upgrade then you will still have it - the upgrade will not remove it.

If you want to know how popular this error is check out this Google Search
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 03:53

Hi

i am not sure what's wrong with my.cnf. HOw can i check which part of it is wrong? :shock:

This shows on the console window and the event log while runnning the mysql start script. It asks me to run mysql_upgrade but the problem is, as i said before, i cannot run it,
so what can i do now?



from the event log:

Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

mysql\bin\mysqld: unknown option '--skip-bdb'

Aborting






from the console window:

Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 10:45:44 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
081231 10:45:45 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
081231 10:45:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
081231 10:45:45 [ERROR] mysql\bin\mysqld: unknown option '--skip-bdb'
081231 10:45:45 [ERROR] Aborting

081231 10:45:45 [Note] mysql\bin\mysqld: Shutdown complete


MySQL konnte nicht gestartet werden
MySQL could not be started
Press any key to continue . . .





Sharley wrote:Did you edit the my.cnf file correctly - check again.

The error is usually because MySQL is not started.

Check the Application event viewer.

Make sure that the service is not installed:
Run xampp\mysql\mysql_uninstallservice.bat

Try starting with the mysql_start.bat file in the xampp folder or use the XAMPP Control Panel.

This is an upgrade and if you had a MySQL password for root before the upgrade then you will still have it - the upgrade will not remove it.

If you want to know how popular this error is check out this Google Search
Last edited by danielc on 31. December 2008 03:59, edited 1 time in total.
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby Sharley » 31. December 2008 03:57

Please paste the my.cnf file here.
Thanks
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 04:05

Sharley wrote:Please paste the my.cnf file here.
Thanks


many thanks for your help, truely thanks from my heart

I have run the uninstall services script. It didn't solve the problem, and i have setup the root password.
Do i need to provide it in the my.cnf or i need to specify it in somewhere in the upgrade process? I don't need to do anything with it in the previous upgrades

and this is the my.cnf content:

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password = your_password
port = 3306
socket = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"

port = 3306
socket = mysql

old-passwords
#character-set-server = latin1
#collation-server = latin1_general_ci
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci



skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin=C:/xampp/mysql/data/mysql-bin

# Uncomment the following if you are NOT using BDB tables
skip-bdb

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:/xampp/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:/xampp/mysql/data/
#innodb_log_arch_dir = C:/xampp/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server="C:/xampp/mysql/bin/mysqld.exe"
#user=root
#password=
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby Sharley » 31. December 2008 04:32

...i have setup the root password.
Do i need to provide it in the my.cnf or i need to specify it in somewhere in the upgrade process?...
No, there is no place to add it, it is encrypted in MySQL when you created it any way - the password is not an issue at the moment.

Comment out the skip-bdb part as it is not contained in the new version my.cnf file which also gave an error.

Try uncommenting the innodb section back to the defaults for this exercise as it is this part that may be causing issues that are mentioned in the returned error message from the start bat file.

This is the defaults with the upgrade edit included, just copy and paste over yours and save the file then try and restart MySQL with the mysql_start.bat file again - as you noticed using the bat file to start components is much more helpful with it's returned error messages. ;)
Code: Select all
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/"
#innodb_log_arch_dir = "C:/xampp/mysql/"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
If that allows you to run the mysql_upgrade.exe file (also just try double clicking on this file from within the bin folder - no need to run from a console window) then after it is successful you can always comment out the innodb section again.

Fingers crossed. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 04:42

modifed, now it shows:

C:\xampp>mysql_start.bat
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 11:39:39 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
081231 11:39:40 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
081231 11:39:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
081231 11:39:40 [ERROR] mysql\bin\mysqld: unknown option '--skip-bdb'
081231 11:39:40 [ERROR] Aborting

081231 11:39:40 [Note] mysql\bin\mysqld: Shutdown complete


MySQL konnte nicht gestartet werden
MySQL could not be started
Press any key to continue . . .
C:\xampp>
C:\xampp>

C:\xampp\mysql\bin>mysql_upgrade.exe
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
C:\xampp\mysql\bin\mysqlcheck.exe: Got error: 2003: Can't connect to MySQL serve
r on 'localhost' (10061) when trying to connect
FATAL ERROR: Upgrade failed
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby Sharley » 31. December 2008 05:08

Groan!

Ok replace the innodb section with your original but leave this line commented out like so:
# Uncomment the following if you are NOT using BDB tables
# skip-bdb

This is what I get when I start MySQL from the start bat file in a vanilla 1.7 (no update):
Code: Select all
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait  ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 13:58:21  InnoDB: Started; log sequence number 0 46409
081231 13:58:21 [Note] Event Scheduler: Loaded 0 events
081231 13:58:21 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community'  socket: ''  port: 3306  MySQL Community Server (GPL)


Can you check in the Task Manager - right click on the Task Bar then select Task Manager>Proc
esses - look for any mysql file processes running, if you find any then select and click the End Process button and try again to start MySQL after returning the my or my.cnf file to pre edit stage.

Quick question, in the bin folder I only have a file that looks like a shortcut called my which is in reality the my.cnf file that I have to drag into a text editor to read and edit, is this the case in your bin folder?
Or do you have one or both my.cnf and a shortcut my file?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 05:15

seems it is working now, :D



C:\xampp>mysql_start.bat
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 12:12:49 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
081231 12:12:49 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
081231 12:12:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
081231 12:12:49 [ERROR] Can't open and lock privilege tables: Table 'mysql.serve
rs' doesn't exist
081231 12:12:49 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20
. Created with MySQL 50015, now running 50130. Please use mysql_upgrade to fix t
his error.
081231 12:12:49 [ERROR] mysql.user has no `Event_priv` column at position 29
081231 12:12:49 [ERROR] Cannot open mysql.event
081231 12:12:49 [ERROR] Event Scheduler: An error occurred when initializing sys
tem tables. Disabling the Event Scheduler.
081231 12:12:49 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)

but:

C:\xampp\mysql\bin>mysql_upgrade.exe
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
C:\xampp\mysql\bin\mysqlcheck.exe: Got error: 1045: Access denied for user 'root
'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed

how can i provide the password with upgrade?
Last edited by danielc on 31. December 2008 05:18, edited 1 time in total.
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 05:17

Sharley wrote:Quick question, in the bin folder I only have a file that looks like a shortcut called my which is in reality the my.cnf file that I have to drag into a text editor to read and edit, is this the case in your bin folder?
yes, this is the case, i have to use wordpad to open and edit it.
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby danielc » 31. December 2008 05:50

I have googled it and solved the problem,many thanks!
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby Sharley » 31. December 2008 05:53

danielc wrote:I have googled it and solved the problem,many thanks!
Do you mind telling the forum how you solved this problem so it closes this thread with a final successful result that it might help others, please?

BTW Notepad is a text editor and this should be used to edit any files in XAMPP not WordPad.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: cannot start mysql during upgrade

Postby danielc » 02. January 2009 03:43

Sharley wrote:
danielc wrote:I have googled it and solved the problem,many thanks!
Do you mind telling the forum how you solved this problem so it closes this thread with a final successful result that it might help others, please?

BTW Notepad is a text editor and this should be used to edit any files in XAMPP not WordPad.
Sure :D

The reason of using wordpad instead of notepad is notepad can't regconise the newline (\n) of the file, but wordpad can. i know it sounds strange as the history background of wordpad should be only edit windows's rtf. Anyway, it still works..
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: cannot start mysql during upgrade

Postby danielc » 02. January 2009 03:49

danielc wrote:seems it is working now, :D



C:\xampp>mysql_start.bat
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
081231 12:12:49 [Warning] option 'thread_stack': unsigned value 65536 adjusted t
o 131072
081231 12:12:49 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
081231 12:12:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
081231 12:12:49 [ERROR] Can't open and lock privilege tables: Table 'mysql.serve
rs' doesn't exist
081231 12:12:49 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20
. Created with MySQL 50015, now running 50130. Please use mysql_upgrade to fix t
his error.
081231 12:12:49 [ERROR] mysql.user has no `Event_priv` column at position 29
081231 12:12:49 [ERROR] Cannot open mysql.event
081231 12:12:49 [ERROR] Event Scheduler: An error occurred when initializing sys
tem tables. Disabling the Event Scheduler.
081231 12:12:49 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)

but:

C:\xampp\mysql\bin>mysql_upgrade.exe
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
C:\xampp\mysql\bin\mysqlcheck.exe: Got error: 1045: Access denied for user 'root
'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed

how can i provide the password with upgrade?


I have google it and found the options of using mysql_upgrade, - u [username] and - p
-p stands for using password

so it should be mysql_upgrade.exe -u root -p , if root have password,

This is the result from me:

C:\xampp\mysql\bin>mysql_upgrade.exe -u root -p
Enter password: ***********
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
Running 'mysqlcheck'...
cdcol.cds OK
font.font OK
gallery2.g2_accessmap OK
gallery2.g2_accesssubscribermap OK
gallery2.g2_albumitem OK
gallery2.g2_animationitem OK
gallery2.g2_cachemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_cachemap`" to fix
it!
gallery2.g2_childentity OK
gallery2.g2_comment OK
gallery2.g2_dataitem OK
gallery2.g2_derivative OK
gallery2.g2_derivativeimage OK
gallery2.g2_derivativeprefsmap OK
gallery2.g2_descendentcountsmap OK
gallery2.g2_entity OK
gallery2.g2_exifpropertiesmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_exifpropertiesmap
`" to fix it!
gallery2.g2_externalidmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_externalidmap`" t
o fix it!
gallery2.g2_factorymap OK
gallery2.g2_failedloginsmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_failedloginsmap`"
to fix it!
gallery2.g2_filesystementity
error : Table upgrade required. Please do "REPAIR TABLE `g2_filesystementity`
" to fix it!
gallery2.g2_group
error : Table upgrade required. Please do "REPAIR TABLE `g2_group`" to fix it
!
gallery2.g2_item
error : Table upgrade required. Please do "REPAIR TABLE `g2_item`" to fix it!

gallery2.g2_itemattributesmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_itemattributesmap
`" to fix it!
gallery2.g2_lock OK
gallery2.g2_maintenancemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_maintenancemap`"
to fix it!
gallery2.g2_mimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_mimetypemap`" to
fix it!
gallery2.g2_movieitem OK
gallery2.g2_permissionsetmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_permissionsetmap`
" to fix it!
gallery2.g2_photoitem OK
gallery2.g2_pluginmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginmap`" to fi
x it!
gallery2.g2_pluginpackagemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginpackagemap`
" to fix it!
gallery2.g2_pluginparametermap
error : Table upgrade required. Please do "REPAIR TABLE `g2_pluginparameterma
p`" to fix it!
gallery2.g2_ratingcachemap OK
gallery2.g2_ratingmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_ratingmap`" to fi
x it!
gallery2.g2_recoverpasswordmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_recoverpasswordma
p`" to fix it!
gallery2.g2_rssmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_rssmap`" to fix i
t!
gallery2.g2_schema
error : Table upgrade required. Please do "REPAIR TABLE `g2_schema`" to fix i
t!
gallery2.g2_sequenceid OK
gallery2.g2_sequencelock OK
gallery2.g2_sessionmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_sessionmap`" to f
ix it!
gallery2.g2_tkoperatnmap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnmap`" to
fix it!
gallery2.g2_tkoperatnmimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnmimetype
map`" to fix it!
gallery2.g2_tkoperatnparametermap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkoperatnparamete
rmap`" to fix it!
gallery2.g2_tkpropertymap OK
gallery2.g2_tkpropertymimetypemap
error : Table upgrade required. Please do "REPAIR TABLE `g2_tkpropertymimetyp
emap`" to fix it!
gallery2.g2_unknownitem OK
gallery2.g2_user
error : Table upgrade required. Please do "REPAIR TABLE `g2_user`" to fix it!

gallery2.g2_usergroupmap OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to f
ix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fi
x it!
mysql.help_relation OK
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix
it!
mysql.host OK
mysql.proc
error : Table upgrade required. Please do "REPAIR TABLE `proc`" to fix it!
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone
error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" to fix i
t!
mysql.time_zone_leap_second
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_leap_secon
d`" to fix it!
mysql.time_zone_name
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" to
fix it!
mysql.time_zone_transition
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition
`" to fix it!
mysql.time_zone_transition_type
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition
_type`" to fix it!
mysql.user OK
phpmyadmin.pma_bookmark OK
phpmyadmin.pma_column_info OK
phpmyadmin.pma_designer_coords OK
phpmyadmin.pma_history OK
phpmyadmin.pma_pdf_pages OK
phpmyadmin.pma_relation OK
phpmyadmin.pma_table_coords OK
phpmyadmin.pma_table_info OK
tutorial.user OK
webauth.user_pwd OK

Repairing tables
gallery2.g2_cachemap OK
gallery2.g2_exifpropertiesmap OK
gallery2.g2_externalidmap OK
gallery2.g2_failedloginsmap OK
gallery2.g2_filesystementity OK
gallery2.g2_group OK
gallery2.g2_item OK
gallery2.g2_itemattributesmap OK
gallery2.g2_maintenancemap OK
gallery2.g2_mimetypemap OK
gallery2.g2_permissionsetmap OK
gallery2.g2_pluginmap OK
gallery2.g2_pluginpackagemap OK
gallery2.g2_pluginparametermap OK
gallery2.g2_ratingmap OK
gallery2.g2_recoverpasswordmap OK
gallery2.g2_rssmap OK
gallery2.g2_schema OK
gallery2.g2_sessionmap OK
gallery2.g2_tkoperatnmap OK
gallery2.g2_tkoperatnmimetypemap OK
gallery2.g2_tkoperatnparametermap OK
gallery2.g2_tkpropertymimetypemap OK
gallery2.g2_user OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_topic OK
mysql.proc OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
Running 'mysql_fix_privilege_tables'...
OK
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Re: [Problem solved]cannot start mysql during upgrade

Postby danielc » 02. January 2009 03:55

After that by following the "howto" it should be logging on to the console to preform table repair. As i have setup root password , i added the -u and -p options of mysql.

so,it should be mysql -u root -h localhost -p

This is the result from me:

C:\xampp\mysql\bin>mysql -u root -h localhost -p
Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.1.30-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql>
mysql> use mysql;
Database changed
mysql> REPAIR TABLE `event`;
+-------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+--------+----------+----------+
| mysql.event | repair | status | OK |
+-------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql> REPAIR TABLE `help_category`;
+---------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+----------+
| mysql.help_category | repair | status | OK |
+---------------------+--------+----------+----------+
1 row in set (0.00 sec)

mysql> REPAIR TABLE `help_keyword`;
+--------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| mysql.help_keyword | repair | status | OK |
+--------------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql> REPAIR TABLE `help_topic`;
+------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------+
| mysql.help_topic | repair | status | OK |
+------------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql> REPAIR TABLE `proc`;
+------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------+--------+----------+----------+
| mysql.proc | repair | status | OK |
+------------+--------+----------+----------+
1 row in set (0.02 sec)

mysql> REPAIR TABLE `servers`;
+---------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| mysql.servers | repair | status | OK |
+---------------+--------+----------+----------+
1 row in set (0.00 sec)

mysql> REPAIR TABLE `time_zone_name`;
+----------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+----------+
| mysql.time_zone_name | repair | status | OK |
+----------------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql> quit;
Bye

C:\xampp\mysql\bin>mysql_upgrade.exe -u root -p
Enter password: ***********
Looking for 'mysql.exe' as: C:\xampp\mysql\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\xampp\mysql\bin\mysqlcheck.exe
This installation of MySQL is already upgraded to 5.1.30, use --force if you sti
ll need to run mysql_upgrade
danielc
 
Posts: 16
Joined: 30. December 2008 05:54

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 93 guests