< Browse > Home /

| Mobile | RSS

naveen.malla

Export and Import MYSQL Linux commands

Export
steps:
1) mysqldump -u web_user -p databasename > sqlfilename
2) Prompts you to enter Password:
3)Enter the password then the database will be backup on given sqlfile
Import
mysqldump -u web_user -p database_name < sqlfilename

[ More ] May 14th, 2009 | No Comments | Posted in Mysql, Php |