sql import
I have a big problem
I exported my sql database from my previous xampp as the computer was in a bad way
I managed to export the database as a .sql file but the device then crashed and I cannot get any more data from it
When I try to import the .sql file into the latest WAMP on my pc using phpmyadmin I get the following errors and the table structure is all wrong
I have all the htdocs files from a backup but obviously I need the database tables
See attached files
127_0_0_1.sql
I exported my sql database from my previous xampp as the computer was in a bad way
I managed to export the database as a .sql file but the device then crashed and I cannot get any more data from it
When I try to import the .sql file into the latest WAMP on my pc using phpmyadmin I get the following errors and the table structure is all wrong
I have all the htdocs files from a backup but obviously I need the database tables
See attached files
127_0_0_1.sql
Last Comment
The error being reported suggests your MariaDB/MySQL table schema data was corrupt.
Glad you found a backup that worked!
Tip: Setup backups to dump + compress + save your database every night, then keep a few weeks or months of backups, so you always have at least 1x working backup.
Glad you found a backup that worked!
Tip: Setup backups to dump + compress + save your database every night, then keep a few weeks or months of backups, so you always have at least 1x working backup.
ASKER
Thanks David
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I have just located a sql dump which I managed to do only a few days ago - Phew111111111111
This was created using the mysql dump command
Imported successfully
I have no idea why the sql file (attached) exported using PHPMyAdmin was no good!