Topic "backing up database"

Author Message
toproadliveradio
[View user's profile]

Joined: 2007-05-05
Posts: 2
i'm trying to backup my database

my host told me to use this
mysql -h servername -u USER -pPASSWORD database-name < dumpfilename.sql

i'm logged onto the server now...and i'm at the command line

i'm TOTALLY confuse
was is the specific info to put in the command line (so i could just input my info)?
thx.
Advertisements
toproadliveradio
[View user's profile]

Joined: 2007-05-05
Posts: 2
mysqlhost -u user -ppassword database

correct in comman line?
not working
TS

Guest


I'm not sure what this has to do with WinSCP. I think your host was telling you how to restore your database, not back it up. You probably want something along the lines of

mysqldump -ssl -F -h dbserver.example.com -u toproadliveradio -r dbdump.sql

Run "man mysqldump" or "mysqldump --help" (or Google) for more information. The -ssl is optional but highly recommended. Substitute the name of your database server for dbserver.example.com and substitute your database username in place of toproadliveradio.
AMK

Guest


Is there a way to schedule mysqldump with WinSCP? I've been struggling with this for months.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24538
Location: Prague, Czechia
AMK wrote:
Is there a way to schedule mysqldump with WinSCP? I've been struggling with this for months.

For scheduling read FAQ. For executing remote command see "call" command in scripting documentation. Note that you would have to probably increase session timeout.

If you wish to execute only the mysqldump (without downloading), you would have it easier with plink from PuTTY package.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License