Shulou(Shulou.com)06/01 Report--

In my usual work, I need to import and export databases. For general small databases, we always use phpmyadmin,navcate to visualize the operation, but how to operate in linux? what command line do we use?

1. Import operation of database, use source command: Mysql > Use databasename; Mysql > Source / var/dc3688.sql2, import command of database mysql-uroot-p password database name < table data to be imported mysql-uroot-padmin databaseName dump.sql

You can operate it and summarize your own method of operation.

The article is from http://www.dc3688.com/.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.