Apr 16

Import and Export Mysql Database

Category: mysql

Found this pretty useful

For exporting DB:

mysqldump -u username -ppassword database_name > FILE.sql

while importing DB:

mysql -u username -ppassword database_name < FILE.sql

 easy but useful.. =) oh.. and got it on this site: Clockwatchers thanks. =)

Finally seeing the light.. =)

VN:F [1.9.6_1107]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.6_1107]
Rating: 0 (from 0 votes)
DiggTwitterTechnorati FavoritesRedditNewsVineFacebookShare

Related posts:

  1. Unable to connect to the database:The MySQL adapter “mysql” is not available. Unable to connect to the database:The MySQL adapter "mysql" is...
  2. Importing CSV to mysql Importing CSV to mysql...
  3. MySql Error in ubuntu solving mysql error of error 1045 Access denied for user...

Tags: , , ,

Leave a Comment

Get Adobe Flash playerPlugin by wpburn.com wordpress themes