Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to fix mysql stop unexpectedly

How to fix MySQL shutdown unexpectedly
Note: If you don’t do following very carefully there are chances you can lose your databases. So be very careful to follow point 1.

1. Rename the folder xampp/mysql/data to xamppmysql/data_bk
2. Create a new folder xampp/mysql/data
3. Copy the content that resides in xampp/mysql/backup to the new mysql/data folder
4. Copy all your database folders that are in xamppmysql/data_bk to xampp/mysql/data
   Important: Do not copy the mysql, performance_schema, and phpmyadmin folders from xampp/mysql/data_bk
5. Finally copy the ibdata1 file from xampp/mysql/data_bk and replace it inside xampp/mysql/data folder
Start MySQL from XAMPP control panel
Comment

PREVIOUS NEXT
Code Example
Sql :: python sqlalcahmey compare datetime using AND_ or OR_ 
Sql :: mysql auto increment jumping 
Sql :: How to fix a collation conflict in a SQL Server query 
Sql :: pl/pgsql declare variable 
Sql :: get last query in codeigniter 4 
Sql :: sqlite closes value 
Sql :: contact mysql column field 
Sql :: install package for sqlserver in asp.net core 
Sql :: difference between nvl and nvl2 in oracle 
Sql :: MySQL - How to find word with the most similar beginning 
Sql :: oracle chain step succeeded 
Sql :: SQL Copy Table Schema Only 
Sql :: crear usuario oracle 
Sql :: oracle create job if not exists 
Sql :: mysql vs sql server performance benchmark 
Sql :: laravel How to find the password of mysql on desktop docker in laravel 
Sql :: opensuse stop MySQL 
Sql :: sql update table one column 
Sql :: table values functions in SQL 
Sql :: mysql_error replacement 
Sql :: multiple value select mysql 
Sql :: sqlalchemy sequence postgresql 
Sql :: what is group function in sql 
Sql :: union and union all 
Sql :: is not null mysql 
Sql :: fatal database postgres does not exist 
Sql :: pl sql call web service 
Csharp :: c# get current directory 
Csharp :: how to make c# open brower 
Csharp :: c# find start and end of month from object date 
ADD CONTENT
Topic
Content
Source link
Name
1+7 =