Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : phpBB2 Database backup help ?

[Ivan23]

I'm loading a new phpBB2 and now doing a backup of database.

the file is so big that i had to brake it down per / file then the hole thing at once ...

the following files in phpmyadmin is still to big:
phpbb_privmsgs Browse
phpbb_privmsgs_text
phpbb_ranks
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch

I can't upload them to the new database >? So what i do know ?

[deadserious]

If you have telnet/ssh access that would probabally be your best bet. But if you don't ask your host they'll probablly do it for you.

[dreamrae.com]

over ssh on a *inx box do the following:

cd /your_sites_pwd/; mkdir mysql_backup; mysqldump --password=your_pass_here your_forum_database_name> mysql_backup/file_name_to_save_as.sql; tar -zczf mysql-`date '+%d-%B-%Y'`.tar.gz --directory mysql_backup/ file_name_to_save_as.sql; rm mysql_backup/*; rmdir mysql_backup;


example: mysite.net
mysql user name: mysite
mysql password: 123456
database name: mysite_phpbb

commands:

cd /home/mysite/; mkdir mysql_backup; mysqldump --password=123456 mysite_phpbb> mysql_backup/backup_mysite_phpbb.sql; tar -zczf mysql-`date '+%d-%B-%Y'`.tar.gz --directory mysql_backup/ backup_mysite_phpbb.sql; rm mysql_backup/*; rmdir mysql_backup;