Solved

data from mysql

Posted on 2014-03-22
7
688 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
The viewer will learn how to count occurrences of each item in an array.
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…

617 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