Solved

data from mysql

Posted on 2014-03-22
7
673 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
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.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

776 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