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.

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

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


Import
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.

2 comments:

  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.

    ReplyDelete
  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

    ReplyDelete