How to load a sql file into MySql

It's very simple thanks to pipes.

mysql -u username -p < sqlfile.sql

Make sure your sql file has a "use database" line.

Posted 02/06/2010

blog comments powered by Disqus

My primary blog My computer science blog My data mining blog
Windows Flush DNS Insert a line of text to the top of a file wget don't save file ls color scheme Dump MySQL schema only gca alias for faster git Recursive ls vim macros pwd while in a symlink directory Case sensitivity in MySQL table names and lower_case_table_names ANSI or ASCII and Unicode or UTF-8 and Newlines The BASH Programming Language Cygwin Error: Could not resolve hostname X: Non-recoverable failure in name resolution Plugins for Notepad++ More tips on using rsync to deploy your website Linux Go Back to Previous Directory Should your source code be in one folder or should it be nested? Bug Workaround for JS Charts Error: Not enough data to display chart Change the file owner or group in Linux How to load a sql file into MySql Shortcut for switching to a Windows directory in Cygwin Cygwin treats the Windows Clipboard like a file New tricks in Vim Use cat to combine or print the contents of a file Pipes, standard output and standard input Run multiple commands at once The only 5 git commands you need to know Use scp to download a file from a server Clear screen in cygwin Use sed to find and replace Unix date command Bash variables How to fix an overwhelmed Gmail Accout Seven aliases that can save you time List only directories using ls Turn off bell in cygwin git clone without history Learn Symbolic Links in 30 seconds Create a new user in Linux Use aliases to save time How I organize my Dropbox Use git to get the latest source code only What non-web software do you use the most? Fix permission problems using chmod Use the linux find command to find files cron in 2 steps Use grep to search multiple files at once Use rsync to deploy your website SSH into your server without a password Get VIM Working in Cygwin About this Blog
RSS Admin
Coupon Bill - my side project