Advertisement:

Author Topic: after backupupload in phpmyadmin problem  (Read 993 times)

Offline dominioboys

  • Semi-Newbie
  • *
  • Posts: 59
after backupupload in phpmyadmin problem
« on: May 23, 2019, 02:53:11 AM »
my database echo via phpmyadmin but it tells me that the limit is 500mb I went via php.ini to change the parameters and after restarting apache it remains the same, but I have proven that anyway I "500mib" that is written there is not is in the php.ini strings where I find a high solution?

Offline Darknico

  • Language Moderator
  • SMF Hero
  • *
  • Posts: 1,671
  • Gender: Male
  • Italian Moderator
    • Darknico on GitHub
    • Darknico.com
Re: after backupupload in phpmyadmin problem
« Reply #1 on: May 23, 2019, 06:25:08 AM »
500mb is a .sql file?
Use gzip/zip/tar version.
Italian SMF - Supporto Italiano per la board SMF - Ci trovate tutti li!! :)





Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,231
Re: after backupupload in phpmyadmin problem
« Reply #2 on: May 23, 2019, 04:50:22 PM »
If you're on shared hosting, it's unlikely you'll be able to change that setting, it will revert back to limit set by host.  If your database is larger than 500mb, you can ask host support to import it, or use a third party utility like MySQLDumper or BigDump.

Offline dominioboys

  • Semi-Newbie
  • *
  • Posts: 59
Re: after backupupload in phpmyadmin problem
« Reply #3 on: May 23, 2019, 05:19:53 PM »
is sql and 2,9 gb db file :o

limit phpmyadmin is 500mb

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,231
Re: after backupupload in phpmyadmin problem
« Reply #4 on: May 23, 2019, 05:44:38 PM »
I've never seen a shared server where phpmyadmin will import a database even close to that size.

If your database is larger than 500mb, you can ask host support to import it, or use a third party utility like MySQLDumper or BigDump.

Offline dominioboys

  • Semi-Newbie
  • *
  • Posts: 59
Re: after backupupload in phpmyadmin problem
« Reply #5 on: May 23, 2019, 06:41:56 PM »
how do you load the database manually?

Offline Darknico

  • Language Moderator
  • SMF Hero
  • *
  • Posts: 1,671
  • Gender: Male
  • Italian Moderator
    • Darknico on GitHub
    • Darknico.com
Re: after backupupload in phpmyadmin problem
« Reply #6 on: May 24, 2019, 04:32:22 AM »
mmhhh... very very big...

Number of members, topic/post?
the error log was empty before backup?
Italian SMF - Supporto Italiano per la board SMF - Ci trovate tutti li!! :)





Offline dominioboys

  • Semi-Newbie
  • *
  • Posts: 59
Re: after backupupload in phpmyadmin problem
« Reply #7 on: May 24, 2019, 04:42:20 AM »
in this dabatase i have two scritp

Offline Darknico

  • Language Moderator
  • SMF Hero
  • *
  • Posts: 1,671
  • Gender: Male
  • Italian Moderator
    • Darknico on GitHub
    • Darknico.com
Re: after backupupload in phpmyadmin problem
« Reply #8 on: May 24, 2019, 05:39:14 AM »
Number of members, topic/post?

View in SMF stats

the error log was empty before backup?

View in SMF Admin - Maintenence - Error log
Italian SMF - Supporto Italiano per la board SMF - Ci trovate tutti li!! :)