17 Dec
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
I am a software engineer who specializes in Internet applications. I have worked with a wide variety of technologies and programming languages to open source LAMP environments. I have more than 6 years of object-oriented programming experience and am highly proficient in ActionScript, PHP, MYSQL, JavaScript, Jquery and a multitude of other technologies used in modern web applications.
Latest posts by Rajeev Achra (see all)
- 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