Error: MySQL shutdown unexpectedly. | ib_buffer_pool' for reading: No such file or directory





2020-04-09 17:25:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-09 17:25:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-09 17:25:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-09 17:25:56 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09 17:25:56 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-09 17:25:56 0 [Note] InnoDB: Waiting for purge to start
2020-04-09 17:25:56 0 [Note] InnoDB: 10.3.15 started; log sequence number 1603190; transaction id 9
2020-04-09 17:25:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-09 17:25:56 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
2020-04-09 17:25:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-09 17:25:56 0 [Note] Server socket created on IP: '::'.
2020-04-09 17:25:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-09 17:25:57 0 [Note] InnoDB: Uses event mutexes
2020-04-09 17:25:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-09 17:25:57 0 [Note] InnoDB: Number of pools: 1
2020-04-09 17:25:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-09 17:25:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-09 17:25:57 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-09 17:25:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2020-04-09 17:25:57 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2020-04-09 17:25:57 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2020-04-09 17:26:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-09 17:26:02 0 [Note] InnoDB: Uses event mutexes
2020-04-09 17:26:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-09 17:26:02 0 [Note] InnoDB: Number of pools: 1
2020-04-09 17:26:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-09 17:26:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-09 17:26:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-09 17:26:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
2020-04-09 17:26:02 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
2020-04-09 17:26:02 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
2020-04-09 17:26:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-09 17:26:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-09 17:26:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-09 17:26:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-09 17:26:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-09 17:26:03 0 [Note] InnoDB: Waiting for purge to start
2020-04-09 17:26:03 0 [Note] InnoDB: 10.3.15 started; log sequence number 1603190; transaction id 9
2020-04-09 17:26:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-09 17:26:03 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
2020-04-09 17:26:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-09 17:26:03 0 [Note] Server socket created on IP: '::'.




I solved using below method.


1. Go to xampp\mysql\backup and copy all files

2. Paste the files on C:\xampp\mysql\data replace and continue.
Read More

SSH: Copy a folder SSH COMMAND 

cp -R folder_name/ folder_new_location_backup/
Read More

LOG MySQL Queries to check running. (SHOW VARIABLES SET GLOBAL general_log = 'ON'; SET GLOBAL general_log = 'OFF'; )



SHOW VARIABLES LIKE "general_log%";
SET GLOBAL general_log = 'ON';
SET GLOBAL general_log = 'OFF';
Read More

AngularJs - Adding initial value to input 





  <input type='text' class='frm-input' ng-model='customer.UserId' ng-init="customer.UserId = profile[0].UserID">
Read More

How to create a Hotspot using your PC or a laptop, for you to connect your phone to share internet access.



I was looking a wifi Hotspot using PC/Laptops in windows based, because i need to share my PC/laptop's internet to my phone.I don't have any  Access Point or a wireless router, so as usual Hi Google!
I started turn over and over in searching these keywords  "How to share my PC or Laptop internet", "How to create hotspot using windows", click next and next and next! Then I found one, name is Connectify I use it in a few days only due to licensing issue.




Then, when Connectify say Need to buy license
(I was shocked i dont have money! lolz.).
Again, Have a nice day Google,
then finally I found the best one the "MyPublicWifi".
Anyway I love you Google so much, your my savior.


Link:http://www.mypublicwifi.com/publicwifi/en/index.html

I hope this article helps, Thank you.


Read More
Subscribe to: Comments (Atom)