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.

1 comment:

  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