I recently moved a large database to NFO web hosting, however the speed isn't what I expected(the daemons for the database are remote). When importing, the execution time limits on the web server did not apply. However now I am trying to export via mysqldump through ssh, and it gets terminated after a short time, not long enough for the database to export.
Your php execution time is also limited to 300s(I think), which again isn't long enough for the database to finish exporting through phpmyadmin.
Is there another way to get my database off of your web hosting?
Database export
- soja
- This is my homepage
- Posts: 2389
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Fri May 18, 2012 3:20 pm
Database export
Quoted from ticket which asked me to post here:
Not a NFO employee
Re: Database export
http://www.navicat.com/products/navicat-for-mysql
This is what I use, works like a charm. It either has a trial or lite version, either should get the job done for you.
This is what I use, works like a charm. It either has a trial or lite version, either should get the job done for you.
Re: Database export
I ended up just exporting table by table(although one table was still too large to export). Luckily that table was disposable(I ended up deleting everything from it after the move anyway).
Thanks for the suggestion.
Thanks for the suggestion.
Not a NFO employee