From now on I will make sure I have a back up but mysql crashed and I reinstalled it, which of course worked but now all i have is my old data folder to work with.
I moved the"app_name" folder and ibdata1 and got my tables and columns back but still get an error:
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Is there a file I can move from old data to restore this function/value? perhaps ib_logfile0?
what file will restore unique column?
2 years ago
2 years ago
#1
2 years ago
#2
Hello,
Found this.
https://stackoverflow.com/questions/12947668/where-does-mysql-store-database-files-on-windows-and-what-are-the-names-of-the-f
Dan
Found this.
https://stackoverflow.com/questions/12947668/where-does-mysql-store-database-files-on-windows-and-what-are-the-names-of-the-f
Dan
2 years ago
#3
Well after some looking I learned that not all tables have a unique identifier column and that simply enabling auto increment on an ID field would enable this.
This all started with a db crash, which seems to happen using xampp every couple weeks to me. In case this helps anyone I have learned that in the xampp/mysql/data folder is all the db's, tables, etc.
Each Trongate app has its own folder in here. After a crash restoring the necessary Trongate app folder along with ibdata and the two ib_logfiles along with files from backup in xampp/mysql/ do the trick
This all started with a db crash, which seems to happen using xampp every couple weeks to me. In case this helps anyone I have learned that in the xampp/mysql/data folder is all the db's, tables, etc.
Each Trongate app has its own folder in here. After a crash restoring the necessary Trongate app folder along with ibdata and the two ib_logfiles along with files from backup in xampp/mysql/ do the trick
2 years ago
#4
Hi Fin,
Glad you sorted that out. I too had a database crash and learnt a lot from it. Can you tell me what OS you are running (Windows, Mac or Linux?) Is it MySQL or MariaDB? There are several recovery tools in the bin folder of 'xampp/mysql/bin'. You are correct that all the databases are kept in 'xampp\mysql\data' and the 'ibdata1' file is the index for all valid databases, if this file is corrupted you are in a bit of a pickle. I'm not sure why this corruption is happening to you regularly, maybe you are not shutting down the database correctly or your hard/ sd drive might be corrupting the data.
I'm on Windows, and have setup an automated daily backup that executes this script I created:It backs up all my local databases in separate folders and found it invaluable - you are quite welcome to use it.
Enjoy!
ps. 'xampp/mysql/bin' needs to be in your path
Glad you sorted that out. I too had a database crash and learnt a lot from it. Can you tell me what OS you are running (Windows, Mac or Linux?) Is it MySQL or MariaDB? There are several recovery tools in the bin folder of 'xampp/mysql/bin'. You are correct that all the databases are kept in 'xampp\mysql\data' and the 'ibdata1' file is the index for all valid databases, if this file is corrupted you are in a bit of a pickle. I'm not sure why this corruption is happening to you regularly, maybe you are not shutting down the database correctly or your hard/ sd drive might be corrupting the data.
I'm on Windows, and have setup an automated daily backup that executes this script I created:It backs up all my local databases in separate folders and found it invaluable - you are quite welcome to use it.
Enjoy!
ps. 'xampp/mysql/bin' needs to be in your path