Solved

data from mysql

Posted on 2014-03-22
7
665 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 34

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 34

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 34

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now