Advertisement:

Author Topic: uploading MySQL database to a new host  (Read 4223 times)

Offline az_mufti

  • Newbie
  • *
  • Posts: 7
uploading MySQL database to a new host
« on: October 18, 2018, 08:54:46 AM »
my site was hosted at ixwebhosting that is closed for good. They asked me to download the backups. Now i bought hosting at Godaddy. following the steps i have uploaded my backups but cannot import database via myphpadmin plz help

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: uploading MySQL database to a new host
« Reply #1 on: October 18, 2018, 09:36:00 AM »
What's the error that phpMyAdmin generates? Did you make the backup via phpMyAdmin on your previous host, or via a custom site/database backup tool?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,243
Re: uploading MySQL database to a new host
« Reply #2 on: October 18, 2018, 05:18:43 PM »
How large is the database?  phpmyadmin will often timeout without error, it just spins it's wheels and db doesn't import.  GoDaddy has two backup/restore utilities, depending on whether you're on an older or newer server.  If your backup is .sql (not zipped) you may be able to restore it using their utility.

Whatever posessed you to move to GoDaddy?  They're one of the worst hosts around. :P


Offline az_mufti

  • Newbie
  • *
  • Posts: 7
Re: uploading MySQL database to a new host
« Reply #3 on: October 20, 2018, 06:35:48 AM »
How large is the database?  phpmyadmin will often timeout without error, it just spins it's wheels and db doesn't import.  GoDaddy has two backup/restore utilities, depending on whether you're on an older or newer server.  If your backup is .sql (not zipped) you may be able to restore it using their utility.

Whatever posessed you to move to GoDaddy?  They're one of the worst hosts around. :P



you are absolutely right. I have restored my database. I got a dummy account at another host and database was uploaded in one go. As for the next step i had to run repair_settings.php but fail to do so getting error 500
any clue

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,243
Re: uploading MySQL database to a new host
« Reply #4 on: October 20, 2018, 05:11:12 PM »
That's a server error, look in server error log.

Offline Looking

  • SMF Hero
  • ******
  • Posts: 2,370
  • SMF Customization
    • jeanborde on Facebook
    • SMF Custom Themes & Custom Coding
Re: uploading MySQL database to a new host
« Reply #5 on: November 15, 2018, 06:38:58 AM »
Quote
Now i bought hosting at Godaddy
* Worried face *