☠ MASQ ☠

Test your restores, not your backups...

Bill Prew

Data Specialist

Patricia Timm

<div>
<div class="content wysiwyg-content">
imported an excel file (csv) into a database. IS there any way to cancel the data import. Someone accidentally imported a batch file into a mysql database. They imported client ids and choose the wrong client on the drop down when importing. The tables are modified as well. I am not familar with the setup of the tables as this is not my area. Would I have to go into the backups and take earlier copy ? In addition, the database was updated throughout the day so a backup would override updates. . I can view the front end of mysql how can I view the backend and get to the workbench if I need to query the database for these records? Thanks in advance Any ideas on how to resolve this erroneous excel import?
</div>
</div>


imported an excel file (csv) into a database. IS there any way to cancel the data import. Someone accidentally imported a batch file into a mysql database. They imported client ids and choose the wrong client on the drop down when importing. The tables are modified as well. I am not familar with the setup of the tables as this is not my area. Would I have to go into the backups and take earlier copy ? In addition, the database was updated throughout the day so a backup would override updates. . I can view the front end of mysql how can I view the backend and get to the workbench if I need to query the database for these records? Thanks in advance Any ideas on how to resolve this erroneous excel import?

imported an excel file (csv) into a database. IS there any way to cancel the data import.

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.