List:General Discussion« Previous MessageNext Message »
From:David T-G Date:January 29 2003 9:49pm
Subject:Re: mysql dump for remote db
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mark --

...and then Mark Stringham said...
% 
% Well it looks like I have limited options. 

Yep.  Hey, you could always host with me ;-)


% 
% I'm guessing that the web host will let me have limited rights to the 
% server as it is - probably only basic FTP and other limited DB rights - 
% I do hve some control using phpmyadmin to manipulate data. 

OK.

If I were you I'd just try a quick test.  Whip up a php page that says

  <?php
    exec("du -h -d 1",$results,$exit) or die("Could not run du\n") ;
    print "space is:<br>\n<pre>\n" ;
    print_r($results) ;
    print "</pre><br>\n" ;
    print "exit code was '$exit'<br>\n" ;
  ?>

and see what you get.  If it works, whip up another about like

  <?php
    $stamp = date("Y-m-d") ;
    exec("mysqldump -uUSER -pPASS DATABASE",$results,$exit)
      or die("Could not run mysqldump\n") ;
    print "results are:<br>\n<pre>\n" . print_r($results)
      . "</pre><br>\n" ;
    print "exit code was '$exit'<br>\n" ;
  ?>

with USER, PASS, and DATABASE set accordingly (and you should check the
mysqldump grammar; this is all right off the top of my head) and if it
doesn't try any of system, `` or popen.


% 
% I'll almost bet that they won't let me run a task from the server. 
% What about running a script from an exe ?

What script, what exe, and what machine?


% 
% thanks 

Sure thing!


% 
% MS


mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+OEx9Gb7uCXufRwARAod+AKDaV3f6KSh2eT7zuvIy3gn/osAV6QCgv160
rlm+atsvuT22qIj4fZEKId4=
=0Umb
-----END PGP SIGNATURE-----
Thread
question about primary keyVicente Valero27 Jan
  • re: question about primary keyVictoria Reznichenko28 Jan
    • mysql dump for remote dbMark Stringham28 Jan
      • Re: mysql dump for remote dbNicholas Stuart28 Jan
      • Re: mysql dump for remote dbZak Greant28 Jan
      • Re: mysql dump for remote dbDavid T-G29 Jan
  • Re: question about primary keyDavid T-G28 Jan
Re: mysql dump for remote dbDan Nelson28 Jan
Re: mysql dump for remote dbMark Stringham29 Jan
  • Re: mysql dump for remote dbDavid T-G29 Jan
Re: mysql dump for remote dbMark Stringham29 Jan