Database export

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Fri May 18, 2012 3:20 pm

Database export

Post by soja »

Quoted from ticket which asked me to post here:
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?
Not a NFO employee
User avatar
TacTicToe
This is my homepage
This is my homepage
Posts: 848
Joined: Fri Feb 18, 2011 1:08 pm
Location: USA
Contact:

Re: Database export

Post by TacTicToe »

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.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: Database export

Post by soja »

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.
Not a NFO employee
Post Reply