Script to upload large database to Cloud Sites during phpBB 3.2.5 Upgrade

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
rlaughton
Registered User
Posts: 22
Joined: Fri Jun 29, 2012 7:37 pm
Location: Milton Ontario Canada
Name: Richard Laughton
Contact:

Script to upload large database to Cloud Sites during phpBB 3.2.5 Upgrade

Post by rlaughton » Sat Feb 16, 2019 4:58 pm

This relates to my issue in upgrading from 3.0.14 to 3.2.5, as described here:
[Solved] Upgrade 3.0.14 to 3.2.5: Duplicated but "The requested topic does not exist."

The tech at our host Register.ca provided this additional information that may be useful to other members here:
Mike @Register.ca wrote:If PHPmyadmin still times out you can use the cron to execute a command line:

You can upload databases that are 50MB or less into Cloud Sites using phpMyAdmin or myLittleAdmin database managers. However, if you need to import a database that exceeds 50MB, you will need to use a script and schedule a cron job to upload the database.

Below is a sample script that you can set up to upload a large database into Cloud Sites.

The code below is only an example, your specific site may require a different configuration. We recommend speaking with your developer before implementing any scripts. If you do copy/paste this code, it must be saved as a .config file only.

Code: Select all

#!/bin/sh
mysql -h DB_HOST -u DB_USER -p'DB_PASSWORD' DB_NAME < /path/to/file/db_import.sql
Replace the placeholders with your actual information, definitions of the information needed are below:

DB_HOST: The name of the database host.
DB_USER: The name of the database user.
DB_PASSWORD: The password of the target database.
DB_NAME: The name of the database you are creating/restoring.

This is the closest you can get to the command line and SSH.

Post Reply

Return to “[3.2.x] Support Forum”