How to Export the database in mysql using command prompt?
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
login into your webhost
Sun, 06/22/2008 - 19:18 — adminlogin into your webhost using ssh.
enter your username/password for the webhost
type below mysql command.
mysql -uUSERNAME –pPASSWORD DATABASENAME > MYDATABASE.sql
eg : username:root
password:pwd
databsename:mydb
mysql -uroot -ppwd mydb > mybackup.sql
above command will take the backup of mydb into mybackup.sql file.
u can use mysqldump comand
Thu, 06/26/2008 - 17:21 — Anonymousu can use mysqldump comand also
mysqldump -uusername -ppassword database name > export.sql