php - How to create a table in MySQL from the sql dump of a table taken from other database instance? -


i'm using mysql via phpmyadmin.

i've exported 1 table 1 database instance in mysql.

now want create same table data instance of mysql database downloaded sql dump.

can create it? if yes, how? if no, why?

you have import dump database done terminal using

mysql -u<username> -p<password> <database> < <dump.sql>  

assuming dump file contains create table query , associated data table or table exist in database.

you phpmyadmin.

  1. first select database
  2. click import button
  3. select file import clicking file import
  4. finally click go start import

Comments

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -