Resolve problem of MySQL on XAMPP

7:47:48 PM  [mysql] Error: MySQL shutdown unexpectedly.

7:47:48 PM  [mysql] This may be due to a blocked port, missing dependencies, 

7:47:48 PM  [mysql] improper privileges, a crash, or a shutdown by another method.

7:47:48 PM  [mysql] Press the Logs button to view error logs and check

7:47:48 PM  [mysql] the Windows Event Viewer for more clues

7:47:48 PM  [mysql] If you need more help, copy and post this

7:47:48 PM  [mysql] entire log window on the forums

___________________________________________________________________________

2023-06-23 19:47:48 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 17424

2023-06-23 19:47:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2023-06-23 19:47:48 0 [Note] InnoDB: Uses event mutexes

2023-06-23 19:47:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.12

2023-06-23 19:47:48 0 [Note] InnoDB: Number of pools: 1

2023-06-23 19:47:48 0 [Note] InnoDB: Using SSE2 crc32 instructions

2023-06-23 19:47:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2023-06-23 19:47:48 0 [Note] InnoDB: Completed initialization of buffer pool

2023-06-23 19:47:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2023-06-23 19:47:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2023-06-23 19:47:48 0 [Note] InnoDB: Setting file 'D:\xampp8\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2023-06-23 19:47:48 0 [Note] InnoDB: File 'D:\xampp8\mysql\data\ibtmp1' size is now 12 MB.

2023-06-23 19:47:48 0 [Note] InnoDB: Waiting for purge to start

2023-06-23 19:47:49 0 [Note] InnoDB: 10.4.28 started; log sequence number 4909603; transaction id 5570

2023-06-23 19:47:49 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp8\mysql\data\ib_buffer_pool

2023-06-23 19:47:49 0 [Note] Plugin 'FEEDBACK' is disabled.

2023-06-23 19:47:49 0 [Note] InnoDB: Buffer pool(s) load completed at 230623 19:47:49

2023-06-23 19:47:49 0 [Note] Server socket created on IP: '::'.

AND How to resolve this problem is:

Go to xampp/mysql directory

Rename the /data folder to /data_old

Copy the /backup folder and paste in same place

Rename the /backup_copy folder to /data

Go to /data_old folder and copy all your database folder expect phpmyadmin, mysql, performance_schema

Go to /data folder and paste all database folder copied from /data_old

Go to /data_old folder again and copy ibdata1 file

Go to /data folder again and paste ibdata1 file here

Restart MySQL button server again. twice in my case to make it work.

How to copy files fast over network or LAN using cmd robocopy on Windows

Before run robocopy, you must know source and destination network or LAN

open CMD and run

ex copy 

from D:\

to \\YOUR-PC\D\

robocopy D:\ \\YOUR-PC\D\ /E /Z /ZB /XO /R:5 /W:5 /TBD /NP /V /MT:16

Notes:

/E — Copy Subdirectories, including empty ones.

/Z — Copy files in restart-able mode.

/ZB — Uses restart-able mode. If access is denied, use backup mode.

/XO — Exclude files that are older than those they're being copied over (skip for existing files)

/R:5 — Retry 5 times (you can specify a different number, the default is 1 million).

/W:5 — Wait 5 seconds before retrying (you can specify a different number, the default is 30 seconds).

/TBD — Wait for share names To Be Defined (retry error 67).

/NP — No Progress – don’t display percentage copied.

/V — Produce verbose output, showing skipped files.

/MT:16 — Do multithreaded copies with n threads (default is 8).

/compress — Enables SMB compression to speed up transfers over the network.

Modul dan Sistem informasi aplikasi Berbasis web full source code framework Codeigniter

 7 Paket dan 3 Paket Modul dan Sistem informasi aplikasi Berbasis web full source code framework Codeigniter versi 3

Kami menyediakan sistem aplikasi berbasis web dengan framework codeigniter. 3 modul masuk dalam 7 folder controller, model dan view.

Kami akan kirimkan link contoh aplikasi via chat.

Jika ada pengiriman, itu hanya amplop link coding. Namun jika sudah ACC tanpa pengiriman, maka segera untuk klik Selesaikan pesanan dan kami harapkan bintang 5

kunjungi dan chat kami untuk informasi lebih lanjut. jangan lupa nantikan versi 9 Paket CI.

Welcome to CodeIgniter!

The page you are looking at is being generated dynamically by CodeIgniter.

If you would like to edit this page you'll find it located at:

application/views/welcome_message.php

The corresponding controller for this page is found at:

application/controllers/Welcome.php

BERIKUT 3 PILIHAN MODUL APLIKASI SISTEM INFORMASI BERBASIS WEB FRAMEWORK CODEIGNITER VERSI 3

- Aplikasi Hak Akses

- Aplikasi Log Activity

- Aplikasi Ajax dan SSP(Server Side Processing)

BERIKUT 7 PILIHAN MODUL APLIKASI SISTEM INFORMASI BERBASIS WEB FRAMEWORK CODEIGNITER VERSI 3

- Aplikasi User/ Pengguna

- Aplikasi Hak Akses

- Aplikasi Log Activity

- Aplikasi Ajax dan SSP(Server Side Processing)

- Aplikasi Laporan Document (Upload Excel - Print Pdf)

- Aplikasi Wisuda

- Aplikasi Inventory (Purchasing, Gudang, Produksi, Finish Good)

* Ubah application/config/routes -> $route['default_controller'] = 'welcome'; sesuai dengan aplikasi yang akan anda tuju menjadi indeks

try it

Full source code

free and bayar

https://shope.ee/AyXGy1x4c 

<?php

defined('BASEPATH') or exit('No direct script access allowed');

/*

| -------------------------------------------------------------------------

| URI ROUTING

| -------------------------------------------------------------------------

| This file lets you re-map URI requests to specific controller functions.

|

| Typically there is a one-to-one relationship between a URL string

| and its corresponding controller class/method. The segments in a

| URL normally follow this pattern:

|

|   example.com/class/method/id/

|

| In some instances, however, you may want to remap this relationship

| so that a different class/function is called than the one

| corresponding to the URL.

|

| Please see the user guide for complete details:

|

|   http://codeigniter.com/user_guide/general/routing.html

|

| -------------------------------------------------------------------------

| RESERVED ROUTES

| -------------------------------------------------------------------------

|

| There are three reserved routes:

|

|   $route['default_controller'] = 'welcome';

|

| This route indicates which controller class should be loaded if the

| URI contains no data. In the above example, the "welcome" class

| would be loaded.

|

|   $route['404_override'] = 'errors/page_missing';

|

| This route will tell the Router which controller/method to use if those

| provided in the URL cannot be matched to a valid route.

|

|   $route['translate_uri_dashes'] = FALSE;

|

| This is not exactly a route, but allows you to automatically route

| controller and method names that contain dashes. '-' isn't a valid

| class or method name character, so it requires translation.

| When you set this option to TRUE, it will replace ALL dashes in the

| controller and method URI segments.

|

| Examples: my-controller/index -> my_controller/index

|       my-controller/my-method -> my_controller/my_method

*/

$route['default_controller'] = 'welcome';

$route['akses'] = 'akses/home';

$route['users'] = 'users/home';

$route['log'] = 'log/home';

$route['ssp'] = 'ssp/home';

$route['doc'] = 'doc/home';

$route['wisuda'] = 'wisuda/home';

$route['inventory'] = 'inventory/home';

$route['404_override'] = 'My404';

$route['translate_uri_dashes'] = TRUE;