 Trying to move IPB 2.0 to a new host |
|
ISO Image
Creator
Trying to move IPB 2.0 to a new host
Jun 14 2005, 03:23 PM
Post
#1
Helpful Member
Group: Members
Posts: 68
Joined: 10-January 05
Member No.: 26,596
United States
I'm trying to backup the database ibrd1 and then upload it to the new host. I'm having trouble on the download and upload. It seems that no tables past ibf_posts is getting backed up and therefore not being created on the other side.
Any ideas?
Jun 16 2005, 06:37 AM
Post
#2
Administrator
Group: Admin
Posts: 10,302
Joined: 9-February 03
From: Jacksonville, FL
Member No.: 1
United States
Make a full site backup, and download it. Should have the sql in there.
Normally when I move a site from one host to another, I find that the only way I can get the full db moved (easily) is to go into phpmyadmin and export each table one by one and paste the sql into the phpmyadmin on the new host. With tables like ibf_posts, often I have to export only like 500 or 1000 posts at a time. For a site like bfarber.com, it's a HUGE chore moving hosts. 
Jun 16 2005, 12:40 PM
Post
#3
Helpful Member
Group: Members
Posts: 68
Joined: 10-January 05
Member No.: 26,596
United States
QUOTE(bfarber @ Jun 16 2005, 07:37 AM)Make a full site backup, and download it. Should have the sql in there.
Normally when I move a site from one host to another, I find that the only way I can get the full db moved (easily) is to go into phpmyadmin and export each table one by one and paste the sql into the phpmyadmin on the new host. With tables like ibf_posts, often I have to export only like 500 or 1000 posts at a time. For a site like bfarber.com, it's a HUGE chore moving hosts. 
damnit. That's 100 tables to move
Okay, thanks for the tip. I'll try that.
Jun 16 2005, 12:44 PM
Post
#4
Newbie
Group: Members
Posts: 32
Joined: 6-October 04
From: U.K.
Member No.: 21,775
United Kingdom
Download the whole thing as an sql file! From the old host
Then upload about 5000 lines at a time on the new host and it should allow that much without hiccups! 
Jun 16 2005, 02:37 PM
Post
#5
Helpful Member
Group: Members
Posts: 68
Joined: 10-January 05
Member No.: 26,596
United States
I found an easier way. Just get the host to give you SSH access and run mysql right on the server.
I love knowing Linux shell commands!
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
Lo-Fi Version
Time is now: 11th February 2012 - 03:12 PM
Webber Enhanced skin created by Im4eversmart of RuneHQ.
