Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
2dcoder
Forum Newbie
Posts: 6 Joined: Tue Feb 15, 2005 1:09 pm
Post
by 2dcoder » Wed Feb 16, 2005 5:24 am
Currently I use the backup/restore function in Cpanel to download/upload my database. Is there are a way I can just FTP into a folder and do the same? Thanks.
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Wed Feb 16, 2005 7:04 am
Is this ODBC or MySQL? .... I think your answer will be no if you are on a shared server. This will not be accessible for your user account ...
2dcoder
Forum Newbie
Posts: 6 Joined: Tue Feb 15, 2005 1:09 pm
Post
by 2dcoder » Wed Feb 16, 2005 8:56 am
I'm runing MySql on my own dedicated server. Im hoping there is a way to simply FTP into the server and upload/download the database?
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Feb 16, 2005 9:13 am
uploading and downloading the databases' storage files is probably not the best idea. Getting extractions of the data is the safest path.
Maugrim_The_Reaper
DevNet Master
Posts: 2704 Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland
Post
by Maugrim_The_Reaper » Wed Feb 16, 2005 9:19 am
Use the command line (ssh) to mysqldump into a directory - or phpMyAdmin offers a similar method. Instructions for importing a dumpfile back into a database is there in the manual...
2dcoder
Forum Newbie
Posts: 6 Joined: Tue Feb 15, 2005 1:09 pm
Post
by 2dcoder » Wed Feb 16, 2005 3:15 pm
Ok, thanks for the comments.