Exporting selected rows in phpMyAdmin?

FerdieQO · Jan 30, 2017

I have a table 1500 rows and I want to export selected 80 rows from phpMyAdmin to import to another table. Is it possible to do this? can you guys guide me?

Dr. McKay · Jan 30, 2017

Clicking on rows you want to export and click export, you will have a .sql file and store it on your computer.

Exporting selected rows in phpMyAdmin 2.png

In this step, it will export rows from "your table" you chose

Exporting selected rows in phpMyAdmin 3.png

Back to the table you want to add extra rows and click on import

In the case you don't want to use this function to add extra rows from a file, opening .sql file and finding the command start with INSERT INTO...
For examples

Code:

--
-- Dumping data for table `wp_posts`
--

INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
(24, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '24', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=24', 31, 'nav_menu_item', '', 0),
(25, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '25', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=25', 36, 'nav_menu_item', '', 0),
(26, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '26', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=26', 32, 'nav_menu_item', '', 0),
(27, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '27', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=27', 33, 'nav_menu_item', '', 0);

and adding into SQL tab and click Go to run these queries
Selected rows will be added to your chosen tables.

Exporting selected rows in phpMyAdmin?

FerdieQO

Well-known member

Dr. McKay

Well-known member

Attachments

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud