Advertisement:

Author Topic: Repeated failure to import database into fresh install of SMF  (Read 1403 times)

Offline Bivouac

  • Newbie
  • *
  • Posts: 6
Repeated failure to import database into fresh install of SMF
« on: October 04, 2017, 12:26:56 PM »
    Hello!

    Having succeeded in exporting a backup of my database via phpMyAdmin (due in no small part to some excellent advice from 'Sir Osis'), I'm now having difficulties importing it into a fresh install of SMF on my new hosting package.

    I've installed SMF, and it's working nicely.  So I tried to import my SQL file into it, and phpMyAdmin has timed out three times in succession.  It's not a huge file by any means (60 mb), so I'm assuming the error is mine (rather than simply that it's taking so long that phpMyAdmin has got bored and gone bowling instead).

    Now I'm wondering if I've totally misunderstood what I'm meant to be doing. 

    Am I correct in thinking that this is the procedure?

    • Create new, empty database
    • Install new SMF forum onto that database
    • Import database SQL via phpMyAdmin on top of the existing (new) forum?

    ...Or am I supposed to be importing it into a totally blank database, without a forum pre-installed on it?
    Would that be what's causing phpMyAdmin to time out? 

    Many thanks in advance for your help, oh wise and generous people of SMFland.

    Cheers,
    Bivouac.




Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,072
Re: Repeated failure to import database into fresh install of SMF
« Reply #1 on: October 04, 2017, 12:28:15 PM »
could be a limit set by the host. you may need your host to import the backup for you.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,350
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Repeated failure to import database into fresh install of SMF
« Reply #2 on: October 04, 2017, 12:29:59 PM »
Yeah might be too large for the form.
You can try zip/compress the file before upload as well.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,096
  • 'Tis the gift to be simple
Re: Repeated failure to import database into fresh install of SMF
« Reply #3 on: October 04, 2017, 12:35:57 PM »
If you still have access to original database, export it as gzip (empty logs first), it will be smaller than sql, and try importing it.  phpmyadmin will often fail to import a 60mb database, even if limit is much higher.  If it doesn't go, do what Illori suggested and ask host support to import it.

Offline Bivouac

  • Newbie
  • *
  • Posts: 6
Re: Repeated failure to import database into fresh install of SMF
« Reply #4 on: October 04, 2017, 12:45:11 PM »
Cool. Thanks very much guys.  I'll try the gzip method first.  (Not 100% sure what you meant by "empty logs first", Sir Osis... Sounds slightly scary. Does that involve deleting any of the existing data or contents???) 

One of the reasons I'm treading with a certain degree of caution is that my forum members are still actually using the current/old forum, even as we speak, and I don't want to risk them having the content pulled from under their feet if at all possible.  I'm trying to make the migration to the new site/host as smooth as possible for them.

Also, is phpMyAdmin the only method of importing the database (other than having the hosting company do it), or are there other, more user-friendly alternatives I could try?

Thanks again.
Bivouac.

Offline Bivouac

  • Newbie
  • *
  • Posts: 6
Re: Repeated failure to import database into fresh install of SMF
« Reply #5 on: October 04, 2017, 12:56:45 PM »
Aha!  I think I've sussed what Sir Osis meant by "emptying logs"...  Under "Structure", do I simply go to all the entries like smf_log_activity and click on the garbage bin icon? 

That won't break the forum or anything, will it?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,096
  • 'Tis the gift to be simple
Re: Repeated failure to import database into fresh install of SMF
« Reply #6 on: October 04, 2017, 01:02:17 PM »
You can empty logs on Admin -> Logs and Admin -> Forum Maintenance, don't mess with the database directly.  Some hosts have database backup/restore feature in control panel, you can also use a third party utility like MySQLDumper to export/import database.

Offline Bivouac

  • Newbie
  • *
  • Posts: 6
Re: Repeated failure to import database into fresh install of SMF
« Reply #7 on: October 04, 2017, 01:04:05 PM »
Brilliant!  That sounds a lot less dangerous!  Thanks.   :D