Database Backup

[mlbfan]

Is it possible, here at FutureQuest, to FTP into your account and transfer your mySQL database to your local drive? I am currently using phpMyAdmin to export a CSV version but the tables are ALL so large that a single giant FTP session at 3:00 a.m. once a week would be much easier and much more effecient....

Fingers crossed,

Sean

[Terra]

Do you have a Dedicated IP at home?

If not, can you get one?

--
Terra
sysAdmin
FutureQuest

[jimbo]

I have one, and am eagerly awaiting the continuation of this thread :).

-jim

[Terra]

You could order an external ODBC connection and perform a network compressed mysqldump directly from the MySQL server to your local machine...

This would bypass using our Community Servers as an intermediary, if disk space is a concern...

It's quick, simple, and effective...[nbsp][nbsp]You can even do this if you have a Microsoft Windows box, as you can get the utilities from:
http://www.mysql.com/downloads/mysql-3.23.html

It would also open up administering your databases using local Win32 GUI tools, which is sometimes easier than using something like phpMyAdmin...

--
Terra
sysAdmin
FutureQuest

[jimbo]

Terra, is that a per month charge for the external ODBC?[nbsp][nbsp]Or is it $30 for 6 months?[nbsp][nbsp]Because I like the sound of this, and as you know, disk space (in my situation) is a concern.

-jim

[PaulKroll]

http://www.futurequest.net/Packages.php

$30, 1 IP, six months. (Near the bottom of the page.)

[jimbo]

$30, 1 IP, six months. (Near the bottom of the page.) Thanks - I saw that.[nbsp][nbsp]I just wasn't sure if it was $30/mo. for 6 months or $30 for 6 months.[nbsp][nbsp]:)

-jim

[mlbfan]

>>Do you have a Dedicated IP at home?

I do not, but I am finding out if it is possible for me to obtain one. The moment I do I'll be sure to look into this as it would seem to be the best route for me in the long run...

Thanks,

Sean