Cpanel/Linux Server Uploading A Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
2dcoder
Forum Newbie
Posts: 6
Joined: Tue Feb 15, 2005 1:09 pm

Cpanel/Linux Server Uploading A Database

Post by 2dcoder »

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.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

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 »

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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

uploading and downloading the databases' storage files is probably not the best idea. Getting extractions of the data is the safest path.
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

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 »

Ok, thanks for the comments.
Post Reply