Go to terminal window
To export type following command
âmysqldump -u USERNAME -p dbname tableName > tableName.sqlâ
Here
mysqldump      is default mysql command
USERNAME Â Â Â Â is your databse username with sufficieant previliges
dbname          is your database name in which table exist
tableName       is your table which you want to export
tableName.sql    is you sql file name in which you want to export query
For example
mysqldump -uroot -p lastdrawer lkp_doctor > lkp_doctor_bak.sql
It will ask for password for this user. insert password and hit enter.
To import table in particular database use following command
mysql -u USERNAME -p -D dbname < tableName.sql
For example
mysql -u root -p -D isdocin < lkp_doctor_bak.sql
- Jquery webcam plugin - June 19, 2016
- How To Add and Delete Users on a CentOSServer - June 5, 2016
- How To Set Up vsftpd on CentOS 6 - June 5, 2016