Note to self: Import MySQL dumpfile
I wonder how many times I have searched google on how to correctly import a MySQL dumpfile through a command line.
mysql -p -h DBSERVER dbname < dbname.sql
___ ___ ___ ___ ___
/\ \ /\__\ /\ \ /\ \ ___ /| |
\:\ \ /:/ _/_ \:\ \ /::\ \ /\ \ |:| |
\:\ \ /:/ /\__\ \:\ \ /:/\:\__\ \:\ \ |:| |
___ /::\ \ /:/ /:/ _/_ _____\:\ \ /:/ /:/ / /::\__\ __|:| |
/\ /:/\:\__\ /:/_/:/ /\__\ /::::::::\__\ /:/_/:/__/___ __/:/\/__/ /\ |:|__|____
\:\/:/ \/__/ \:\/:/ /:/ / \:\~~\~~\/__/ \:\/:::::/ / /\/:/ / \:\/:::::/__/
\::/__/ \::/_/:/ / \:\ \ \::/~~/~~~~ \::/__/ \::/~~/~
\:\ \ \:\/:/ / \:\ \ \:\~~\ \:\__\ \:\~~\
\:\__\ \::/ / \:\__\ \:\__\ \/__/ \:\__\
\/__/ \/__/ \/__/ \/__/ \/__/
H U S S F E L T . N E T
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[www@henrik ~]$ blog -13
I wonder how many times I have searched google on how to correctly import a MySQL dumpfile through a command line.
mysql -p -h DBSERVER dbname < dbname.sql