Increasing the importation and exportation capability of the database

Hi!

I tried to make a backup of my database like I've done many times before, by exporting a single sql file through phpMyAdmin. I couldn't, because accroding to the GoDaddy operators I must increase the importation and exportation capability for MySQL via phpMyAdmin. Nevertheless, I was able to download all pages displaying the tables of the db separately, and the guys at GoDaddy told me I can use them to restore my db if I ever need to.

But still, if possible, I'd like to get some help on how to be able to export my db as a single sql file again. I was told I need to change the values for max_execution_time, max_input_time and memory_limit in the PHP Configuration Editor, at WHM, but they told me it can't be just any value, because if I increase these too much I can have problems. They also told me I need to perform a procedure through SSH, and even though I've access my server through SSH (Putty), I must confess I didn't unserstand exactly the procedures explained in the tutorials below:
https://dev.mysql.com/doc/refman/5.5/en/server-configuration-defaults.html

https://documentation.cpanel.net/display/ALD/PHP+Configuration+Editor

http://serverfault.com/questions/64054/mysql-and-phpmyadmin-export-doesnt-always-export-everything

http://stackoverflow.com/questions/17481716/how-to-prevent-connection-timeouts-for-large-mysql-imports

So, any way of explaining me what precisely I should be doing to be able to export my database as a single sql file again?

Thanks.

  • Michael Bissett

    Hey @Gabriel, hope you're doing well today! :slight_smile:

    Let's walk through this here:

    I was told I need to change the values for max_execution_time, max_input_time and memory_limit in the PHP Configuration Editor, at WHM, but they told me it can't be just any value, because if I increase these too much I can have problems.

    True, you do need to be careful about how you go about increasing those values, as you could really use up the resources available to your server (which will cause problems).

    I'm not sure I follow this though:

    hey also told me I need to perform a procedure through SSH, and even though I've access my server through SSH (Putty), I must confess I didn't unserstand exactly the procedures explained in the tutorials below:
    https://dev.mysql.com/doc/refman/5.5/en/server-configuration-defaults.html

    https://documentation.cpanel.net/display/ALD/PHP+Configuration+Editor

    http://serverfault.com/questions/64054/mysql-and-phpmyadmin-export-doesnt-always-export-everything

    http://stackoverflow.com/questions/17481716/how-to-prevent-connection-timeouts-for-large-mysql-imports

    The time that going in via the command line is mentioned, that would be managing the database by means other than using phpMyAdmin, not sure how that all ties in?

    I would think that the earlier values they mentioned to adjust would be sufficient, may I ask what doesn't seem so clear presently?

    And to back up to this:

    Nevertheless, I was able to download all pages displaying the tables of the db separately, and the guys at GoDaddy told me I can use them to restore my db if I ever need to.

    My thoughts on the matter... what happens when your site gets real big? Like I (and GoDaddy's techs) have mentioned, increasing those limits mentioned earlier would only get you so far, you would reach a ceiling eventually. Exporting the entire database probably wouldn't be too feasible once your network gets big enough.

    Plus, what happens if only one site on your network runs into trouble? I would think being able to restore that site's database tables separately would be a handy thing, instead of having to sift through the entire backup file (as you're going to have other sites on the network inside that file).

    Kind Regards,
    Michael

  • Wheel of Commerce

    Well, I've just confirmed with them that having the backup separated in many files doesn't cause me any issues if I ever need to restore the db, so all is well. In other words: I won't need to look into this, haha. Especially considering that I'll upgrade to a fully managed server before launching anyway, so it really doesn't make any sense wasting time on this. But thanks for the help, man! :slight_smile:

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.