Posts

Showing posts with the label importing

Script for creating html bookmarks file for Chrome to import

#!/bin/bash # # Run this script on a file named urls.txt with all your URLs and pipe the output to an HTML file. # Example: ./convert_url_file.sh > bookmarks.html echo "<!DOCTYPE NETSCAPE-Bookmark-file-1>" echo '<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">' echo '<TITLE>Bookmarks</TITLE>' echo '<H1>Bookmarks</H1>' echo '<DL><p>'   cat urls.txt |   while read L; do     echo -n '    <DT><A HREF="';         echo ''"$L"'">'"$L"'</A>';   done echo "</DL><p>"    

Loading (importing) an .sql mysql dumpfile and showing progress bar

When loading and importing a large .sql mysql dump file and you wish to know how long is it going to take and where does the process status is standing using a progress bar from the mysqldump loading you can us pv (pipe viewer) For example: pv sqldumpfile.sql | mysql database name About pv (pipe viewer) utility for Linux: