Jul 24, 2008

Help Moving Mysql Files To A New Host - IPB files

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Help Moving Mysql Files To A New Host - IPB files

Gyad
Well, my partners on my forum has decided to move our site to a newer host. A paid one to be exact. And we did that already. Now all we need to do is move our forum over to the new host. We want to do this without losing all of our posts and other data. I know it has something to do with the MySQL files but I don't really understand it. Some help would be appreciated.

We are running Invision Power Board 1.3.1 final

Also, we're thinking about upgrading our board to a newer version of IPB because we heard that its better in more ways than one. But then again, it might be harder to do.

So basically, we want to :

-Move our IPB database from this host to the newer one without losing the data
-Upgrade our board version

Also, before you go yelling at me for any reason, make note that I :

-am not leaving because Trap17 isn't good enough
-am not leaving Trap17 at all, my partners are wink.gif [They are bloodsucking leeches]
-already searched the forums, but I didn't find anything useful [Or that I didn't look hard enough]

*
Any help would be greatly appreciated.

 

 

 


Reply

Dragonfly
Firstly, you must know how to back-up your Invision Power Board files and folders from Cpanel or simply download it from FTP. That way files and folders can be backed-up. Cpanel back-up is very easy. Just go to your Cpanel and among many icons that appear at Cpanel home there is BACK-UP as well. Click that and it will guide you how to back up. You can download backed-up file (it will be tar or zip file) to your computer. And upload again the file to a new server using your Cpanel and extract there as usual. And re-arrange the folder path.

If you back-up by downloading files and folders using ftp, whatever you've download upload again in your new host. Don't upload all at once, but do folder by folder, this is good because sometimes due to internet connection some files may not be transfer to the server fully. In that case your forum will always have problems.

Now Database. There are two ways to back up the database. One way is from IPB control panel, if you are admin you can do it.

The second one is using phpMyAdmin which you can find once again in the Control panel homepage. Click phpMyAdmin and you will find the page where left side there will be option to choose which database you want to manage. Select the drop-down menu (one the left menu -left side of the page). It will open the database of the forum. On top of the page you will then be able to see options like query, export, etc. CLick Export, when you did there will be options to select TABLES. SELECT ALL and export it as gzip file (tick this option). It will prompt you to download the file as gzip file. Save it to your drive and finish the download.

How to install :
In your new host, login to Cpanel and find databases > MySQL database, create new database. Create user with password. And assign the user with ALL privileges option.

Now go back to your Cpanel home and click on phpMyAdmin once again. And select the database you've created using drop-down menu as usual. Now on the main body of the phpMyAdmin page you will be able to see run your query. Import the back-up gzip file, browse and upload it. It will install it. That's it.

You must edit configuration file in your IPB board, assing the new value for file path and others including the database username and password. Your forum should work normally.

I hope this helps. If not, please respond, more members can help you out.

 

 

 


Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : moving, mysql, files, host, ipb, files

  1. How Do I Find My Mysql Password? [resolved]
    Cannot access my MySQL (5)
  2. Remote Access Mysql
    (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies.....
  3. Trap17 Host Servers
    Are they still the same? (1)
    Are the trap17 host servers still the same? Right now my domain has its DNS set to ns1.trap17.com
    and ns2.trap17.com, am I correct or did the server change also change the DNS?? Thank you
    /wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />....
  4. Css Problem On Website
    I've uploaded the html/css files but the css isn't working/ (8)
    Help? I've uploaded all of the html files and css files into the public_html folder , but the
    css isn't taking effect. I've checked both the css and te html files , nothing wrong with
    them. Halp me? www.genesis.trap17.com/home.html /sad.gif" style="vertical-align:middle" emoid=":("
    border="0" alt="sad.gif" />....
  5. Where Do I Upload My Ftp Files? [resolved]
    As in, which directory? (1)
    I recently got approved for hosting. I have an account right now, but I don't know which
    directory to post my FTP stuff in. (I don't know if this is in support or not; the search
    results didn't return anything.) I remember with my last host that had CPanel that you had to
    upload it into the "public_html" folder. So I do that, or do I just upload it into the root
    directory? Thanks in advance! (EDIT: Oh, never mind, it is /public_html.)....
  6. Question About The Upgrade And The Mysql Usage ?
    question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
  7. About My Host
    No help needed (3)
    Yesterday my host request was approved. Today i was making the website and i tried to host a forum.
    The website theme is programming, helps, guides, computing, tutorials on different programming
    languages. And i realised that a forum is more handy for helps and tutorials, and the users can help
    each others in a easier way. My doubt is: Is it really necessary a portal for my case? And can i
    sell programs at my website if i want to? Feel free to give your opinion. ~ Greetz Joćo Lopes....
  8. Transferring Files From One Host To Another
    Take my site to trap17 (8)
    As I said, I had to move my web site away from Trap17 temporarily because I had ran out of disk
    space. Now, when my upgrade is finalised, I would like to ask for a little assistance. The provider
    I will be moving my site from, back to Trap17 also uses Cpanel, and the admin let me know to do a
    backup and that backup could be simply transferred via FTP to my new provider. The backup includes
    all my files and MySQL data, in other words, the whole web site. It is in a .tar.gz format. How do I
    get all this across? Do I 'unzip' the file and then transfer them bit by bi....
  9. Ftp Trap17 Account Help Please
    cPanel issues and can't upload files (14)
    A few days ago I tried to log into cPanel on my site ( www.liamssite.trap17.com ) and it didnt work.
    Also, whenever I try to upload a file (I use filezilla) I get this: QUOTE Status: Resolving
    IP-Address for liamssite.trap17.com Status: Connecting to 64.69.46.210:21... Status: Connection
    established, waiting for welcome message... Response: 220---------- Welcome to Pure-FTPd ----------
    Response: 220-You are user number 2 of 50 allowed. Response: 220-Local time is now 11:31. Server
    port: 21. Response: 220-This is a private system - No anonymous login Response: 220-....
  10. Unable To Resolve Host Name Using Ftp. Help!
    (2)
    I am using SmartFTP but it will not connect to the site here. I am using my username and password.
    This is what it keeps saying: Resolving host name "ftp://ftp.itek.trap17.com/" Unable to resolve
    host name. Active Help: http://www.smartftp.com/support/kb/81 Cannot login waiting to retry
    (30s)... What am I doing wrong here?....
  11. Moving
    (11)
    Hey, I will be out for 3 days, am moving to another house /biggrin.gif"
    style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" /> I didn't have time to
    create enough credits to uphold my account, due to this move. but I'll be back next saturday to
    eliminate my negative amount... See you all then!....
  12. Can't Find My Fantastico Installation!
    Where is the files I installed (2)
    Before anyone points it out, I searched this forum for similar topics and couldn't find any, I
    checked the FAQ's and couldn't find any one of them that addresses my problem: I just
    installed joomla in a sub directory (public_html/Joomla) and I wanted to change some stuff so I went
    into my FTP program and connected to my account, I checked, doubled checked and triple checked all
    the public html/FTP/WWW folders and I couldn't find the joomla installation, the site come up
    fine in browser but I can't seem to find the directory of where it is located, t....
  13. Question About Adding Message Board To Site
    Using mysql? (5)
    Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
    how can I set up a messageboard. Thanks. std split from another topic ....
  14. Help! I Deleted All My Files!
    (5)
    Hi guys, i got hosted yesterday and i loged on to my file manager and deleted all the files in there
    i replaced them with my site including the index.htm page and now when i try to view it it says no
    page found!!! i dont no why this is as with my site when i payed for hosting from
    one.net it was as simple as using the run program and typing in mt ftp:\\ account copy the
    index.htm file and i was up and running! Can anyone help with what i have done wrong please
    thank you. /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sa....
  15. Need Help Installing Smf
    It's not finding the files I upload. (5)
    I downloaded the zip version of the SMF, from www.simplemachines.org I am using SmartFTP, to upload
    the files. I created a folder, named Forum, and uploaded all the SMF files there. On the
    simplemachines site, it tells me to type my site url followed by /forum/install.php, or whatever the
    directory I installed it on is called. I tried that, and I come up with this on the page. Not
    Found The requested URL /forum/smf1.1/install.php was not found on this server. Additionally, a 404
    Not Found error was encountered while trying to use an ErrorDocument to handle the re....
  16. Phpbb2.17 Mysql Problems
    Just this week they started (4)
    The forum has been up and running for about a year and a half. It has been through numerous server
    upgrades, etc, including the recent HDD change, but for some reason, just this week it started
    throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
    SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
    be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
    u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,....
  17. Moving Phpbb2 Forums To This Host.
    I want to make sure it goes right. (3)
    I am moving my phpBB2 forums from my old host, my-php.net, to this one. I have full access to my old
    forums. I was wanting help on this to make sure nothing goes wrong. My forum members and I can not
    risk having to lose all of our current information. So what I am thinking I have to do is. Export
    my forums mySQL database with phpmyadmin. Import it into my database here on this host. Move the
    forum directory to this sites ftp account. Change the root directory in my forum settings. I know
    there has to be some things I have to change right? Some files or other settings....
  18. 99 Mysql Databases?
    (2)
    I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
    lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
    have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
    just prefix my tables, but I was just wondering why it would say that. If for some reason it was
    letting me get more than one database, and I wasn't supposed to, I don't want to get my
    account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m....
  19. Mysql Access Error[resolved]
    (5)
    The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
    never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
    Please kindly look into this.....
  20. Mysql Server Problems [resolved]
    (3)
    hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
    ERRORS, like that the server is going down so now and often is it due to my cms or is the server
    having some probs ? this is what i just saw from the statistics: QUOTE Service Status
    named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
    (5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
    Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17....
  21. Cpanel And Mysql Problem. [resolved]
    (3)
    hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
    to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
    ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
    loads with a blank page. however both worked earlier today. so is there a problem with the server?
    and if there is, will it be fixed?....
  22. Accidentally Deleted Pre-set Files
    (3)
    I made a bo-bo lol I've accidentally deleted those pre-set files that are in the file manager
    when you first register, you know those _vti thingy magiggers, well i accidentally deleted them, so
    i was wondering if an admin can re-insert them for me /biggrin.gif" style="vertical-align:middle"
    emoid=":D" border="0" alt="biggrin.gif" /> or re-set my hosting whatever you have to do.... thanks
    /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
  23. Problems With Deleting Files In My Account
    blendergalactica.com (3)
    Suddenly all my file permission aren't writable in the Joomla directory. Furthermore, when I go
    to delete old files or overwrite them, I get a varity of errors both in my FTP programs and using
    the Cpanel flie manager. When I checked the needed directories file permission they read 777
    (which is needed for installing components) yet when I got to access them they are unwritable. This
    has just happened in the last day or so and the not being able to delete files mannual in the past
    week. I get this error on changing file permissions: QUOTE FTP Error: Could ....
  24. Upload Script To Transfer Files From Laptop To Desktop
    (3)
    Would it be allowed to have an upload script to transfer text files (homework) from laptop to
    desktop? Because my printer is set up from my desktop, and most of my homework is done on my laptop.
    So would this be allowed? Thanks.....
  25. Is My Host Created?!
    the page failed at the procesing.. (3)
    hi! i used the process page to submitt hosting! i had waited along time! but suddenly it
    gave me "can not find servers" error! so i dont know if my account is created or not! please
    help me! thanks....
  26. Is It Possible To Access The Mysql Remotely?
    (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?....
  27. How To Crate Mysql Database?
    urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ....
  28. Installing Apache, Mysql, Phpmyadmin Locally
    Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
  29. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
  30. Uploading Files And Connecting To Ftp
    using WsFtppro (27)
    The fastest, most reliable way to upload or download files is through FTP. If you don't already
    have your own Web page, read our reviews of over 80 free Webhost. If you don't have an FTP
    client, Download WS_FTP Pro now. Step 1 - Connect your computer to the Internet. Step 2 - Launch
    WS_FTP Pro by clicking on the WS_FTP Pro icon that's on your desktop. If you do not have a
    WS_FTP Pro icon on your desktop, click on the Start button and then select Programs, then WS_FTP,
    and then WS_FTP Pro. Step 3 - Connecting to an FTP site: When you open WS_FTP Pro, you&#....

    1. Looking for moving, mysql, files, host, ipb, files

Searching Video's for moving, mysql, files, host, ipb, files
Similar
How Do I
Find My
Mysql
Password?
[resolved] -
Cannot
access my
MySQL
Remote
Access Mysql
Trap17 Host
Servers -
Are they
still the
same?
Css Problem
On Website -
I've
uploaded the
html/css
files but
the css
isn't
working/
Where Do I
Upload My
Ftp Files?
[resolved] -
As in, which
directory?
Question
About The
Upgrade And
The Mysql
Usage ? -
question
about the
upgrade and
the mysql
usage?
About My
Host - No
help needed
Transferring
Files From
One Host To
Another -
Take my site
to trap17
Ftp Trap17
Account Help
Please -
cPanel
issues and
can't
upload files
Unable To
Resolve Host
Name Using
Ftp.
Help!
Moving
Can't
Find My
Fantastico
Installation
! -
Where is the
files I
installed
Question
About Adding
Message
Board To
Site - Using
mysql?
Help! I
Deleted All
My
Files!
Need Help
Installing
Smf -
It's not
finding the
files I
upload.
Phpbb2.17
Mysql
Problems -
Just this
week they
started
Moving
Phpbb2
Forums To
This Host. -
I want to
make sure it
goes right.
99 Mysql
Databases?
Mysql Access
Error[resolv
ed]
Mysql Server
Problems
[resolved]
Cpanel And
Mysql
Problem.
[resolved]
Accidentally
Deleted
Pre-set
Files
Problems
With
Deleting
Files In My
Account -
blendergalac
tica.com
Upload
Script To
Transfer
Files From
Laptop To
Desktop
Is My Host
Created?!
; - the page
failed at
the
procesing..
Is It
Possible To
Access The
Mysql
Remotely?
How To Crate
Mysql
Database? -
urgent help
Installing
Apache,
Mysql,
Phpmyadmin
Locally -
Solving the
"php_mb
string.dll
missing"
;
Mysql
Database
Setup :
Setting Up
Mysql
Database -
Guide to use
MySQL
database in
your site
Uploading
Files And
Connecting
To Ftp -
using
WsFtppro
advertisement



Help Moving Mysql Files To A New Host - IPB files



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE