Advertisement:

Author Topic: Database (big) problem after upgrade made by my hosting  (Read 733 times)

Offline Portugal

  • Jr. Member
  • **
  • Posts: 186
Database (big) problem after upgrade made by my hosting
« on: December 28, 2017, 06:18:18 AM »
Hi to all members,

First of all, I hope you all had a merry Christmas. Now I would ask your help for the next (big) problem.
On December 23, my hosting remembered to upgrade (without my previous knowledge), or because I had not been aware of this, I did not back up that day, but luckily I did it on the 21st. I assume that I will only lose data regarding these days, and I say I presume because I am not being able to upload the contents of my database (name.sql).
Since the hosting also allows the database to be restored, I also tried it, but without success, because only 70 tables are saved, when in fact they are 128 in total.
The database is about 650Mb, it is quite large, but what I see is that it is still far from the limit of 1.024Mb.
I have already asked my hosting to reset the service before the upgrade, but I am told that it is impossible, and this is causing enormous damage at all levels, but especially my forum's reputation towards members, users and of course, search engines.
I've tried almost everything, I'm not able to reset the database, can anyone give me some tips how to solve this?
Thank you for your attention, especially for database specialists.

Greetings,
Portugal

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,145
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Database (big) problem after upgrade made by my hosting
« Reply #1 on: December 28, 2017, 10:23:14 AM »
What type of hosting?

You could also split the database file into multiple parts and do parts at a time. You will just need to make you run the full query if you cut the file into parts.
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 Portugal

  • Jr. Member
  • **
  • Posts: 186
Re: Database (big) problem after upgrade made by my hosting
« Reply #2 on: December 28, 2017, 10:45:00 AM »
Hi vbgamer45,

Thanks for your help and sugestion. My hosting account is a shared old account (for that they are made this upgrade). Now im considering to move for an VPS.
Sugest any tool to split that database? And the query?

Thanks


What type of hosting?

You could also split the database file into multiple parts and do parts at a time. You will just need to make you run the full query if you cut the file into parts.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,145
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Database (big) problem after upgrade made by my hosting
« Reply #3 on: December 28, 2017, 11:00:35 AM »
I use hjsplit since it splits by filesize but you will have to open each file and move the queries that are cut into parts and move them from one file to another.
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 Portugal

  • Jr. Member
  • **
  • Posts: 186
Re: Database (big) problem after upgrade made by my hosting
« Reply #4 on: December 28, 2017, 11:04:36 AM »
vbgamer45, i will go to try...

Thanks

I use hjsplit since it splits by filesize but you will have to open each file and move the queries that are cut into parts and move them from one file to another.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,829
  • 'Tis the gift to be simple (duh)
Re: Database (big) problem after upgrade made by my hosting
« Reply #5 on: December 28, 2017, 03:15:58 PM »
If you can't import the database with cpanel restore or phpmyadmin, your host should be able to do it for you.  You can also try importing it with a third party utility like MySQLDumper.  Manually splitting the sql is not really a good idea.  You need to move to a better host.


Offline Portugal

  • Jr. Member
  • **
  • Posts: 186
Re: Database (big) problem after upgrade made by my hosting
« Reply #6 on: December 28, 2017, 04:53:31 PM »
Thanks, in fact you are absolutlly right. My hosting is..... (better dont say a word). I solve this for now, uploading with a simple tool (bigdump)
 i think its the name.

Thanks to all.


Regards
Portugal
If you can't import the database with cpanel restore or phpmyadmin, your host should be able to do it for you.  You can also try importing it with a third party utility like MySQLDumper.  Manually splitting the sql is not really a good idea.  You need to move to a better host.