move the board to another host

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
samjesse
Registered User
Posts: 126
Joined: Fri Apr 23, 2010 6:49 am

move the board to another host

Post by samjesse »

Hi

I have 3.0.7-PL1 and some mods, all set up and working. I did a backup ACP > Maintenance > Backup > Full - all tables - download to local workstation.

Now that I have a backup_1275552821_dd0d754db8894b35.sql.gz

what do I do with it in order to move it to another host?

thx
Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: move the board to another host

Post by Pit$Bull »

samjesse
Registered User
Posts: 126
Joined: Fri Apr 23, 2010 6:49 am

Re: move the board to another host

Post by samjesse »

In the instruction in the link provided, in the section where it talks about 1) Using phpMyAdmin to Back Up the Database. it states:

In the Options section of this page, ensure the Add DROP TABLE checkbox is checked.
but I have
Add DROP TABLE / DROP VIEW checkbox

are they the same?

thx
Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: move the board to another host

Post by Pit$Bull »

Seems it's covering both which should be no problem..
samjesse
Registered User
Posts: 126
Joined: Fri Apr 23, 2010 6:49 am

Re: move the board to another host

Post by samjesse »

In the step where I need to restore the database.
Does the database which needs to be created on the new server has to have the same name/credentials as the old one being restored?
because I am getting

Error

SQL query:

--
-- Database: `xyz`
--
CREATE DATABASE `xyz` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'abc'@'10.%' to database 'xyz'


The reason why I used slightly different credentials because I was not able to create the database with the same credentials, I was getting
Database logins must be 2-16 characters in length. Database logins must consist of lowercase letters, numbers, and underscores with at least one non-numeric character.


I created a database with the "same" credentials but at importing I am getting
Error

SQL query:

--
-- Database: `xyz`
--
CREATE DATABASE `xyz` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1007 - Can't create database 'xyz'; database exists
Locked

Return to “[3.0.x] Support Forum”