Move board to new location/server/website

[howitz Zdrave]

Thanks frans , i uploaded the database 165mb and i connected the bigdump.php db settings , now when i go import it says

Error at the line 15: CREATE DATABASE `varalicar_com` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Query: CREATE DATABASE `varalicar_com` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL: Access denied for user 'howitz_howitz'@'localhost' to database 'varalicar_com'


in bigdump.php

$db_connection_charset = 'latin1 COLLATE latin1_swedish_ci'; - i inputed many more , dunno whats the problem , tried the same encoding that i exported the database.

On my new server in phpmy admin i inputed lantin1 and latin1_swedish_ci both settings and new database COLLATE ?!

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: s69.loopia.se
-- Generation Time: May 20, 2008 at 12:55 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

I have readed that i want to import into existing database so i need to remove these codes

Code: Select all

CREATE DATABASE `varalicar_com` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `varalicar_com

in the exported database right ? or

Is there anyway i can add permissions so the import can create the same database name ?

[..::Frans::..]

There are 2 possibilities:

1. the user you are using doesn't have enough grants (rights) to create the database OR
2. you didn't fill out all nessecary fields in bigdump.php

[howitz Zdrave]

The user i created in cpanel has checked ALL privileges
in bigdump.php i have entered the right character encoding and the newly created db info
Now i have found that if i want to restore into the existing database i need to remove this code at the start of the exported dump sql file that i have...

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: s69.loopia.se
-- Generation Time: May 20, 2008 at 12:55 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

-- --------------------------------------------------------

this one

CREATE DATABASE `varalicar_com` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `varalicar_com`;

Edit: i found that in phpmyadmin thru cpanel

Create new database:
No Privileges

That's why bigdump cannot create the database
I am currently searching for a function to enable that

[distefano]

Hi,
i try to move my board to a new server
i followed the instructions, as i've done this before and it worked.
now i only get a blank page when visiting the new url.
and as i'm typing this post i realize that i triple-checked my config.php database settings, but never the sql version.
so i changed it from sqli to sql and it works.
thanks for your attention, maybe this will help someone someday.

Dude, r u a seer or a prophet? It has really helped me 2day. Mu config.php had "$dbms = 'mysqli';" and i had 3 change it to "$dbms = 'mysql';" and it really helped coz i was getting a blank page.

Thnx again mate! A big thnx also goes 2 FRANS. U're a gem.

[girish979]

If i can transfer the Full Backup to new server. then can u tell me how to do

[TheNovice Rhet]

.
And now y'all will find out why my User ID.

I've been doing what I thought was a fair amount of homework and the step-by-step here seemed easier to understand than that which I found over on phpBB Documentation or their Support, or something. I have that one hanging right here in front of my head. I also have Frans' hanging off to the left.

Problem is, even after looking at at least 10 different sites for this that and the other I am still having trouble getting a handle on all this. So I'm wondering if I just ask questions, will y'all try to be patient with this old man and help me get through this.

What I'm trying to do is move a forum that was set up a few months ago, but has never been opened to the public. it has a few threads done by my partner, but we are not talking about any large database. I need to move the forum to a new host. So I'm going at this step-by-step, obviously.

My very first problem is I cannot find what is listed as "old database" nor can I find the "database password". Okay, I'm reviewing my post and I am beginning to realize that it's not actually listed as "Old" database, right? Okay, that just goes to show you how stupid I am. So the database referred to there is simply what I am seeing and explained below, right?

I'm right now looking at the "Old site" and in MySQL Databases under "Current Databases" there are two databases -- one is 0.21 MB and the User Name is the same name as the Database. The next Database listed below that is 2.31 MB and that User Name is also the same as the database.

Now, in phpMyAdmin <version 2.11.6> I don't see anything listed as "Old Database" (I think I understand this -see above- but I'll leave this as I first typed it, just in case). By the way, the server version is <5.0.51a>. One potential problem that may be the killer here is in the left-hand column under "Create new database" there is, in bright red letters, "No Privileges". Other than that it would seem I have access to everything else.

So is that "No Privileges" a killer? And where can I find the information to fill in this part of Frans' instructions.

The url is ...................
Database ....................
Database_user ..............
Database_password .........

URL I reckon is easy, except that "board" part confuses me.
"old_db" I don't get. (Maybe I do now, a bit.)
"old_db_user" seems to be two different users for two different database. By the way, I can create new users.
And the "database_password" I haven't a clue.

So, am I a hopeless novice way over my head, or do you think there is any hope for me.

Oh yes, now ...:::Frans:::... you understand what I meant in that introduction thread.

Any help, advice, etc. y'all are willing to provide will sure be greatly appreciated. Even if it's, "Forget it old man, you need a pro."

Thank you.

.

[..::Frans::..]

ok, let's try to shed some light on this.

OLD database:

You have currently the database that your partner filled with some postings but was never opened to the public.

That database has a name (and i used "old_database as an example name) but it can be anything you like or anything you or anyone else typed in when created that thing.

To "talk" to the databsae (still referring to the old one, with your partner's postings) you need (same with your standard windows xp account etc.) a username and a password. So, the username needs at least 1 user that has complete access to the database and tables with it's own password. If you can't find those 2, or the database name, just open up the config.php file @ the root of your (still talking about the old!!!) board and you will miracly find all this info in there....

[TheNovice Rhet]

.
Okey-dokey.

Sure appreciate the help.

Off to look for miracles, which ain't no big deal for a Trekkie who was a Trekkie before most of the world knew we existed.

Yep, sure do appreciate the help.

.

[..::Frans::..]

k, take pen and my print, fill in these information there.....


and next: take the same info (database_name, user and password) from the NEW server, again,m take my explanation and fill in the blanks @ new_db so i think you should be on your way again......(these data can be found in the info mail you got from the new host company)

[TheNovice Rhet]

.

ok, let's try to shed some light on this.
... just open up the config.php file @ the root of your (still talking about the old!!!) board and you will miracly find all this info in there....

This root stuff and phpconfiguration file relates to FTP?

I mean, I did a google search and saw something about Apache, some code, something about FTP.

Wrong? Something easier to find.

Sorry. you see how easy it is for me to get lost.

Well, I'm looking at the FTP Accounts right now and something about changing passwords. Is any of that helpful. I haven't done anything yet, so i haven't broken anything yet.

I guess what I mean is I still don't see any passwords, but I'm looking.

.