Announcement

Collapse
No announcement yet.

moving servers...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • moving servers...

    I switched to my new host and I got a backup of the database from the old one and i'm trying to install it on the new one. I tried doing this in cpanel and phpmyadmin but they both give me errors. I then thought about going into notepad and copy and paste each query but when I go to open it it just crashes my computer.I already saw the Moving Servers Guide but I asked my host how to do what the guide says and he has no clue what it means. And now I am really starting to get fustrated. This will be the 4th time that a fourm will be messed up because of moving servers. And my forum was really doing good on the last host and I don't want to start all over again. Can someone tell me what other options I have to get this old database up. Thanks.

  • #2
    Originally posted by GTA3_Mafia
    I switched to my new host and I got a backup of the database from the old one and i'm trying to install it on the new one. I tried doing this in cpanel and phpmyadmin but they both give me errors. I then thought about going into notepad and copy and paste each query but when I go to open it it just crashes my computer.I already saw the Moving Servers Guide but I asked my host how to do what the guide says and he has no clue what it means. And now I am really starting to get fustrated. This will be the 4th time that a fourm will be messed up because of moving servers. And my forum was really doing good on the last host and I don't want to start all over again. Can someone tell me what other options I have to get this old database up. Thanks.
    Installing on the new one should be no problem in cpanel. Just make the current copy called backup.sql or whatever and browse on your computer and "restore" and it should be fine.

    There's the ssh method of restoring but that takes awhile.

    Comment


    • #3
      I tried in cpanel but it gave me an error that said not in a gzip format but it was.

      Comment


      • #4
        Originally posted by GTA3_Mafia
        I already saw the Moving Servers Guide but I asked my host how to do what the guide says and he has no clue what it means.
        Your host has 'no clue'? Not a good sign at all.

        How was the backup database created?
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          I talked with another guy that said he would run a sql command or somthing like that for me last night but he isn't responding to me anymore. And I made the backup in cpanel.

          Comment


          • #6
            GTA3_Mafia

            Ok, do you have access to SHH? If so, login using a program such as "putty". Enter your username, press enter, then enter your password and press enter.

            When you have sucessfully logged in, upload the .sql file to your ROOT directory, such as /home/username/ NOT /public_html/. Once it's uploaded, run the following query:

            mysql -uUSERNAME -p DATABASE < /home/username/file.sql

            Then you will be asked for a password, so enter your databases username password, not your FTP/cpanel login.

            If you need anymore help, just ask.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X