Solved

data from mysql

Posted on 2014-03-22
7
679 Views
Last Modified: 2014-03-22
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
Comment
Question by:rgb192
  • 4
  • 3
7 Comments
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39947640
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
 

Author Comment

by:rgb192
ID: 39947800
where would I see the wamp errors.

wamp icon turns orange
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 39947807
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:rgb192
ID: 39947830
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
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39947835
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
 

Author Closing Comment

by:rgb192
ID: 39947970
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
 

Author Comment

by:rgb192
ID: 39948002
I have a related question about restoring usernames/passwords

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question