Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: dominioboys on May 23, 2019, 02:53:11 AM

Title: after backupupload in phpmyadmin problem
Post by: dominioboys 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?
Title: Re: after backupupload in phpmyadmin problem
Post by: Darknico on May 23, 2019, 06:25:08 AM
500mb is a .sql file?
Use gzip/zip/tar version.
Title: Re: after backupupload in phpmyadmin problem
Post by: Sir Osis of Liver 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.
Title: Re: after backupupload in phpmyadmin problem
Post by: dominioboys on May 23, 2019, 05:19:53 PM
is sql and 2,9 gb db file :o

limit phpmyadmin is 500mb
Title: Re: after backupupload in phpmyadmin problem
Post by: Sir Osis of Liver 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.
Title: Re: after backupupload in phpmyadmin problem
Post by: dominioboys on May 23, 2019, 06:41:56 PM
how do you load the database manually?
Title: Re: after backupupload in phpmyadmin problem
Post by: Darknico on May 24, 2019, 04:32:22 AM
mmhhh... very very big...

Number of members, topic/post?
the error log was empty before backup?
Title: Re: after backupupload in phpmyadmin problem
Post by: dominioboys on May 24, 2019, 04:42:20 AM
in this dabatase i have two scritp
Title: Re: after backupupload in phpmyadmin problem
Post by: Darknico 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