bahattab
13-12-2008, 12:27 AM
BACKING UP YOUR MYSQL DATABASE
1. Using Netfirms File Manager or the touch command in SSH, create a file called dbBackupFile.sql. The file may reside anywhere inside your /www folder.
2. To make a backup copy of your mysql database via a SSH session (backs up your database in extended format using the -e switch):
%/usr/local/nf/bin/mysqldump -e --force --quick -h mysqlhost -u Username -pPassword DatabseID > dbBackupFile.sql
for exporting the database :
mysqldump database name > backup.sql
for Exa. :
mysqldump emad_vbForum > backup_10.sql
(You will then be prompted to enter your database password.)
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 -u Username -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 dbBackupFile.sql. The file may reside anywhere inside your /www folder.
2. To make a backup copy of your mysql database via a SSH session (backs up your database in extended format using the -e switch):
%/usr/local/nf/bin/mysqldump -e --force --quick -h mysqlhost -u Username -pPassword DatabseID > dbBackupFile.sql
for exporting the database :
mysqldump database name > backup.sql
for Exa. :
mysqldump emad_vbForum > backup_10.sql
(You will then be prompted to enter your database password.)
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 -u Username -pPassword DatabaseID tablename > tables.sql
for exporting the database :
mysqldump database name > backup.sql
for Exa. :
mysqldump emad_vbForum > backup_10.sql