<div>
Ok folks<br>I have just located a sql dump which I managed to do only a few days ago - Phew111111111111<br>This was created using the mysql dump command<br>Imported successfully<br>I have no idea why the sql file (attached) exported using PHPMyAdmin was no good!
</div>


Ok folks
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!

<div>
The error being reported suggests your MariaDB/MySQL table schema data was corrupt.<br />
<br />
Glad you found a backup that worked!<br />
<br />
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.
</div>


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.

Tech

doctorbill

<div>
<div class="content wysiwyg-content fr-view">
I have a big problem<br>I exported my sql database from my previous xampp &nbsp;as the computer was in a bad way<br>I managed to export the database as a .sql file but the device then crashed and I cannot get any more data from it<br>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<br>I have all the htdocs files from a backup but obviously I need the database tables<br>See attached files<a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569330/columns-in-phpmyadmin.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569330/columns-in-phpmyadmin.png" class="fr-fic fr-dib"></a><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569331/import-error-message.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569331/import-error-message.png" class="fr-fic fr-dib"></a><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569332/127_0_0_1.sql" rel="ugc">127_0_0_1.sql</a>
</div>
</div>


columns-in-phpmyadmin.png

import-error-message.png

127_0_0_1.sql


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

sql import

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.

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.