Data AccessCore JavaApp FrameworksViewTestingBuildingDeploymentDev ToolsSecurityOpinions

Monday, March 16, 2009

MySQL Import and Export

Two useful commands below to help you import and export data to and from MySQL databases.

To export data from a MySQL database, use the mysqldump utility.

mysqldump -u(your_username) -p(password) (database_name) > (BACKUPFILE.sql) 

The file produced can be used to pipe back into a different MySQL database.

mysql -u(username) -p(password) (database_name) < (BACKUPFILE.sql)

Remove the parenthesis and replace the values in both commands above.


  1. The companies in these countries can benefit from having lower production costs and a competitive advantage over large countries. Increased demand for imported products is growing exponentially and companies to bring export opportunities to take seriously.

  2. A business loan moneylender gives entrepreneurs a whole of loan in advance. In return, the entrepreneur consents to pay back the central sum in addition to the expense, by giving the moneylender an every day level of their visa and ace card deals until the point when the payback is finished. Cash Advances Chicago

  3. Amazing sharing, thanks for sharing with the online community. cheat droid apk xmodgames apk droid4x download

  4. On Pictame2, we created 'Trending Now' and 'Hot Users' pages and also related users suggestions for you to discover the most exciting users on Instagram.