Re: It's Friday (a MySQL Question)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Well you certainly can not use this without the command line, however some
hosts restrict you from the command line but still allow you to run commands
via php's exec() function (Rackspace Sites is an example of this).

pseudo code example:
exec('mysqldump [options] --all-databases ... ');

Of course this is only if your hoster supports it, and if the user has
proper mysql privileges (which I think are SELECT, LOCK TABLES, and SHOW
VIEW).

mysqldump is a great program with many options so you can dump your db just
the way you want it ;)  If it's something you can and choose to use I would
suggest reading over the link I sent you so you can customize it's output.


Chris.

On Sat, Aug 14, 2010 at 8:51 AM, tedd <tedd@xxxxxxxxxxxx> wrote:

> At 6:53 PM -0400 8/13/10, chris h wrote:
>
>> Tedd I don't know if this will resolve your issue or not, but have you
>> looked into using mysqldump?
>>
>> <http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html>
>> http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
>>
>>
>> That's what I use for my backups.
>>
>>
>> Chris.
>>
>
> Chris:
>
> I would like to do that, but I simply don't know how.
>
> I think the reason for that is that I usually work on shared hosted
> accounts and the hosts don't permit command line stuff -- so I think, but I
> could be wrong. Plus, I stopped doing command line stuff back in the Apple
> ][ days.
>
> Granted this is another hole in my knowledge, but I think that even if I
> knew how, I don't think it would solve my current problem. Am I wrong?
>
>
> Cheers,
>
> tedd
>
> --
> -------
> http://sperling.com/
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux