MySQL Advance Go Back DATABASE IMPORT views 02:14 MySQL IMPORT capability allows to restore lost or corrupt data. It also allows you to recover older copies of your database in case of an emergency. We have seen how to export database earlier. In this section, we will see how to retrieve data (IMPORT) from exported files. Let us first drop database before we start IMPORT. Before we start IMPORT, we will have to create blank database with same name. SHOW TABLES command returns empty set which means there are no tables available in the database inventory. REGEXP: Transactions, ALTER Command Transactions Indexes:Temporary Tables, Clone Tables, Database Info USING SEQUENCES: HANDLING DUPLICATES, SQL INJECTION DATABASE EXPORT: PHP SYNTAX, DATABASE IMPORT Hypertext Processor DATABASE IMPORT