• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 748
  • Last Modified:

data from mysql

I had an old installation of wamp


C:\wamp\bin\mysql\mysql5.5.24\data

now when I replace data folder

C:\wamp\bin\mysql\mysql5.6.12\data

and restart computer
wamp does not run
0
rgb192
Asked:
rgb192
  • 4
  • 3
1 Solution
 
Dan CraciunIT ConsultantCommented:
You don't need to restart the computer. Just restart the MySQL server.

What is the error you get when trying to start MySQL?
0
 
rgb192Author Commented:
where would I see the wamp errors.

wamp icon turns orange
0
 
Dan CraciunIT ConsultantCommented:
Click on the WAMP icon, then go to MySQL->Service->Start/resume service.

If it fails to start, go to MySQL->MySQL log.
See here:
wamp mysql
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
rgb192Author Commented:
I stopped all services and attempted to start mysql service


2014-03-22 11:08:18 8776 [Note] Plugin 'FEDERATED' is disabled.
2014-03-22 11:08:18 8776 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 11:08:18 8776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-22 11:08:18 8776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-22 11:08:18 8776 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-22 11:08:18 8776 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 11:08:18 8776 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 11:08:18 8776 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 11:08:20 8776 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 11:08:20 8776 [Note] InnoDB: Waiting for purge to start
2014-03-22 11:08:20 8776 [Note] InnoDB: 5.6.12 started; log sequence number 1625977
2014-03-22 11:08:20 8776 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ce15b1fa-b1d3-11e3-8a71-00ff1a150f9f.
2014-03-22 11:08:20 8776 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-22 11:08:20 8776 [Note] IPv6 is available.
2014-03-22 11:08:20 8776 [Note]   - '::' resolves to '::';
2014-03-22 11:08:20 8776 [Note] Server socket created on IP: '::'.
2014-03-22 11:08:23 8776 [Note] Event Scheduler: Loaded 0 events
2014-03-22 11:08:23 8776 [Note] wampmysqld: ready for connections.
Version: '5.6.12-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2014-03-22 11:33:59 8776 [Note] wampmysqld: Normal shutdown

2014-03-22 11:33:59 8776 [Note] Giving 0 client threads a chance to die gracefully
2014-03-22 11:33:59 8776 [Note] Event Scheduler: Purging the queue. 0 events
2014-03-22 11:33:59 8776 [Note] Shutting down slave threads
2014-03-22 11:33:59 8776 [Note] Forcefully disconnecting 0 remaining clients
2014-03-22 11:33:59 8776 [Note] Binlog end
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'partition'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_METRICS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_CMP'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'INNODB_TRX'
2014-03-22 11:33:59 8776 [Note] Shutting down plugin 'InnoDB'
2014-03-22 11:33:59 8776 [Note] InnoDB: FTS optimize thread exiting.
2014-03-22 11:33:59 8776 [Note] InnoDB: Starting shutdown...
2014-03-22 11:34:00 8776 [Note] InnoDB: Shutdown completed; log sequence number 1625987
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'BLACKHOLE'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'ARCHIVE'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'MRG_MYISAM'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'MyISAM'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'MEMORY'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'CSV'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'sha256_password'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'mysql_old_password'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'mysql_native_password'
2014-03-22 11:34:00 8776 [Note] Shutting down plugin 'binlog'
2014-03-22 11:34:00 8776 [Note] wampmysqld: Shutdown complete

