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.
Labels:

2 comments:

  1. pick and packJuly 9, 2011 at 3:24 AM

    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. AngelaHoltDecember 22, 2018 at 4:33 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)