2. Restore the backup file to the database and then retrieve the table via the database<\/strong><\/p>\n However, as the data in the database increases, the first method can cause the editor application to hang if the backup file size is too large, then the second method is less effective and very time-consuming because restoring a backup file can take approximately 1 hour.<\/p>\n Here are the steps to extract a table from the mysqldump backup file: 2. Determine the mysql backup file you want to extract, for example you can use northwind.sql which is included in the bundle link below.<\/strong><\/p>\n 3. Type the following command in the command prompt<\/strong><\/p>\n grep -n “Table structure” “northwind.sql”<\/p>\n Explanation: the above command prints the line number of the search for the word “Table structure”<\/p>\n 4. Determine which table you want to extract, in this example the employees table and type the following command:<\/strong><\/p>\n sed -n “129.168 p” “northwind.sql” > tmp.sql<\/p>\n Explanation: the above command sends output to a file with the name tmp.sql from the northwind.sql file with the provisions of rows from 129 to 168. Notice in the picture, the employees table is on line 129 then the next table employeeterritories is on line 169.<\/p>\n 5. Restore the employees table in the tmp.sql file to the mysql database<\/strong><\/p>\n Here are the tools grep and sed that have been downloaded plus an example of a mysql dump backup file. This tutorial has been successfully practiced on computers with the following specifications:
\n1. Download additional tools, namely Grep and Sed.<\/strong><\/p>\n![\"Grep](\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2011\/05\/grep1.jpg\")
<\/p>\n
\nDownload<\/a>
\nAfter downloading, change the file extension to 7z and extract the file using Winrar or 7zip. good luck<\/p>\n
\n– OS Windows XP
\n– 1gb ram memory
\n– mysql 5.0.17<\/p>\n
![Download<\/a>\nAfter downloading, change the file extension to 7z and extract the file using Winrar or 7zip. good luck<\/p>\nThis tutorial has been successfully practiced on computers with the following specifications:\n– OS Windows XP\n– 1gb ram memory\n– mysql 5.0.17<\/p>\nOh, I didn’t forget to include the original link<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Starting from the difficulties I experienced, when I wanted to retrieve a table from a large mysqldump backup file… which was around 500mb and above, while the conventional method was too time-consuming even though...<\/p>\n","protected":false},"author":1,"featured_media":288,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,14],"tags":[11,82],"class_list":["post-273","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-komputer","category-recommended","tag-database","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t](\"https:\/\/www.bagi2info.com\/wp-content\/uploads\/2011\/05\/extract-single-table.jpg\"){kind=link}