artodeto's blog about coding, politics and the world | Entries tagged as import

Skip to content

Entries tagged as import

Related tags

cli apress arch linux arguments autocomplete backport bash bazzline book classmap client combine component composer console convert csv daramtiq dbms debian debian 6 dramatiq dtrace english file manager filesystem fix free as in freedom free software generator git github github.com gpl gui howto imagemagick link linux locator message_queue module multiboot mysql nas open source opensolaris opensource operation system packagist php php 5.3 phpunit posix private project propel python readline rest security server shell signal handler smf soap ssh sshfs svn symfony tool tr typer unix usb stick valkey vcf vi vim virtual box web wsdl zend framework zend framework 2 zfs zones ajax cifs error solving javascript proxy 1080p 32c3 acta activedirectory addon advertisement algorithm alias alternativlos amazon android anonymous function ansible antifragile software apache apache-ant apt-get aptitude arch architecture archlinux archzfs arduino arm array array_replace attraktor audio aur ausbeutung auth autoloading avc awareinterface backend backup bankster bash. howto behavior beta bios blog bounce management bridged broken browser brüsselokratie buffer buffer manipulation bug bürgerüberwachung business model c++ cache caldav car ccc checksum chrome client-server closures cloud cms code coding standard com command component github.com composer nyancat conference congress constants couchdb count create_function cronjob crypto cryptome.org cubox cups curl dac daily data management data mapper database datamining date datenschutz datetime debug debugger debugging decorator delete Demokratie demonstration dependency injection dependentinterface design pattern design patterns desktopmanager deutsch deutschland development devop diff diskspace dkms docker domain driven domain driven design domain model donate donation dpkg dummheit email emscripten encoding energie error erziehung europa event event driven example exploit export extension extract files facebook fcc feature fedora fefe fight for the future file file synchronization filesytem filter filtering finanzindustrie find firefox firefox os fluxbox flyway fork framework free bsd freeze freifunk frontend froscon fsf function gadgat game gdm gentoo german gesetz gnupg goals goldene mitte google gpt gpu grep grub gtk guest hack hackfressenbuch hacking hamburg hardened hardware hardware database HaXe hdd hdmi heartbeat help helper hhvm holiday holoiso host hosts housekeeping html html 5 httpd https i3wm illumos image tool improvement independent infrastructure initiative injectinterface innodb installer intel interface internet explorer interval iso it java jenkins jquery json kde kde active plasma kernel kernel howto kgraft kickstart kvm laf lambda function language lantern law leanpub led leedtime legacy code lenovo lgplv3 library limit limit manager link docker link zend framework 2 link. opensource links live_cd lobby locale lock log level log level weight log request log4php logger luks lvm lxc mac machtwahn mail maintenance mariadb markdown marketing marktfreie mattermost mbr meego meetup meinungsfreiheit memory mempo milax mindworks mint mkdir mobile device mock modelstorm monitoring monsanto mootools framework mozilla multilingual multimedia music musikpiraten mysql cluster replication netbeans network networkmanager neutralität nextcloud nosql note notes notion nsa ntpd number ohloh.net openbox openelec openjdk openssl openzfs orm owncloud p2p packagemanager packages packagist.org pacman pair programming partition pcmanfm pear pentadactyl percona performance perl5 permission pgp phantomjs phar php 5.4 php user group php.usergroup php5 phpcs phpstorm phpug phpughh ping pipeline piwik plugin podman policy politik pollution portable application powershell printer privacy process process fork manager profile programming language proxy logger psr logger psr standard psr-3 logger quake raspberry pi raspberrypi recession redis refactoring regex release replace report requirement return path rpc rsync rust scaling schwarzraubmordnazikommunistenterrorkopierer screenshoot search search engine sed selinux serendipity services sha1 shadow copy shellscripting shibboleth shutdown slides smart smarty smtp snapshot snippet sorting soziale verantwortung sozialverhalten specification spl splitter ssd ssl/tls steam steuerveruntreuung storage storage management string sudo syncthing synergy systemd systemV tablet tabs tag talk talks tanenbaum targeted te team teamviewer template terminator test test proxies testcase themes thinkpad thread thunderbird tizen tmpfiles.d tomcat tool.bazzline.net totalüberwachung translation true story ttip tubaf tutorial type hint uberspace überwachungsstaat udev uefi ultra-low-cost computer uml unit test unittest unrar update upgrade usb useability user management usergroup usort uuid validator ventoy view helper virtual reality virtualizationm qubes os visual vorratsdatenspeicherung vote web. link webbrowser webperformance webservice website weltenretter weltenvebesserer weltenverbesserer weltenzerstörer windowmanager windows windows 7 wireshark working with strings wxwidgets x11 xbmc xfce4 xml xrandr xserver yaml zabbix zenburn microsoft windows terminal zend framework controller plugin zendframework zendframework2 zfsonlinux zpool phpmyadmin time

mysql import big *.sql files using the cli

Posted by artodeto on Sunday, August 21. 2011

If you need to import big \*.sql files into your mysql dbms, just log in using the cli support on your shell.

mysql - u -p

After that, change to your database ("show databases;" and "use mydatabase") and use the following command to insert the *.sql file.

>mysql source /path/to/source.sql