Advertisement:

Author Topic: Need help to transfer a SMF/SQL backup from one Hosting to another.  (Read 2531 times)

Offline RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Hi there
I have a new hosting and still have the old one working as well.
My new hosting has SQL Import so I downloaded a SMF/SQL backup from my old provider and went to upload to my new hosting.
The new hosting says "Character set utf-8

A problem pops up saying:
Error
SQL query:
--
-- Table structure for table `smf_ads`
--
DROP TABLE IF EXISTS `smf_ads`

MySQL said: Documentation
#1046 - No database selected

Any ideas

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,030
  • Gender: Male
    • Macedonian electronics forum
Re: Need help to transfer a SQL backup from one Hosting to another.
« Reply #1 on: June 15, 2018, 09:53:19 PM »
Are you trying to import to an empty or to a populated database? Have you actually created an empty database on the new host? Does the same thing happen using phpMyAdmin?

And you should really think about upgrading to SMF 2.0.x. The 1.1.x branch is EOL (no updates, not even security patches).
"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: 8,985
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #2 on: June 15, 2018, 09:54:18 PM »
Did you export with phpmyadmin?  Are you trying to import with pma?  Did you create a scratch database on new server?

Offline RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #3 on: June 15, 2018, 09:57:00 PM »
Hey there
I am using php My Admin and there is a clean directory , just started with them yesterday.
The SQL file is 20MB if that makes any difference

Offline RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #4 on: June 15, 2018, 09:59:40 PM »
Hey Sir Osis
What is a scratch file?
I was attempting to simply install the SMF directory file as saved from the old hosting, and upload the saved backup SQL file

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,030
  • Gender: Male
    • Macedonian electronics forum
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #5 on: June 15, 2018, 10:01:49 PM »
By clean directory, I think you mean a clean (empty) database. Could you post a screenshot of phpMyAdmin?

Did you export with phpmyadmin?

Also a valid question.

The SQL file is 20MB if that makes any difference

How big is your forum? Are you sure that's the whole dump of the database, not just a part of it?

What is a scratch file?

He meant, did you create an empty database on the host ;).
"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 RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #6 on: June 15, 2018, 10:06:37 PM »
Backup was using mySQL through Godaddy

Offline RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #7 on: June 15, 2018, 10:08:05 PM »
I can make a blank Database on the new hosting

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,030
  • Gender: Male
    • Macedonian electronics forum
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #8 on: June 15, 2018, 10:12:05 PM »
Backup was using mySQL through Godaddy

Haven't had experience with Godaddy. Other members might be of more help, at least on the export part of the problem (if there was a problem during the export/dumping of the database).

I can make a blank Database on the new hosting

Do that and try importing the database dump in the newly created empty database ;).
"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 RYFB

  • Semi-Newbie
  • *
  • Posts: 16
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #9 on: June 15, 2018, 10:14:33 PM »
Good idea Giga Watt

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,030
  • Gender: Male
    • Macedonian electronics forum
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #10 on: June 15, 2018, 10:51:46 PM »
Change the name of the sql file to, let's say smfdb.sql, compress it in a zip archive and change the name of the archive to smfdb.sql.zip (because the output file name of the archiver will probably be smfdb.zip, you need to add the extra .sql before the .zip extension). Upload it like that, see if the same error appears ;).
"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: 8,985
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #11 on: June 16, 2018, 12:00:11 AM »
GoDaddy has two cpanel backup utilities, depending on server you'll have one or the other.  Older one saves .sql to /db_backups, you can download it from there.  Newer one downloads .sql directly to local.  Both have worked well when I've used them if db isn't too large, 20mb should not be a problem.  Importing a 20mb via pma will usually work on most hosts, but not all.  If you're having problems you can zip it as suggested, or ask host support to import it.  You must create a new db to import the backup into.
 

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,827
Re: Need help to transfer a SMF/SQL backup from one Hosting to another.
« Reply #12 on: June 16, 2018, 05:51:51 AM »
looks like you are following the wrong process to move your forum to a new host. take a look at

https://wiki.simplemachines.org/smf/Hosting_-_How_do_I_move_my_SMF_forum_to_a_different_host