Importing databases and tables with phpMyAdmin

phpMyAdmin series

8. Importing databases and tables with phpMyAdmin

This tutorial assumes you've already logged in to phpMyAdmin

Now let's learn how to import a database

Click the database you wish to import here
FutureHosting Best Hosting in Ireland - Importing databases and tables with phpMyAdmin

Let's assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data.

Therefore, let's first delete the existing details table from our database
FutureHosting Best Hosting in Ireland - Importing databases and tables with phpMyAdmin

Now let's import the saved copy of our database, which includes the details table
FutureHosting Best Hosting in Ireland - Importing databases and tables with phpMyAdmin
FutureHosting Best Hosting in Ireland - Importing databases and tables with phpMyAdmin

That's it! The demo1234_members database has been successfully imported, as indicated here.
FutureHosting Best Hosting in Ireland - Importing databases and tables with phpMyAdmin

This is the end of the tutorial. You now know how to import databases and tables using phpMyAdmin

Ця відповідь Вам допомогла?

 Роздрукувати цю статтю

Також прочитайте

Copying a database table with phpMyAdmin

phpMyAdmin series 12. Copying a database table with phpMyAdmin This tutorial assumes you've...

Modifying fields in database tables with phpMyAdmin

phpMyAdmin series 5. Modifying fields in database tables with phpMyAdmin This tutorial assumes...

Running SQL queries on a database with phpMyAdmin

phpMyAdmin series 9. Running SQL queries on a database with phpMyAdmin This tutorial assumes...

Deleting fields from database tables with phpMyAdmin

phpMyAdmin series 6. Deleting fields from database tables with phpMyAdmin This tutorial assumes...

Deleting tables from a database with phpMyAdmin

phpMyAdmin series 3. Deleting tables from a database with phpMyAdmin This tutorial assumes...