2014-03-22 11:34:39 5432 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Table 'mysql.plugin' doesn't exist
2014-03-22 11:34:39 5432 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-03-22 11:34:39 5432 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 11:34:39 5432 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-22 11:34:39 5432 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-22 11:34:39 5432 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-22 11:34:39 5432 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 11:34:39 5432 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 11:34:40 5432 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 11:34:41 5432 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=13245454
2014-03-22 11:34:41 5432 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-03-22 11:34:41 5432 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2014-03-22 11:34:49 5432 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2014-03-22 11:35:00 5432 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2014-03-22 11:35:00 5432 [Warning] InnoDB: New log files created, LSN=13245454
2014-03-22 11:35:00 5432 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 11:35:00 5432 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-03-22 11:35:01 5432 [Note] InnoDB: Tablespace and datafile system tables created.
2014-03-22 11:35:01 5432 [Note] InnoDB: Waiting for purge to start
2014-03-22 11:35:01 5432 [Note] InnoDB: 5.6.12 started; log sequence number 13245454
2014-03-22 11:35:01 5432 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8825317f-b1d7-11e3-8a89-00ff1a150f9f.
2014-03-22 11:35:01 5432 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-22 11:35:01 5432 [Note] IPv6 is available.
2014-03-22 11:35:01 5432 [Note]   - '::' resolves to '::';
2014-03-22 11:35:01 5432 [Note] Server socket created on IP: '::'.
2014-03-22 11:35:01 5432 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2014-03-22 11:48:16 6324 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Table 'mysql.plugin' doesn't exist
2014-03-22 11:48:16 6324 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-03-22 11:48:16 6324 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 11:48:16 6324 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-22 11:48:16 6324 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-22 11:48:16 6324 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-22 11:48:16 6324 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 11:48:16 6324 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 11:48:16 6324 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 11:48:17 6324 [Note] InnoDB: Log scan progressed past the checkpoint lsn 13245964
2014-03-22 11:48:17 6324 [Note] InnoDB: Database was not shutdown normally!
2014-03-22 11:48:17 6324 [Note] InnoDB: Starting crash recovery.
2014-03-22 11:48:17 6324 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-03-22 11:48:19 6324 [Note] InnoDB: Restoring possible half-written data pages 
2014-03-22 11:48:19 6324 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 13249625
2014-03-22 11:48:34 6324 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 233530, file name .\mysql-bin.000047
2014-03-22 11:48:37 6324 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 11:48:38 6324 [Note] InnoDB: Waiting for purge to start
2014-03-22 11:48:38 6324 [Note] InnoDB: 5.6.12 started; log sequence number 13249625
2014-03-22 11:48:40 6324 [Note] Recovering after a crash using mysql-bin
2014-03-22 11:48:40 6324 [Note] Starting crash recovery...
2014-03-22 11:48:40 6324 [Note] Crash recovery finished.
2014-03-22 11:48:50 6324 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-22 11:48:50 6324 [Note] IPv6 is available.
2014-03-22 11:48:50 6324 [Note]   - '::' resolves to '::';
2014-03-22 11:48:50 6324 [Note] Server socket created on IP: '::'.
2014-03-22 11:48:50 6324 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2014-03-22 11:52:21 4212 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Table 'mysql.plugin' doesn't exist
2014-03-22 11:52:21 4212 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-03-22 11:52:21 4212 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 11:52:21 4212 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-22 11:52:21 4212 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-22 11:52:21 4212 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-22 11:52:21 4212 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 11:52:21 4212 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 11:52:21 4212 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 11:52:21 4212 [Note] InnoDB: The log sequence numbers 13245454 and 13245454 in ibdata files do not match the log sequence number 13249635 in the ib_logfiles!
2014-03-22 11:52:21 4212 [Note] InnoDB: Database was not shutdown normally!
2014-03-22 11:52:21 4212 [Note] InnoDB: Starting crash recovery.
2014-03-22 11:52:21 4212 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-03-22 11:52:21 4212 [Note] InnoDB: Restoring possible half-written data pages 
2014-03-22 11:52:21 4212 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 233530, file name .\mysql-bin.000047
2014-03-22 11:52:22 4212 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 11:52:22 4212 [Note] InnoDB: Waiting for purge to start
2014-03-22 11:52:22 4212 [Note] InnoDB: 5.6.12 started; log sequence number 13249635
2014-03-22 11:52:22 4212 [Note] Recovering after a crash using mysql-bin
2014-03-22 11:52:22 4212 [Note] Starting crash recovery...
2014-03-22 11:52:22 4212 [Note] Crash recovery finished.
2014-03-22 11:52:22 4212 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-22 11:52:22 4212 [Note] IPv6 is available.
2014-03-22 11:52:22 4212 [Note]   - '::' resolves to '::';
2014-03-22 11:52:22 4212 [Note] Server socket created on IP: '::'.
2014-03-22 11:52:22 4212 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2014-03-22 15:21:13 6392 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Table 'mysql.plugin' doesn't exist
2014-03-22 15:21:13 6392 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-03-22 15:21:13 6392 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 15:21:13 6392 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-22 15:21:13 6392 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-22 15:21:13 6392 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-22 15:21:13 6392 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 15:21:13 6392 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 15:21:13 6392 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 15:21:13 6392 [Note] InnoDB: The log sequence numbers 13245454 and 13245454 in ibdata files do not match the log sequence number 13249635 in the ib_logfiles!
2014-03-22 15:21:13 6392 [Note] InnoDB: Database was not shutdown normally!
2014-03-22 15:21:13 6392 [Note] InnoDB: Starting crash recovery.
2014-03-22 15:21:13 6392 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-03-22 15:21:13 6392 [Note] InnoDB: Restoring possible half-written data pages 
2014-03-22 15:21:13 6392 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 233530, file name .\mysql-bin.000047
2014-03-22 15:21:14 6392 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 15:21:14 6392 [Note] InnoDB: Waiting for purge to start
2014-03-22 15:21:14 6392 [Note] InnoDB: 5.6.12 started; log sequence number 13249635
2014-03-22 15:21:14 6392 [Note] Recovering after a crash using mysql-bin
2014-03-22 15:21:14 6392 [Note] Starting crash recovery...
2014-03-22 15:21:14 6392 [Note] Crash recovery finished.
2014-03-22 15:21:14 6392 [Note] Server hostname (bind-address): '*'; port: 3306
2014-03-22 15:21:14 6392 [Note] IPv6 is available.
2014-03-22 15:21:14 6392 [Note]   - '::' resolves to '::';
2014-03-22 15:21:14 6392 [Note] Server socket created on IP: '::'.
2014-03-22 15:21:14 6392 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Open in new window

0
 
Dan CraciunIT ConsultantCommented:
Check that you have the folder C:\wamp\bin\mysql\mysql5.6.12\data\mysql and in it there are user.frm, user.MYD and user.MYI.

You can copy the whole \data\mysql from a fresh install of MySQL if the user tables are missing or damaged.
0
 
rgb192Author Commented:
I copied
\data\mysql\
into current \data

ran mysql (see your picture on how to run mysql from wamp)
http://filedb.experts-exchange.com/incoming/2014/03_w12/841302/wamp-mysql.png

and wamp icon changed color from red to orange


I think everything worked so I will close question.

Thank you.
0
 
rgb192Author Commented:
I have a related question about restoring usernames/passwords

http://www.experts-exchange.com/Database/MySQL/Q_28395073.html
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now