bahattab
13-12-2008, 12:53 AM
How to DUMPING A TABLE FROM YOUR MYSQL DATABASE
1. Using Netfirms File Manager or the touch command in SSH, create a file called tables.sql. The file may reside anywhere inside your /www folder.
2. Execute the following command in SSH ( backs up your database in extended format using the -e switch ):
/usr/local/nf/bin/mysqldump -e --force --quick -h mysqlhost -uUsername -pPassword DatabaseID tablename > tables.sql
for exporting the database :
mysqldump database name > backup.sql
for Exa. :
mysqldump emad_vbForum > backup_10.sql
1. Using Netfirms File Manager or the touch command in SSH, create a file called tables.sql. The file may reside anywhere inside your /www folder.
2. Execute the following command in SSH ( backs up your database in extended format using the -e switch ):
/usr/local/nf/bin/mysqldump -e --force --quick -h mysqlhost -uUsername -pPassword DatabaseID tablename > tables.sql
for exporting the database :
mysqldump database name > backup.sql
for Exa. :
mysqldump emad_vbForum > backup_10.sql