2) Using SSH to Back Up the Database
Open an SSH connection to your server and browse to the location where you wish to store the backed up database file. Run the following command to back up the database:
Code:
Select allmysqldump -u USERNAME -p PASSWORD --default-character-set utf8 DATABASE_NAME | gzip > NAME_OF_FILE.GZ
Be sure to substitute
USERNAME and
PASSWORD with the correct database username/password values. Also be sure to substitute
DATABASE_NAME with your newly created database name and
NAME_OF_FILE.GZ with the full name of the database backup GZ file.
Open an FTP connection to your server and browse to the location where this file is stored. Transfer it to your computer.
3) Using the phpBB ACP to Back Up the Database
This option is a good solution for smaller boards with below-average sized databases or for users who do not have access to phpMyAdmin.
Visit your old board’s Administration Control Panel. Select the
Maintenance Tab. On the left-hand side, click
Backup.
Ensure all the options are selected as shown in the image below. Be sure to click the
Select all button before proceeding with the backup.
Click
Submit. Depending on the size of the database and your server's configuration, this will take a few moments to process. You will be presented with a file for download. Save this to your computer.
Restore
Restoring the Database
On your new hosting provider/domain, create a new blank database which will contain the transferred forum’s database. Take note of the database name, username, and password.
Select one of the three options below to restore your database. Use whichever one is best based on your needs and what tools you have available to you.
1) If the database file is less than 2MB (exactly), follow these instructions
Load phpMyAdmin on your new hosting provider/domain. Select the new database from the drop down menu on the left-hand side. In the right-hand window, select the
Import tab. Browse your computer for the database file. Be sure the
Character set is set to
utf8.
Click
Go. Depending on your internet connection, this may take a few moments to load. If all went well, you will be presented with a confirmation message. Proceed to the next step.
2) If the database file is greater than 2MB (exactly) and you wish to use BigDump, follow these instructions
Extract the contents
bigdump.zip file and open
bigdump.php in your text editor.
Find the following section of code and fill it in appropriately with your database name, username, and password:
Code:
Select all // Database configuration
$db_server = 'localhost';
$db_name = '';
$db_username = '';
$db_password = '';
Leave
$db_server as its default value.
Edit the following line:
Code:
Select all$db_connection_charset = '';
To this:
Code:
Select all$db_connection_charset = 'utf8';
Also edit this:
Code:
Select all$linespersession = 3000; // Lines to be executed per one import session
$delaypersession = 0;
To this:
Code:
Select all$linespersession = 3000; // Lines to be executed per one import session
$delaypersession = 300;
Save the file.
With FileZilla, open an FTP connection to your server. Create a new directory somewhere on your server and name it
dump. Set the permissions of this folder to full write. Most often, you will need to right click the file and select
File permissions or
Properties. Set the permissions to 777, as shown below.
Upload both
bigdump.php and your database backup file to this directory. Point your browser to the
dump/bigdump.php file on your new domain. Follow the on-screen instructions to import the database backup file.
Depending on the size of the backup, this will take some time to complete. Please do not close your browser during this process. You will receive a confirmation message when it is complete. After this is complete, delete the
dump folder from your server. Proceed with the instructions.
3) If you wish to use SSH to restore the database backup, follow these instructions
Upload the database backup SQL file to a location on your server via FTP.
Open an SSH connection to your server and browse to the location where this SQL file is located. Run the following command in SSH to restore the database.
Code:
Select allgunzip < NAME_OF-FILE.GZ | mysql -u USERNAME -p PASSWORD --default_character_set utf8 DATABASE_NAME
Be sure to substitute
USERNAME and
PASSWORD with the correct database username/password values. Also be sure to substitute
DATABASE_NAME with your newly created database name and
NAME_OF_FILE with the full name of the database backup SQL/GZ file.
- IMPORTANT: The command above will only work if the database was gzipped when exported. If the instructions were followed in this article, then this will be the case.
Depending on the size of the database backup, this may take a few moments to complete. If there have been no errors, you will be brought back to the prompt.
Restoring the phpBB Files
Upload the backed up phpBB files to the location you desire on the new server via FTP.
Final Steps
Rebuilding the config.php file
Please reference the following article for the steps necessary to rebuild your config.php file and replace the old one:
http://www.phpbb.com/kb/article/rebuild ... gphp-file/
Changing your board’s cookie settings
Please note that this step is only necessary if you have moved to a new domain name.
Reference the following article for the steps necessary to update your new board's cookie settings:
http://www.phpbb.com/kb/article/fixing- ... -settings/
all i ask is for some support from your end and tell me that it cant be done cause i know it can !