Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Location
    Las Vegas
    Posts
    797

    phpBB2 Database backup help ?

    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 ?

  2. #2
    Join Date
    May 2002
    Posts
    441
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Baltimore, Maryland
    Posts
    580
    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •